[pcornaille]

HelHello,

I used Mysql with a lot of databases (580 databases today).
I have only one binary log for all theses databases.
If I have to recover one database because a bad SQL stament has destroye some datas.
The method :
1. I restore the database xxxx using mysqldump < xxxx.sql
2. I made a file with all the binary logs from the date of the databases backup and the curent binary log (all_binary.log)
3. Using vi editor I commente the row of bad SQL stament.
4. I apply the all_binary.log file by :
# mysqlbinlog all_binary.log | mysql

Question:
The bad SQL stament will not be apllied
All the SQL staments of the others databases will be apllied or not? Does exist a risk to use this method ?

Thank for your help.
Pierre Cornaille