tachtler:mysqldumper
Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen RevisionVorhergehende Überarbeitung | |||
tachtler:mysqldumper [2012/05/08 23:06] – klaus | tachtler:mysqldumper [Unbekanntes Datum] (aktuell) – gelöscht - Externe Bearbeitung (Unbekanntes Datum) 127.0.0.1 | ||
---|---|---|---|
Zeile 1: | Zeile 1: | ||
- | ====== MySQLDumper ====== | ||
- | |||
- | [[http:// | ||
- | |||
- | ===== Voraussetzungen ===== | ||
- | |||
- | Als Voraussetzung für die Installation von [[http:// | ||
- | * Lauffähiger Web-Server z.B. [[http:// | ||
- | * PHP ab der Version 4 oder höher [[http:// | ||
- | * Perl [[http:// | ||
- | |||
- | ===== Herunterladen ===== | ||
- | |||
- | Die aktuelle Version von [[http:// | ||
- | * '' | ||
- | |||
- | ===== Installation ===== | ||
- | |||
- | Ab hier werden '' | ||
- | < | ||
- | $ su - | ||
- | Password: | ||
- | </ | ||
- | |||
- | Nach dem herunterladen des Archivs in das Verzeichnis - hier z.B. ''/ | ||
- | < | ||
- | # cd /tmp | ||
- | </ | ||
- | |||
- | Anschließend muss dieses Archiv mit nachfolgendem Befehl entpackt werden: | ||
- | < | ||
- | # unzip / | ||
- | </ | ||
- | |||
- | Anschließend sollte ein neues Verzeichnis mit dem **abweichenden Namen** - | ||
- | * **'' | ||
- | im Verzeichnis ''/ | ||
- | |||
- | Das Verzeichnis sollte nun mit nachfolgendem Befehl gleichzeitig umbenannt und in das Verzeichnis | ||
- | * **''/ | ||
- | verschoben werden: | ||
- | < | ||
- | # mv / | ||
- | </ | ||
- | |||
- | Jetzt kann das nicht mehr benötigte Archiv im Verzeichnis ''/ | ||
- | < | ||
- | # rm / | ||
- | </ | ||
- | |||
- | Anschließend ist es noch notwendig folgende Verzeichnisse im Verzeichnis ''/ | ||
- | < | ||
- | # mkdir / | ||
- | # mkdir / | ||
- | # mkdir / | ||
- | # mkdir / | ||
- | </ | ||
- | |||
- | Abschließend ist es noch notwendig die benötigten Besitzrechte und vereinzelt Dateirechte dem neuen Verzeichnis und einzelnen Unterverzeichnissen mit dessen Inhalt durch nachfolgendem Befehl zuzuweisen: | ||
- | < | ||
- | # chown -R root.root / | ||
- | # chown apache.apache / | ||
- | # chmod -R 755 / | ||
- | </ | ||
- | |||
- | ==== Erweiterungen installieren ==== | ||
- | |||
- | === Backups via E-Mail === | ||
- | |||
- | Um Backups via e-Mail versenden zu können, ist es notwendig das [[http:// | ||
- | * **MIME:: | ||
- | zu installieren! | ||
- | |||
- | Zur Installation der Web-Anwendung [[http:// | ||
- | * **'' | ||
- | installiert werden. | ||
- | |||
- | Mit nachfolgendem Befehl, wird das Pakete **'' | ||
- | < | ||
- | # yum install perl-MIME-Lite | ||
- | Loaded plugins: fastestmirror, | ||
- | Loading mirror speeds from cached hostfile | ||
- | 54 packages excluded due to repository priority protections | ||
- | Setting up Install Process | ||
- | Resolving Dependencies | ||
- | --> Running transaction check | ||
- | ---> Package perl-MIME-Lite.noarch 0: | ||
- | --> Processing Dependency: perl(MIME:: | ||
- | --> Processing Dependency: perl(Email:: | ||
- | --> Processing Dependency: perl(Mail:: | ||
- | --> Running transaction check | ||
- | ---> Package perl-Email-Date-Format.noarch 0: | ||
- | ---> Package perl-MIME-Types.noarch 0: | ||
- | ---> Package perl-MailTools.noarch 0: | ||
- | --> Processing Dependency: perl(Date:: | ||
- | --> Processing Dependency: perl(Date:: | ||
- | --> Running transaction check | ||
- | ---> Package perl-TimeDate.noarch 1: | ||
- | --> Finished Dependency Resolution | ||
- | |||
- | Dependencies Resolved | ||
- | |||
- | ================================================================================ | ||
- | | ||
- | Size | ||
- | ================================================================================ | ||
- | Installing: | ||
- | | ||
- | Installing for dependencies: | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | |||
- | Transaction Summary | ||
- | ================================================================================ | ||
- | Install | ||
- | Upgrade | ||
- | |||
- | Total download size: 265 k | ||
- | Installed size: 523 k | ||
- | Is this ok [y/N]: y | ||
- | Downloading Packages: | ||
- | (1/5): perl-Email-Date-Format-1.002-5.el6.noarch.rpm | ||
- | (2/5): perl-MIME-Lite-3.027-2.el6.noarch.rpm | ||
- | (3/5): perl-MIME-Types-1.28-2.el6.noarch.rpm | ||
- | (4/5): perl-MailTools-2.04-4.el6.noarch.rpm | ||
- | (5/5): perl-TimeDate-1.16-11.1.el6.noarch.rpm | ||
- | -------------------------------------------------------------------------------- | ||
- | Total 1.8 MB/s | 265 kB | ||
- | Running rpm_check_debug | ||
- | Running Transaction Test | ||
- | Transaction Test Succeeded | ||
- | Running Transaction | ||
- | Installing | ||
- | Installing | ||
- | Installing | ||
- | Installing | ||
- | Installing | ||
- | |||
- | Installed: | ||
- | perl-MIME-Lite.noarch 0: | ||
- | |||
- | Dependency Installed: | ||
- | perl-Email-Date-Format.noarch 0: | ||
- | perl-MIME-Types.noarch 0: | ||
- | perl-MailTools.noarch 0: | ||
- | perl-TimeDate.noarch 1: | ||
- | |||
- | Complete! | ||
- | </ | ||
- | |||
- | Mit nachfolgendem Befehl kann überprüft werden, welche Inhalte mit den Paket **'' | ||
- | < | ||
- | # rpm -qil perl-MIME-Lite | ||
- | Name : perl-MIME-Lite | ||
- | Version | ||
- | Release | ||
- | Install Date: Mon 14 Nov 2011 08:34:27 AM CET Build Host: c6b6.bsys.dev.centos.org | ||
- | Group : Development/ | ||
- | Size : 189936 | ||
- | Signature | ||
- | Packager | ||
- | URL : http:// | ||
- | Summary | ||
- | Description : | ||
- | MIME::Lite is intended as a simple, standalone module for generating (not | ||
- | parsing!) MIME messages... specifically, | ||
- | decent single- or multi-part message with text or binaryattachments. | ||
- | not require that you have the Mail:: or MIME:: modules installed. | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | </ | ||
- | |||
- | === Backups via Perl-Scripts === | ||
- | |||
- | Um Backups via Perl-Script erstellen zu können, ist es notwendig das [[http:// | ||
- | * **CGI/ | ||
- | zu installieren! | ||
- | |||
- | Zur Installation der Web-Anwendung [[http:// | ||
- | * **'' | ||
- | * **'' | ||
- | * **'' | ||
- | * **'' | ||
- | installiert werden. | ||
- | |||
- | Falls die Datenbank [[http:// | ||
- | * **'' | ||
- | ebenfalls erforderlich! | ||
- | |||
- | Mit nachfolgendem Befehl, wird das Pakete **'' | ||
- | < | ||
- | # yum install perl-CGI | ||
- | Loaded plugins: fastestmirror, | ||
- | Loading mirror speeds from cached hostfile | ||
- | 54 packages excluded due to repository priority protections | ||
- | Setting up Install Process | ||
- | Resolving Dependencies | ||
- | --> Running transaction check | ||
- | ---> Package perl-CGI.x86_64 0: | ||
- | --> Finished Dependency Resolution | ||
- | |||
- | Dependencies Resolved | ||
- | |||
- | ================================================================================ | ||
- | | ||
- | ================================================================================ | ||
- | Installing: | ||
- | | ||
- | |||
- | Transaction Summary | ||
- | ================================================================================ | ||
- | Install | ||
- | Upgrade | ||
- | |||
- | Total download size: 191 k | ||
- | Installed size: 401 k | ||
- | Is this ok [y/N]: y | ||
- | Downloading Packages: | ||
- | perl-CGI-3.49-115.el6.x86_64.rpm | ||
- | Running rpm_check_debug | ||
- | Running Transaction Test | ||
- | Transaction Test Succeeded | ||
- | Running Transaction | ||
- | Installing | ||
- | |||
- | Installed: | ||
- | perl-CGI.x86_64 0: | ||
- | |||
- | Complete! | ||
- | </ | ||
- | |||
- | Mit nachfolgendem Befehl kann überprüft werden, welche Inhalte mit den Paket **'' | ||
- | < | ||
- | # rpm -qil perl-CGI | ||
- | Name : perl-CGI | ||
- | Version | ||
- | Release | ||
- | Install Date: Mon 14 Nov 2011 09:55:59 AM CET Build Host: c6b4.bsys.dev.centos.org | ||
- | Group : Development/ | ||
- | Size : 410902 | ||
- | Signature | ||
- | Packager | ||
- | URL : http:// | ||
- | Summary | ||
- | Description : | ||
- | CGI.pm is a stable, complete and mature solution for processing and | ||
- | preparing HTTP requests and responses. Major features including processing | ||
- | form submissions, | ||
- | generation and manipulation, | ||
- | Some HTML generation utilities are included as well. | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | </ | ||
- | |||
- | Mit nachfolgendem Befehl, wird das Pakete **'' | ||
- | < | ||
- | # yum install perl-DBI perl-Compress-Zlib perl-Net-FTPSSL | ||
- | Loaded plugins: fastestmirror, | ||
- | Loading mirror speeds from cached hostfile | ||
- | 54 packages excluded due to repository priority protections | ||
- | Setting up Install Process | ||
- | Resolving Dependencies | ||
- | --> Running transaction check | ||
- | ---> Package perl-Compress-Zlib.x86_64 0: | ||
- | --> Processing Dependency: perl(Compress:: | ||
- | --> Processing Dependency: perl(IO:: | ||
- | --> Processing Dependency: perl(IO:: | ||
- | --> Processing Dependency: perl(IO:: | ||
- | --> Processing Dependency: perl(IO:: | ||
- | ---> Package perl-DBI.x86_64 0: | ||
- | ---> Package perl-Net-FTPSSL.noarch 0: | ||
- | --> Processing Dependency: perl(IO:: | ||
- | --> Processing Dependency: perl(Net:: | ||
- | --> Running transaction check | ||
- | ---> Package perl-Compress-Raw-Zlib.x86_64 0: | ||
- | ---> Package perl-IO-Compress-Base.x86_64 0: | ||
- | ---> Package perl-IO-Compress-Zlib.x86_64 0: | ||
- | ---> Package perl-IO-Socket-SSL.noarch 0: | ||
- | --> Processing Dependency: perl(Net:: | ||
- | ---> Package perl-Net-SSLeay.x86_64 0: | ||
- | --> Running transaction check | ||
- | ---> Package perl-Net-LibIDN.x86_64 0: | ||
- | --> Finished Dependency Resolution | ||
- | |||
- | Dependencies Resolved | ||
- | |||
- | ================================================================================ | ||
- | | ||
- | ================================================================================ | ||
- | Installing: | ||
- | | ||
- | | ||
- | | ||
- | Installing for dependencies: | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | |||
- | Transaction Summary | ||
- | ================================================================================ | ||
- | Install | ||
- | Upgrade | ||
- | |||
- | Total download size: 1.3 M | ||
- | Installed size: 3.2 M | ||
- | Is this ok [y/N]: y | ||
- | Downloading Packages: | ||
- | (1/9): perl-Compress-Raw-Zlib-2.023-115.el6.x86_64.rpm | ||
- | (2/9): perl-Compress-Zlib-2.020-115.el6.x86_64.rpm | ||
- | (3/9): perl-DBI-1.609-4.el6.x86_64.rpm | ||
- | (4/9): perl-IO-Compress-Base-2.020-115.el6.x86_64.rpm | ||
- | (5/9): perl-IO-Compress-Zlib-2.020-115.el6.x86_64.rpm | ||
- | (6/9): perl-IO-Socket-SSL-1.31-2.el6.noarch.rpm | ||
- | (7/9): perl-Net-FTPSSL-0.15-1.el6.noarch.rpm | ||
- | (8/9): perl-Net-LibIDN-0.12-3.el6.x86_64.rpm | ||
- | (9/9): perl-Net-SSLeay-1.35-9.el6.x86_64.rpm | ||
- | -------------------------------------------------------------------------------- | ||
- | Total 6.7 MB/s | 1.3 MB | ||
- | Running rpm_check_debug | ||
- | Running Transaction Test | ||
- | Transaction Test Succeeded | ||
- | Running Transaction | ||
- | Installing | ||
- | Installing | ||
- | Installing | ||
- | Installing | ||
- | Installing | ||
- | Installing | ||
- | Installing | ||
- | Installing | ||
- | Installing | ||
- | |||
- | Installed: | ||
- | perl-Compress-Zlib.x86_64 0: | ||
- | perl-Net-FTPSSL.noarch 0: | ||
- | |||
- | Dependency Installed: | ||
- | perl-Compress-Raw-Zlib.x86_64 0: | ||
- | perl-IO-Compress-Base.x86_64 0: | ||
- | perl-IO-Compress-Zlib.x86_64 0: | ||
- | perl-IO-Socket-SSL.noarch 0: | ||
- | perl-Net-LibIDN.x86_64 0: | ||
- | perl-Net-SSLeay.x86_64 0: | ||
- | |||
- | Complete! | ||
- | </ | ||
- | |||
- | Mit nachfolgendem Befehl, wird das Pakete **'' | ||
- | < | ||
- | # yum install perl-DBD-MySQL | ||
- | Loaded plugins: fastestmirror, | ||
- | Loading mirror speeds from cached hostfile | ||
- | 54 packages excluded due to repository priority protections | ||
- | Setting up Install Process | ||
- | Resolving Dependencies | ||
- | --> Running transaction check | ||
- | ---> Package perl-DBD-MySQL.x86_64 0: | ||
- | --> Finished Dependency Resolution | ||
- | |||
- | Dependencies Resolved | ||
- | |||
- | ================================================================================ | ||
- | | ||
- | ================================================================================ | ||
- | Installing: | ||
- | | ||
- | |||
- | Transaction Summary | ||
- | ================================================================================ | ||
- | Install | ||
- | Upgrade | ||
- | |||
- | Total download size: 134 k | ||
- | Installed size: 338 k | ||
- | Is this ok [y/N]: y | ||
- | Downloading Packages: | ||
- | perl-DBD-MySQL-4.013-3.el6.x86_64.rpm | ||
- | Running rpm_check_debug | ||
- | Running Transaction Test | ||
- | Transaction Test Succeeded | ||
- | Running Transaction | ||
- | Installing | ||
- | |||
- | Installed: | ||
- | perl-DBD-MySQL.x86_64 0: | ||
- | |||
- | Complete! | ||
- | </ | ||
- | |||
- | Mit nachfolgendem Befehl kann überprüft werden, welche Inhalte mit den Paket **'' | ||
- | < | ||
- | # rpm -qil perl-DBD-MySQL | ||
- | Name : perl-DBD-MySQL | ||
- | Version | ||
- | Release | ||
- | Install Date: Mon 14 Nov 2011 10:18:20 AM CET Build Host: c6b3.bsys.dev.centos.org | ||
- | Group : Development/ | ||
- | Size : 345831 | ||
- | Signature | ||
- | Packager | ||
- | URL : http:// | ||
- | Summary | ||
- | Description : | ||
- | An implementation of DBI for MySQL for Perl. | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | / | ||
- | </ | ||
- | |||
- | ===== Konfiguration Webserver ===== | ||
- | |||
- | Eine sehr elegante Art die Web-Anwendung in eine bestehende [[http:// | ||
- | <code apache> | ||
- | # | ||
- | # mysqldumper.tachtler.net | ||
- | # | ||
- | < | ||
- | ServerAdmin webmaster@tachtler.net | ||
- | ServerName mysqldumper.tachtler.net | ||
- | ServerAlias www.mysqldumper.tachtler.net | ||
- | ServerPath / | ||
- | DocumentRoot "/ | ||
- | AddHandler cgi-script .pl | ||
- | < | ||
- | Options ExecCGI | ||
- | AllowOverride AuthConfig | ||
- | Order allow,deny | ||
- | Allow from all | ||
- | </ | ||
- | DirectoryIndex index.php | ||
- | ErrorLog logs/ | ||
- | CustomLog logs/ | ||
- | </ | ||
- | </ | ||
- | |||
- | :!: **HINWEIS** - Zu beachten ist hier, die Zeilen mit dem Inhalten | ||
- | * **AddHandler cgi-script .pl** - da hier die Ausführung von [[http:// | ||
- | * **Options ExecCGI** - da hier die Ausführung von CGI-Scripten erlaubt wird! | ||
- | * **DirectoryIndex index.php** - da hier die erste Seite der Anwendung ein PHP-Script ist! | ||
- | |||
- | Ein erneuter oder erster Start des [[http:// | ||
- | < | ||
- | # service httpd start | ||
- | </ | ||
- | oder einen erneuten Start des [[http:// | ||
- | < | ||
- | # service httpd restart | ||
- | </ | ||
- | macht die oben beschriebenen Konfigurationen für den [[http:// | ||
- | |||
- | Der Aufruf von [[http:// | ||
- | * [[http:// | ||
- | |||
- | ===== Konfiguration ===== | ||
- | |||
- | Die Konfiguration von [[http:// | ||
- | * [[http:// | ||
- | |||
- | Nach dem Aufruf des, sollte folgende Seite erscheinen: | ||
- | |||
- | {{: | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | Hier sollte die Sprache ausgewählt werden und zum Abschluss die Schaltfläche **Installation** gewählt werden. Nachfolgend erscheint dann diese Seite: | ||
- | |||
- | {{: | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | Hier sind die Angaben zur [[http:// | ||
- | |||
- | {{: | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | Abschließend ist die Schaltfläche **speichern und Installation fortsetzen** zu drücken, die Installation sollte damit abschlossen sein und nachfolgende Seite sollte erscheinen: | ||
- | |||
- | {{: | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | :!: **WICHTIG** - **Zum Abschluss ist noch der __Verzeichnisschutz__ zu erstellen, was durch drücken der gleichnamigen Schaltfläche erfolgen kann !!!** | ||
- | |||
- | {{: | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | Nach Eingabe der gewünschten Daten muss die Schaltfläche **Verzeichnisschutz erstellen** gedrückt werden, es sollte noch ein Bestätigungfenster erscheinen, was mit der Schaltfläche **OK** bestätigt werden sollte: | ||
- | |||
- | {{: | ||
- | |||
- | Abschließend wurden zwei Dateien im Verzeichnis ''/ | ||
- | * **'' | ||
- | * **'' | ||
- | erstellt, wie nachfolgende Seite auch zeigen sollte. | ||
- | |||
- | {{: | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | \\ | ||
- | Durch drücken der Schaltfläche **Home** kann der Startbildschirm von [[http:// | ||
- | |||
- | **Damit sollte die Installation von [[http:// | ||