you might also try --opt as an argument to mysqldump such as:
mysqldump -u root --opt --add-drop-table db_name > output.dmp On Thu, 2005-06-02 at 08:46 +0200, [EMAIL PROTECTED] wrote: > Hi, > try stop server, cold copy to dev server, start on dev. > > mathias > Selon ManojW <[EMAIL PROTECTED]>: > > > 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]
