forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Feature Request: Autocommit In Database Backup
- This topic is empty.
-
AuthorPosts
-
-
July 13, 2009 at 11:05 am #29315
peterlaursen
ParticipantWe have been doing this for the last 6-9 months already. Just use the option to 'generate sync script' and you will see. Doesn't it? What version are you using?
(and there is not need to SET AUTOCOMMIT=1 at the end because it is a SESSION variable and Data Sync runs in a seperate connection. But we do COMMIT.)
A very simple sync job involving a single table with 8.13 beta:
/*
Copyright© Webyog Softworks Pvt. Ltd. All Rights Reserved.
MySQL – 5.0.83-community-nt
*********************************************************************
*/
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
/* SYNC DB : ******* */
SET AUTOCOMMIT = 0;
/* SYNC TABLE : `*******` */
insert into …..
COMMIT;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */
;/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-
July 13, 2009 at 11:08 am #29316
peterlaursen
Participantbut there is a cosmetical issue with a semicolon!
-
July 13, 2009 at 11:24 am #29317
peterlaursen
ParticipantMy mistake .. you were referring to backups.
We have this option in 'scheduled backup' – please see attached. The interactive backup feature from database/table menu/context menu we try to keep as simple as possible.
[attachment=1216:scdback.jpg]
-
July 13, 2009 at 11:37 am #29318
DonQuichote
Memberpeterlaursen wrote on Jul 13 2009, 01:05 PM:We have been doing this for the last 6-9 months already. Just use the option to 'generate sync script' and you will see. Doesn't it?I downloaded the latest version (8.12 enterprise) and to find that option. I was using 8.06. I now see your answer to where the option is located. I just made a dump with tools>”Backup database as SQL dump”. I use SQLyog purely for development. Scheduled backup is done with scripts on the Linux servers. Thanks for the answer.
-
-
AuthorPosts
- You must be logged in to reply to this topic.