asked on "Atach" mysql database
Hi,
In SqlServer i can copy database files from a pc to another pc, and then attach and view tables with management studio. I can do the "same" with phpadmin, but when i create dbfile and import sqlquery for ex. Now i have a folder with some mysql files (I think that will be the tables of the database) and i need "attach" or import database to phpadmin to export some data, is possible?
best regards
In SqlServer i can copy database files from a pc to another pc, and then attach and view tables with management studio. I can do the "same" with phpadmin, but when i create dbfile and import sqlquery for ex. Now i have a folder with some mysql files (I think that will be the tables of the database) and i need "attach" or import database to phpadmin to export some data, is possible?
best regards
MySQL ServerDatabasesApache Web Server
Last Comment
rp
ASKER
Hi,
Although I'm not so familiar with mysql, it seems to me that to do what you tell the server would have to be active. The problem is that I have only the files and are not "attached" to the server.
best regards
Although I'm not so familiar with mysql, it seems to me that to do what you tell the server would have to be active. The problem is that I have only the files and are not "attached" to the server.
best regards
That's confusing. MySQL does not 'attach' databases like SQL Server does.
phpMyAdmin won't connect to a MySQL installation unless MySQL is running. Give us an example of the file names. If they are '*.sql', then you should be able to import them into MySQL with either phpMyAdmin or at the command line.
phpMyAdmin won't connect to a MySQL installation unless MySQL is running. Give us an example of the file names. If they are '*.sql', then you should be able to import them into MySQL with either phpMyAdmin or at the command line.
ASKER
Hi,
As I have said many have little knowledge in mysql. Supposedly I have a series of files .MYD, .MYI that I think will be tables that belong to a data base. I do not have access to the server where this database was, only have the files. Intend to read the content and then export to sqlserver, like a .sql script.
thanks
As I have said many have little knowledge in mysql. Supposedly I have a series of files .MYD, .MYI that I think will be tables that belong to a data base. I do not have access to the server where this database was, only have the files. Intend to read the content and then export to sqlserver, like a .sql script.
thanks
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks
http://dev.mysql.com/doc/refman/5.0/en/copying-databases.html
http://www.cyberciti.biz/tips/howto-copy-mysql-database-remote-server.html