How do I import the .sql DB into MySQL

[toolance]

How do I import the mysql_catalog.sql DB into MySQL

Hi,

 

I'm just learning the basics of creating and editing databases in Mysql working in the mysql.exe DOS prompt on my local Windows machine.

 

I'm having a really hard time finding the command which will let me import an existing DB. I cant find anything on the mysql site that works. I've also noticed that there seem to be 2 ways to work in MySQL with DOS. One is by launching the mysql.exe dos prompt directly, the other it to just launch a DOS prompt and then navigate to the msql admin application.. which is best?

 

I'm more familiar with working directly in the mysql.exe application which requires a ; after every command.

 

Please help a newbie to import an existing database.

 

Cheers

T.Lance

[Paul_w]

Install phpMyAdmin, work fine on windows as well as linux etc. Much easier to work with!

 

http://www.phpwizard.net/projects/phpMyAdmin/

[Guest]

Hi there ,

 

there are alot of contributions over there that request to modify the sql file ,

i have phpadmin installed on my server but i am newbie inthis would any one pls descripe in easy steps how can i edit an sql file with phpadmin and add the changes to the sql file to make teh contribute work .

Thanks

[pisces69]

Please, if anybody out there can help us, I would appreciate it. I've looked on phpmyAdmin's site, but it is currently down. If someone can please explain how to write .sql file to the sql database.

 

Thank you

[chfields]

You go into my phpadmin, choose your database, then click on what you want to change IE: configuration, scroll down and you will see a box that says Run SQL query/queries on database. Inside the box it will say SELECT * FROM `customers` WHERE 1, you just copy and paste the changes in pace of that and click go. That will do it.

 

Now I use Cpanel5 and this is how I do it. Hopefully this will help you.

It's not very hard, Before I had oscommerce I never even saw a database or worked with one.