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:
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:
Once you have the databased exported into a
.sql
file, you can import it with themysql
command into your Managed MySQL cluster.Syntax:
Hope that this helps! Regards, Bobby