12-14-2012
Thanks a lot. That all makes sense. Ok. I'll implement the script as you have shown me, but won't get to test it until after Christmas when we go live with this new database. Thanks for all your help.
This User Gave Thanks to timgolding For This Post:
8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated.
Input:
test_data_1
1 2 90%
4 3 91%
5 4 90%
6 5 90%
9 6 90%
test_data_2
3 5 92%
5 4 92%
7 3 93%
9 2 92%
1 1 92%
...
Output:... (7 Replies)
Discussion started by: justthisguy
7 Replies
2. Shell Programming and Scripting
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)
Discussion started by: bulkbiz
5 Replies
3. UNIX for Dummies Questions & Answers
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)
Discussion started by: dahr
3 Replies
4. UNIX for Advanced & Expert Users
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)
Discussion started by: DILEEP410
7 Replies
5. Shell Programming and Scripting
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:
mysqldump -A --add-drop-table > mysql-daily-backup.sql &> /tmp/backup_log/mysql.log
Is there anything wrong with the syntax?
---------- Post updated at 08:32 PM... (0 Replies)
Discussion started by: proactiveaditya
0 Replies
6. UNIX for Dummies Questions & Answers
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)
Discussion started by: Ultrix
1 Replies
7. Shell Programming and Scripting
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)
Discussion started by: timgolding
2 Replies
8. Shell Programming and Scripting
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)
Discussion started by: jackcracker
7 Replies
LEARN ABOUT SUSE
exim_convert4r4
EXIM_CONVERT4R4(8) System Manager's Manual EXIM_CONVERT4R4(8)
NAME
exim_convert4r4 - Convert Exim configuration from v3 to v4 format
SYNOPSIS
exim_convert4r4
DESCRIPTION
This script is provided to assist in updating Exim configuration files. It reads an Exim 3 configuration file on the standard input, and
writes a modified file on the standard output. It also writes comments about what it has done to the standard error file. It assumes that
the input is a valid Exim 3 configuration file. A typical call to the conversion script might be
exim_convert4r4 < /etc/exim/exim.conf > /etc/exim4/exim4.conf.new
The output file MUST be checked and tested before trying to use it on a live system. The conversion script is just an aid which does a lot
of the "grunt work". It does not guarantee to produce an Exim 4 configuration that behaves exactly the same as the Exim 3 configuration it
reads.
Each option change in the new file is preceded by an identifying comment. In fact, the conversion script tends to make quite a mess of
your configuration, and you should expect to go through it afterwards and tidy it up by hand.
Unless you are running a very straightforward configuration, the automatic conversion is likely to generate a non-optimal configuration.
You should not only check it thoroughly, but also run as many tests as you can, to ensure that it is working as you expect. In particular,
you should test address routing, using -bt and -bv, and the policy controls, using -bh. If possible, you should also do some live tests
(i.e. send and receive some messages) before putting Exim 4 into service.
If you have a very complicated configuration, it is possible that exim_convert4r4 will break it in some situations, which is why thorough
testing is strongly recommended.
BUGS
This manual page needs a major re-work. If somebody knows better groff than us and has more experience in writing manual pages, any patches
would be greatly appreciated.
SEE ALSO
exim(8), the files in /usr/share/doc/exim4-base/, especially Exim4.upgrade.gz
AUTHOR
This manual page was stitched together from Exim4.upgrade by Andreas Metzler <ametzler at downhill.at.eu.org>, for the Debian GNU/Linux
system (but may be used by others).
March 26, 2003 EXIM_CONVERT4R4(8)