MySQL Data Transfer

1
MySQL Data Transfer
Looking for an application that do the following
Programming Language Delphi 7 or Delphi 2006 DO
NOT USE ANY Components

• Transfer the content of 2 Tables from Multiple
  number of Databases The list of Databases will be
  in a table
• Create a transfer schedule Daily or weekly or
  monthly
• Create Transfer log
• Create Error Log
• During the transfer I will need progress bar
  showing the status of the transfer

2
Site 1
Site 5
Site 2
Site 6
Master Site
Site 3
Site 7
Site 4
Site (n-1)
3
All the sites will have the same database tables
and fields All I need is the data in 2
tables SyS_INI Sys_Info
4
When transferring the data from a database to the
master database PCID will need to be Reset
(reassign)
As you can see the PCID has to match between
sys_ini sys_info in both tables So when
resetting the value of the PCID it has to match
on both table for all the sites With out
duplication
5
Database 1
1st Record will have ID 1 and PCID 1 2ndRecord
will have ID 2 and PCID 2 (N-1) Record will have
ID (n-1) and PCID (n-1)
Database 2
1st Record will have ID 1 and PCID 1 2ndRecord
will have ID 2 and PCID 2 (N-1) Record will have
ID (n-1) and PCID (n-1)
Database (n-1)
1st Record will have ID 1 and PCID 1 2ndRecord
will have ID 2 and PCID 2 (N-1) Record will have
ID (n-1) and PCID (n-1)
Transferring
When Transferring the data from Database to the
master database The PCID has to match between
sys_ini and sys_info and cant be duplicated in
the master database
6
Databases
Master Database
Database 1 both tables sys_ini sys_info
1st Record will have ID 1 and PCID 1 2ndRecord
will have ID 2 and PCID 2 (N-1) Record will have
ID (n-1) and PCID (n-1)
1st Record will have ID 1 and PCID 1 2ndRecord
will have ID 2 and PCID 2
3rd t Record will have ID 3 and PCID 3 4th Record
will have ID 4 and PCID 4
Database 2 both tables sys_ini sys_info
5th Record will have ID 5 and PCID 5 6th Record
will have ID 6 and PCID 6 (N-1) Record will have
ID (n-1) and PCID (n-1)
1st Record will have ID 1 and PCID 1 2ndRecord
will have ID 2 and PCID 2 (N-1) Record will have
ID (n-1) and PCID (n-1)
On both tables sys_ini sys_info
Database (n-1) both tables sys_ini sys_info
1st Record will have ID 1 and PCID 1 2ndRecord
will have ID 2 and PCID 2 (N-1) Record will have
ID (n-1) and PCID (n-1)
7
Results After Transfer
Master Database
All the Data from all the databases With out
duplicate of the PCID
Fist Transfer the master database will be
empty From Second Transfer on make a copy of the
both tables sys_ini and sys_info Sys_ini_Date and
sys_info_Date I will need X days copy X the
number of copy Get it from server.ini (See
picture) Then Empty or overwrite the existing
data with the new data
8

• Create a transfer schedule Daily or weekly or
  monthly

I need to have a scheduler tab when I can
Schedule the transfer from a selected Databases
or all databases
I need to have a tab where it will have 3
buttons 1 Transfer from all databases 2
Transfer from selected databases 3 Close
minimize the Application to the tray
9
Databases information Table Site Name MySQL
Database IP MySQL Port MySQL Database Name MySQL
Table Name MySQL Database User Name My SQL
Database Password Last Transfer
The application should have A configuration file
Server.ini Where I can set the port. IP, User
Name, Password, Server Name
10
Destination database is in the server.ini
11
(No Transcript)
12
If you have any suggestion or better Idea do not
hesitate to message me
If you have any question do not assume just
message
Thanks a lot Donnie