Select a Category

How to backup MySQL Database

Problem Need to backup the MySQL database for safe keeping on backup server.

Solution

To backup Database You can use MySQLdump in linux to dump the database into a SQL file for safe keeping in other backup server. The command is in the following structure:

mysqldump -u username -p password databasename > output_file_name

Example

mysqldump […]