Nolio Official KB: How do I export and Restore a MySQl database?

Document created by MaryGreening on Jul 9, 2014
Version 1Show Document
  • View in full screen mode
Export the Nolio MySQL database
To export the Nolio MySQL database (nolio_db by default) go to \bin and type in the command mysqldump -u root nolio_db > c:\nolio_db.sql.
If the user root has a password, add the command -p after -u root.
Restore the Nolio MySQL database
To restore the Nolio MySQL database from the file nolio_db.sql:
1.Create the database by the command  mysqladmin -u root create restored_db.
2.Restore the database by the command mysql -u root restored_db < nolio_db.sql.

 

This document was generated from the following discussion: Nolio Official KB: How do I export and Restore a MySQl database?

Attachments

    Outcomes