Home » Tag Archives: backup database

Tag Archives: backup database

Backup and Restore MySQL Database Using mysqldump

mysqldump is an effective tool to backup MySQL database. It creates a *.sql file withDROP table, CREATE table and INSERT intosql-statements of the source database. To restore the database,  execute the *.sql file on destination database. Using mysqldump, you can backup a local database and restore it on a remote database at the same time, using a single command. In …

Read More »