Shell> mysqldump db_name > backup-file.sql If you have a single MySQL database to backup, input this command: You have three ways to use mysqldump to backup MySQL database in Windows or Linux, the syntax is listed below:ġ.Ĝlick Start, input cmd into the dialog box and press enter. If you have shell or telnet access to your web server, you can backup your MySQL database by using the mysqldump command (backup MySQL database command line). In addition, you can try the third party database backup software to do MySQL backup and restore for you.īackup and restore MySQL database using command prompt (mysqldump) Or you could use phpMyAdmin to manage your MySQL database. Generally speaking, you could use MySQL built-in backup program named mysqldump to backup your MySQL database in case of data loss. MySQL database backup and restore solutions
How would you backup and restore MySQL database in Windows or Linux? Here you will get three ways to do that job for you. As the most important component of the website, you have to backup MySQL database to avoid problems occur, like database corrupted, lost or impropriate modify, etc. MySQL is one of the most popular database engines, and provides the service of database for websites.
0 kommentar(er)
