HELP! Can't import SQL dump into SQLyog

[neophyte]

I don't do this kind of thing very often, so I'm stuck. About a year ago I did a php/sql site for a client. Uploaded everything and all is well.

Now my client wants some maintenance done on the site - added DB functionality. Unfortunately, my computer crashed 3 months ago and I lost my development database for the site.

So... I did a SQL dump of the live database via myphpadmin. It spit everything into a text file with a .sql extension. I can open the file in note pad and everything is there.

I use SQLyog for DB/Table creation and have never used command line procedures. I have tried the SQLyog import wizard but there's no option to import from a text file with a .sql extension. Have also tried and tried every other "import" type command in SQLyog, but again without any luck.

Can anyone help me with this? Please? Or tell me another way to get the database re-created using this .sql dump file.

Thanks to all in advance,

Neophyte

[maccas]

I am not sure what SQLyog is. Why not import it with phpmyadmin? It's easy, just create a database, select it and click on sql and browse for the file.

[neophyte]

maccas -

SQLyog is a graphical front end used to create/alter SQL databases on your LOCAL machine.

What I need is to use this .sql text file to re-create a database on my local machine. I'm sure theres a way SQLyog could do this, I just don't know how.

If there's another way it can be done not using SQLyog, then I'm also happy to try it...just as long as the "other" way isn't too complicated or technical.

[neophyte]

Found out how to do it.

SQLyog has a terminal-type window. I just cut the dump from the text file, pasted it into the terminal window, execuited the query(ies), and boom: perfect.

Thanks to those who read my post and either scrached their head or the one person who posted a reply.

Neophyte

[Twisted Mind]

Ehm dunno why ur doing al that that hard u can do

DB > inport from sql file...

BTW neophyte stinkt.