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.
Backup & Restore for MySQL databases
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?
Hello,
nice that this good project continues...
With appropriate modifications the version numbers should be increased.
For Example to 1.24.5
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!
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.
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
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?
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.
In der Hoffnung, dass jemand das ganze übernimmt.
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.
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 ?
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.
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?
I need information about instalation.
thanks
Héctor Téllez Arias
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.
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.
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.
When restoring a 230 MB Mwediawiki 1.19 database i get the error
Sql:
Erweiterte Inserts: 1
Unbekannter SQL-Befehl::
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.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.