How to backup and restore MySQL database by using command line — Nazir SysAdmin


How to backup MySQL database: To create backup of MySQL database or databases, the database must exist in the server. The format of command line would be. # mysqldump -u [username] –p[password] [database_name] > [dump_file.sql] 1. How to Backup a Single MySQL Database To take a backup of single database, use the command as follows. […]

via How to backup and restore MySQL database by using command line — Nazir SysAdmin

Advertisements