Results 1 to 1 of 1

Thread: Dump mysql database on server, Free Mysql Dumper php Script

  1. #1
    Administrator Jennifer's Avatar
    Join Date
    Jul 2010
    Posts
    99

    My Social Networking

    Add Jennifer on Facebook

    Cool Dump mysql database on server, Free Mysql Dumper php Script

    MySqlDumper Copyright (C)2004-2007 Daniel Schlichtholz (admin@daniel-schlichtholz.de) & Steffen Kamper

    Dump mysql database on server, Free Mysql Dumper php Script-loveyourdata-nohorn.png

    Dump mysql database on server, Free Mysql Dumper php Script-free-mysql-dumper.jpg

    This program is free software; you can redistribute it and/or modify it under
    the terms of the GNU General Public License as published by the Free Software
    Foundation; either version 2 of the License, or (at your option) any later
    version.

    This program is distributed in the hope that it will be useful, but WITHOUT
    ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
    FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
    details.

    You should have received a copy of the GNU General Public License along with
    this program; if not, write to the Free Software Foundation, Inc., 675 Mass
    Ave, Cambridge, MA 02139, USA.

    MySQLDumper features

    • Easy installation, easy handling - you don't have to be an expert to backup your databases. MySQLDumper controls nearly every potential error pit automatically without bothering you with technical details.
    • Before you start a backup all your parameters are shown again, so you definitely know what you are doing :-)
    • Faster backups und restore (compared to older versions of MySQLDumper)
    • Send Emails with or without your dumpfile attached / you can set the maximum size of the attachement. If it grows bigger it won't be attached. If you need the sending of backups via E-Mail you can use Multidump and let MySQLDumper split the data into several files. You can define the split size in the configuration and MySQLDumper will mail you each file seperately.
    • Send dumpfiles via FTP to up to 3 different server. This is also working using the multipart feature.
    • MySQLDumper can read Dumpfiles from other scripts via the integrated parser (for example from phpMyAdmin)
    • Security: MySQLDumper can generate a .htaccess-file to protect itself and all of your backup-files
    • MySQLDumper can do Multipart-Backups. That means: it can automatically split the dumpfile if it gets bigger than your chosen size. When you want to restore a backup and choose the wrong part - it doesn' matter: MySQLDumper will notice that and will get the correct startfile automatically.
    • SQL-Browser: You have access to your MySQL-Tables. You can delete tables, edit or insert data. You can run/ save any SQL-Statement.
    • Database-Overview: look at running processes or even stop them
    • Very good file-overview: backups of the same database are shown as one entry. Click it to see all of the files.
    • Automatic file-deletion: set your own rules to delete old backups. Specify the number of backups you want to hold and let MySQLDumper automatically delete the older ones to save server webspace.
    • Perl Cronscript: all features of the PHP-Script are integrated in a Perlscript (crondump.pl) that can be started via a Cronjob. When you are allowed to run Perl on your space you can automatically let MySQLDumper backup your database at defined times automatically on a regular basis. This way you can't forget to do a backup!
    • Complete log files: watch the log files and you know what happened.
    • Since 2003 MySQLDumper continues to be developed.
    • ect. ect. ect ...


    Installation:

    - upload the folder mysqldumper to your webspace
    - chmod the file "config.php" to 777
    - start the script in your browser (http://www.deineDomain.de/mysqldumper/)
    - Follow the Installationscript
    - in step 2 (Configuration) change Data (Host, Name, Password) of your databaseconnection and save
    - in case of safe_mode=1 you must create the folders manually.
    create following folders in the Scriptdir:

    Code:
         - work
         - work/backup
         - work/config
         - work/structure
         - work/log
    and chmod these folders to 0777

    - Ready !



    Guidance for the Perl script:

    When you can execute Perl anywhere:

    1. In MySQLDumper switch to the page Backup.
    2. Copy the path, that stands behind entry in crondump.pl for $absolute_path_of_configdir:
    3. open the file "crondump.pl" in the editor
    4. paste the copied path there to the $absolute_path_of_configdir-variable (no blanks,no new line)
    5. Save crondump.pl
    6. chmod the scripts to 0755.
    7. If the ending .cgi is desired, change the ending of all 3 files from .pl to .cgi (rename)
    8. If the Scripts are renamed to *.cgi , change Fileextension to cgi in the MySQLDumper Configuration (cronscript)

    Done.

    --------------------------------------
    When perl is only allowed in cgi-bin:

    Many user have a cgi-bin directory, in which Perl can be executed.
    This is usually available via Browser http://www.domain.com/cgi-bin/ .

    In this casse do the following steps:

    1. in MySQLDumper call the page Backup and click "Backup Perl".
    2. Copy the path, that stands behind entry in crondump.pl for $absolute_path_of_configdir:
    3. open the file "crondump.pl" in the editor
    4. paste the copied path there with absolute_path_of_configdir (no blanks, no new line)
    5. Save crondump.pl
    6. copy crondump.pl, as well as perltest.pl and simpletest.pl to the cgi-bin directory (ASCII mode in the ftp-client!)
    7. chmod 755 the scripts to 0755.
    7b. If the ending cgi is desired, change the ending of all 3 files .pl to .cgi (rename)
    8. in MySQLDumper switch to the page Configuration
    9. click on Cronscript
    10. change the Perl execution path to /cgi-bin/ or ./../cgi-bin (depending on your file-structure. Path is relative from MSD-Dir)
    10b. if the Scripts are renamed to *.cgi , change Fileextension to cgi
    11 save the Configuration
    -------------------------------------

    Ready ! The scripts are now available from the Page "Backup".


    Windowsuser must change the first line of all Perlscripts, to the path of Perl.

    Example:
    Code:
    instead of:  #!/usr/bin/perl w 
    now #!C:\perl\bin\perl.exe w
    Attached Files Attached Files

Similar Threads

  1. MySQL server status with mysqlreport report script
    By Meer in forum Server Administration
    Replies: 1
    Last Post: 08-15-2011, 05:54 AM
  2. PHP not connecting to a MySQL database server
    By Meer in forum Server Administration
    Replies: 0
    Last Post: 10-09-2010, 10:16 PM
  3. Replies: 0
    Last Post: 10-09-2010, 09:48 PM
  4. Replies: 0
    Last Post: 10-06-2010, 06:47 PM
  5. How to Dump just the table structure to a file in MySQL
    By AP admin in forum Database Administration
    Replies: 0
    Last Post: 07-28-2010, 08:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •