Difference between revisions of "MySQLDumper"
Regis Carr (talk | contribs) |
Regis Carr (talk | contribs) |
||
| Line 82: | Line 82: | ||
| EN | | EN | ||
|- | |- | ||
| + | |||
| [https://www.royandboucher.com/tng/index.php Our Roy and Boucher Family] | | [https://www.royandboucher.com/tng/index.php Our Roy and Boucher Family] | ||
| [[User:KenRoy|Ken Roy]] | | [[User:KenRoy|Ken Roy]] | ||
| Line 95: | Line 96: | ||
| 14.0.4 | | 14.0.4 | ||
| EN,DE,CS | | EN,DE,CS | ||
| − | + | |- | |
| + | |||
| [https://www.CarrFamilyTree.com/ Carr’s Garage] | | [https://www.CarrFamilyTree.com/ Carr’s Garage] | ||
| [[User:Regis Carr | Regis Carr]] | | [[User:Regis Carr | Regis Carr]] | ||
| Line 102: | Line 104: | ||
| v14.0.3 | | v14.0.3 | ||
| EN, DE, NO | | EN, DE, NO | ||
| + | |- | ||
} | } | ||
Revision as of 12:09, 30 April 2024
|
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 |
|
|
If you have trouble downloading with Google Chrome, Vivaldi, Brave or other Chromium based browser, try using a right-click and select Open in new Window, then F5, or use another browser such as Firefox
|
|
|
MySQLDumper applies to TNG version 14.0 notes = MySQLDumper has been tested with MySQLi, MariaDB, PHP 7, PHP 8.1 and 8.2. If you encounter any problems, please use the Mod Support link below to provide the details and we will look into it. |
|
| MySQLDumper | ||||
|---|---|---|---|---|
| Summary | Provides easy, reliable backup of TNG databases. | |||
| Validation | ||||
| Mod Updated | 5 Feb 2023 | |||
| Download link | For
| |||
| Download stats | view statistics | |||
| Author(s) | Daniel Schlichtholtz | |||
| Homepage | MySQLDumper | |||
| Mod Support | Support for MySQLDumper | |||
| Contact Developer | As above | |||
| Latest Mod | 1.30.3 | |||
| Min TNG V | 9.0.0 | |||
| Max TNG V | 14.0 | |||
| Files modified | ||||
| Related Mods | ||||
| Notes | Tested with PHP 8.2 and both MySql AND MariaDB | |||
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. A major benefit of using MySQLDumper over phpMyAdmin is that it backs up and restores in measured segments so that it does not time out, even with larger databases.
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 timing out when dealing with large databases. 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 through PHP 8.2 -- Rick Bisbee
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.
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
- Fantastic backup tool for big databases - Hans Weebers
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 |
| Roots & Relatives Remembered | Ron Krzmarzick | Public & Private ..fast and reliable. | 1.30.1 | 14.0.4 | EN,DE,CS |
| Carr’s Garage | Regis Carr | Public & XAMPP | v14.x.x | v14.0.3 | EN, DE, NO |
