Automating

This topic is empty.

Viewing 10 reply threads

Author

Posts
- October 8, 2003 at 3:50 pm #8199
  
  ianblackford
  Member
  
  Hi,
  
  First let me say, I am EXTREMELY new to SQLyog and I'm not sure of what I'm doing on a PC (I work on a mac).
  
  My situation is this: I have a hosted MySQL database with a table containing weborders, I want to be able to extract the days orders at two intervals in the day lets say 11.00am and 2.00pm and update a local db with only those records.
  
  Is that possible and can anybody point me in the direction of how to do it?
  
  Also I then need to write each order out as individual text files.
  
  Again is that possible and automatable?
  
  The reason I want to automate it is I will install all this at a clients office and I need it to work without his input.
  
  Any help would be greatly appreciated.
  
  Ian
- October 8, 2003 at 3:56 pm #15074
  
  CalEvans
  Member
  
  While it is possible to use SQLyog to do this, I would suggest that you look into writing a script (PHP? PERL?[ASP?]) that does this and call it as a cron [or windows scheduler] job twice a day. It would be much easier.
  
  =C=
- October 8, 2003 at 4:27 pm #15075
  
  Ritesh
  Member
  
  Quote:
  
  My situation is this: I have a hosted MySQL database with a table containing weborders, I want to be able to extract the days orders at two intervals in the day lets say 11.00am and 2.00pm and update a local db with only those records.
  
  The upcoming version of SQLyog i.e. SQLyog 3.6 provides you a Wizard based interface to sync data. This is zillion times easier than writing a PHP/Perl script. Morever, this process can be scheduled. You can download a Release Candidate of SQLyog 3.6 from http://www.webyog.com/sqlyog/SQLyog36.exe. I am waiting for your comments 🙂
  
  Quote:
  
  Also I then need to write each order out as individual text files.
  
  This feature is planned for future release of SQLyog.
- October 8, 2003 at 9:42 pm #15081
  
  ianblackford
  Member
  
  I've just downloaded SQLyog 3.6 and I'll take a look at that also.
  
  Ian
- October 8, 2003 at 9:42 pm #15076
  
  ianblackford
  Member
  
  CalEvans wrote on Oct 8 2003, 03:56 PM:
  
  While it is possible to use SQLyog to do this, I would suggest that you look into writing a script (PHP? PERL?[ASP?]) that does this and call it as a cron [or windows scheduler] job twice a day. It would be much easier.
  
  =C=
  
  That's easy for you to say! 😮 I haven't got a clue where to start!
  
  Can you point me in the right direction please?
  
  Ian
- October 8, 2003 at 9:42 pm #15077
  
  ianblackford
  Member
  
  CalEvans wrote on Oct 8 2003, 03:56 PM:
  
  While it is possible to use SQLyog to do this, I would suggest that you look into writing a script (PHP? PERL?[ASP?]) that does this and call it as a cron [or windows scheduler] job twice a day. It would be much easier.
  
  =C=
  
  That's easy for you to say! 😮 I haven't got a clue where to start!
  
  Can you point me in the right direction please?
  
  Ian
- October 8, 2003 at 9:43 pm #15079
  
  ianblackford
  Member
  
  CalEvans wrote on Oct 8 2003, 03:56 PM:
  
  While it is possible to use SQLyog to do this, I would suggest that you look into writing a script (PHP? PERL?[ASP?]) that does this and call it as a cron [or windows scheduler] job twice a day. It would be much easier.
  
  =C=
  
  That's easy for you to say! 😮 I haven't got a clue where to start!
  
  Can you point me in the right direction please?
  
  Ian
- October 8, 2003 at 9:43 pm #15080
  
  ianblackford
  Member
  
  CalEvans wrote on Oct 8 2003, 03:56 PM:
  
  While it is possible to use SQLyog to do this, I would suggest that you look into writing a script (PHP? PERL?[ASP?]) that does this and call it as a cron [or windows scheduler] job twice a day. It would be much easier.
  
  =C=
  
  That's easy for you to say! 😮 I haven't got a clue where to start!
  
  Can you point me in the right direction please?
  
  Ian
- October 8, 2003 at 9:44 pm #15078
  
  ianblackford
  Member
  
  CalEvans wrote on Oct 8 2003, 03:56 PM:
  
  While it is possible to use SQLyog to do this, I would suggest that you look into writing a script (PHP? PERL?[ASP?]) that does this and call it as a cron [or windows scheduler] job twice a day. It would be much easier.
  
  =C=
  
  That's easy for you to say! 😮 I haven't got a clue where to start!
  
  Can you point me in the right direction please?
  
  Ian
- October 8, 2003 at 9:49 pm #15082
  
  ianblackford
  Member
  
  What the heck happened! 😮
  
  I only clicked the button once!
  
  Ian
- October 9, 2003 at 6:47 am #15083
  
  Shadow
  Member
  
  The syncronization of the dbs can be done with SQLyog, but you'll have to write a script that extracts each order as a separate text file. You could download MyODBC from MySql's site and write a VBScript that does the job. The problem is that windows scheduler does not have the option of executing a file after another job was finished…
Author

Posts