Link to home
Create AccountLog in
Avatar of rp
rpFlag for Portugal

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
Avatar of lcohan
lcohan
Flag of Canada image

Avatar of 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
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.
Avatar of rp

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
ASKER CERTIFIED SOLUTION
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of rp

ASKER

Thanks