Importing into MySql

[tazdog]

Hello,
Somewhat new to mysql and php so I'm learning here..

What I'm trying to do is import a *.sql file that I dumped from phpmyadmin.

I have changed servers but both are running Linux.

I did upload the .sql file by ftp and then ran an import command
mysql -u username -p DBNAME < .sql
But it says that it fails on Line 12: Can't Create DB 'DBNAME' Database Exists.

So is there something I'm doing wrong in phpmyadmin that could be causing this on the export..?

Also I have tried a php script called bigdump as 1 DB I need to move is 40mb. But still having the same error when trying to use bigdump php script.

I appreciate any help offered.

thanks
Scott

[devinemke]

you actually don't need to upload your .sql file to the server. you can run the backup from your local machine via phpMyAdmin. you will probably run into problems with a db of that size. you may have to tweak a few of these php.ini settings:
max_execution_time
max_input_time
post_max_size
upload_max_filesize
mysql.connect_timeout