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 HPUX
vpardump
vpardump(1M) vpardump(1M)
NAME
vpardump - manage monitor dump files
SYNOPSIS
[vparmon[dumpfile]]
DESCRIPTION
The command is used to create (on PA-RISC systems only) and analyze a virtual partition monitor dump file. vparmon is the image of the
virtual partition monitor and dumpfile is the crash dump file corresponding to that image. is normally run from the rc script to analyze a
crash dump during HP-UX boot. If no options are specified, checks if the dumpfile has been cleared. If not, it analyzes dumpfile and
prints information about the crash to standard out. Then marks the dumpfile as clear. If dumpfile is not specified, the string is
appended to vparmon as in If vparmon is not specified, it defaults to
The dumpfile must exist prior to a vpar monitor crash. On PA-RISC systems, the and options create the dumpfile on PA-RISC. If is used, a
dumpfile is created that is large enough to contain the monitor image. If additional structures are required, such as I/O Page Directo-
ries, the option is used to reserve space for a full monitor crash dump. On Itanium(R)-based systems, the monitor dumpfile is created in
the EFI partition of the monitor's boot disk as needed. It is not necessary to pre-allocate a dump file in A monitor dump typically
requires less than 75 megabytes of free space in the EFI partition. In order to ensure that a complete crash dump can be saved, this much
free space must be maintained in the EFI partition.
Options
recognizes the following command-line options:
Analyze the
dumpfile. This option can be used to force an analysis even if dumpfile has been cleared.
Mark dumpfile as clear. No analysis is performed.
Analyze
dumpfile even if the versions do not match.
Initialize
dumpfile for a full dump. Supported only on PA-RISC systems.
Initialize
dumpfile for a normal dump. Supported only on PA-RISC systems.
Do not analyze the
dumpfile.
Enable verbose output.
The and options are allowed on Itanium-based systems for compatibility. No action is taken for the and options.
Operands
recognizes the following command-line operands:
vparmon The name of the image of the virtual partition monitor. If vparmon is not specified, it defaults to
dumpfile The name of the crash dump file corresponding to the image of the virtual partion monitor. If dumpfile is not specified,
the string is appended to vparmon as in
Security Restrictions
This command is restricted to processes owned by superuser or with the privilege. See privileges(5) for more information about privileged
access on systems that support fine-grained privileges.
RETURN VALUE
returns the following values:
Analyzed
dumpfile successfully.
Created a new
dumpfile.
A dumpfile does not exist.
The dumpfile is cleared, no action taken.
Error attempting to create a
dumpfile.
Error analyzing the
dumpfile.
Command syntax error.
EXAMPLES
Analyze the default dumpfile and create it if it does not exist:
Suppress the analysis of the default dumpfile, and reserve space for a full dump:
AUTHOR
was developed by the Hewlett-Packard Company.
SEE ALSO
vparextract(1M), privileges(5).
vpardump(1M)