Can someone tell me what alternative to make backup copies of the web-based databases that are compatible with php7?

[VinylDisk]

Xenforo 2 and Xenforo Media Galery go better with php 7.

Can someone tell me what alternative to make backup copies of the web-based databases that are compatible with php7?

Regards

 

[VinylDisk]

https://github.com/DSB/MySQLDumper you could try this

It is not well designed for complex databases with BLOD fields such as XenForo.

This software gives me problems.

 

[VinylDisk]

As long as possible, I make backup copies by console:

mysqldump -v --opt --events --routines --triggers -umyser -pmypassword dbname > dbname_`date +%Y-%m-%d_%H_%M`.sql

Replace myuser on:
-umyser

Replace mypassword on
-pmypassword

 

[Paul B]

I have used mysqldump for years without issue.

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

 

[VinylDisk]

I have used mysqldump for years without issue.

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

The options is perfect:

--single-transaction --skip-lock-tables

 

[anon666]

It is not well designed for complex databases with BLOD fields such as XenForo.

This software gives me problems.

I found some problems with this software (MySQLDumper), so I stopped using it.

Surely it's for the reason that you indicate.