View source for Backing up and restoring MySQL database

<yambe:breadcrumb>Mysql configuration</yambe:breadcrumb>
=Backing up and restoring MySQL database=

==MySQL database backup==

To backup MySQL database one can use '<tt>mysqldump</tt>' program. Syntax for mysqldump is:
<pre>
mysqldump -u <mysql_username> -p <database_name> > <database_name>.sql
</pre>

To automatically compress the database before it is stored on disk the output of mysqldump can be passed through bzip2 as:
<pre>
mysqldump -u <mysql_username> -p <database_name> | bzip2 > <database_name>.sql.bz2
</pre>


==Restoring MySQL database==

To restore MySQL database we can use '<tt>mysql</tt>' command line client. Command to restore database is:
<pre>
cat <dump_file>.sql | mysql -u <mysql_username> -p <database_name>
</pre>


To restore a compressed database along with password we can take help of '<tt>bunzip2</tt>' and '<tt>sshpass</tt>' utilities in following manner:
<pre>
bunzip2 -c <dump_file>.sql.bz2 | sshpass -p <mysql_database_password> mysql -u <mysql_username> -p <database_name>
</pre>



<yambe:breadcrumb>Mysql configuration</yambe:breadcrumb>