How to Move an Entire MySQL Database

Learn how to move a MySQL database to another drive or even another server without any downtime.

Check out my vlog channel @TonyFlorida
#mysql

[WernerVanAswegen]

Thank you for the video. I caught the error regarding the datadir in the conf file for mysql, but I still had an error when trying to start the mysql service. In my case the issue was that the owner and group of the mysql directory and subdirectories on the new drive. It all defaulted to root:root. I cahnged it to be the same as the (thankfully backed-up) mysql.bak directory and that solved the problem.

[helloandris_]

Great stuff, your explanation helps a lot!

[aonwebdesign]

Great videos.
Thanks for the work you do.
A kind request:
Can you please test WordPress Server security on DO & Linode, and Performance for Plesk 3 domain free licence server on DO & Linode?
Thanks in advance.

[brunourmalmiranda]

Hello, great video, i got a crucial question for me.. my hestia cp server went down and at this moment i only can access the files. I have my wordpress site that i backed up already to create a new instance with it but the database i dont have a dump file.. i was looking to transfer the databases and users to my new instance and that was how i ended up on your excellent video.. i wanted to transfer the files from the old instance to my new mysql / phpmyadmin instance but maybe the best way is to mount it and reconnect like you teach on this video?

[GopalPokhrel]

this is moving to another drive. can we move the database to another server or vm with the same procedures.?

[swarupkumar]

You showed up in my recommendation feed. Good content👏

[moatazezzat]

thanks for the video, i do mysql backups using : mysqldump command and i restore it via phpmyadmin

[ivanobuffa]

I have a mariadb and I followed a very equivalent procedure. Everything is fine however what you didn't show and anyone else (I know it sounds silly) is if the mysql DB service still runs automatically after a reboot. I have this problem. After changing everything, all is good. However, after I reboot the mariadb service won't go up. I'm not going to bother you here with the error obviously but it would be interesting if you could have a look at my system (perhaps a remote call) so that I can show you what the problem is but if you are busy or not willing to do so... I would understand! Thank you and keep it up :)

[Nimitz_oceo]

Can you do a video of the migration without downtime? Like temporarily moving the DB to a docker container and then performing the actual migration to the new drive and then shifting the traffic back to the new drive? I know it sounds tedious but that is what most of us deal with on a regular basis