I've got my applications running on a server that backs up every hour using MySQLdump. My goal is to take this 'dump' and re-import it into my desktop computer using MySQLAdministrator. I go through the procedure of restoring this 'backup.sql' file and it grinds for some time as though something is happening...and then nothing?? There are no error messages...just no tables in the empty database that was supposed to have been restored. It is important to point out here that I can accomplish the backup/restore for any MySQL applications on my desktop computer, just fine. I find in the MySQL folder a ibdata1, ib_logfile0 and ib_logfile1 that are VERY large but they are binary and I have no idea what 'jewels of wisdom' they might offer. Is there anyone out there that could share some insight in how they would restore (partially or full) a backup into their production database? I worry that some crazy person could attack my site with dirty language that I'd have to clean up. Anyway, I appreciate any thoughts. Kathleen
KathysKode@gmail.com wrote:
I've got my applications running on a server that backs up every hour using MySQLdump. My goal is to take this 'dump' and re-import it into my desktop computer using MySQLAdministrator. I go through the procedure of restoring this 'backup.sql' file and it grinds for some time as though something is happening...and then nothing??
<snip> Hi
Have you tried using the command line client? The command would look like so:
mysql -u *username* -h *hostname* -p *databasename* < backup.sql
Where *username* must be replaced with your username, *hostname* can be replaced with a hostname or left blank if the db is on localhost, and *databasename* must be replaced with your databasename.
By running this, you may see some warning messages that are not apparent from the Administrator tool.
Otherwise, you can perhaps try posting a small snippet of the backup file (if you feel comfortable doing it) - and we can have a look-see.
R
