MySQL Forums
Forum List  »  Backup

Re: Understanding mysqldump in a bit more detail
Posted by: Peter Brawley
Date: January 30, 2020 07:08PM

To see mysql dump options & defaults, run ...

mysqldump --help --verbose | more

To see what an invocation has actually done, inspect the dump file it has created.

DBs are deleted before being dumped into if --add-drop-database option is given.

By default tables are dropped before being created and populated.

For a command sequence to follow for resetting and restarting a slave: see "Reset slave" at

Options: ReplyQuote

Written By
Re: Understanding mysqldump in a bit more detail
January 30, 2020 07:08PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.