Release Automation

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

Jul 08, 2014 09:04 PM

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?

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Related Entries and Links

No Related Resource entered.