mysqldump from the commandline. You are most likely running into php execution time limits using phpmyadmin
OR you could probably just copying the underlying files, .frm,MYI and MYD I've successfully done that with myisam databases going from version 4 - 5 on tables exceeding 50M rows. Not sure about innoDB though. On Mon, Mar 10, 2008 at 1:29 PM, Terry Babbey <[EMAIL PROTECTED]> wrote: > 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 > > [EMAIL PROTECTED], 519.542.7751 x3293 > > > > -- Help build our city at http://free-dc.myminicity.com !
