Tech Help - Moving MySQL Database

[MikeGracia]

Hi guys!

Okay, I'm going to take out an SSD for my DayZ Epoch database.

I'm struggling to sort out how to move it!

Support suggested I posted on these forums, as they said to:

1. Shut down the MySQL server.
2. Change the datadir variable in the MySQL configuration. Make sure to edit this in both the [mysqld] and [mysqld_safe] sections.
3. Change the basedir variable in the same sections.
4. Move the current data folder to the new location you specified.
5. Restart your MySQL server.

The only problem is that the variables datadir (in 2 sections) and basedir (in both sections) are NOT present in the my.ini file (which is where support thought they should be).

JUST TO BE SURE I am checking the correct my.ini file, in my server restart batch file I use:

--defaults-file=server_setup\xampp\mysql\bin\my.ini

So I have navigated to that my.ini file, and that's the one I'm checking... Could there be another? A basic Windows one or something?!

Hmmm any advice guys?

[.=QUACK=.Major.Pain]

Why not just export the database,
Uninstall the mysql program you use.
Reinstall it on the SSD drive.
Import the database.

[Spray]

If you don't see the setting located in the applicable section, feel free to add it. For instance:

Code: Select all

[mysqld]
datadir="E:/MySQL/data"
max_connections=60
read_buffer_size=3M
sort_buffer_size=3M
...

You won't need to change the basedir unless you want to move the entire installation. It would probably be best to just move the datadir to the SSD.

[Michigan]

Why not just export the database,
Uninstall the mysql program you use.
Reinstall it on the SSD drive.
Import the database.

This, this is what I did for my old gameserver and brought it here.

[.=QUACK=.Major.Pain]

It would be the same if your just moving from hard drive to SSD wouldn't it?
Or are you trying to keep WAMP on the hard drive and just the data on the SSD?

[MikeGracia]

It would be the same if your just moving from hard drive to SSD wouldn't it?
Or are you trying to keep WAMP on the hard drive and just the data on the SSD?

Open to both options really, just trying to get the database to run on SSD for faster access etc

What would you recommend? Data only on SSD or whole install?

[.=QUACK=.Major.Pain]

I think the easiest way is to fully install it on the SSD.
I wouldn't know enough about separating the program from the database and syncing it all properly.