In this tutorial you are going to learn how to backup MySQL databases via command line on Linux server. Also, we’ll cover restoring a mysql database through command line.<\/p>\n
Do you know that MySQL provides an amazing tool to backup and restore databases?<\/p>\n
Let’s dive in and learn about it.<\/p>\n
<\/span><\/p>\n The mysqldump<\/span> 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<\/span> command can also generate output in CSV, other delimited text, or XML format..<\/p>\n MySQL.COM<\/b><\/span> Definition<\/span><\/p>\n You can use mysqldump command utility to dump database or tables data into textfiles with SQL queries. Later, MySQL can restore database by executing all the SQL queries stored in dumped text files. <\/p>\n There are in general three ways to use mysqldump<\/span>\u2014in order to dump a set of one or more tables, a set of one or more complete databases, or an entire MySQL server\u2014as shown here:<\/p>\n mysqldump [<\/span>options<\/em>] <\/span>db_name<\/em> [<\/span>tbl_name<\/em> …]<\/span>mysqldump [options<\/em>] –databases db_name<\/em> …<\/span>mysqldump [options<\/em>] –all-databases<\/span><\/p>\n If you want to backup single database, execute below command to dump database contents to text file.<\/p>\n mysqldump sampledb > sampledb.sql<\/span><\/p>\n To backup multiple databases, execute below command.<\/p>\n mysqldump –databases database_db1 database_db2 > mutilple_databases.sql<\/span><\/p>\n For all databases on server, execute below command.<\/p>\n mysqldump –all-databases > all_databases.sql<\/span><\/p>\n All above commands generates .sql<\/span> file which will be used for restoring databases.<\/p>\n <\/span><\/p>\nHow to Backup a Database?<\/h4>\n
MySQL Database Command Line Basics<\/h3>\n