Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 678
  • Last Modified:

"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
0
rflorencio
Asked:
rflorencio
2 Solutions
 
lcohanDatabase AnalystCommented:
0
 
rflorencioAuthor Commented:
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
0
 
Dave BaldwinFixer of ProblemsCommented:
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.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
rflorencioAuthor Commented:
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
0
 
Dave BaldwinFixer of ProblemsCommented:
No, that won't work, those are not in 'SQL' format.  ".MYD" and ".MYI" are the 'data' and 'index' file for a MyISAM database.  You can put them in a directory for their database and restart MySQL and see if it picks them up.
0
 
Muhammad WasifCommented:
There must be files like .frm. Without them, you may not be able get the data as Dave has suggested. If you have all three files e.g. table1.FRM, table1.MYD and table1.MYI (or atleast .FRM and .MYD) then you can read the data as Dave suggested.
0
 
rflorencioAuthor Commented:
Thanks
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now