Extract tables and columns in Windows from sql dump

[adam5532]

Hi,
This must be really simple but the documentation for MySQL in Windows seems virtually non-existent.

I have done a datebase dump from my ISP and now have a file named databasename.sql (real name excluded for security). I am trying to open it in Access so that I can populate the tables with data and then re-upload it. I have MySQL installed and the ODDC driver loaded.

I make a connection, but no tables exist. It looks like I need to extract the data from the single .sql file into files with .myd, .myi, .frm.

How do I do this?

Thanks,
Adam Liberman
Liberman Souns

Adam Liberman

 

[sleipnir214]

You don't. Basically, you throw the .sql file at MySQL and let it deal with it.

Your installation of MySQL should have a command-line app called mysql.exe or mysql.com which allows you to enter arbitrary SQL queries.


From the command prompt, issuing the command:

mysql <databasename> < databasename.sql

should do it.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[adam5532]

Thanks! Got it to work!
- Adam

Adam Liberman

 

[QatQat]

Adam5532,

One of the nice things about MySQL is that it is truly multiplatform.
MySQL for Windoz is still MySQL with all features; the documentation is far from non-existant.

only server/service/daemon admin commands are obvioulsy different.
Download the PDF Manual; it clearly gives instructuions for both versions.

http://www.mysql.com/downloads/download.php?file=Downloads/Manual/manual.pdf&pick=mirror

Bye


Qatqat

The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)