Link to home
Start Free TrialLog in
Avatar of prenreg
prenreg

asked on

.FRM, .MYD, and .MYI files covert

is there a way to convert .FRM, .MYD, and .MYI files to. sql   I'm having an issue getting these files copied to hosting company
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

You should use the 'mysqldump' program (or phpMyAdmin) on the original server.  It will create '*.sql' files that you can upload to your hosting using phpmyadmin.  That's the way I do it every week.

Note that those files are only for 'MyIsam' databases.  To export InnoDB databases, you Must use the 'mysqldump' program (or phpMyAdmin).
just to add to Dave's comment. mysqldump will output the create database/tables and the insert directives for the data that will then need to be run on the destination.

Are you able to access the hosting provider mysql remotely?
mysqldump -u user -p --database=yourdB > yourdb.sql
Avatar of prenreg
prenreg

ASKER

THANKS for the input!!
I don' t think so. I only see PHPMyAdmin  regrading mySQL remote.  
my original server crashed, reinstalled os now trying to install app so i can create create '*.sql' per dave's comment.

unable install. https://www.experts-exchange.com/questions/28702249/web-platform-installer-Error-check-network-connect.html
ASKER CERTIFIED SOLUTION
Avatar of prenreg
prenreg

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial