Moving Database from c drive to d drive

6 posts
[expired user #7406]'s profile image [expired user #7406] posted 8 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?

10136 posts
ansgar's profile image ansgar posted 8 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.