dsb/mysqldumper

Backup & Restore for MySQL databases

MySQLDumper

Backup & Restore for MySQL databases

This project is no longer maintained and inactive. Please take a look for alternatives.

Adding version 1.24 as master to make bug fixing via pull request as easy as possible.

mysqldumper's Issues

PHP7

Hi, with PHP7 and the latest version from here the install ends on Step 2.
Title Step 2 is visible, nothing else.

Can somebody confirm?

XSS Vulnerability

There are multiple instances of XSS within MySQLDumper. Some of them are stored, which implies that it will persist for all users and social engineering is not required.

The easiest way to patch this is simply use htmlentities every time you echo something.

If the database name is an XSS payload, it will execute the javascript when viewing the databases possible within the application.

Backup: Set database name

I created a backup file of my database, successfully. After i tried to import the generated sql file in phpMyAdmin. I get an error because the file does not set the database name.

I got it to work by modifying the "functions_dump.php". I have added "$statuszeile.="USE {$databases['Name'][$dump['dbindex']]};".$nl;".

Is this a good modification or is there another method?

Delete backups of deleted databases? Or sort by "last backup"?

I often delete databases and I am wondering if there is a feature to delete the backups of old, deleted databases, because I also do not need the backups anymore.

Alternativly I tried to click on the table header "Last Backup" (german: "letztes Backup") in the overview of all backups/databases, but there is no sort function for this table, when clicking on the table header.
Otherwise I could relativly fast delete the old backups manually.

http://forum.mysqldumper.de - Ende des Projekts MySQLDumper

Hallo @DSB

Ich habe gerade deine News auf gelesen.
Es ist schade, dass du dein Engagement beendest und auch, dass sich niemand findet, der es bislang übernehmen möchte.

Ich möchte aber dennoch einen Vorschlag für eine letzte Bemühung zur sauberen Abwicklung machen.

• Bitte mache ein Letztes Release mit einer höheren Versionsnummer.
• Bitte aktualisiere den Banner auf http://www.mysqldumper.de mit dem Hinweis auf das Ende deines Engagements.
• Bitte verlinke den Download Button von sourcforge auf diese Seite hier. Auch der Link unter "Zusätzliche Services" verweist auf eine Falsche, sogar nicht vorhandene Seite.
• Verweise bitte auch von https://sourceforge.net/projects/mysqldumper/ auf diese Seite hier.
• Aktualisiere zudem bitte die README.md um diese Info

In der Hoffnung, dass jemand das ganze übernimmt.

Change the Version-Number

Hello,

nice that this good project continues...
With appropriate modifications the version numbers should be increased.
For Example to 1.24.5

Backup: INSERT INTO

At the moment the MySQLDumper create for every data-set one INSERT INTO.

Give it a way to combine it as a insert-block like INSERT INTO ... VALUES more than this one data-set ?

PERL Automatic save - Select tables

Hi @DSB,

how to add the possibility to select table for PERL automatic save?

I know this db_actual_tableselected in PHP config file, how to add in mysqldumper.conf.php and crondump.pl files?

a new php 7 release...?

according to the latest changes in the german wikipedia, MySQLDumper from github is compatible with PHP 7...

if that's correct, wouldn't it be a good idea to release a new version, to make it clear for everyone, that this project is still maintained and also easy to decide which version should be used? - and if not, a correction of the wikipedia-article would be appropriate.

thanks in advance for some clarification!

Restore problem

When restoring a 230 MB Mwediawiki 1.19 database i get the error
Sql:
Erweiterte Inserts: 1
Unbekannter SQL-Befehl::

Max execution time

I am working with Mysqlumper master under xampp php7.025
When restoring a database of 835 MB (generated at strato with by phpmyadmin ) i get after some minutes the error
Fatal error: Maximum execution time of 30 seconds exceeded in L:\xammp7025\htdocs\Dumper\restore.php on line 131 - change of 100-10000 to 5000-20000 has no effect.

Incorrect number of fields

the actual number of recordrs is 776

MSD 1.24.4: str_replace issue if path contains 'inc'

In: inc/functions_global.php on function Realpfad there is a str_replace call which removes the string 'inc' from path.

function Realpfad($p) { global $config; $dir=dirname(__FILE__); $dir=str_replace('inc','',$dir); $dir=str_replace('\\','/',$dir); $dir=str_replace('//','/',$dir); if (substr($dir,-1)!='/') $dir.='/'; return $dir; }
This causes problems if you have this string mentioned in your path, e.g.:

/var/www/distinct/mysqldumper/

will be replaced to:

/var/www/distt/mysqldumper/

which results in an endless loop later on because the path does not exist on the system usually ;-)
A quick & dirty fix which resolved it for me was:

$dir=str_replace('/inc','',$dir);

the "/inc" is not used elsewhere in my path so it works, but it wouldn't work if somebody uses:

/var/www/incasdf/mysqldumper/

for example.

MySQLDumper :: SQL-Browser "Columns" reading bug

Hello, when I'm browsing some tables, the "SQL Browser" is showing some wrong table constellations. So I can't read the data statements inside a table when opening with the SQL-Browser of MySQLDumper.

Instalación?

I need information about instalation.

thanks

Héctor Téllez Arias

msdtrigger - Starting MySQLDumper from an Windows PC

Hallo,

leider bin ich des Englischen nicht ausreichend mächtig, aber:
Ich habe mir vor 3 Jahren mal ein Programm erstellen lassen, das die Datenbanksicherungen des MySQLDumpers von einem Windows-PC aus startet. (mit Visual Studio 2010)

Allerdings müssen in die XML Steuerdatei die entsprechenden Logindaten im Klartext eingetragen werden (Sicherheitsrisiko)! Die Verbindung kann jedoch auch per SSL aufgebaut werden.

Vielleicht möchte es dennoch der ein oder andere für seine Projekte nutzen, es liegt auch im Quelltext vor...
https://github.com/Code-4-All/msdtrigger

UTF8 - BIN

When i make a backup then i have the choice between several versions like UTF-8 UTF-16 etc. When i install Mediawiki (like 1.27.4) i can choose between bin and UTF-8 . What must i do to get the original 'BIN'
which is recommended.

Uncaught Error: Call to undefined function ereg()

I tried newest MySQLDumper from Github because of PHP7. After updating of all files, I started a test. The backup or restore worked without problems. However, I found a problem if I want to delete a backup file.

`Uncaught Error: Call to undefined function ereg() in \msd\inc\functions.php:89
Stack trace:
#0 \msd\filemanagement.php(201): DeleteFilesM('work/backup/', 'database_2016...')
#1 {main}

thrown in \msd\inc\functions.php on line 89`

Please for help or fix.