On Tue, 2007-06-19 at 11:46 +0800, [EMAIL PROTECTED] wrote: > This must not be > mysqldump --opt -u root -p live > > it must be > mysqldump --opt -u root -plive
actually live is the database name! > Then you need to be consistant (what is --opt ??) >From the manpage... ยท --opt This option is shorthand; it is the same as specifying --add-drop-table --add-locks --create-options --disable-keys --extended-insert --lock-tables --quick --set-charset. It should give you a fast dump operation and produce a dump file that can be reloaded into a MySQL server quickly. The --opt option is enabled by default. Use --skip-opt to disable it. See the discussion at the beginning of this section for information about selectively enabling or disabling certain of the options affected by --opt. MySQL v5.0 in Ubuntu. -- Simon Wong <[EMAIL PROTECTED]> -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html