How to use MySQL backup and restore in PHP?

Backing up and restoring a MySQL database in PHP can be achieved by following these steps: Back up the database: Use the mysqldump command to dump the database into a SQL file. Restore the database: Use the mysql command to restore the database from the SQL file.

How to use MySQL backup and restore in PHP?

MySQL database backup and restore is critical to maintaining data security and recoverability. This article will show you how to perform these operations in PHP, including practical examples.

Backup database

To back up the MySQL database, you can use the mysqldump command in PHP.

$command = 'mysqldump --user=username --password=password database_name > backup.sql';
exec($command);

This command will create a SQL dump of the database in the backup.sql file.

Restore the database

To restore the MySQL database, you can use the mysql command in PHP.

$command = 'mysql --user=username --password=password database_name < backup.sql';
exec($command);

This command will restore the database from the backup.sql file.

Practical case

Let us give a practical case using the above code. Let's say we have a database called users and we want to back up and restore it.

// 备份数据库
$command = 'mysqldump --user=root --password=my_password users > users_backup.sql';
exec($command);

// 还原数据库
$command = 'mysql --user=root --password=my_password users < users_backup.sql';
exec($command);

Running this script will back up the users database to the users_backup.sql file and then restore it from that file.

The above is the detailed content of How to use MySQL backup and restore in PHP?. For more information, please follow other related articles on the PHP Chinese website!