Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Moving Database from c drive to d drive

lordrom's profile image lordrom posted 4 years ago in Import/Export Permalink

Hi,

Need to move my datbase from c drive to d drive since it is filling up and I have more room on d drive.

Is there a quick and easy way?

ansgar's profile image ansgar posted 4 years ago Permalink

This does not have much to do with HeidiSQL. Indeed, you should just exit all HeidiSQL's on localhost and then

  • stop your MySQL server
  • move the data directory to wherever you want
  • edit your my.ini and tell it where you moved it:
    [mysqld]
    datadir=D:/where/ever/data
  • start your MySQL server

Please login to leave a reply, or register at first.