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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s