Debug PHP Version 5.1.6 script to backup MySQL tables
$5-10 USD
Оплачується при отриманні
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 '[url removed, login to view]';
include '[url removed, login to view]';
print "hello!<br />";
$tableName? = 'matches';
$backupFile = 'backup/[url removed, login to view]';
$query? ? ? ? ? = "SELECT * INTO OUTFILE '$backupFile' FROM $tableName";
$result = mysql_query($query);
$numberRecords = mysql_num_rows($result);
print "goodbye $numberRecords times!<br />";
include '[url removed, login to view]';
/* restore script
include '[url removed, login to view]';
include '[url removed, login to view]';
$tableName? = 'matches';
$backupFile = 'backup/[url removed, login to view]';
$query? ? ? ? ? = "SELECT * INTO OUTFILE '$backupFile' FROM $tableName";
$result = mysql_query($query);
include '[url removed, login to view]';
include '[url removed, login to view]';
include '[url removed, login to view]';
// To restore the backup you just need to run LOAD DATA INFILE query like this :
$tableName? = 'mypet';
$backupFile = '[url removed, login to view]';
$query? ? ? ? ? = "LOAD DATA INFILE 'backupFile' INTO TABLE $tableName";
$result = mysql_query($query);
include '[url removed, login to view]';
*/
?>
## 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.
ID Проекту: #3541858