176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

MySql Database Backup
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Nov 16, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Fri, Nov 16, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Not Sure
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

I have a web site that uses MySql and is hosted with Aplus.net. They do not have a method to do daily scheduled backups that can be restored. Therefore I need a Cronjob or some other method to automatically do daily backups and store the backups somewhere so they can be restored easily. Aplus has given me the following Cronjob code that is supposed to do backups but I dont' understand it so can't evaluate if it works or is enough to do what I need:
#!/usr/bin/perl
use warnings;
use strict;

# Set connection values
my $DATABASE = 'database_name';
my $DUMP_DIR = '/path/to/backup_folder/';
my $MYSQLADMIN = '/usr/bin/mysqldump';
my ($DUMP_FILE,$DUMP_SCRIPT);
######################################

$DUMP_FILE = $DUMP_DIR . $DATABASE . ".sql";
if(-e "$DUMP_FILE") { unlink("$DUMP_FILE"); }
$DUMP_SCRIPT = $MYSQLADMIN . " --defaults-file=/home/<username>/.my.cnf"
. ' --opt' . " $DATABASE > $DUMP_FILE";
system("$DUMP_...

Sign in or Register to see more

Desired Skills
MySQL Administration, PHP
Job ID: 35260749
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 United States  |  
Winner
FixIT is an IT consulting firm that focuses on understanding and meeting the needs of each client by providing productive, progressive and...
1
  |  
 0.0   |  $0 Earnings   |  1 Jobs
Bid ID: 35263640  |  Submitted: Nov 16, 2012 15:37 ET 
Delivery
Within 1 day
$54.79

 India  |  
Languages: C, C++, Java, C#, SQL Web Development: HTML, JavaScript, CSS, XML, PHP, jquery, AJAX, Joomla, Drupal, ASP.NET MVC3 DBMS: SQL Server...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 35262890  |  Submitted: Nov 16, 2012 15:00 ET 
Proposal SEALED

 United States  |  
We have 12+ years of experience developing websites and applications using Open Source Technologies, such as; Joomla, WordPress, eCommerce,...
4
  |  
 4.5   |  Private   |  16 Jobs
Bid ID: 35262173  |  Submitted: Nov 16, 2012 14:28 ET 
Proposal SEALED

Ranked 10th out of all the wordpress providers on elance*************** 500+ projects in Last 3 years ****** More then 98% Satisfied Customers...
10
  |  
 4.9   |  Private   |  73 Jobs
Bid ID: 35261742  |  Submitted: Nov 16, 2012 14:10 ET 
Proposal SEALED

Souvik M.      
Souvik M.'s identity has been verified.  Learn More
 India  |  
Build an exciting career by hard work and honesty. Over 9 Yrs Experience on MySQL, PHP, SQL Server, ASP, JSP, VB, Flash, Dreamweaver, Photoshop,...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 35261269  |  Submitted: Nov 16, 2012 13:49 ET 
Proposal SEALED

Ashish Salve      
Ashish Salve's identity has been verified.  Learn More
 India  |  
I have been working as full time freelance programmer since last 7+ years. I have experience of 217 projects on elance and many more off elance....
Skills: C, WordPress, PHP
8
  |  
 3.5   |  Private   |  27 Jobs
Bid ID: 35261160  |  Submitted: Nov 16, 2012 13:44 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »