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.