Scheduled "database Copy"

[ESAT RENNES]

Hi,

EDIT : I use SQLYog enterprise 5.32 and 6.05.

I would like to know if there are any plans to give us the ability to schedule the “copy database to another host/db” feature.

As a matter of fact, I've 3 servers :

• server_X8 (linux, mysql 3.23) I can't update it – production server – database_X8 with old structure
• server_K2 (windows 2003, mysql 5.1) – test server – database_K2 with new structure
• server_K8 (windows 2003, mysql 5.1) – production server – database_K8 with new structure

The goal is to update data from database_K2 and database_K8 witch are improved versions of database_X8 (including stored procedures and relationships not included in version 3.23).

I do so :

• First, I copy database_X8 (old structure) from server_X8 to database_K2_raw (old structure) on server_K2
• Then, I run the data syncronization wizard to update database_K2 (new structure) with database_k2_raw (old structure) data
• Last, I run the data syncronization wizard to update database_K8 (new structure) with database_k2 (new structure) data (without constraint checking)

As you can see, at the moment, I can't schedule the first step, and that's rather annoying… …it prevents me to make a full automatic update job running at midday and midnight. I must use the “copy database” feature for the first step and not the syncronization wizard because Mysql versions are different between the servers (“CONCAT_WS” error).

Regards.

[peterlaursen]

there are no plans to schedule 'copy database'

If database_X8 is static (and if YOU know the structure of it)

this “copy database_X8 (old structure) from server_X8 to database_K2_raw (old structure)”

.. could be done by a 'notifications service' job executing CREATE DATABASE and CREATE TABLE statements.

Also you should try if the CONCAT_WS error still occurs. With recent versions we handle most differences between server versions.

[Author]

Posts