From TNG_Wiki
Jump to navigation Jump to search
Restricted Downloads of MySQLDumper are restricted to logged in users. If you do not have a user account on the TNG Wiki use the Request Account link to request a user account Restricted
Caution If you are having trouble downloading with the Google Chrome browser, try using try right-click and select Open in new Window, then F5, or use another browser Caution

Ambox notice.png MySQLDumper has been tested with MySQLi, PHP 7, PHP 8 and 8.1. If you encounter any problems, please use the Mod Support link below to provide the details and we will look into it.
TNG 13.0

Summary Provides easy, reliable backup of TNG databases.
Mod Updated 25 Jan 2021
Download link
Download stats view statistics
Author(s) Daniel Schlichtholtz
Homepage Bisbee Family Connection
Mod Support Support for MySQLDumper
Contact Developer As above
Latest Mod 1.30.1
Min TNG V 9.0.0
Max TNG V 13.0
Files modified
Related Mods
This is and easy to use Addon for your website.

This program is amazingly useful for backing up your live website database and restoring an exact copy to an offline site you may be using for testing. It can also restore your live database if something should happen to it.


MySQLDumper (MSD) is a PHP and Perl based tool for backing up MySQL databases. You can easily dump your data into a backup file and - if needed - restore it. It is especially suited for shared hosting webspaces, where you don't have shell access. MySQLDumper uses a proprietary technique to avoid this problem. It only reads and saves a certain amount of data, then calls itself recursively via JavaScript and remembers how far in the backup process it was. The script then resumes backing up from that point.

The original Developer was Daniel Schlichtholtz who last published in 2012, after which he no longer maintained it. Several people have updated it since then, but most of these projects just fell by the way.

I have depended on MySQLDumper for many years during which time there were few comparable utilities to take its place. With each change to MySQL and PHP I was forced to upgrade my personal copy of MySQLDumper to keep it working. This version is my latest update, compatible with MySQLi, PHP 7 and PHP 8. -- Rick Bisbee

Note This is very important information!

When a database is restored by MSD, the indexes are not enabled by default. To re-enable the indexes after restoring a database you must do the following: As soon as MSD has successfully restored the database, click on the Database Overview button. If you see warning at the top of the page that your indexes have not been enabled, and some of the tables are notated in the Key State column as needing to be enabled, go to the bottom of the page and click on the button at the bottom right, Enable keys. The page will return showing all keys enabled.

If you want to go back and check later, in the MSD Home page, click on the Databases button at the top, then click on the database you want to check. Scroll down to the bottom of the page to see the status of our keys. If necessary, click on the 'Enable Keys' button at the bottom right.

Caveat and Disclaimer

As stated above, I did not write this program and I cannot guarantee that all of it works as intended by the author. As always, protect your database and use MSD at your own risk. One way to protect your live database is to use phpMyAdmin to make a copy of it. If something goes wrong, you can copy the replicated database back to your main.


MSD is installed by unpacking the download zip file and adding its folder to your TNG root directory, where you can name it anything you want -- I prefer "dback" (but then I live in Arizona).

Next, navigate a browser to your new folder, for example,, and follow the instruction to finish installing it. If you are installing on a live site, it is always good practice to password protect the MSD folder. MySQLDumper will offer to do that for you when you've finished installing it.

To view installation illustrations, go to How To Regularly Back Up Your Large MySQL Database with MySQLDumper

Updating To New Version

Updating an older version without losing your library of SQL backups is easy. Download and unzip the MySQLDumper package. Rename the folder to match the name of your current MSD folder and copy it over your current MSD folder.


Once the backup is finished you can find the zipped files stored in the /work/backup/ folder inside the folder where you installed MySQLDumper.

Potential Problem

Php.ini max_execution_time is 30 seconds by default. If you have a very large table in your database containing long strings of text, and restoring the sql file to your database seems to hang, increase the max_execution_time to 60.

TNG User Related feedback

I use htedit (german) to produce an .htaccess file that protects the MySQLDumper directory

  • Utilities recommended by Henny Savenije on User List

Sites using MySQLDumper

If you download and install this mod, please add your TNG site to the table below:
If you have any problem to do it, send me a mail...

URL User Note Mod-Version TNG-Version User-language
A Bisbee Family History Rick Bisbee A must-have for mod developers 1.30.1 13.1.2 EN
Our Roy and Boucher Family Ken Roy Essential database backup / restore tool 1.30.1 13.1.2 EN, FR