I am using a log-bin file on each of the Servers and Each Server is a Slave of the Previous Server with the Last One in the Chain is the the Sever for the Save Number 1. any Topology will be fine as long as all the data is the same in all the Servers at the end of the day.

Only the information and new records from the Previous Server in the Change need to be Restored into the Next Servers Databases.

The backup must be done automatically on Server A and then Restored Immediately Afterwards on Server B until all 7 Servers have the Previous Servers Information. When Server B completes its Restore from Server A it must Start a Backup and complete the Sequence chain until all are updated automatically. There are 10 databases on Each Server that are identical in nature. Regards BC

Data Loss is not critical. If Migration is used every 5 minutes they all synchronize with each other fine. Each server is in a stand alone world. The other servers information is not critical as long as it gets there eventually. Regards BC

Yes. I have to have a solution that does not require any licensing or cost. The Information has to be updated automatically with some frequency (say every 5 to 15 minutes) so that when all 7 Stand Alone Servers have the same information and new records and record changes in all of there databases which would be identical in nature. It can be accomplished with any free tool or package that works with MySQL 5.1. They all communicate with each other and I granted access for each of them for Replication and set up Relay and Binary Log Files as is required with Replication but none of the servers get updated when new records are entered in any server or changed. If a Backup is done on any Server it takes less than a minute. If it can be Restored on the Next Server in the Change and Vice Versa, it should be OK as long as it can be deployed automatically and it is staggered so there is no Writing Conflicts. Regards BC

I am using MySQL version 5.1 on each of the Networked PC's. There are 7 i all. How do I Backup all the Databases on Server 1 and Append Restore the Backup on Server 2 so it gets all the changes from the First Server, I will do this with 7 Servers in Progression so they Loop Every 15 Minutes. I am using Windows XP professional on each of the 7 Servers and the all have the same Databases. Each Server would have all the New Records in the Tables from the Previous Server. I have tried using Replication on them all but it does not update whena recors is added or changed on any of the 7 Servers. When records are added or changed on any of the 7 Servers, the other 6 must be Updated with the change or addition. I appreciate any suggestions or help or Topology changes. Regards BC

All lines of code that pertain to the Previous Change Master are removed from the My.ini files. Is there anyway to change or verify the master .info file or Purge it?

I ran the same command set on each of the slaves, stopped each of the slave servers after updating the information and then restarted them each. Went back to the Main server and stopped it and restarted it. Got the same exact error message upon starting the server. Trying to start the server ... Server was started. The syntax 'for replication startup options' is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead. Slave SQL thread initialized, starting replication in log 'MEDCO1.000002' at position 4, relay log '.\MEDCO1-relay-bin.000036' position: 4 Event Scheduler: Loaded 0 events C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld-debug: ready for connections. Version: '5.1.30-community-debug-log' socket: '' port: 3306 MySQL Community Server - Debug (GPL) Slave I/O: error connecting to master 'slave-user@master-hostname:3306' - retry-time: 60 retries: 86400, Error_code: 2005

Do you run that command on the MASTER Server or all of the SLAVE Servers. I am running Windows XP Professional on all Units.

It is already in my my.ini File on all my Slaves. It is as follows: CHANGE MASTER TO MASTER_HOST='master-hostname' MASTER_USER='slave-user' MASTER_PASSWORD='slave-password' What else do you suggest trying?

How do I get rid of the following erroe message? The syntax 'for replication startup options' is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.

I have Seven Separate MySQL Servers that Have The Same Local Databases on Each Platform that need to update each other at the completion of a run (or test). Each Server will Retain its local results and also update the other 6 Servers when it completes its test or run. It can run in stand alone mode if Network is Down. If Network is up it must receive the other 6 Servers Informatio as well when the other servers complete a test or run and the Network is up. What is the easiest Way to accomplish this using the free features of MySQL? Please provide examples or free utilities or code generators that can accomplish this. Regards. BC.

How do I convert an MsAccess Database into a MySQL Database and is their a free Utility to do so?

As long as it is free and each local machine can get its local results as well as all the other 11 platforms data and Query each other and it is fre and seamless to the end user it really doesn't matter. It does not have to be fast it just need to be reliable and accurate. Any strategy that can accomplish this for fre is acceptable as long as local and master results can be received from each local machine.

The Customer Specified and Suggested this configuration. I do not have to do it that way as long as is completely free and NoLicenses are requires. The end user must have the ability to retrieve data from the LocalDatabase at any time. The Database must be updated locally after each use or run and must all be available globally to the other 11 local machines (tester) or a master or supervisor machine (Tester) MASTER1 which is updated with all the other 11 localMachines (Testers) as well as its own local data. All records must be updated after each Machine (Tester) Cycle or the Next time that the machine (tester) is turned on it needs to update accordingly. Backups will be done locally on each machine at some specified frequency defined by the customer. Each machine has its own Unique Results and 1 Master or allMust have the others information avalaible to them to Query. I have the Database Created in MS Access for the first machine Tester) but the Customer will not accept it because it Requires Office or Licensing to be installed on 12 PC Platforms. SQL Server Express 208 willnot allow you to import a Database from MS Access and Save it as a SQLServer Express 2008 Database. Hope you can help. Regards BC

The Customer Specified and Suggested this configuration. I do not have to do it that way as long as is completely free and NoLicenses are requires. The end user must have the ability to retrieve data from the LocalDatabase at any time. The Database must be updated locally after each use or run and must all be available globally to the other 11 local machines (tester) or a master or supervisor machine (Tester) MASTER1 which is updated with all the other 11 localMachines (Testers) as well as its own local data. All records must be updated after each Machine (Tester) Cycle or the Next time that the machine (tester) is turned on it needs to update accordingly. Backups will be done locally on each machine at some specified frequency defined by the customer. Each machine has its own Unique Results and 1 Master or allMust have the others information avalaible to them to Query. I have the Database Created in MS Access for the first machine Tester) but the Customer will not accept it because it Requires Office or Licensing to be installed on 12 PC Platforms. SQL Server Express 208 willnot allow you to import a Database from MS Access and Save it as a SQLServer Express 2008 Database. Hope you can help. Regards BC

I will try it.

As long as all the information from the Local Server or PC is available to the Local User (Operator) and the Supervisor Dedicated PC Database contains all the Locals Information and Changes and Updates it really doesn't matter. As long as it is completely FREE and no Licenses are required I am FREE to do any Suggested Configuration. As long as each Machine (Tester) can get it Own Database Information from It's PC and Anyone on the Supervisor PC or on the Same Network can get it as well or Log into the Supervisor and retrieve it for FREE its all good. Regards BC

The Customer wants each Machine (Tester) to have its own Database (Unique and Resident) as well as having either all the other Platforms contain each others Data recors and Updates or one designated Supervisor Server with all the other Servers updating their individual changes to it. Regards BC

Do you have the Link for the Fre version of Sync Framework? Regards BC