Announcement

Collapse
No announcement yet.

Options for mysqldump via SSH

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

  • Options for mysqldump via SSH

    Just wondering what the consequence is of not including the -Q option in the command below when taking a MYSQL dump?

    PHP Code:
    mysqldump --opt --u dbusername -p databasename backupname.sql 

  • #2
    •--quick, -q
    This option is useful for dumping large tables. It forces mysqldump to retrieve rows for a table from the server a row at a time rather than retrieving the entire row set and buffering it in memory before writing it out.
    http://dev.mysql.com/doc/refman/5.0/...ysqldump_quick

    vb_backup.sh has this, but I do not for my small site..

    Comment


    • #3
      Thanks for that. I seemed to have missed this reply for some reason. Ta!

      Comment

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