[ACCEPTED]-Change database files location in MySQL administrator?-mysql
Normally it works like this:
- shut down MySQL
- change the
datadirvariable in the MySQL configuration
- change the
basedirvariable in the same section.
- move the location over
- restart MySQL
If that doesn't 5 work I have no idea. On linux you can try 4 to move the socket to a new location too, but 3 that shouldn't affect windows. Alternatively 2 you can use a symbolic link on *nix what 1 most people do I guess.
- Navigate to
C:\Program Files\MySQL\MySQL Server 5.4\and locate the
- Find the SERVER SECTION and go to approx line 76 and modify the datadir line to where you want your MySQL application data to be stored
- Now navigate to
C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.4\data\and copy and paste the mysql folder into your new location.
- Restart the MySQL Server in Control Panel > Administrative Tools > Service
You also have to manually modify mysql's 1 configuration (usually my.conf)
MySQL Administrator cannot be used for tasks 9 like this. It is merely a tool for looking 8 at MySQL servers, despite its name. Relocating 7 data is described in many MySQL tutorials 6 and in the manual IIRC. But basically it's 5 just moving the data to a new location while 4 the server is shut down and then correcting 3 the paths in the servers config file. After 2 that you should be able to restart the server 1 and connect MySQL Administrator to it.
Make sure you give the Network Service Full 5 permissions in the security tab of Windows 4 Explorer options. If the server can't read/write 3 etc. to the selected folder the service 2 will either not start or it will attempt 1 a start and shut right down.
More Related questions