What language do you plan to write this job in? If you want a random interval it’s far simpler to skip cron and code a loop in your test application with a random interval.
Mike > On Jun 3, 2016, at 2:38 PM, Trevor James <ja...@telfer.uottawa.ca> wrote: > > Good Day everyone, I know this is one that someone in the know can do in > about 2 minutes and will take me a couple of hours of google time to figure > out. > > I would like to set up a chron job to add a record to a database in MySQL. > > Background, I wish to do a reasonable test of our backup system on MySQL > databases. > > I have a TurnKey LAMP server setup, so now I wish to add a record to a table > in a database (I haven't set anything up just yet it will depend on the data > I can push into the table) > > I can go into MySQL create Database, Create Table etc, so that is ok, so > let's assume I have TestDatabase with TestTable with one field called > TestData (type can be anything, but how about a date/time or string) > > Now I would like to set up a chron that every X minutes (I would like > something semi random, but let's say every 83 minutes if it is easy) add a > new record to the database > > date > mysqldatabse > > Then between backups I will kill the machine and restore from backup and then > run a mysqlcheck on the database. > > In theory we should have dataloss (since the backup is not continuous) which > is acceptable, a corrupted database will not be which is what I wish to verify > > Thanks in advance for any assistance you can give. > > T. James > _______________________________________________ > Linux mailing list > Linux@lists.oclug.on.ca > http://oclug.on.ca/mailman/listinfo/linux _______________________________________________ Linux mailing list Linux@lists.oclug.on.ca http://oclug.on.ca/mailman/listinfo/linux
