Can you re-create a MySQL database from .frm .MYD and .MYI files?
Permalink 2 users found helpful
Hi There,
I've upgrade my local machine but forgot about all my local MAMP databases.
I have my original disk and have found where MAMP pro has stored all the databases:
/Libary/Application Support/appsolute/MAMP PRO/db/mysql
But in the databases folders are what look to be the separate tables for the c5 database and for each table there is a:
- .frm file
- .MYD file
- .MYI file
Do I import all these files to re-create the database or is that not possible?
All the articles I've read on these files were a bit technical so any help here would be awesome!
Cheers
Ben
I've upgrade my local machine but forgot about all my local MAMP databases.
I have my original disk and have found where MAMP pro has stored all the databases:
/Libary/Application Support/appsolute/MAMP PRO/db/mysql
But in the databases folders are what look to be the separate tables for the c5 database and for each table there is a:
- .frm file
- .MYD file
- .MYI file
Do I import all these files to re-create the database or is that not possible?
All the articles I've read on these files were a bit technical so any help here would be awesome!
Cheers
Ben
Thanks for that,
What if I can't run phpMyAdmin on that machine?
i.e. the data is there on my old disk but MAMP no longer starts up from that disk - so doesn't see those databases.
Can I just copy that data into the same folder in the new disk and have MAMP see those databases?
What if I can't run phpMyAdmin on that machine?
i.e. the data is there on my old disk but MAMP no longer starts up from that disk - so doesn't see those databases.
Can I just copy that data into the same folder in the new disk and have MAMP see those databases?
You can try, I have no clue if that will work.
Tutorial:http://www.siteground.com/tutorials/php-mysql/mysql_export.htm...