missing table after sql file restore
Posted: 17. December 2012 15:05
I ran a backup this morning (windows backup to external disk) before I uninstalled xampp and reinstalled it. I've restored the files of one of my sql databases using the windows restore folder option. (wishing I'd exported the database and saved it that way before uninstalling). Anyway, there seems to be a table missing from my database even though I can see it in xampp\mysql\data\database_name. It does not appear in the list of table in phpmyadmin for that database.
When I try and run my joomla website localhost/site_name/administrator I get this error: Table 'barrow6fc.j9kig_session' doesn't exist SQL=INSERT INTO `j9kig_session` (`session_id`, `client_id`, `time`) VALUES ('jmeds9v2hndn0b7hfve15g28e4', 1, '1355751892').
I notice that in my list of files in the database folder I see j9kig_session.frm but not j9kig_session.MYD or j9kig_session.MYI . I've now run unwipe and found all 206 j9kig* files, but the j9kig_session.MYD or j9kig_session.MYI are still not among them. So presumably this means that, my backup and then restore had actually restored all the files there were (none missing), so why am I getting the above error?
I'd really appreciate any help...
Thanks,
Naomi
When I try and run my joomla website localhost/site_name/administrator I get this error: Table 'barrow6fc.j9kig_session' doesn't exist SQL=INSERT INTO `j9kig_session` (`session_id`, `client_id`, `time`) VALUES ('jmeds9v2hndn0b7hfve15g28e4', 1, '1355751892').
I notice that in my list of files in the database folder I see j9kig_session.frm but not j9kig_session.MYD or j9kig_session.MYI . I've now run unwipe and found all 206 j9kig* files, but the j9kig_session.MYD or j9kig_session.MYI are still not among them. So presumably this means that, my backup and then restore had actually restored all the files there were (none missing), so why am I getting the above error?
I'd really appreciate any help...
Thanks,
Naomi