06-02-2006
How to backup openfile?
Hi
I am using Sun Solaris 8 with mysql install. I am using "tar" command to backup mysql database without turn off the mysql services/process. But when i try to restore the msql database to another Solaris 8 server(with same file structure), mysql services can not startup
![Frown Smilie](https://www.unix.com/images/smilies/frown.gif)
.
Thus I try to use ufsdump to backup angain and restore again, the mysql services still cannot start up
![Confused Smilie](https://www.unix.com/images/smilies/confused.gif)
.
Did any command to backup the open file? Or Any idea on my situation?
Please Help........................
Regards
Cher
8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I am taking a class all about linux. Where where asked to find the best backup program. We never did agree and are system was set up with scp because some one already knew how to use it and thus the quickest to set up. Great example of legacy support.
However, on my computer i do not have a... (1 Reply)
Discussion started by: macdonto
1 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I performed backup on tape and I want to append more files to my previous backup on the same backup tape. But before I do that I need to know the backup file size of the first backup I performed so that I know the available size on the backup tape. Can someone help me what command I will use... (0 Replies)
Discussion started by: ayhanne
0 Replies
3. SCO
I am trying to make a full backup of my system using the cpio command. The Tape Unit is a SCSI DDS.
The process started fine but after about 30 minutes, it just stopped and showed the following message:
1755 Signal 31 - Core dumped
Any idea of what is causing this and how to fix it?
... (4 Replies)
Discussion started by: zionpc
4 Replies
4. UNIX for Advanced & Expert Users
hi,
am trying to backup data on cd, cuz i don not have tape device....!!!
i've rewritable CDROM,
am using solaris 10 for x86 on vmware .....
how to make a backup data to a cd_rom againist to tape ?
# ufsdump 0f cd_rom (1 Reply)
Discussion started by: sasame
1 Replies
5. AIX
hi seniors today i took a backup using tar cmd in this i took two files for backup,backup was done succesfully but while viewing using tar -tvf ------- its showiing only one file at a time and i took backup in /etc/hosts,/etc/sen/nes (7 Replies)
Discussion started by: senmak
7 Replies
6. UNIX for Advanced & Expert Users
I am trying to backup my .bash_history and I want to keep every version of the backup. I am thinking to put one of these in my crontab.
0 0 * * 0,3 cat .bash_history > boo
0 0 * * 0,3 cp .bash_history boo
I would like the backups to be called boo1, boo2, boo3, etc. I would like to keep... (7 Replies)
Discussion started by: cokedude
7 Replies
7. Shell Programming and Scripting
Hi Everyone,
we are running rsync with --backup mode, Are there any rsync options to remove backup folders on successful deployment?
Thanks in adv. (0 Replies)
Discussion started by: MVEERA
0 Replies
8. Shell Programming and Scripting
HI all, im new to shell scripting. need your guidence for my script. i wrote one script and is attached here
Im explaining the requirement of script.
AIM: Shell script to run automatically as per scheduled and backup few network devices configurations. Script will contain a set of commands... (4 Replies)
Discussion started by: saichand1985
4 Replies
LEARN ABOUT DEBIAN
cvm-mysql
cvm-mysql(8) System Manager's Manual cvm-mysql(8)
NAME
cvm-mysql - MySQL module
SYNOPSIS
cvm-mysql
CREDENTIALS
Pass phrase
DESCRIPTION
This module queries a MySQL database for the account name, compares the stored pass phrase with the given one using crypt(3).
CONFIGURATION VARIABLES
CVM_MYSQL_DEFAULT_FILE
The full path of the defaults file to read if the following variable is set. If not set, the file $HOME/.my.cnf will be read (the
MySQL default).
CVM_MYSQL_DEFAULT_GROUP
If set, the module will read connection default options from the named group in the defaults file as above
CVM_MYSQL_HOST
The hostname or IP of the MySQL server. If not set, a connection to the local host is assumed.
CVM_MYSQL_USER
The MySQL login ID to connect as. If not set, the invoking user is assumed.
CVM_MYSQL_PASS
The password for the above user.
CVM_MYSQL_DB
The database name, must be set.
CVM_MYSQL_PORT
The port number for the TCP/IP connection (only used if the server is not local).
CVM_MYSQL_POSTQ (optional)
The SQL query to execute after the credentials have been validated, see cvm-sql(7).
CVM_MYSQL_PWCMP (optional)
The password comparison module to use.
CVM_MYSQL_SOCKET
The path to the socket that should be used for connections to a local server.
CVM_MYSQL_QUERY (optional)
The SQL query to issue to retrieve the row containing the account information from the database, see cvm-sql(7).
SEE ALSO
cvm-sql(7), cvm-pgsql(8), cvm-pwfile(8), cvm-qmail(8), cvm-unix(8), cvm-vmailmgr(8), cvm-benchclient(8), cvm-checkpassword(8), cvm-test-
client(8)
http://untroubled.org/pwcmp/pwcmp.html
http://untroubled.org/cvm/cvm.html
cvm-mysql(8)