Cancelled

Simple Rotating Backup Download Application

I need a desktop application that logs in to a web site and downloads a backup file and then saves it using a naming convention that gives us a set of rotating backups.

The backup file is a MySQL dump from phpMyAdmin. The php script that creates the file already exists and your app needs to log in to our web site and download a text file called cmbak.sql.

You will provide your own database for testing as ours is a production system with confidential data.

The app will log in by posting a user name and password to an html form. The app will allow us to change the URL, userid and password used. See example login form in detailed requirements below.

The backup file will be downloaded from a URL that can be changed in the app. See example php backup script in detailed requirements below.

The app will be written in C# and source code provided so we can change it later. Although I'll probably come back to you for any changes.

It will be a basic GUI that runs automatically every day at a time that can be changed in the app. It will also have a button to run the backup manually.

The PC we use it on will have the app added to the windows startup menu (no need to run as a service).

After a backup file is downloaded it will be saved to a folder named "c:\bak" and this folder name can be changed in the app. The file is saved using conditions and naming conventions defined in detailed requirements below.

Any parameters that can be changed in the app must be saved so the app remembers them if closed and re-opened.

After the app is created we'll need approx 1 week to test it.

Let me know if you have questions or need clarification on anything.

## Deliverables

I need a desktop application that logs in to a web site and downloads a backup file and then saves it using a naming convention that gives us a set of rotating backups.

The backup file is a MySQL dump from phpMyAdmin. The php script that creates the file already exists and your app needs to log in to our web site and download a text file called cmbak.sql.

You will provide your own database for testing as ours is a production system with confidential data.

The app will log in by posting a user name and password to an html form. The app will allow us to change the URL, userid and password used. See example login form below.

The backup file will be downloaded from a URL that can be changed in the app. See example php backup script below.

The app will be written in C# and source code provided so we can change it later. Although I'll probably come back to you for any changes.

It will be a basic GUI that runs automatically every day at a time that can be changed in the app. It will also have a button to run the backup manually.

The PC we use it on will have the app added to the windows startup menu (no need to run as a service).

After a backup file is downloaded it will be saved to a folder named "c:\bak" and this folder name can be changed in the app. The file is saved using the following conditions and naming conventions:

On 1st day of month: save backup file as [url removed, login to view] where YYYY is the current year and MM is the current month. If the file already exists it is over written. So we get a permanent archive of monthly backups.

On Sunday's: save backup file as [url removed, login to view] where W is the current week of the month (1 to 5). If the file already exists it is over written. So we get 4 or 5 weekly rotating backups going back 1 month.

Every day: save backup file as [url removed, login to view] where DDD is the current day (mon, tue, wed etc). If the file already exists it is over written. So we get 7 rotating daily backups going back 1 week.

Date conditions are not mutuially exclusive, e.g. on the first day of the month that is a sunday 3 files are written.

Any parameters that can be changed in the app must be saved so the app remembers them if closed and re-opened.

The html form for the login page looks like this:

<form action="" method="post" name="frmCampaign" id="frmCampaign">

<p>User ID<br>

<input name="txtUserid" type="text" id="txtUserid" value=""></p>

<p>Password<br>

<input name="txtUserpw" type="password" id="txtUserpw" value=""></p>

<p><input type="submit" name="Submit" value="Submit"></p>

</form>

The php that creates the backup file looks something like this (untested example code):

<?php

session_start();

if($_SESSION["myusername"] == ''){

header("location:[url removed, login to view]");

}

$this->db = mysql_connect ("[url removed, login to view]", "sqluserid", "pass")

$command = "mysqldump --opt --skip-extended-insert --complete-insert --host=[url removed, login to view] --user=sqluserid --password=pass mydb > /var/users/myuserid/[url removed, login to view]";

system($command);

$write_physical=system($command);

$file = "/var/users/myuserid/[url removed, login to view]";

$fh = fopen($file, 'r') or die('Could not open file!');

$data = fread($fh, filesize($file)) or die('Could not read file!');

fclose($fh);

header("Content-type: application/x-msdownload");

header("Content-Disposition: attachment; filename=[url removed, login to view]");

header("Pragma: no-cache");

header("Expires: 0");

print ("$header\n$data");

?>

After the app is created we'll need approx 1 week to test it.

Let me know if you have questions or need clarification on anything.

Evner: PHP

Se mere: windows action script, web content dump, web content downloads, sql code convention, mysql database download for windows, html 5 login form, get yyyy from date in sql, files will not download, file download service, downloads site html 5, download mysql database for windows, sql r, sql in r, r sql, web die, value added service, mysql backup, download time, DDD, backup windows

Om arbejdsgiveren:
( 5 bedømmelser ) New Zealand

Projekt ID: #3311133

20 freelancere byder i gennemsnit $265 på dette job

TopSEOExpertscom

See private message.

$399.5 USD in 14 dage
(221 bedømmelser)
7.9
DebasisB

See private message.

$382.5 USD in 14 dage
(150 bedømmelser)
7.0
programsmith

See private message.

$420.75 USD in 14 dage
(54 bedømmelser)
6.9
thetoxic

See private message.

$255 USD in 14 dage
(47 bedømmelser)
6.1
logicarchitects

See private message.

$212.5 USD in 14 dage
(47 bedømmelser)
6.0
mobiletech1604

See private message.

$382.5 USD in 14 dage
(67 bedømmelser)
6.0
matfizvw

See private message.

$382.5 USD in 14 dage
(58 bedømmelser)
6.1
expertcoder1vw

See private message.

$374 USD in 14 dage
(33 bedømmelser)
5.3
evansly

See private message.

$85 USD in 14 dage
(21 bedømmelser)
4.7
intelviper

See private message.

$170 USD in 14 dage
(35 bedømmelser)
4.6
rickeisermannvw

See private message.

$148.75 USD in 14 dage
(29 bedømmelser)
4.5
rased108

See private message.

$85 USD in 14 dage
(28 bedømmelser)
4.4
gganchev

See private message.

$212.5 USD in 14 dage
(13 bedømmelser)
3.7
muzammal86janjua

See private message.

$289 USD in 14 dage
(15 bedømmelser)
3.3
eysha01

See private message.

$399.5 USD in 14 dage
(3 bedømmelser)
2.8
imadalavivw

See private message.

$255 USD in 14 dage
(5 bedømmelser)
0.7
tsharmavw

See private message.

$120 USD in 14 dage
(0 bedømmelser)
0.0
rajnsuvw

See private message.

$594.15 USD in 14 dage
(1 bedømmelse)
0.0
emiliohg

See private message.

$170 USD in 14 dage
(0 bedømmelser)
0.0
bailout

See private message.

$170 USD in 14 dage
(0 bedømmelser)
0.0