Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Ubuntu - Backups - Backup and restore mysql databases ======

===== To backup (dump) a single mysql database to a file =====

<code bash>
mysqldump -u foo -p foodb > foodb.sql
</code>

where:

  * **-u** is for username.
  * **-p** is for mysqldump to ask for password.
  * **foodb** is the name of the database.
  * **foodb.sql** is the file to dump the database.

----

===== To backup (dump) all databases to a file =====

<code bash>
mysqldump -u foo -p --all-databases > alldb.sql
</code>

where:

  * **-u** is for username.
  * **-p** is for mysqldump to ask for password.
  * **<nowiki>--all-databases</nowiki>** is to tell mysqldump to dump all databases available.
  * **alldb.sql** is the dumpfile name.

----

===== To restore a mysql database from dumpfile =====

1. From terminal

<code bash>
mysql -u foo -p foodb < foodb.sql
</code>

where:

  * **-u** is for username.
  * **-p** is for mysqldump to ask for password.
  * **foodb** is the name of the database.
  * **foodb.sql** is the file to dump the database.

----

2. From inside mysql console where you have to access mysql console first:

<code mysql>
mysql> source foodb.sql 

or 

mysql> \. foodb.sql
</code>

where foodb.sql is the dumpfile.

----