XF 2.1 Can't import database

[DaveL]

Afternoon all.
Currently pulling my hair out here as my site is down and i'm struggling to get it back up and running again.

I'm trying to import a backup database that I created earlier today via SSH, but it's not working. I'm in the correct directory and using:
mysql -u username_dave -p database_xenforo < backup240420.sql

It then asks for my password, which I enter. It then jumps straight back to [root public_html)# without doing anything.

Really struggling to work out what is going on. Any help greatly appreciated.

 

[andybond]

The password bit is strange when importing . There is no space after the -p

mysql -u username_dave -pdatabase_xenforo < backup240420.sql

 

[DaveL]

The password bit is strange when importing . There is no space after the -p

mysql -u username_dave -pdatabase_xenforo < backup240420.sql

Thanks for the reply. I haven't entered the password in the command as it asks me for it when I press enter.

Username: username_dave
Database: database_xenforo

 

[DaveL]

How strange, I checked earlier and the database was 884MB, just checked again and it's showing as 0MB.
Will re-upload and try again. Hopefully that was the issue.

 

[Paul B]

I can't think what else it could be - the command line returning without an error is an indication that the command completed successfully.

 

[DaveL]

Got there in the end! No idea what went wrong, but all up and running again!