Database Import Problem

[praveer]

Easiest method for you mate ...

Login to ssh and do this ...

mysql -uUSERNAME -pPASSWORD DATABASENAME < MYDATABASE.sql

instead of USERNAME put your username
instead of PASSWORD put your pass ofc
instead of DATABASENAME put your empty database that you created to import your data into
instead of MYDATABASE.sql put your .sql file name.

Good luck,
Ryan

But the file is stored locally on my computer. Its not on the VPS. Will the method stil work?

Thanks

[raj11]

@praveer
use ftp to upload database to ur server first,then login to ssh & use this command

mysql -u dbusername -p databasename < /path/to/backupname.sql

You will be prompted for the database password. Enter it and the database will restored.

[praveer]

Mate here uploading speed sucks

[Pirate]

How big is your db?

Compress the file before upload.

[vps9Ryan]

Mate here uploading speed sucks

then just go in ssh and type

nano file.sql

it will open up text editor, just copy the text from your own computer and paste it in the terminal.

then save the file and run the command

mysql -u dbusername -p databasename < file.sql



If you still need help, let us know

Cheers,
Ryan

[praveer]

Its 45 MB lemme try to compress it.

[vps9Ryan]

Its 45 MB lemme try to compress it.

Yea, do that

It is quite big, so do not use the copy/paste method. Better to just let it upload.

Cheers,
Ryan