10-22-2012
Wouldn't it be easier to duplicate/replicate the database with database means?
I don't know which DB you use (probably mySQL), but all DB softwares i know of allow to create a complete dump of its contents. Create such a dump, transfer it to the staging-machine (simple file-transfer) and again use the DB mechanisms to update your DB there.
I hope this helps.
bakunin
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Could someone give me a hint how to get or write such a job ?
I want to schedule a Oracle export using the crontab, I really do not know how to do this.
Concreet: How do I write such a script ?
Thanks for your help. (1 Reply)
Discussion started by: c.d.israel
1 Replies
2. Shell Programming and Scripting
I have a microsoft access database with anout 220 lines. theres a question and 4 option awnsers and only ones correct which is also listed in th database.
Is there any perl script that will copy and the lines from the database and put into a .asp website ? (2 Replies)
Discussion started by: perleo
2 Replies
3. UNIX for Dummies Questions & Answers
hi
i'm a bit stuck trying to find the correct syntax in order to run a cron job which just truncates all info from a single table in my database
i have a main database - db1
and i have a table in that database - userips
i wish to create a cron job that truncates or removes all the info... (9 Replies)
Discussion started by: wingchun22
9 Replies
4. Shell Programming and Scripting
Hi All,
I need to convert the data from excel to database table in sybase. Please provide some sample script..
thanks,
Royal. (1 Reply)
Discussion started by: royal9482
1 Replies
5. Shell Programming and Scripting
Hi,
Please help me to write cron job for calling sql function
daily. I have Postgres database. (1 Reply)
Discussion started by: kulbhushan
1 Replies
6. Solaris
hi..
i have a need .. my php runs on my linux redhat box with mysql.. i want my php code to refer another mysql database
which is in solaris 10 x86... can u tell me the procedure ..
how it can be done through php .. sorry am new to php...
is it possible to redirect from linux mysql to... (7 Replies)
Discussion started by: senkerth
7 Replies
7. Solaris
I installed Oracle 10 software on Solaris 11 Express, everything was fine execpt I can't create database using dbca.rsp file. I populated file with following options.
OPERATION_TYPE = "createDatabase"
GDBNAME = "solaris_user.domain.com"
SID = "solaris_user"
TEMPLATENAME = "General... (0 Replies)
Discussion started by: solaris_user
0 Replies
8. Shell Programming and Scripting
Hi,
I have many servers distributed on my customer locations all servers has MYSQL database.
I want to backup database for each server on server at my location using scheduler.
So I create Shell script file to backup and copy the database file from customer server to my server as... (3 Replies)
Discussion started by: amsbas
3 Replies
9. Shell Programming and Scripting
Need to implement new CRON job or modify the existing one in MDM PROD in coming days, which will send email of SQL statement running from past 1 minute.Currently there is one CRON job in PROD, which send below email.
there is one cron job which send email, when there is long running... (0 Replies)
Discussion started by: dampu
0 Replies
LEARN ABOUT DEBIAN
cfetoolimport
CFETOOLIMPORT(8) User Contributed Perl Documentation CFETOOLIMPORT(8)
NAME
cfetoolimport - import the contents of a database from XML format
SYNOPSIS
cfetool import name --file|-f filename [--path|-p directory name] [--daily|-d] [--weekly|-w] [--yearly|-y] [--verbose|-v] [--help|-h]
DESCRIPTION
Creates a new database from it's XML representation, in the format created by rrdtool dump.
The -d, -w, and -y options specify which databases to create and look for in the dump, and may be combined. If they are all omitted, the
default is to only import the weekly database.
OPTIONS
--file|-f filename
Specifies the XML file to restore.
--path|-p
The directory in which to create the new database folder. If this argument is not provided, the current working directory will be used.
--daily|-d
Create a database for recording daily patterns.
--weekly|-w
Create a database for recording weekly patterns.
--yearly|-y
Create a database for recording yearly patterns.
--verbose|-v
Print details of the command's execution to the standard output stream.
--help|-h
Print a short help message and then exit.
EXAMPLE
% cfetool import temperature_copy --path /my/path --file ./temperature.xml
Create a new weekly database, "temperature_copy", in the "/my/path" directory, and import it's contents from the file "temperature.xml" in
the current working directory.
AUTHORS
The code and documentation were contributed by Stanford Linear Accelerator Center, a department of Stanford University. This documentation
was written by
Elizabeth Cassell <e_a_c@mailsnare.net> and
Alf Wachsmann <alfw@slac.stanford.edu>
COPYRIGHT AND DISCLAIMER
Copyright 2004 Alf Wachsmann <alfw@slac.stanford.edu> and
Elizabeth Cassell <e_a_c@mailsnare.net>
All rights reserved.
perl v5.8.4 2004-09-21 CFETOOLIMPORT(8)