XF 2.2 dumping the database errors

[Jim Boy]

hey, usually when I try to do a mysqldump on my very large xf (2.2.15) database I get errors on certain tables causing the dump to fail. Errors are usually DDL being changed on tables like xf_table_view. Asking copilot, its response is that I should ignore that table and nine others in the dump command and that Xenforo will simply recreate them.

Is this true, is there a better way and is this actually documented somewhere?

 

[Rene_V]

Errors are usually DDL being changed on tables like xf_table_view.

There is no such xenforo default table a.f.a.i.k. Maybe it's added by a third party add on?

Asking copilot, its response is that I should ignore that table and nine others in the dump command and that Xenforo will simply recreate them.

What are the other tables mentioned in the error? My advice, if I may of course, is that such errors shouldn't be ignored because it can lead to an incomplete backup and restore afterwards.

usually when I try to do a mysqldump on my very large xf (2.2.15) database

By mysqldump, do you mean when using the mysqldump SSH command, or the mysqldumper script?

 

[Itworx4me]

hey, usually when I try to do a mysqldump on my very large xf (2.2.15) database I get errors on certain tables causing the dump to fail. Errors are usually DDL being changed on tables like xf_table_view. Asking copilot, its response is that I should ignore that table and nine others in the dump command and that Xenforo will simply recreate them.

Is this true, is there a better way and is this actually documented somewhere?

P

Post in thread 'How to duplicate MYSQL database on CentOS VPS?'

Mar 18, 2015

I prefer to use this for dumping:

mysqldump -u -p --single-transaction --skip-lock-tables database_name > /path/to/backup/database_name_$(date +%d.%m.%y).sql

• Paul B

•