Database Import Problem

[Praveer]

Hello all,

I am trying to import DB. But after few minutes it says :

No activity within 1440 seconds; please log in again.

I tried 2-3 times but with no luck.

I am using Kloxo.

Can anyone please suggest me some way how to stop this message and import the database successfully?

Thank you

 

[devilboy23]

you can try mysqldump, and restore database

 

[Praveer]

Never used that. Me using phpmyadmin. Actually I am on a new server and backup on my computer not on any server.

 

[Dj Mad]

do u have ssh acces?

 

[devilboy23]

Never used that. Me using phpmyadmin. Actually I am on a new server and backup on my computer not on any server.

just download mysqldump, then place it in your public_html folder, install it, add your database logins, upload the db backup you got through ftp, and dump it to a new database or exisiting one.

 

[Mr.WT]

use bid dump

 

[Praveer]

Yes I do have SSH Access.

Ok will try what you suggested devilboy23.

Mr.WT lemme try Mysqldump first

Thanks

 

[adanrott]

just import it via ssh, easy :P

 

[Dj Mad]

Yes I do have SSH Access.

Ok will try what you suggested devilboy23.

Thanks

u could ssh,it should be faster and easier.

 

[vps9Ryan]

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

 

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

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