All Questions
7 questions
11
votes
4
answers
28k
views
Verify mysqldump backup is corruption free
We've got a cron task backing up our Database using mysqldump - my main concern is corruption, short of manually importing and checking the backups each time whats the best way to check / verify a ...
- 221
63
votes
8
answers
138k
views
Restore mysql database with different name
How can we restore mysql database with different name from mysqldump file.
I dont't want to open dump file and edit it. Any other better methods?
- 1,536
5
votes
2
answers
8k
views
How to merge MySQL backup files (*.sql)
We have several MySQL backup files of a database in *.SQL format and we want to restore the database by using these files. However, as the sql files contains "DROP TABLE" definitions, running one ...
- 1
5
votes
4
answers
24k
views
mysql duplicate entry error 1062 when restoring backup
Sorry, I seen similar threads but I still couldn't find it addressing my issue plus, I needed some more info on this.
Requirement: To create an exact replica 'db4' of an existing DB 'db3'.
Procedure ...
- 51
5
votes
2
answers
15k
views
Problem with View When Restoring a MySQL Backup
I have a database (InnoDB) with some tables, views and routines...
Periodically I do a backup using the command line:
mysqldump -u user -ppassword --routines db_name > backup.sql
But I have a ...
- 151
1
vote
1
answer
63
views
how to verify mysql backup file using BlackHole
I'm interested in trying this solution: https://dba.stackexchange.com/a/44893/71052, also referenced here: https://dba.stackexchange.com/a/206151/71052
The problem I face is the following:
mysqldump ...
- 131
1
vote
1
answer
6k
views
mysqlbinlog failing with " ERROR 1032 (HY000) at line 48: Can't find record in `` " Error
I am facing some issue with PITR restore using mysqlbinlog . It is failing with the following error .
# mysqlbinlog mysql-bin.000035 | mysql -u root -p db
Enter password:
ERROR 1032 (HY000) at ...
- 173