Ractive: Created page with " back it up with: mysqldump -u -p > /media/temp/ NOTE: there is no space between -p and the password restore: mysql -u..."

2018-06-17T15:57:21Z

Created page with " 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..."

New 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

Backup MySQL Database - Revision history

Ractive: Created page with " back it up with: mysqldump -u -p > /media/temp/ NOTE: there is no space between -p and the password restore: mysql -u..."