Backup with MySQLMan

[Thomas P]

Hi there,

I'm about to backup the vB db with MySQLMan from http://www.gossamer-threads.com/scri...lman/index.htm as I read here that MySQLMan achieves this tasks better than PHPMyAdmin (I have no telnet access).

Clicking on dump database confronts me with a couple of options:

MySQLMan: SQL Dump

1.1) Dump to screen.
1.2) Dump to file. Path: (...)

Select tables:
2.1 Dump all tables in database mcseboard
2.2 Dump selected tables only

(list of all tables)


CREATE TABLE statements:
3.1 Write CREATE TABLE statements.
3.1.1 Options: Add a DROP TABLE IF EXISTS statement before each CREATE TABLE statement.
(--add-drop-table)
3.2 Do not write CREATE TABLE statements.
(--no-create-info)

INSERT statements:
4.1 Write INSERT statements.
Options:
4.1.1 Use INSERT statements that name each column to be inserted.
(--complete-insert)
4.1.2 Write INSERT DELAYED statements.
(--delayed-insert)
4.1.3 Write multiple-row INSERT statements.
(--extended-insert)
4.2 Do not write table data.
(--no-data)

Maybe someon can look it over and state the appropriate opts?
Thanks in advance,
-Tom

P.S.: I'd go for 1.2 - 2.1 - 3.1? - 3.1.1? (umm...?) - 4.1? - 4.1.1?

[Mike Sullivan]

1.2

2.2 -- don't dump searchindex and word. But, if you ever have to restore, you'll need to rebuild your searchindex! (if you don't want to do that, you need to dump those two tables)

3.1
3.1.1

4.1
<no 4.1.x option -- although 4.1.3 wouldn't be bad>

[BobHope]

I use this program as well and always dump with ALL options set (which is the default). Would this be the same as doing a dump via telnet in that all sections are dumped? Why would deselecting some options really matter other than making the dump smaller.

[Mike Sullivan]

Originally posted by BobHope
Why would deselecting some options really matter other than making the dump smaller.

It doesn't.

There's just a few options you shouldn't have selected (--no-create-info and --no-data) -- the rest don't make a huge deal actually.

[Thomas P]

Thanks for your expertise!
-Tom