database retrieval

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
xs2manish
Forum Commoner
Posts: 26
Joined: Mon Aug 22, 2005 10:46 pm

database retrieval

Post 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
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post 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.
xs2manish
Forum Commoner
Posts: 26
Joined: Mon Aug 22, 2005 10:46 pm

Post 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
Hyarion
Forum Newbie
Posts: 12
Joined: Tue Nov 01, 2005 4:30 am
Location: South Africa

Post 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?
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

Uninstallating mysql should leave you data intact... There should be a folder named "data" intact in the mysql directory
Post Reply