Page 1 of 1

How to get MySQL backups?

Posted: Mon Dec 16, 2024 1:49 pm
by dls
Until last week, I was not aware about no more shell access.
I want to get backups/dumps of my MySQL databases (I think I have two)

A tech support person tried to tell me that if it does not show up in member tools, that I dont have a DB. That's false, since I am running a WordPress install that does run off of MySQL.

So, is there any method to get at our own databases?

I do think that taking away shell access was a bad move, and I will be cancelling my account soon (but I need my data first)

Re: How to get MySQL backups?

Posted: Tue Dec 17, 2024 1:05 pm
by joemuller
I've placed the latest full database backups (in mysqldump format) into a folder called 'database_backups' on your account. They should be downloadable via FTP from ftp.sonic.net using your 'dls' account.

-- Joe M

Re: How to get MySQL backups?

Posted: Tue Dec 17, 2024 3:19 pm
by dls
thanks much Joe! I would have done it myself, but us users dont have access to the tools. Cheers

Re: How to get MySQL backups?

Posted: Wed Dec 18, 2024 11:47 am
by joemuller
Glad I could help out!

Just for completeness, the Databases portion of Member Tools is still around, but it will not show the database for your (and many others') sites because they were set up with our One-Click installer. A choice was made when designing the One-Click Install to not present the database connection information or configure the extra bits necessary to use the Database Management tools. (phpMyAdmin with some extra authentication)

Regardless of how the Wordpress site was set up, if the database is on Sonic's servers (see the DB_NAME line in wp-config.php), we can provide the latest nightly backup (in mysqldump format) by customer request.

-- Joe M