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

[The Rock]

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

The Rock Reviewed by The Rock on 18th Jun 2011. How to IMPORT MySQL database using SSH in Kloxo On VPS ?? How to IMPORT MySQL database using SSH in Kloxo On VPS ?? :facepalm: Rating: 5

[.: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.