Learn how to move a MySQL database to another drive or even another server without any downtime. Find more at tonyteaches.tech Check out my vlog channel @TonyFlorida #mysql
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.
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?
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 :)
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.
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
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.
Clear and concise... thank you!
You're welcome!
You showed up in my recommendation feed. Good content👏
subscribed
Appreciate it!!
Great stuff, your explanation helps a lot!
Glad to help!
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?
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 :)
you need to set the mariadb service to be enabled, this should be default
`sudo systemctl enable mariadb`
That lava lamp is a vibe 👌🏽
Sure is!
this is moving to another drive. can we move the database to another server or vm with the same procedures.?
thanks for the video, i do mysql backups using : mysqldump command and i restore it via phpmyadmin
Sure thing Moataz. mysql dump is another great option
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.
Thanks a lot .
Most welcome!
Nice tutorial
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
tony how do i change the ip address
Yo! Tony 👍