PHPMyAdmin Import Problem

[obrienkev]

Hi all,

I backed up(using export) a database from one server.

Then I went to upload that backup file into another database on another server.

I get the error 'File could not be read'

Why is this?

Thanks.

[superwormy]

Did you export the data as SQL commands or...? Look in the file and make sure the file looks good. Try it from the command line ( assuming MySQL here... ) with the mysql 'source /path/to/sql_file.sql' command.

[obrienkev]

How do I import into a mysql db table from the command line?

Thanks.

[superwormy]

At a command prompt:

mysql -u your_username -p your_database

That puts you in the MySQL shell thingy, then type:

source /path/to/sql_dump_file.sql