Announcement

Collapse
No announcement yet.

Backup with MySQLMan

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Backup with MySQLMan

    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?
    www.MCSEboard.de
    German Windows Server & IT Pro Community dedicated to Windows Client & Server Systems. MVPs inside

  • #2
    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>

    Comment


    • #3
      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.

      Comment


      • #4
        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.

        Comment


        • #5
          Thanks for your expertise!
          -Tom
          www.MCSEboard.de
          German Windows Server & IT Pro Community dedicated to Windows Client & Server Systems. MVPs inside

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X