- 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
Create table in MySQLSort MySQL resultsList all tables in a MySQL databaseDelete all records from a table in MySQLFind MySQL data directory locationList databases on MySQL serverDelete records from MySQL tableGet last 30 days records in MySQLBackup MySQL data onlyBackup MySQL databaseBackup MySQL schema onlySkip tables in MySQL backupBackup only selected tables in MySQLBackup MySQL database without locking tablesBackup only certain rows from MySQL databaseCreate INSERT statement for each record with mysqldump
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