forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Copying A Db To Another Host(Or Local) Using Sja
June 1, 2012 at 11:35 am #12692
I was wondering if there was a way to copy a database (all tables) using SJA
We have table structures that change often, where a sync might not work all the time, and was wondering if there was a SJA option which works like the GUI method where we can “Drop if exist in target”
June 1, 2012 at 12:02 pm #33489
No there is not currently.
We do have requests for a non-attended/non-interactive 'mode' of Schema Sync integrated in SJA (either as a separate job type or as an option combined with Data Sync or both), refer http://code.google.com/p/sqlyog/issues/detail?id=560 .
I cannot promise any priority of this. We will priortize next major features after relasing 10.1 in 1-2 weeks.
May 17, 2013 at 3:01 pm #33490
Hi, Just wondering if this topic has ever been reviewed or is on a path to become available.
Again to reiterate It would be great to do something like this with SJA
1. backup local DB
2. backup remote DB
3. Copy remote DB wiping out local DB (just like Copy Database with drop as your go Command in the GUI program)
4. Do changes, testing etc…
5. Copy local DB wiping out remote DB.
With Drupal, the DB's tables are always changing, and this for many sites would would so useful, i.e. if it can become a part of SJA.
In the meantime, I do appreciate this product. Keep up the great work!
September 10, 2013 at 11:28 am #33491
Can't you use Data Sync? If not, why not?
October 23, 2013 at 5:41 pm #33492
the table structures change often and the sync does not accommodate that unless that has been changed recently?
Specifically we would like to use SJA to automate this.
For now, we manually copy the DB using the webyog interface.
Just to add since I was curious as to changes….
I tried using SJA to sync 2 DBs. One table had a structure difference and the sync stopped, HOWEVER, after emptying the target DB before the sync, it worked perfectly.
Possibly there is a way that SJA can empty the target first?
October 24, 2013 at 3:07 pm #33493
Yes there is such workaround.
You may use the 'SQL Scheduler and Reporting Tool' to execute DROP TABLE statement(s), next Data Sync to sync.
Finally build a batch file like described here: http://faq.webyog.com/content/27/35/en/can-i-execute-more-sja-jobs-at-the-same-time.html.
the batch file can be scheduled manually from the Windows Scheduler interface.
January 20, 2017 at 5:15 pm #33494
While this solution does work, it is often that we need to add new tables to the script
i.e. DROP TABLE IF EXISTS… now @ 568 tables for Drupal applications
NOTE: This is only to add a wish to my wishlist i.e. a SJA command to Empty DB first vs the extra step/script of Dropping Each table… then doing a Sync which adds all data and structure.
Thanks for the continued support + excellent product.
You must be logged in to reply to this topic.