Jump to content


Photo

Schedule Backup To Include All Existing Tables


  • Please log in to reply
2 replies to this topic

#1 jrosen1040

jrosen1040

    Newbie

  • Members
  • Pip
  • 5 posts

Posted 25 January 2012 - 09:02 PM

Can the scheduled backups be set to include all tables in the database, even those that did not exist at the time the backup job was created? I'm afraid I will forget to change the job as we create new tables and thereby not get the new ones backed up? If this is possible, how do I do it? Thanks!

#2 peterlaursen

peterlaursen

    Advanced Member

  • Admin
  • PipPipPip
  • 7,869 posts
  • Gender:Male
  • Location:Skagen, Denmark
  • Interests:well ... jazz/folk music, photography, chess, nature, ecology, history, bicycling, Highland Malts ... well, Lowland Malts and Cognac too actually :-) just wonder how I get the time to touch a computer! SQLyog and MONyog? no that's not interest, that's BASIC NEEDS simply!

Posted 26 January 2012 - 09:25 AM

Well, yes. Please see image.

Attached File  alltables.jpg   42.24KB   12 downloads


In that case the XML-jobfile will read

..

<tables all="yes">
</tables>

..





.. and note that no specific tables are listed. The job will backup the tables (and no other objects) that exist at the time of backup.


Computers make your grey hair come off ....

Peter Laursen
Webyog

#3 jrosen1040

jrosen1040

    Newbie

  • Members
  • Pip
  • 5 posts

Posted 27 January 2012 - 01:42 PM

Thanks! I should have realized that. For some reason I thought it was recording all the table names individually in the xml file.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users