MySQLDumper

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 and PHP 8. 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


MySQLDumper
Summary Provides easy, reliable backup of TNG databases.
Validation
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
Notes
This is and easy to use Addon for your website.



Msd001.jpg
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.

Description

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

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.

Installation

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, https://example.com/dback, 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.

Backups

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