I've been backing up my forum's database with MySqlDumper for about 15 years. It's been very simple to use. However, my server host recently updated to PHP 7.4 and the last version of MySqlDumper (ver. 1.24.4, which dates from at least 2009) won't work with PHP 7.4.

Can anyone suggest an alternative? The sql file from my most recent back-up (before the PHP upgrade) is 165 MB, so my database isn't huge but it is also not small.

Does it need to be automatic, or do you pull the backup using your web browser?

Do you have SSH access?

Is your mysql server local only, or can you login remotely with a mysql client?

Here's how I do it, personally, via a scheduled task (Windows Server 2016 environment):

Code:

mysqldump -u username -p dbname > I:\Enterprise Admin Share\backup\[date_time]\dbname.sql

But since you can't use mysqldump, I may have another idea. For xmbhost, we allow people to download their database directly from the web hosting control panel. I will see if I can un-specialize our code!