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
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
Are you able to access the hosting provider mysql remotely?
mysqldump -u user -p --database=yourdB > yourdb.sql
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Note that those files are only for 'MyIsam' databases. To export InnoDB databases, you Must use the 'mysqldump' program (or phpMyAdmin).