You will desire to take hot backups when: The advantages of MySQL hot backup are that it does not block normal database operations, and it captures even changes that occur while the backup is happening. MySQL hot backup means to backup a MySQL database while the database is running and applications are reading and writing to it. Reliable software to run MySQL hot/cold backup in Windows Mysql> source /path/to/your_sql_file.How to create hot backup of MySQL databases with MySQL Enterprise Backup? Mysql -u USERNAME -pPASSWORD DATABASE_NAME use GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES ON new_drupal_database.* TO IDENTIFIED BY 'password' 'password' is the password required for that username 'localhost' is the web server host where Drupal is installed 'username' is the username of your MySQL account 'databasename' is the name of your database Use database NEW_DRUPAL_DATABASE 5 grant privileges Mysqldump -u USERNAME -pPASSWORD OLD_DRUPAL_DB_NAME > new_drupal.sql 3 then create the new database or use the truncated same database.Ĭreate database NEW_DRUPAL_DATABASE 4 Read the document in your drupal core folderĪccording to the inside the Drupal core folder (see your drupal core folder for (PostgreSQL) and for sqlite ) The mysqldump command you do from terminal, not from the mysql commandline

Restoring from a MySQL dumpġ Backup your Drupal sites folder. If not deleted, these 'new' tables will cause errors the next time you attempt an update and if you ignore those errors because things initially appear to work, you may encounter more problems due to duplicate data, old data or just plain database corruption later on. (For example, although mysqldump adds DROP/CREATE TABLE lines to the dump by default, it only does that for tables that it knows about.)

Drupal updates may rename tables or rearrange table data into new tables, and these tables typically won't be deleted when you restore a database backup. IMPORTANT: Before restoring a backup made before an update, you must make sure to completely empty your database. While an investigation is done into what went wrong. However, occasionally things don't go to plan and when this happens (more often than not) the database backup must be restored. Most of the site updates are happened without incident and when successful, the database dump you made can be discarded or archived.

Mysql backup and restore