Снова про бэкап MySQL

[winhex]

Здравствуйте уважаемые, нужна ваша помощь по следующему вопросу.
Есть база mysql размером ~ 100 mb. Проблема в том, что внутри нее хранятся еще и блобы. Пока они лежали в ФС никаких проблем с бэкапом/восстановлением этой базы не было.
Сейчас пытаюсь бэкапить такой командой:

Код: Выделить всё

mysqldump --hex-blob -u [user] -p[pass] -f [base] | gzip -c | ssh user@XX.XX.XX.XX "cat > /home/backups/mysql_dump/2M-FO-blob-dst.sql.gz"

Дамп сливается, но в процессе валят такие ошибки:

Код: Выделить всё

mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'show fields from `og_templates`': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'show table status like 'og\_timeslots'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'show fields from `og_timeslots`': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'show table status like 'og\_user\_passwords'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'show fields from `og_user_passwords`': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'show table status like 'og\_user\_ws\_config\_categories'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'show fields from `og_user_ws_config_categories`': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'show table status like 'og\_user\_ws\_config\_option\_values'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'show fields from `og_user_ws_config_option_values`': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'show table status like 'og\_user\_ws\_config\_options'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'show fields from `og_user_ws_config_options`': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'show table status like 'og\_users'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'show fields from `og_users`': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'show table status like 'og\_workspace\_billings'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'show fields from `og_workspace_billings`': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'show table status like 'og\_workspace\_objects'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'show fields from `og_workspace_objects`': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'show table status like 'og\_workspace\_templates'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'show fields from `og_workspace_templates`': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'UNLOCK TABLES': MySQL server has gone away (2006)

Код: Выделить всё

uname -r
2.6.32-4-pve

OC Debian Lenny, 64bit

Но БД крутится в контейнере OpenVZ на Debian Squeeze

Код: Выделить всё

mysql-server (5.1.49-3)

[serzh-z]

Причины могут быть разными: http://dev.mysql.com/doc/refman/5.1/en/gone-away.html

[Ism]

MySQL server has gone away

Такое сообщение может быть, если опция max_allowed_packet слишком мала

http://flex-plex.ru/?p=66

[winhex]

MySQL server has gone away

Такое сообщение может быть, если опция max_allowed_packet слишком мала

http://flex-plex.ru/?p=66

Осталось неясным, пробовал указывать эту опцию mysqldump при копировании, но проблема осталась:

Код: Выделить всё

mysqldump --max_allowed_packet=2M -u [user] -p[pass] -f [base] | gzip -c | ssh user@XX.XX.XX.XX "cat > /home/backups/mysql_dump/2M-FO-blob-dst.sql.gz"

Или это опция сервера, и какой размер указывать?

[ivan2ksusr]

Код: Выделить всё

[mysqld]
...
max_allowed_packet=16M
...