If you just dump the structure with mysqldump and then build
SELECT INTO OUTFILE .... and LOAD DATA INFILE ....
statements for each table, the process will run faster than even the
"extended insert" option of mysqldump.
-----Original Message-----
From: ManojW [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 01, 2005 7:01 PM
To: mySQL list
Subject: Mysqldump
Greetings,
I took a dump of (pretty chunk) database, the output is close to 45G. I
am trying to reload this dump file onto a development server but it's
taking looooong time to load the database. Is their a faster way to load the
data in? I am using plain and simple mysql < dump.sql syntax on a Mysql
4.0.24 server.
Thanks in advance!
Cheers
Manoj
--
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]
