The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Help in backing up my databse using cron job

Discussion in 'Data Protection' started by WSS1428, Jan 18, 2008.

  1. WSS1428

    WSS1428 Registered

    Joined:
    Jan 18, 2008
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Hello;

    I need a help where I can backup my SQL database daily at 3 o'clock in the morning using the corn job commands in my site cpanel.

    I am very new to this and never tried it before. I really appreciate any help in details as much as possible.

    Thank you


    WS
     
  2. peacemaker

    peacemaker Member

    Joined:
    Nov 29, 2007
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    login to cpanel ...

    in advanced options...you can find cronjob....go there ....go to standerd cron manager

    set the time to 3 (synchronize it with ur system time)

    the command to run
    : mysqldump <databsename> > <databasename>.sql
    eg : mysqldump anj_db > anj_db.sql

    hope it helped you :)
     
    #2 peacemaker, Jan 18, 2008
    Last edited: Jan 18, 2008
  3. WSS1428

    WSS1428 Registered

    Joined:
    Jan 18, 2008
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Thanks for your help, can you also tell me how to backup the same database but on a remte server. I appreciate giving me the full command.

    example: I need to copy db.sql to www.remoteserver.com/backup

    Thanks alot
     
Loading...

Share This Page