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
