CRON Job to copy database and replace existing database Post: 302719207

Sponsored Content

Top Forums Shell Programming and Scripting CRON Job to copy database and replace existing database Post 302719207 by nzrobert on Monday 22nd of October 2012 08:57:24 AM

10-22-2012

Registered User

CRON Job to copy database and replace existing database

I have a reseller account with hostgator, which means i have WHM and Cpanel. I have set up a staging environment for one of my wordpress installations (client website), which is essentially sitting at staging.domain.com (live site is at domain.com). The staging website is a complete copy of the live website and utilises a different database.

The idea behind this is to test all new module updates / wordpress updates prior to releasing to the live website, however.. Content can chance on the live website without the staging website receiving the updates (want to use this as a backup also.)

What I want to do is set up a daily CRON job to copy the database from one hosting account to and replace another database. (tables and all) on a daily basis. I figure this will only be possible at host manager level (WHM) as a cpanel user will not have permission to interface between 2 different accounts.

Does anyone know how to do this? Do I need to create a PHP script to run every day? What would that look like.. Sorry I know its a big ask, im just clueless at this level.

nzrobert

View Public Profile for nzrobert

Find all posts by nzrobert

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Crontab job for exporting a Oracle database

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.

2. Shell Programming and Scripting

PERL: Read from Database and copy

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 ?

3. UNIX for Dummies Questions & Answers

how to run cron job to truncate database table

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...

4. Shell Programming and Scripting

Sample ksh script for copy the data from excel to database table ?

Hi All, I need to convert the data from excel to database table in sybase. Please provide some sample script.. thanks, Royal.

5. Shell Programming and Scripting

How to write cron job for calling sql function database is postgres

Hi, Please help me to write cron job for calling sql function daily. I have Postgres database.

6. Solaris

redirect solaris database from linux database..

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. Solaris

Can't create database after Oracle Database installation

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...

8. Shell Programming and Scripting

Problem with backup and copy a database

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...

9. Shell Programming and Scripting

Need to implement new CRON job or modify the existing one in MDM PROD in coming days, which will sen

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...

LEARN ABOUT DEBIAN

libgphoto2_port

LIBGPHOTO2_PORT(3)					  The gPhoto2 Reference (the man					LIBGPHOTO2_PORT(3)

NAME

       libgphoto2_port - cross-platform port access library

SYNOPSIS

       #include <gphoto2/gphoto2_port.h>

DESCRIPTION

       The libgphoto2_port library was written to provide libgphoto2(3) with a generic way of accessing ports. In this function, libgphoto2_port
       is the successor of the libgpio library.

       Currently, libgphoto2_port supports serial (RS-232) and USB connections, the latter requiring libusb to be installed.

       The autogenerated API docs will be added here in the future.

ENVIRONMENT VARIABLES

       IOLIBS If set, defines the directory where the libgphoto2_port library looks for its I/O drivers (iolibs). You only need to set this on
	      OS/2 systems and broken/test installations.

       LD_DEBUG
	      Set this to all to receive lots of debug information regarding library loading on ld based systems.

       USB_DEBUG
	      If set, defines the numeric debug level with which the libusb library will print messages. In order to get some debug output, set it
	      to 1.

SEE ALSO

       libgphoto2(3), The gPhoto2 Manual, [1]gphoto website, automatically generated API docs, [2]libusb website

AUTHOR

       The gPhoto2 Team.
       Hans Ulrich Niedermann <gp@n-dimensional.de>. (man page)

REFERENCES

       1. gphoto website
	  http://www.gphoto.org/

       2. libusb website
	  http://libusb.sourceforge.net/

								    08/16/2006							LIBGPHOTO2_PORT(3)