Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
How can I export / import a database correctly?
We use a database cluster. When I export the database I run the following command:
mysqldump --single-transaction --quick -u[user] -p[password] -h[host] -P[port number] [database] > [path]
I use homestead to work locally, and to import the database I execute this command:
mysql -uhomestead -psecret -D [database] < [file.sql]
But I receive an error message:
ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.
This is the first time I have this error. What does it mean? What is the correct way to export / import?
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.×