#2006 - MySQL server has gone away Local host when importing to localhost

[sunflowertami]

Hi,

I'm trying to bring my live database into my localhost so that I can work on the upgrade and test before going to the live site.

I realize that in 2 years time, the database has gotten large and therefore I'm having problems importing the database into myphp. Everytime it hits the "products" table it goes into an error: #2006 - MySQL server has gone away

Is there anyway around this? Thanks

[kobra]

Assuming that you are attempting this with phpadmin
You might get a "putty" command interface such as "winputty" if on a windows box
and use the following:

mysql database < file.sql

Example:
mysql jsmith_db < db-backup.sql

[sunflowertami]

Hi Kobra,

Yes I am using phpMyAdmin 2.6.4-pl1 and I don't see a win putty selection on it?

Did you mean run it on windows? Start-Run-Cmd?

Thanks for your help in advance!

[kobra]

Winputty is another application that provides a command line interface to your AMP Stack install
Google for it

[sunflowertami]

Hi,

I got Putty.exe and WinPutty-CD. I'm really at a loss as to how to use it... please help! Thanks

[kobra]

They have documentation included and you can Google for additional