09-12-2006
restore mysql dump file in many remote servers?
Hi all,
I want to restore DB file in many mysql servers, i already using script for sending the dumpfile in all servers, but it's just annoying if i have to restore the dumpfile in all servers, i want just execute 1 script, and will restore in all remote mysql servers. I make script but not working, im sure my logics it's not correct
Hope somebody can help me.
Thanks.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have a file with .dmp.gz. I am trying to uncompress this file in a new directory. was able to use gzip to take off the gz extension. How do I get the .dmp extension off? Will ufsrestore work on SUN system?
HELP! (2 Replies)
Discussion started by: sankera
2 Replies
2. Red Hat
Hi,
I am using RHEL 4.0
I need to take backup of a directory and then restore it to some other location.
For taking Backup of final directory, I am using this code:
dump -0aj -f /home/vicky/final.dump /home/vicky/final/
Now, I am trying to restore this final.dump to some other... (2 Replies)
Discussion started by: vikas027
2 Replies
3. Shell Programming and Scripting
Hi folks
I have mysql dump which having insert queries, i want to break that file when 10 complete "INSERTS" lines so extract that line and store in 1.sql and 2.sql and for next 10 insert lines.
pls guide me how can i do that.
Regards,
Bash (2 Replies)
Discussion started by: learnbash
2 Replies
4. UNIX for Dummies Questions & Answers
Hi all, having problem with dump & restore for cloning simple linux system.
The command is : dump -0u -f /temp/var.dump /dev/sda5
But somehow the result displayed:
~~~~~~
dump: ACLs in inode #1250760 won't be dumped: Inappropriate ioctl for device
dump: ACLs in inode #1250761 won't be... (1 Reply)
Discussion started by: mycoolwater
1 Replies
5. UNIX for Dummies Questions & Answers
Hi all,
i am a real dummy to unix and in need of help.My platform is Sun solaris(5.9)
I have a dump file, an oracle cold backup taken with ufsdump command. This dump file resides on the disk, not the tape.
I want to extract this dump file to a directory. But i cant, i read about ufsrestore... (1 Reply)
Discussion started by: merope
1 Replies
6. UNIX for Dummies Questions & Answers
I want to copy over the contents of one partition on hard drive A to another partition on hard drive B. Using DD command caused problems since it overwrote the partition information on hard drive B and made hard drive B's partition size the same as the one on partition A.
Our department manager... (5 Replies)
Discussion started by: mojoman
5 Replies
7. UNIX for Dummies Questions & Answers
Hi :-)
i have a dump of a backupdisk (~540GB / ext3). The Backups have some 100 millions of hardlinks (backups are created with storeBackup). The OS is linux.
A restore of a directory ended after some days with the errormessage "no memory to extend symbol table"
The restore of the complete... (0 Replies)
Discussion started by: turricum
0 Replies
8. Shell Programming and Scripting
I have a script (below) which works ok, but I have tried to modify it as I want to keep the older files for a restore if needed. I have tried adding a date suffix to the newly created files (second lump of code), but it doesn't seem to work.
I get the error:
$SOURCEDIR/p1db_$DATEVAR.sql:... (3 Replies)
Discussion started by: ojobson
3 Replies
9. Solaris
hi all
i have a DLT tape in that tape backup is there is in veritas volume format and i want to restore it in ufs file system how can i do it?
right now i don't have veritas file system setup. i have only ufs file sysytem
please help some production data is to be restore. (3 Replies)
Discussion started by: nikhil kasar
3 Replies
10. UNIX and Linux Applications
Hi All,
I have a linux centos instance which has a dump file. I need to import the dump file to the oracle server which is located at some remote location. I have installed the oracle client on my machine and I am able to connect to the remote oracle server.
Now how to import the dump to the... (3 Replies)
Discussion started by: Palak Sharma
3 Replies
LEARN ABOUT CENTOS
pmdamysql
PMDAMYSQL(1) Performance Co-Pilot PMDAMYSQL(1)
NAME
pmdamysql - MySQL database PMDA
DESCRIPTION
pmdamysql is a Performance Co-Pilot PMDA which extracts live performance data from a running MySQL database.
INSTALLATION
pmdamysql uses a configuration file from (in this order):
o /etc/pcpdbi.conf
o $PCP_PMDAS_DIR/mysql/mysql.conf
This file can contain overridden values (Perl code) for the settings listed at the start of pmdamysql.pl, namely:
o database name (see DBI(3) for details)
o database user name
o database pass word
Once this is setup, you can access the names and values for the mysql performance metrics by doing the following as root:
# cd $PCP_PMDAS_DIR/mysql
# ./Install
If you want to undo the installation, do the following as root:
# cd $PCP_PMDAS_DIR/mysql
# ./Remove
pmdamysql is launched by pmcd(1) and should never be executed directly. The Install and Remove scripts notify pmcd(1) when the agent is
installed or removed.
Binary Status values in text
Some of the status values are in the form of YES/NO or ON/OFF.
Since these cannot be intepreted by tools like PMIE, they have been duplicated with a _num extension and the values of 1 (YES/ON) or 0
(NO/OFF).
Eg:
o mysql.slave_status.slave_io_running
o mysql.slave_status.slave_io_running_num
FILES
/etc/pcpdbi.conf
configuration file for all PCP database monitors
$PCP_PMDAS_DIR/mysql/mysql.conf
configuration file for pmdamysql
$PCP_PMDAS_DIR/mysql/Install
installation script for the pmdamysql agent
$PCP_PMDAS_DIR/mysql/Remove
undo installation script for the pmdamysql agent
$PCP_LOG_DIR/pmcd/mysql.log
default log file for error messages from pmdamysql
SEE ALSO
pmcd(1), pmdadbping.pl(1) and DBI(3). # vi: sw=4 ts=4 et:
3.8.10 Performance Co-Pilot PMDAMYSQL(1)