When using innodb, your data is stored in the data/ibdata* files. Copying the database directory is not a valid backup.
In the future, I would suggest using mysqldump. However if you want to make a file-system copy backup with innodb you need to 1. Shutdown the server 2. Copy *everything* in the data directory 3. Store a copy of your my.ini with the backup as well. 4. Restart mysql Regards, Gavin Towey -----Original Message----- From: Néstor [mailto:rot...@gmail.com] Sent: Thursday, September 10, 2009 11:28 AM To: mysql@lists.mysql.com Subject: DB/table problem I am running mysql 5.0 on a windows 2003 host with php and apache I am trying to restore a database from 08/28/2009. The backup is done by windows and all I do is copy the "data/scroller612" folder to the DATA folder in the MYSQL directory. when I restore/copy it I get the following errors my .err file found on the data directory: ========================================================== 090910 11:04:03090910 11:04:03 [ERROR] Cannot find table scroller612/cache from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database? See http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html how you can resolve the problem. ========================================================= When I go to the above link it saids to run the "check table" statement, but when I do this, I get below response: ======================================================= mysql> check table scroller612.access; +--------------------+-------+ ----------+------------------------------------------+ | Table | Op | Msg_type | Msg_text | +--------------------+-------+----------+------------------------------------------+ | scroller612.access | check | Error | Table 'scroller612.access' doesn't exist | | scroller612.access | check | error | Corrupt | +--------------------+-------+----------+------------------------------------------+ 2 rows in set (0.00 sec) ======================================================== It says that the table is corrupt. I can actually log into mysql and see the list of tables, but I can NOT desc or select the tables. how do I restore the back up? Do I need to remove the .frm files , but that would kill my data. Thanks, Nestor :-) The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
