Hi, einer unser Kunden hat uns gefragt, wie er seine DBs täglich sichern kann - und zwar am besten automatisch per Script.
Kennt da jemand was? (er hat auch Cronjobs zur Verfügung)
thx!
cm
Homepage selbermachen 7.852 Themen, 35.619 Beiträge
xafford 
Christoph Maus „MySQL-Datenbanken täglich backupen - automatisch per Script - Wi“
am einfachsten ist es, einfach die .FRM und die .MYD dateien, die zur datenbank gehören zu sichern, da mysql ein flaches format besitzt. einfaches zurückspielen der dateien stellt die datenbank wieder her.
dies funktioniert natürlich auch mit dem mysql-kommandozeilentool und einer batch datei mit
mysql> BACKUP TABLE tabellenname TO 'sicherungsverzeichnis';
bzw aus einer match geraus:
mysql < batchdatei
Christoph Maus xafford „am einfachsten ist es, einfach die .FRM und die .MYD dateien, die zur datenbank...“
Er hat sich das so vorgestellt:
Die DBs werden gesichert (wie mit phpMyAdmin) in eine SQL-Datei gespeichert und dann irgendwo in seinem Webspaceverzeichniss abgelegt, so dass er die bei bedarf downloaden kann.
Die Funktion ist ja eigentlich schon in phpMyAdmin drin und müsste durch ein Cronscript ja nur aufgerufen werden und die entstandene Datei in seinem DIR abgelegt werden.
Nur ich kann halt kein PHP & Co. also is das für mich etwas schwierig... ;-)
Und mein Kollege is z.Zt stark gehandiecaped (er hat nen komplizierten Bruch im Handgelenk und extreme Probleme beim tippen...)
Das mit den FRM und MYD-Files wäre aber auch ne Möglichkeit, aber damit könnte der Kunde schlecht was anfangen...
cm
Zaphod Christoph Maus „Er hat sich das so vorgestellt: Die DBs werden gesichert wie mit phpMyAdmin in...“
man mysqldump:
8>
mysqldump(1) MySQL database mysqldump(1)
NAME
mysqldump - text-based client for dumping or backing up mysql databases , tables
and or data.
USAGE
mysqldump [OPTIONS] database [tables]
OR mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
OR mysqldump [OPTIONS] --all-databases [OPTIONS]
OPTION SYNOPSIS
mysqldump [-A|--all-databases] [-a|--all] [-#|--debug=...] [--character-sets-
dir=...] [-?|--help] [-B|--databases] [-c|--complete-insert] [-C|--compress]
[--default-character-set=...] [-e|--extended-insert] [--add-drop-table] [--add-
locks] [--allow-keywords] [--delayed-insert] [-F|--flush-logs] [-f|--force]
[-h|--host=...] [-l|--lock-tables] [-n|--no-create-db] [-t|--no-create-info]
[-d|--no-data] [-O|--set-variablevar=option] [--opt] [-p|--password[=...]]
[-P|--port=...] [-q|--quick] [-Q|--quote-names] [-S|--socket=...] [--tables]
[-T|--tab=...] [-u|--user=#] [-v|--verbose] [-V|--version] [-w|--where=]
[--delayed] [-e|--extended-insert] [--fields-terminated-by=...]
[--fields-enclosed-by=...] [--fields-optionally-enclosed-by=...]
[--fields-escaped-by=...] [--lines-terminated-by=...] [-v|--verbose] [-V|--ver-
sion] [-O net_buffer_length=#, where #
DESCRIPTION
Dumping definition and data mysql database or table mysqldump supports by executing
-A|--all-databases
Dump all the databases. This will be same as -databases with all databases
selected.
-a|--all
Include all MySQL specific create options.
-#|--debug=...
Output debug log. Often this is 'd:t:o,filename`.
--character-sets-dir=...
Directory where character sets are
-?|--help
Display this help message and exit.
-B|--databases
To dump several databases. Note the difference in usage; In this case no
tables are given. All name arguments are regarded as databasenames.
-c|--complete-insert
Use complete insert statements.
-C|--compress
Use compression in server/client protocol.
--default-character-set=...
Set the default character set
-e|--extended-insert
Allows utilization of the new, much faster INSERT syntax.
--add-drop-table
Add a 'drop table' before each create.
--add-locks
Add locks around insert statements.
--allow-keywords
Allow creation of column names that are keywords.
--delayed-insert
Insert rows with INSERT DELAYED.
-F|--flush-logs
Flush logs file in server before starting dump.
-f|--force
Continue even if we get an sql-error.
-h|--host=...
Connect to host.
-l|--lock-tables
Lock all tables for read.
-n|--no-create-db
will not be put in the output. The above line will be added otherwise, if
--databases or --all-databases option was given.
-t|--no-create-info
Don't write table creation info.
-d|--no-data
No row information.
-O|--set-variable var=option
give a variable a value. --help lists variables
--opt Same as --add-drop-table --add-locks --all --extended-insert --quick
--lock-tables
-p|--password[=...]
Password to use when connecting to server. If password is not given it's
solicited on the tty.
-P|--port=...
Port number to use for connection.
-q|--quick
Don't buffer query, dump directly to stdout.
-Q|--quote-names
Quote table and column names with `
-S|--socket=...
Socket file to use for connection.
--tables
Overrides option --databases(-B).
-T|--tab=...
Creates tab separated textfile for each table to given path. (creates .sql
and .txt files). NOTE: This only works if mysqldump is run on the same
machine as the mysqld daemon.
-u|--user=#
User for login if not current user.
-v|--verbose
Print info about the various stages.
-V|--version
Output version information and exit.
-w|--where=
dump only selected records; QUOTES mandatory!
--delayed
Insert rows with the INSERT DELAYED command.
-e|--extended-insert
Use the new multiline INSERT syntax. (Gives more compact and faster inserts
statements.)
--fields-terminated-by=...
--fields-enclosed-by=...
--fields-optionally-enclosed-by=...
--fields-escaped-by=...
--lines-terminated-by=...
These options are used with the -T option and have the same meaning
as the corresponding clauses for LOAD DATA INFILE. See Mysql manual
section 7.23 LOAD DATA INFILE Syntax.
-v|--verbose
Verbose mode. Print out more information on what the program does.
-V|--version
Print version information and exit.
-O net_buffer_length=#, where # When creating multi-row-insert statements (as with option --extended-
insert or --opt ), mysqldump will create rows up to net_buffer_length
length. If you increase this variable, you should also ensure that
the max_allowed_packet variable in the MySQL server is bigger than
the net_buffer_length.
EXAMPLES
The most normal use of mysqldump is probably for making a backup of whole
databases. See Mysql Manual section 21.2 Database Backups.
mysqldump --opt database > backup-file.sql
You can read this back into MySQL with:
mysql database
or
mysql -e 'source /patch-to-backup/backup-file.sql' database
However, it's also very useful to populate another MySQL server with infor-
mation from a database:
mysqldump --opt database | mysql --host=remote-host -C database
It is possible to dump several databases with one command:
mysqldump --databases database1 [ database2 database3... ] >
my_databases.sql
If all the databases are wanted, one can use:
mysqldump --all-databases > all_databases.sql
SEE ALSO
isamchk (1), isamlog (1), mysqlaccess (1), mysqladmin (1), mysqlbug (1),
mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql (1), perror (1),
replace (1), safe_mysqld (1), which1 (1), zap (1),
AUTHOR
Ver 1.0, distribution 3.23.29a Michael (Monty) Widenius (monty@tcx.se), TCX
Datakonsult AB (http://www.tcx.se). This software comes with no warranty.
Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data
Model Architect / system developer (http://www.mercurmedia.com)
MySQL 3.23 19 December 2000 mysqldump(1)
-----------------------------------------------------------------> ... sollte das Tool deiner Wahl sein - per cronjob aufgerufen und fertig ;-)
Christoph Maus Zaphod „man mysqldump: 8 mysqldump 1 MySQL database mysqldump 1 NAME mysqldump -...“
Danke dir!
cm
