Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2008
    Posts
    255
    Plugin Contributions
    0

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

    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

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

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

    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
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Jun 2008
    Posts
    255
    Plugin Contributions
    0

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

    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!

  4. #4
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

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

    Winputty is another application that provides a command line interface to your AMP Stack install
    Google for it
    Zen-Venom Get Bitten

  5. #5
    Join Date
    Jun 2008
    Posts
    255
    Plugin Contributions
    0

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

    Hi,

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


  6. #6
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

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

    They have documentation included and you can Google for additional
    Zen-Venom Get Bitten

 

 

Similar Threads

  1. Replies: 5
    Last Post: 12 May 2010, 04:26 AM
  2. Replies: 5
    Last Post: 5 Jan 2010, 09:07 PM
  3. 2006 MySQL server has gone away when using PayPal Express
    By valenk1 in forum Built-in Shipping and Payment Modules
    Replies: 0
    Last Post: 16 Oct 2009, 06:25 AM
  4. 2006 MySQL server has gone away
    By cuysan in forum General Questions
    Replies: 4
    Last Post: 26 Feb 2009, 01:30 AM
  5. 2006 MySQL server has gone away
    By blueaura33 in forum General Questions
    Replies: 4
    Last Post: 7 Nov 2008, 06:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg