Page 1 of 1

database retrieval

Posted: Wed Dec 07, 2005 1:35 am
by xs2manish
Hi Everyone

I had an application of client management system running on a local machine. but unfortunately msyql was uninstalled from that system . Now i have copied the database from a that system to another one, and trying to retrieve the data using phpmyadmin which i installed using xampp, but it gives me an error that .myi file missing. Can anyone suggest me how do retreive tha data as it is very important for me to recover it.

Thanks in Advance

Posted: Wed Dec 07, 2005 2:27 am
by Chris Corbyn
It's a MyISAM table type. You'll need that file.

Not sure if it's too late now but the correct thing to do is "dump" or "export" the SQL from the database and then "import" it again on the new server. That's a usual backup procedure ;)

You can use a tool called mysqldump to export the data.

Posted: Wed Dec 07, 2005 9:39 pm
by xs2manish
Hi d11wtq

Thanks for your reply. i tried to export the tables using phpmyadmin but it gives the error that the .myi file can not be found . I also did a serch on the system to find the .myi file but could not find it. am i too late now os should i try mysqldump.

Thanks in advance

Posted: Thu Dec 08, 2005 5:01 am
by Hyarion
You need to do the export or mysqldump on the original pc, not on the one you're using now. However with mysql uninstalled on that system you won't be able to export it.

Have you done a search for that .myi file on the original pc or was your search on the new pc?

Posted: Thu Dec 08, 2005 10:56 am
by John Cartwright
Uninstallating mysql should leave you data intact... There should be a folder named "data" intact in the mysql directory