Release Automation

  • Private Community
Back to discussions
Expand all | Collapse all

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

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

    Posted Dec 18, 2013 03:50 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.