Migrate HUGE Database

Date: Mon, 10 Mar 2008 14:29:42 -0400
From: "Terry Babbey" <terry@xxxxxxxxxxxxx>
Subject: Migrate HUGE Database

Hello,

I have a huge database that I would like to migrate from a server
running 4.0.16 to a server running the Windows version 5.0.45. The
database is approximately 3,500,000 records. I get timeout errors using
PHPMyAdmin to export the data.

 

Does anyone have any suggestions for how I can do this?

 

Thanks,

Terry

 

Terry Babbey

Infrastructure Specialist

Information Technology, Lambton College of Applied Arts & Technology

terry@xxxxxxxxxxxxx, 519.542.7751 x3293

Follow-Ups:
- R: Migrate HUGE Database
  - From: Nanni Claudio
- Re: Migrate HUGE Database
  - From: Phil
- Re: Migrate HUGE Database
  - From: D Hill
- Re: Migrate HUGE Database
  - From: Rob Wultsch
- Re: Migrate HUGE Database
  - From: Daniel Brown

Prev by Date: Updating rows in a table with the information from the same table
Next by Date: MySQL 6.0.4 Alpha has been released ! (part 1 of 2)
Previous by thread: Updating rows in a table with the information from the same table
Next by thread: Re: Migrate HUGE Database
Index(es):
- Date
- Thread

lists-archives.org

Migrate HUGE Database