Author Topic: How to restore database backup in case mysql server break  (Read 8123 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
How to restore database backup in case mysql server break
« on: October 28, 2015, 02:44:10 PM »
I did Mysql update procedure for the 5.5, but everything went wrong. But already I created a topic about it.

Before that, I made a backup as these steps:

Quote
1) Create full database backup (In case mysql server break we have backup to restore).

mysqldump --events --all-databases | gzip > /home/alldatabases.sql.gz

Finally removed the Mysql and I'm trying to do the reinstallation.

How could I once installed, do the restore from this backup?

Offline
**
Re: How to restore database backup in case mysql server break
« Reply #1 on: October 28, 2015, 05:16:13 PM »
Code: [Select]
mysql -u [username] -p [password] < alldatabases.sql.gz