02-27-2006
i agree. my impression would be that you would probably want to backup and rebuild for performance reasons. as for backups... you probably should already be doing that anyways.
8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
1 . Thanks everyone who read the post first.
2 . I have a log file which size is 143M , I can not use vi open it .I can not use xedit open it too.
How to view it ?
If I want to view 200-300 ,how can I implement it
3 . Thanks (3 Replies)
Discussion started by: chenhao_no1
3 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I am quite sure that I am posting a question in the very wrong forum but I have to give a try. It's a question about UNIX theory. I don't have any clue of how to solve this question. If someone could kindly provide some good references or give me the formulas, it will be really... (1 Reply)
Discussion started by: ti_ma
1 Replies
3. UNIX for Dummies Questions & Answers
The /src file is obviously designed to contain source code, so when I download programs, I should put them in /src (because they contain the source files + the executables)? What do most people do with the executables? Do they copy them to /bin, make links to them in /bin, or just leave them in... (4 Replies)
Discussion started by: css136
4 Replies
4. UNIX for Dummies Questions & Answers
I have a 5000 line config.log file with several "maybe" errors. Any reccomendations on finding solvable problems? (2 Replies)
Discussion started by: NeedLotsofHelp
2 Replies
5. Shell Programming and Scripting
Input file
DATA2.2 POSITION_152486.2 COLUMN689699.2
DATA2.2 ROW00000342066 UNIT00000342313
DATA7.2 POSITION_017891.4 COLUMN060361.4
DATA7.2 ROW00000379319 UNIT00000368623
DATA7.2 ROW00000421241 UNIT00000400736
DATA8.1 POSITION_153254.2 COLUMN694986.2
DATA8.1 ROW00000379288... (1 Reply)
Discussion started by: perl_beginner
1 Replies
6. UNIX for Dummies Questions & Answers
Does anyone have any idea of how I can make something like the code below run recursively?
I'll run it on a tree of directories all with different names and all containing a sequence of .dpx files. I've tried to do it using find and exec but can't get it to work right.
What it needs to do is... (4 Replies)
Discussion started by: scribling
4 Replies
7. What is on Your Mind?
Hello,
I have been working as Solaris/Linux Admin since past 8 years. I am looking options for my profile change, but there is some limitation. I worked as 24x7 support for admin, server support, high availability, etc. But been worked on developing side and scripting part.
When I search for Big... (2 Replies)
Discussion started by: nightup2222
2 Replies
8. Solaris
Gents
Actually I have question and i need your support.
I have this NAS file system mounted as /coresys has size of 7 TB
I need to Split this file system into several file systems as mount points I mean how to can I Split it professionally to different NAS mount points how to can I decide... (2 Replies)
Discussion started by: AbuAliiiiiiiiii
2 Replies
LEARN ABOUT DEBIAN
automysqlbackup
automysqlbackup(8) Automatically backup MySQL automysqlbackup(8)
NAME
automysqlbackup - backup all of your database daily, weekly, and monthly
SYNOPSIS
automysqlbackup
DESCRIPTION
This manual page documents briefly the automysqlbackup command.
configuration is stored within the /etc/default/automysqlbackup file
PARAMETERS
USERNAME=dbuser
Username to access the MySQL server e.g. dbuser
PASSWORD="password"
Username to access the MySQL server e.g. password
DBHOST=localhost
Host name (or IP address) of MySQL server e.g localhost
DBNAMES="DB1 DB2 DB3"
List of DBNAMES for Daily/Weekly Backup e.g. "DB1 DB2 DB3"
BACKUPDIR="/backups"
Backup directory location e.g /backups
MAILCONTENT="stdout"
Mail setup What would you like to be mailed to you?
- log : send only log file
- files : send log file and sql files as attachments (see docs)
- stdout : will simply output the log to the screen if run manually.
- quiet : Only send logs if an error occurs to the MAILADDR.
MAXATTSIZE="4000"
Set the maximum allowed email size in k. (4000 = approx 5MB email [see docs])
MAILADDR="user@domain.com"
Email Address to send mail to? (user@domain.com)
ADVANCED OPTIONS
MDBNAMES="mysql $DBNAMES"
List of DBBNAMES for Monthly Backups.
DBEXCLUDE=""
List of DBNAMES to EXCLUDE if DBNAMES are set to all (must be in " quotes)
CREATE_DATABASE=yes
Include CREATE DATABASE in backup?
SEPDIR=yes
Separate backup directory and file for each DB? (yes or no)
DOWEEKLY=6
Which day do you want weekly backups at? (1 to 7 where 1 is Monday)
COMP=gzip
Choose Compression type. (gzip or bzip2)
COMMCOMP=no
Compress communications between backup server and MySQL server?
LATEST=no
Additionally keep a copy of the most recent backup in a separate directory.
MAX_ALLOWED_PACKET=
The maximum size of the buffer for client/server communication. e.g. 16MB (maximum i
SOCKET=
For connections to localhost. Sometimes the Unix socket file must be specified.
#PREBACKUP="/etc/automysqlbackup/mysql-backup-pre"
Command to run before backups (uncomment to use)
#POSTBACKUP="/etc/automysqlbackup/mysql-backup-post"
Command run after backups (uncomment to use)
AUTHOR
This manual page was written by Jose Luis Tallon <jltallon@adv-solutions.net>. for the Debian GNU/Linux system, but can be used by others.
wipe_out 6 Sep 2008 automysqlbackup(8)