• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

mysqldump needed to backup XenForo?

Puntocom

Well-known member
#1
Hello, I'm making daily backups using dump (filesystem backups) and weekly ones using mysqldump.

Is it needed to use mysqldump due to innodb tables, or in case of problems I can just rebuild the search index and I am fine?
 
#2
Hello, Puntocom -


I run the mysqldump daily. The filesystem backup (at least of the directory tree where XenForo is installed) together with the mysqldump (this holds the user, post, thread, etc. information of your XenForo board) is needed to rebuild the board in case of a crash.

Search indexes are created from the current, existing content of the MySQL server database (i.e. it is redundant information).
 

Puntocom

Well-known member
#3
I was doing mysqldump daily but I have the problem for the forum not responding during the time it takes to make the backup.
I use
Code:
mysqldump -uxxx -pyyy --events db > db.sql
I have changed it to
Code:
mysqldump -uxxx -pyyy --single-transaction --events db > db.sql
Any idea? I want to backup at least daily but I don't want to cause any downtime.
 

teletubbi

Well-known member
#8
This is normal and there's nothing you can do about it as far as I know.
There is something.
Use percona and xtrabackup from them. There are no locks. Make hot backups.
My DB is ~ 5GB and i run a daily full backup and every 3 hours an incremental.
You don't even recognize that's a backup is running.