Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

sceduled database restore?

Discussion in 'General Discussion' started by m.bergmannn, Jun 22, 2006.

  1. m.bergmannn

    m.bergmannn Registered

    Joined:
    Jun 22, 2006
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    151
    Hello everybody.

    I hope somebody can help resolve my problem.

    I need to restore every 60 mins. my MySql database. That because i want to create an demo CMS where the people can make changes but every hour i want to restore the original status.

    Somebody has some tips for me? Can i do it with a CronJob?

    Many thanks for help

    Regards
     
  2. Spiral

    Spiral BANNED

    Joined:
    Jun 24, 2005
    Messages:
    2,023
    Likes Received:
    8
    Trophy Points:
    193
    Yep, you can do this with a cronjob.

    Just write a script to redirect your sql file into "mysql" and call that from cron.

    Don't forget to put a "USE <database name>;" on the start of your SQL file.
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice