SMF Support > SMF 2.0.x Support

Cannot backup DB

<< < (2/3) > >>

MrPhil:

--- Quote from: Krash. on May 10, 2012, 11:38:12 PM ---That's a bit hairy for me, and need to be able to confirm that the backup is good, which is another problem.

--- End quote ---

Well, you could start with the SMF backup code. It needs fixing (see my sig > fixes), and then you would extend its function to read and back up just a section of a table at a time, rather than all records. It does require some PHP skills, of course.

To confirm that a backup is good, you can always make a scratch database and restore the backup file(s) into it. If no error messages, and the record count matches the original table(s) count, it's probably good. You could even make a scratch copy of your forum and see if it runs OK with the restored backup. If you want to be absolutely certain it's good, you'd have to write another PHP script to compare the two databases table by table and record by record. There may be code around somewhere to compare a backup file against a live database -- you could look around. You would need to put your live forum into maintenance mode while doing comparisons, so that it doesn't get updated in the meantime and give a false failure.

Krash.:

I can restore the backup to a scratch db on my server, but looks like it would be difficult on GoDaddy.  phpmyadmin isn't working well, and host options are limited.  Got the forum back up & running in 1.1.12 last night, so it's not a panic job.  Cleaned up the db, and it's around 106mb, so may be able to get a good cpanel backup.

Storman™:
As you've found, although GoDaddy is relatively cheap, the downside is that undertaking "normal" website tasks in the backend can be more frustrating than it's worth, partly due to the way they configure things.

Anyway, at least you are running for now. Maybe consider a different host at some stage if you want to expand your forum to the next level especially as your forum is growing in size.

I'll mark the topic as solved but feel free to post back at a later date if you encounter further issues.  ;)

Krash.:

Thanks.  It's the third GoDaddy forum I've worked on, and I've moved one to a better host, but this forum is just a part of a large website, so it would be a big project to move, and I wouldn't recommend it to the owner.  If I can get a good backup, I'll upgrade them to 2.0.2, otherwise we'll probably just clean up and leave it as is.

nend:
GoDaddy has cPanel? I have been using them for a few years and haven't notice no such thing. Must be the dedicated or Virtual servers. I know in their custom control panel you can back up and restore MySql databases at the click of a mouse button.

Navigation

[0] Message Index

[#] Next page

[*] Previous page