Thanks to all for the quick replies. Yes, the mysqldump worked perfectly. Boy do I feel like a newbie now!
If I use the method below, will that transfer the mysql admin database too with the user information? Thanks, Terry -----Original Message----- From: Rolando Edwards [mailto:[EMAIL PROTECTED] Sent: March 10, 2008 2:52 PM To: Daniel Brown; Terry Babbey Cc: mysql@lists.mysql.com Subject: RE: Migrate HUGE Database You can take this a step further nohup mysqldump -h<host of Linux Machine> -u<username> -p<password> --all-databases --routines --triggers | mysql -h<host of Windows Machine> -A This will pipe all the data directly to Windows machine without an intermittent file. Even if you logout of Linux, it should keep going -----Original Message----- From: Daniel Brown [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2008 2:40 PM To: Terry Babbey Cc: mysql@lists.mysql.com Subject: Re: Migrate HUGE Database On Mon, Mar 10, 2008 at 2: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. If you have shell access, do the following: mysqldump -u username -p database_name > database_name.sql To explain: -u username Replace 'username' with the database username. -p This signifies that you'll use a password (at a prompt) database_name The full name of the database to dump > Redirects all output to a file, deleting previous data, if any database_name.sql The SQL output file, written to the current directory. -- </Dan> Daniel P. Brown Senior Unix Geek <? while(1) { $me = $mind--; sleep(86400); } ?> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
