Running MYSQL dump.sql into MYSQL DB?

[brianb]

Hello,

I just dumped my entire MYSQL database into a text file from my webserver...

I'd like to now run all of the commands (creating tables / inserting data) from the text file into my home server....

What's the best way to do this via COMMAND LINE or MYSQL LINE?

Thanks in advance....

[superwormy]

at command prompt:

mysql -u username -p

type password

use your_database_name

source /path/to/yourfile/filename.sql

[brianb]

Worked like a charm!

Thanks!

[brianb]

Here's a new question for this thread...

I want to do this same thing, BUT I'd like to run the text file from my DESKTOP on my home computer into the MySQL of a remote server.

Possible?

Let me know what you think!

Thanks.

[superwormy]

FTP it to the remote machine, then do the same thing already posted. You obviously can't do this without having the data located in some form or another on the same computer the MySQL server is running on, how else would the MySQL server get teh data?

Another option might be to upload the file via HTTP if FTP is not an option. THis is what PHPMyAdmin does.