Can't Restore Bugzilla Database to New MySQL Server Box - Mozilla

This is a discussion on Can't Restore Bugzilla Database to New MySQL Server Box - Mozilla ; Hello there, I'm running into problems trying to restore my Bugzilla "bugs" database on a new server box. The new box is identical to the previous, running MySQL 5.0.45-community-nt edition. My configuration: Old Bugzilla Box: Windows XP SP2 MySQL 5.0.45-community-nt ...

+ Reply to Thread
Results 1 to 2 of 2

Thread: Can't Restore Bugzilla Database to New MySQL Server Box

  1. Can't Restore Bugzilla Database to New MySQL Server Box

    Hello there,

    I'm running into problems trying to restore my Bugzilla "bugs" database on a new server box. The new box is identical to the previous, running MySQL 5.0.45-community-nt edition.

    My configuration:

    Old Bugzilla Box:
    Windows XP SP2
    MySQL 5.0.45-community-nt edition
    MySQL Client version 5.1.11
    MySQL Administrator 1.2.12
    Bugzilla Version 2.22

    New Bugzilla Box:
    Windows Server 2003
    MySQL 5.0.45-community-nt edition
    MySQL Client version 5.1.11
    MySQL Administrator 1.2.12
    Bugzilla Version 2.22

    When I try and restore my .sql export file via the MySQL Administrator on the new Bugzilla box, I get to about 10% progress before a MySQL error is flagged - "The server has returned this error message:MySQL server has gone away", "The restoration failed". My .sqlfile I'mm trying to import is ~51 MB.

    My backup configuration settings on the Old bugzilla:
    Backup Execution Method - InnoDB Online Backup, Complete backup [checked]
    Output File Options - defaults (Complete INSERTS, Comment, Add Drop Statements, Disable)

    Does the backup through MySQL Administrator have to be saved in a certain way to allow migration to a new box?

    Any comments would be greatly appreciated!

    -bonzo3671



    __________________________________________________ __________________________________
    Looking for last minute shopping deals?
    Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsea...egory=shopping

  2. Re: Can't Restore Bugzilla Database to New MySQL Server Box

    Try this:

    Go to a command prompt:
    cd C:\Program Files\MySQL\MySQL Server 4.1\bin
    mysql -u root -pPASSWORD DBNAME < c:\dummyBugzilla.sql


+ Reply to Thread