View source for Backup MySQL Database

From James's Wiki

← Backup MySQL Database

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: Users.

You can view and copy the source of this page.


back it up with:
 mysqldump -u <username> -p<password> <database name> > /media/temp/<database name>

NOTE: there is no space between -p and the password

restore:
 mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]

Source: http://webcheatsheet.com/sql/mysql_backup_restore.php

Return to Backup MySQL Database.

Retrieved from "https://wiki.jamesclaus.com/Backup_MySQL_Database"