Hi. There is a local mysql database on a cloud server with a size of 52GB+
How do I export it to DigitalOcean Managed Databases?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×Hi there @vlladoffwork,
I would usually use one of the tools listed on the MySQL website for exporting databases. I would usually default to the mysqldump tool here:
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
Example usage:
Question
- mysqldump -h your_host -u your_user -p your_db_name > db-name.sql
However, for some extra performance I might sometimes use mysqlpump instead:
https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html
The syntax is quite similar:
- mysqlpump -h your_host -u your_user -p your_db_name > db-name.sql
Once you have the databased exported into a .sql file, you can import it with the mysql command into your Managed MySQL cluster.
Syntax:
- mysql -h your_host -u your_user -p your_db_name < db-name.sql
Hope that this helps!
Regards,
Bobby
Hi! Thx for answer. There is one problem. Records are actively added to the database. Dumping exporting and importing will take n time during which I will lose some of the data
Hi there @vlladoffwork,
One way to avoid data inconsistency is to do the following:
Before scheduling the downtime, I could suggest doing a test run with export and import and timing the whole process, that way you will then be able to know exactly how long of a maintenance window you should schedule.
Hope that this helps!
Regards,
Bobby
Thx. Unfortunately there is no maintenance mode in the application (android application). I will use this method as a last resort if I don’t find another solution.