Restore data from a backup file (.data) into another MySQL
All,
I have an issue with some data that suddenly has disappeared from my system. i run a full backup of the system every hour. I now want to extract the data part of this backup file and insert them into another DB.
I don't want to do a regular full restore since, but merely just get access to the data. The data file that is produced by the backup script is in a java binary format. But I would need to know how to extract that into simple sql files as I can see backup does when running the backup script and compress them into one single data file.
Thanks for you assistance. it's much appreciated
Poul
I have an issue with some data that suddenly has disappeared from my system. i run a full backup of the system every hour. I now want to extract the data part of this backup file and insert them into another DB.
I don't want to do a regular full restore since, but merely just get access to the data. The data file that is produced by the backup script is in a java binary format. But I would need to know how to extract that into simple sql files as I can see backup does when running the backup script and compress them into one single data file.
Thanks for you assistance. it's much appreciated
Poul