Export and Import all MySQL databases at one time

by

Export:

mysqldump -u root -p --all-databases > alldb.sql

Look up the documentation for mysqldump. You may want to use some of the options mentioned in comments:

mysqldump -u root -p --opt --all-databases > alldb.sql
mysqldump -u root -p --all-databases --skip-lock-tables > alldb.sql

Import:

mysql -u root -p < alldb.sql

More Related Contents:

  1. How do I specify unique constraint for multiple columns in MySQL?
  2. Select all columns except one in MySQL?
  3. MYSQL OR vs IN performance
  4. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  5. MySQL Conditional Insert
  6. How to properly create composite primary keys – MYSQL
  7. Is there a MySQL option/feature to track history of changes to records?
  8. MySQL JOIN ON vs USING?
  9. How can I Insert many rows into a MySQL table and return the new IDs?
  10. How to store IPv6-compatible address in a relational database
  11. MySQL: View with Subquery in the FROM Clause Limitation
  12. MySql export schema without data
  13. Scaling solutions for MySQL (Replication, Clustering)
  14. What is cardinality in MySQL?
  15. Docker (Apple Silicon/M1 Preview) MySQL “no matching manifest for linux/arm64/v8 in the manifest list entries”
  16. Using ORDER BY and GROUP BY together
  17. What is the difference between BIT and TINYINT in MySQL?
  18. MySQL ERROR 1290 (HY000) –secure-file-priv option
  19. MySQL Pivot Table Column Data as Rows
  20. updating columns with a sequence number mysql
  21. How repair corrupt xampp ‘mysql.user’ table?
  22. MySQL, Concatenate two columns
  23. How to only select numeric data from mysql?
  24. What is the MySQL query equivalent of PHP strip_tags?
  25. Select all months within given date span, including the ones with 0 values
  26. Laravel MySql DB Connection with SSH
  27. Automatic Rollback if COMMIT TRANSACTION is not reached
  28. Get column sum and use to calculate percent of total (mySQL)
  29. MySQL cartesian product between two SELECT statements
  30. Sum until certain point – MySql

Leave a Comment