Em Andamento

MySQL simple backup script

Hello:

I need a simple script in PHP that will do this:

1: Go through each mysql database on a server

2: Make a backup of the database and all its tables with the name bakN_dbName - where N is a number 1 to 3 depending on which rotation and dbName is the original database name

The backups should be rotated each time the script is run; just a simple fashion, i.e. bak1, bak2, bak3 and then overwrite bak1 again. A simple text file should contain a log of the backup processes in reverse order with timestamps with high level info.

The databases are running and changing constantly, so I want the backup process to be done by MySQL using SELECT & INSERTS rather than simply copying the db files.

All data must be preserved, i.e. watch out for timestamp fields etc.

Database structures change, so bakN files will need to be created each time the script is run.

Table & colum names should be preserved.

If a server contains the databases:

FISH

- table1

- table2

CHIPS

- table1

then after running the script once there will be databases of:

bak1_FISH

- table1

- table2

CHIPS

- table1

- table2

---

All connection data should be in variables.

The database backup may not necessarily be on the same host, so use independent connections for source / destination.

There's a nifty table copy script as part of php_myadmin which seems to do the job perfectly for copying tables, that might save some time.

If there's a simpler way than above, let me know... :) My goal is to have full rotational backups running every X hours to complement more robust daily system backups.

Cheers!

Chris

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

## Platform

PHP

MySQL

Linux

Habilidades: Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software

Ver mais: simply fashion, php and mysql connection, mysql gpl, i want to be a fashion buyer, gpl mysql, goal engineering, fashion names, data structures through c, data structures explained, where fish, nifty, mysql linux php, mysql copy, mysql backup, linux reverse engineering, Go Fish , fish and chips, backup job, backup database, database copy script, php connection select, php backup mysql, mysql change connection, mysql databases server, mysql save data

Acerca do Empregador:
( 65 comentários ) United Kingdom

ID do Projeto: #2984201

Premiar a:

mohammadmus

See private message.

$7 USD em 3 dias
(7 Avaliações)
2.6

2 freelancers estão ofertando em média $12 para este trabalho

superpedro

See private message.

$17 USD in 3 dias
(6 Comentários)
3.7