I have moved magento database (copy and paste xampp/mysql directory) from another system to my laptop(windows7,xampp), and configure mysql service path(xampp control panel showing run mysql fine). But now I am not able to access magento database, only 19 tables are listed in phpmyadmin.
all tables are listed in sqlyog, but when i browse them getting error message "table not exist".
I try to recover and follow this article steps, but when I am run this command
mysqld –innodb_log_file_size=5242880 –innodb_force_recovery=6
on command window, getting an error " Can't create test file \usr\local\mysql\data.lower-test". Can you please suggest me why am i getting this error and how can I resolve it?
If above error we can ignore I mean this error not responsible for get back database then please suggest me how can I get back my database?
PS: I also copied "ibdata1", "ib_logfile0" and "ib_logfile1" on mysql directory. Now I can't access database from old system.
Thanks in advance.