dump not importing

[vB-Host.com]

Sorry to post this both here and .com, but I have a customer waiting, so I need to find a solution ASAP.. ok,

I am trying to import a 17mb sql dump for a new customer. I uploaded the file to the server but as soon as I get the password propt, type in the password and hit enter... I receive the propt you get when it finishes I have tried both mysql -u root -p database < /home/username/dump.sql and mysql -u username -p database < /home/username/dump.sql

any ideas?

[Erwin]

Use this format - also, make sure you have permission to change the database set up properly.

mysql -uUSERNAME -p newdbname < /path/to/dump.sql

[vB-Host.com]

same thing i get.. instant propt it's done. where do I check the permission? I have never had this problem before It is not working using -uroot or -uusername

[filburt1]

There shouldn't be a space between -u and root.

mysql -uusername -p databasename < path/to/dump.sql

...is exactly what you should use, only changing the obvious stuff.

[vB-Host.com]

yes as stated above, I did that and still propts like it is finshed instantly. I used both -ucustomer-name and -uroot but no import

[vB-Host.com]

/me bumps in hopes of an answer still

[Erwin]

It's a database permission issue - search vB.com - there are a few threads on it.