[BETA]Database Back-Up/Restore

[Thunderace]

This backs up your database "totally safe" but also restores (Be wary on a live DB)

When restoring the database needs to be fresh, i.e. free of tables due to the fact that it doesn't "drop" tables. (might add this later if required, and following more testing)

I do not accept responsibility for any problems caused by its use.

***Why do it?***

I know this has been done before but I've had endless problems trying to find a way to backup and restore my database. The backup programs on here and phpmyadmin  didn't work for me as it seemed not to backup all the tables (e.g mods & _topics) and wouldn't restore because of this and timeout/memory problems.

This mod gives two options in "Admin"

Restore Database
Back-Up Database

***Changes to mod file and one upload file***

This mod requires you to edit 2 files...the mod file and uploaddb.php (DB and URL/true path only)

Please make sure you back up english.lng, index.php and Sources/Admin.php

       ***After successful loading/modding please don't leave uploaddb.php in yabbse***

The restore Database feature (uploaddb.php) does not check for admin rights and can therefore be run via browser, you should upload this ONLY as and when you need to restore. (keep it on your desktop)

***Backup***
Creates a backup.sql file on your server (Without drop tables)

***Restore***
Restores your complete database

Note: I have excluded "drop tables" which means that to restore, the database needs to be totally fresh. (Newly set up DB)

Visual HERE

Download HERE

***Credits***
Original Backup Script by woodys
Restore Script by: -
Author:  Andrea Hubacher [email protected]

***Moderators***
If this is dangerous please remove and if there is a better option please redirect

[Tha Master]

Anyone tested this already???

[Thunderace]

LOL  

[Thunderace]

Well if you back up english.lng, index.php and Admin.php

Then the boardmod will do no harm

The 2 uploaded files will do no harm

The backup will do no harm

The only thing to watch is the restore, Don't try to restore to a populated Database.

My advice is to set up an empty "test" database with different user and password, restore to that initially.

[Dr_Michael]

Anybody has tested it?  

[Thunderace]

Just modded a fresh 1.4.1 and ran another backup/restore with no problems.

***Note for downloaders of the first mod***
You will need to take out the "is admin()" line from the top of uploadbd.php as with a blank database this doesn't work. Zip has been updated

[tdkyo]

This mod function is too important to test it. I am afraid it might screw up.

[Mr.Sins]

for people running theire own linux box and that want a graphical users interface for working with mysql

try http://www.webmin.com .

here you also have to functionality to backup your mysql db and add the drop db statement

[David]

for people running theire own linux box and that want a graphical users interface for working with mysql

try http://www.webmin.com .

here you also have to functionality to backup your mysql db and add the drop db statement

Why not just use phpMyAdmin which only does MySQL stuff and not all sorts of nix admin?

[Mr.Sins]

webmin has a plugin for mysqladmin, for mysql noobs like me its mutch easier to have a graph interface through you msie.

a gui is mutch more self explainable then a cmdl.

[David]

Have you ever looked at phpMyAdmin?

www.phpmyadmin.net

Here is a demo
http://www.phpmyadmin.net/phpMyAdmin/

[Mr.Sins]

i didn't know them thx.

the php coded interface is mutch faster then that of webmin it uses cgi.

but like you probably already guessed, i uses webmin for more then only my mysql stuff.

[Termite]

I installed this mod and I get an error when I try to backup.

An Error Has Occurred!

2: fopen("/home/site/public_html/yabbse/backup/backup.sql", "w") - Permission denied
(/home/site/public_html/yabbse/Sources/mysqlbackup.h ln 24

[Termite]

i uploaded a blank file called backup.sql to the backup dir and that fixed the problem. backuping up the database was successful.

---

oh yeah. i think it would be a good idea if you implemented a function that gzips the backup.sql file

[Thunderace]

You might want to edit that post, it shows your path m8