Move database to second disk

[ASTRAPI]

Hello

I want to move my database to my second disk and i was read that i must found the folder for mysql that contains all that info and to copy it in the second disk and then set from my.cnf the path to lod it from the second disk.

How can i locate this folder?

Is there something else to do for that to work?

Thank you

[cPanelDon]

I want to move my database to my second disk and i was read that i must found the folder for mysql that contains all that info and to copy it in the second disk and then set from my.cnf the path to lod it from the second disk.

How can i locate this folder?

Is there something else to do for that to work?

MySQL databases are typically stored within the following directory path:

/var/lib/mysql/

When moving the MySQL data directory, as seen above, it is usually required to update the MySQL configuration file (at "/etc/my.cnf") and as a precaution one may want to create a symbolic link (symlink) from the original path to the new path.

When performing any changes the MySQL server should be fully shutdown and not actively running to minimize the potential for data loss. Due to the risk involved extreme caution is advised.

[ASTRAPI]

create a symbolic link

How can i create this?


Thank you

[boatdesign]

ln -s /path/to/mysqlnewdirectory mysqlolddirectory

[cPanelDon]

create a symbolic link

How can i create this?

ln -s /path/to/mysqlnewdirectory mysqlolddirectory

The example posted by boatdesign is valid. Here is another example just for clarification; as a precaution I've added an additional option "-n" and enabled verbose output:

# ln -nsv /new/path/to/mysql /old/path/to/mysql

For usage information I recommend referring to the manual "man" page and help documentation for "ln":

# man ln
# ln --help

If the MySQL data directory was moved to a directory path at "/new/mysql/" and if the old location is the same as the stock-default (at "/var/lib/mysql/"), the command to create a symlink could look like the following:

# ln -nsv /new/mysql /var/lib/mysql

Warning: Any changes to the MySQL data directory should be performed only while MySQL is shutdown.

[ASTRAPI]

Is it better to copy the directory and all contents of it or just a few files?

Thank you