How to IMPORT MySQL database using SSH in Kloxo On VPS ??

[The Rock]

How to IMPORT MySQL database using SSH in Kloxo On VPS ?? :facepalm:

 

[.:Raymond:.]

mysql -u username -p database_name < dumpfile.sql

Use that

 

[Cory]

Awesome useful tool, I have coded a ssh script once before because I could never remember the correct syntax.

echo "MySQL Username"
read username
echo "MySQL Database"
read database
echo "MySQL File"
read file
mysql -u $username -p $database < $file

Copy and Paste, save as: mysqlimport.sh - chmod +x 755 and sh mysqlimport.sh and follow the onscreen prompts, I should update my easy ssh tools.

 

[The Rock]

mysql -u username -p database_name < dumpfile.sql

Use that

i try that but its not working...

 

[Cory]

You have to be in the same directory as the file.

 

[Dj Mad]

it should be

mysql -uusername -pdatabase_name < dumpfile.sql

 

[Lifetalk]

And the error is?

 

[The Rock]

And the error is?

No such files directories
i give with this also home/admin/my directories.

 

[Lifetalk]

it should be

mysql -uusername -pdatabase_name < dumpfile.sql

That syntax is wrong. There's a space between -u and the username. There is, however, no space between -p and the password (or the password can be left blank and entered at the prompt that follows).


@OP
cd to the directory where the .sql file is hosted, then run the command

 

[Cory]

I don't think it matters, I've used the first syntax and the ones without spaces and they all tend to work.