Hi all. Hello spam filter! sql. query. I had to restore from a backup and run through part of the day's transactions from the --log-update option ... I had accidentally deleted 2500 records, and wanted to replay the logs minus that one delete command :-) One problem which I encountered was that 'create temporary table' commands were in the log, and when I ran them through mysql, I hit a case where 2 different people had created a temporary table of the same name on the same day. The problem is since that since the logs were being re-run (mysql databasename < hostname.xxx -ppassword) with the same connection, the temporary table wasn't being dropped and the second create temporary table command was giving a 'table exists' type error. I got around the problem by 'grep'ing out the create temporary table commands from the log and re-running (they are only used in our case to provide info to clients, not for using in further update / insert commands). I suppose I should add delete table commands when I do a create temporary table command, but since the instructions said that the temporary table would be deleted when the connection was dropped, I left this out. Would it be possible to add a 'drop table' command when a connection which has made a temporary table has been dropped, to make the logs match up with what actually happens? Thanks!
Dan -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
