How to convert MYD, MYI, FRM files to Query?

fatihhk · 02-28-2007, 11:07 AM

Hello there,
I have a database backup that consists MYD, MYI, FRM files.
But I don't know how I work with them?
How could I convert them into the Mysql query? or how to use them?
Thanks in advance...

Peter · 02-28-2007, 12:27 PM

the files you have are raw mysql files not sure if you can convert them to sql but you ussually restore them by placing them in the relevant mysql folder on the server.

http://dev.mysql.com/doc/refman/4.1/...ore-table.html

Matthew. · 02-28-2007, 12:29 PM

Yeah it's strange that if you are using an 'online' web host that you were given these. If you are working on local then navigate to your installation folder and find mysql\data and dump them in there (inside a folder that is the database name)

Matt

02-28-2007, 11:07 AM	#1 (permalink)
fatihhk NamePros Regular Join Date: Apr 2006 Location: Berlin Posts: 335 1.51 NP$ (Donate)	How to convert MYD, MYI, FRM files to Query? Hello there, I have a database backup that consists MYD, MYI, FRM files. But I don't know how I work with them? How could I convert them into the Mysql query? or how to use them? Thanks in advance...

02-28-2007, 12:29 PM	#3 (permalink)
Matthew. Stud Sausage Join Date: Dec 2006 Location: England Posts: 1,546 34.41 NP$ (Donate)	Yeah it's strange that if you are using an 'online' web host that you were given these. If you are working on local then navigate to your installation folder and find mysql\data and dump them in there (inside a folder that is the database name) Matt __________________ My NamePros Tools (firefox plugin, google gadget etc)

02-28-2007, 12:27 PM	#2 (permalink)
Peter Senior Member Join Date: Nov 2003 Location: Scotland Posts: 4,900 0.60 NP$ (Donate)	the files you have are raw mysql files not sure if you can convert them to sql but you ussually restore them by placing them in the relevant mysql folder on the server. http://dev.mysql.com/doc/refman/4.1/...ore-table.html

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)