CODEWITHSUNDEEP
mysqlbackup
user1119566
user1119566

Reputation:

How to make a backup copy of a table at a specific date/time using MySQL?

On 31 Dec 2011, I have to copy the data of one of my database tables into another table automatically at 11:59.

What steps should I follow?

Upvotes: 0

Views: 1380

Answers (1)

Emmanuel N
Emmanuel N

Reputation: 7449

The best bet will be to use MySql Schedular, I know MySQL 5.1.6 come with this, check out this. For more on how you can backup MySql database check out

Using MySQL Schedular you can do something like

  CREATE EVENT MyEvent
  ON SCHEDULE AT TIMESTAMP '2011-12-30 23:59:00'
  DO
  SELECT * INTO MY_NEW_TABLE FROM MY_CURRENT_TABLE;

Upvotes: 2

Related Questions