Timeout errors when restoring mysqldump file from remote location

[trophyhead]

Hi all,

I'm currently getting errors when I try to restore a mysqldump file from my home machine to the Powweb server.

The command works correctly with smaller dumpfiles, but gives me a timeout error with mysqldump files of over 5 Mb or so.

The command looks like this (on my Windows box):

c:\mysql\bin\mysql -uusername -ppassword -hwww.mysite.com databasename < c:\mysqldumpfile.dump

The error I get is:

ERROR 2013 at line 12773: Lost connection to MySQL server during query

Any ideas as to how I might fix this problem? It could be a problem with my connection, but I don't think so...it's to the point where I can *never* upload a file of greater than a certain size using this command.

Thanks!

[newcomer]

use phpmyadmin for that and it's lot easier than that.

go to powweb's tutorials and read about phpmyadmin installation.

[trophyhead]

Maybe you could spoon-feed me a bit, NEWCOMER.

I have mysqladmin installed on my local box (where my data is). How can I use it to get my local data to the live server? My "mysqldump" solution has gotten me this far...will using mysqladmin solve my problem?

Any details as to how you might approach this would be appreciated.

[newcomer]

Hey Trophyhead!

Sorry I went to sleep and just woke up. he he he he

please go to http://forum.powweb.com/showthread.php?s=&threadid=1473&highlight=how+to+use+phpmyadmin+locally

and read how you can use it locally and remotly.