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.
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.
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.
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?