Collapse
Announcement
Collapse
No announcement yet.
Backup and Restore Mysql Database using Mysqldump
Collapse
X
-
Thank you for the information in detail about the process of database backup.
-
Backup and Restore Mysql Database using Mysqldump
Below are mysqldump commands for backup and restore mysql database:
WINDOWS:
Backup:
HTML Code:C:\mysql\bin> mysqldump -u username -p password database > dumbfilename.sql
HTML Code:C:\mysql\bin>mysql -u username -p password database < dumpfilename.sql
UNIX / LINUX
Method 1:Follwed by user's database username and password
Backup:
HTML Code:mysqldump -u username -p password database > dumbfilename.sql
HTML Code:mysql -u username -p password database < dumbfilename.sql
Backup:
HTML Code:mysqldump databasename > dumpfilename.sql
HTML Code:mysql newdatabasename < dumpfilename.sql
Tags: None
Leave a comment: