XMB Forum Software
Not logged in [Login - Register]
Go To Bottom

Printable Version  
Author: Subject: Suggestions for database back-up software?
Carolyn
Experienced
***




Posts: 6
Registered: 6-15-2002
Member Is Offline

Mood: No Mood

[*] posted on 2-15-2021 at 01:18 AM
Suggestions for database back-up software?


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.



View user's profile Visit user's homepage View All Posts By User
miqrogroove
XMB 1.9.12 Lead Developer
*********


Avatar


Posts: 421
Registered: 10-1-2002
Location: Florida
Member Is Offline

Mood: Past Three O'Clock

[*] posted on 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?
View user's profile Visit user's homepage View All Posts By User
bfgadmin
Member
***




Posts: 52
Registered: 5-7-2020
Location: Pittsburgh, PA
Member Is Offline

Mood: Technical

[*] posted on 3-31-2021 at 05:29 PM


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!




View user's profile Visit user's homepage View All Posts By User

  Go To Top

Powered by XMB 1.9.12 (Debug Mode)
XMB Forum Software © 2001-2020 The XMB Group
[Queries: 16] [PHP: 36.9% - SQL: 63.1%]