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

praveer Reviewed by praveer on 21st Jun 2011. Database Import Problem 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. Rating: 5

[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

[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