- Instant help with your Sql coding problems

Backup MySQL database

by Mike
Question:
How to backup MySQL database?
Answer:
mysqldump -u testuser -p testdb > /tmp/backup.sql

mysqldump -u [MYSQL_USER] -p [DATABASE_NAME] > [OUTPUT_FILE]
Description:

The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to another SQL server. The mysqldump command can also generate output in CSV, other delimited text, or XML format.

Reference:
mysqldump reference
Share "How to backup MySQL database?"
Related snippets:
Tags:
mysql backup, mysqldump, backup database, backup mysql database
Technical term:
Backup MySQL database
Trending snippets
List all tables in a MySQL databaseDelete all records from a table in MySQLCreate table in MySQLList databases on MySQL serverSort MySQL resultsFind MySQL data directory locationGet last 30 days records in MySQLDelete records from MySQL tableBackup MySQL schema onlyBackup MySQL databaseBackup MySQL data onlyBackup MySQL database without locking tablesBackup only selected tables in MySQLSkip tables in MySQL backupCreate INSERT statement for each record with mysqldumpBackup only certain rows from MySQL database
Network articles
Convert date to timestamp in PHPRemove all attributes from HTML tags in PHPSet line spacing in CSSAdd a box shadow to only one side of an elementPHP date differencePHP for DummiesPHP string concatenationConvert PHP string to int valueConvert binary to decimal in PHPSetup xdebug 3 debugger for PHPEnable compression in Apache using htaccessSet custom cursor in CSSImport CSS file into HTMLSetup Twitter Meta TagsSet X-Content-Type-Options in ApacheSubmit HTML form to self pageGet the last day of a month in JavaCompare strings in JavaUse foreach in JavaScriptReplace spaces with dashes in JavaScript