RE: Migrate HUGE Database

[Rolando Edwards <redwards@xxxxxxxxxxxxxx>]

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:parasane@xxxxxxxxx]
Sent: Monday, March 10, 2008 2:40 PM
To: Terry Babbey
Cc: mysql@xxxxxxxxxxxxxxx
Subject: Re: Migrate HUGE Database

On Mon, Mar 10, 2008 at 2:29 PM, Terry Babbey <terry@xxxxxxxxxxxxx> 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/mysql?unsub=redwards@xxxxxxxxxxxxxx


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx