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
HEREDownload
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