I want to take a backup of a database and redirect the output of the whole process to a log file. I am using the below command:
Is there anything wrong with the syntax?
---------- Post updated at 08:32 PM ---------- Previous update was at 08:32 PM ----------
Detected the error.
This will create an empty file called mysql-daily-backup.sql and the full SQL dump will go to /tmp/backup_log/mysql.log. So i modified it to:
Serves my purpose now.
Hi @ all
I need a little bit help with a tricky problem ...
Here´s the situation:
We´ve 2 MySQL-Servers, one is productive, the other is Backup.
At the productive Server there runs every 2 hours a cron Job which does a Dump from MySQL-DB with script 'automysqlbackup.sh' and
copy it then... (7 Replies)
I have a very simple script that uses a cron job to take a daily backup of our orders database.
echo "Dumping ORDERS database";
mysqldump -u root --password='mypassword' -h '1.1.1.1' --opt --compress ORDERS $tbl_names > /Volumes/Files_Backup_1/db_backups/orders.sql
echo "Copied database to... (2 Replies)
Hi @all!
In my MySQL-backup-script I backup and compress every single table with this command:
/usr/bin/mysqldump --opt database_x table_y | /usr/bin/pbzip2 -c > "/media/BackUpDrive/Backup/table_x.gz"Unfortunately these files need modification - they have to start with the following line(s):... (7 Replies)
Hi,
I have to upload part of my database periodically when i make changes to product data etc. However I only want to upload certain tables. We suffer from bandwidth chock here, so i want to write a couple of separate scripts that upload parts of the database that changed. The database is large... (5 Replies)
My crontab file tells cron to run a certain shell script at 10:30 AM every day. The shell script backs up my database with mysqldump and then runs a sed script that does some editing of the backup file.
I have programmed the shell script to write an error message to a file I have in my home... (1 Reply)
Hi All,
I have a data calculation process-a perl script running each and every hour which will do some calculations on the data stored in a mysql server. Normally it tooks around 2minutes (max) to complete.
But in case if i did any actions on the linux box where the database is... (7 Replies)
hi,
I need to backup a database but I'm getting the error "bus error - core dumped" just after I run mysqldump command.
The server has installed solaris 9.
Any help would be appreciated (3 Replies)
OS: Linux ambglx02 2.6.16.60-0.21-default #1 Tue May 6 12:41:02 UTC 2008 i686 i686 i386 GNU/Linux
Shell: bash
Currently I have a mysqldump script to backup my mysql database, the command is as below:
/opt/novell/mysql/bin/mysqldump --add-drop-table -u root -p -h mydb > /home/john/mydb.sql
... (5 Replies)
MYSQLDUMP(1) General Commands Manual 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|--version] [-O net_buffer_length=#, where # < 16M]
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 # < 16M
When creating multi-row-insert statements (as with option --extended-insert or --opt ), mysqldump will create rows up to net_buf-
fer_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 < backup-file.sql
or
mysql -e 'source /patch-to-backup/backup-file.sql' database
However, it's also very useful to populate another MySQL server with information 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.mer-
curmedia.com)
19 December 2000 MYSQLDUMP(1)