Find Jobs
Hire Freelancers

Debug PHP Version 5.1.6 script to backup MySQL tables

$5-10 USD

Completed
Posted almost 14 years ago

$5-10 USD

Paid on delivery
I have? scripts that are designed to backup? a specified table in a specified MySQL database and aso restore the backup to the active database. The script does not run. This project is correct the scripts so that they will backup a specifed table in a specifiedd database and store the backup copy on the server in? specific directory and also allow for storing the backup locally on the harddrive of the PC running the script. The two storage locations to be set within the script. The second script will restore the backup to the server from whatever location was specified. I lease my own server but antiticpate that the successful bidder will be capable of demonstrating successful execution of the code on thier own server and then forwardng that code for implementation by me on a specific hosted domain on my leased server. Unless there are debugging issues specific to my server no access will be granted to my server. The code follows: <?php include '[login to view URL]'; include '[login to view URL]'; print "hello!<br />"; $tableName? = 'matches'; $backupFile = 'backup/[login to view URL]'; $query? ? ? ? ? = "SELECT * INTO OUTFILE '$backupFile' FROM $tableName"; $result = mysql_query($query); $numberRecords = mysql_num_rows($result); print "goodbye $numberRecords times!<br />"; include '[login to view URL]'; /* restore script include '[login to view URL]'; include '[login to view URL]'; $tableName? = 'matches'; $backupFile = 'backup/[login to view URL]'; $query? ? ? ? ? = "SELECT * INTO OUTFILE '$backupFile' FROM $tableName"; $result = mysql_query($query); include '[login to view URL]'; include '[login to view URL]'; include '[login to view URL]'; // To restore the backup you just need to run LOAD DATA INFILE query like this : $tableName? = 'mypet'; $backupFile = '[login to view URL]'; $query? ? ? ? ? = "LOAD DATA INFILE 'backupFile' INTO TABLE $tableName"; $result = mysql_query($query); include '[login to view URL]'; */ ?> ## Deliverables Unless the coder can demonstrate the successful impletion and execution of the scripts as specified - including successful execution on my server? - no award of funds will be made. If the code cannot be completed and demonstrated within 7 days of the awardig of this project, no award of funds will be made.
Project ID: 3541858

About the project

5 proposals
Remote project
Active 14 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$3.50 USD in 7 days
5.0 (5 reviews)
3.3
3.3
5 freelancers are bidding on average $23 USD for this job
User Avatar
See private message.
$8.50 USD in 7 days
5.0 (64 reviews)
4.8
4.8
User Avatar
See private message.
$8.50 USD in 7 days
5.0 (6 reviews)
3.2
3.2
User Avatar
See private message.
$8.50 USD in 7 days
5.0 (1 review)
2.5
2.5
User Avatar
See private message.
$85 USD in 7 days
5.0 (1 review)
1.7
1.7

About the client

Flag of UNITED STATES
United States
5.0
33
Member since Feb 24, 2005

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.