How to restore a database?
Hello,
I am testing how to make an incremental backups for a single innodb database and how to restore it. I am having difficulies with restoring the database. Here is my steps:
1 - Creating full backup ./xtrabackup --backup --target-
2 - creating incremental backup after changing some rows ./xtrabackup --backup --target-
3 - Preparing :
./xtrabackup --prepare --apply-log-only --target-
./xtrabackup --prepare --apply-log-only --target-
Now after running these commands, I found a new folder called backup inside the data folder. The folder contains the following files:
ibdata1 xtrabackup_
I stopped at this point, what should I do know?
For testing ,I stoped MySQL and removed the existing database folder db1 and the file ibdata1 inside the data directory and then I cpoied the ibdata1 from the backup folder to the data directory and started MySQL but I did not work.
Thanks for help :)
Question information
- Language:
- English Edit question
- Status:
- Solved
- Assignee:
- No assignee Edit question
- Solved by:
- Alexey Kopytov
- Solved:
- Last query:
- Last reply: