XMB Forum Software

Suggestions for database back-up software?

Carolyn - 2-15-2021 at 01:18 AM

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.

miqrogroove - 2-28-2021 at 04:46 PM

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?

bfgadmin - 3-31-2021 at 05:29 PM

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

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!