Results 1 to 6 of 6

Thread: mysql automatic backup

  1. #1
    Custom User Title
    Join Date
    Oct 2005
    Location
    Wirral UK
    Posts
    1,168
    Thanks
    10
    Thanked
    14 times in 14 posts
    • cougarslam's system
      • Motherboard:
      • Asus Maximus Formula SE (ROG)
      • CPU:
      • Core 2 Duo E6600 @ 3ghz
      • Memory:
      • 4gb Corsair DDR2
      • Storage:
      • 1TB
      • Graphics card(s):
      • BFG Nvidia 8800GT OC 512MB
      • PSU:
      • Corsair HX520
      • Case:
      • Zorro
      • Operating System:
      • Vista Business 32
      • Monitor(s):
      • 2 x 17" crt
      • Internet:
      • adsl max (entanet)

    mysql automatic backup

    I need a freeware mysql program that I can use to automatically back up approx 5 databases every day. these are all on different web servers and i would preferably like to specify which folders the backups go into and specify a template name ie. shop131106.

    cheers

    Matt

  2. #2
    The late but legendary peterb - Onward and Upward peterb's Avatar
    Join Date
    Aug 2005
    Location
    Looking down & checking on swearing
    Posts
    19,378
    Thanks
    2,892
    Thanked
    3,403 times in 2,693 posts
    myphpadmin and set up a cron job?
    (\__/)
    (='.'=)
    (")_(")

    Been helped or just 'Like' a post? Use the Thanks button!
    My broadband speed - 750 Meganibbles/minute

  3. #3
    Agent of the System ikonia's Avatar
    Join Date
    May 2004
    Location
    South West UK (Bath)
    Posts
    3,736
    Thanks
    39
    Thanked
    75 times in 56 posts
    mysqldump $databasename >/$location/$filename
    It is Inevitable.....


  4. #4
    Custom User Title
    Join Date
    Oct 2005
    Location
    Wirral UK
    Posts
    1,168
    Thanks
    10
    Thanked
    14 times in 14 posts
    • cougarslam's system
      • Motherboard:
      • Asus Maximus Formula SE (ROG)
      • CPU:
      • Core 2 Duo E6600 @ 3ghz
      • Memory:
      • 4gb Corsair DDR2
      • Storage:
      • 1TB
      • Graphics card(s):
      • BFG Nvidia 8800GT OC 512MB
      • PSU:
      • Corsair HX520
      • Case:
      • Zorro
      • Operating System:
      • Vista Business 32
      • Monitor(s):
      • 2 x 17" crt
      • Internet:
      • adsl max (entanet)
    Quote Originally Posted by peterb View Post
    myphpadmin and set up a cron job?
    all the servers use phpmyadmin but how can i setup a cron job.

    I don't tend to get access to the command line normally just ftp access/mysql access to the servers as most of the sites use shared servers (easily, heart internet etc)

    at the moment i have the joyous task of exporting the databases each day

  5. #5
    Senior Member
    Join Date
    Dec 2005
    Location
    south of heaven
    Posts
    519
    Thanks
    0
    Thanked
    2 times in 2 posts
    ask your admins to give you access to a local shell with a cron

    thats all there is to it - the rest is automateable. no shareware/****e required.

    tbh, admining a unix-based database without shell access is a bit like trying to fix cars with your bare hands, you need tools darnit - ask your provider if you can setup crons and get shell access or some way to edit a cron if there is no shell access available - if you're lucky you'll get some form of ssh access.
    SmoothNuts!~yaman_an@*.dsl.pipex.com > change my rating to exceptional tbh

  6. #6
    Custom User Title
    Join Date
    Oct 2005
    Location
    Wirral UK
    Posts
    1,168
    Thanks
    10
    Thanked
    14 times in 14 posts
    • cougarslam's system
      • Motherboard:
      • Asus Maximus Formula SE (ROG)
      • CPU:
      • Core 2 Duo E6600 @ 3ghz
      • Memory:
      • 4gb Corsair DDR2
      • Storage:
      • 1TB
      • Graphics card(s):
      • BFG Nvidia 8800GT OC 512MB
      • PSU:
      • Corsair HX520
      • Case:
      • Zorro
      • Operating System:
      • Vista Business 32
      • Monitor(s):
      • 2 x 17" crt
      • Internet:
      • adsl max (entanet)
    I was using navicat for a while and i could use that to conenct to and backup databases.

    trial has now expired and my work dont want to pay for a program.

    sqlyog looks like it can do autobackups anyone used it for this?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Philips PU 51285 Automatic Scart Switcher
    By Nick in forum Reader Reviews
    Replies: 11
    Last Post: 20-03-2007, 09:35 PM
  2. Automatci folder backup under linux?
    By E4xtraordinary in forum Software
    Replies: 12
    Last Post: 03-01-2006, 09:30 PM
  3. Making PHP and MySQL Talk?
    By Dav0s in forum Software
    Replies: 4
    Last Post: 18-09-2005, 10:53 PM
  4. Perl Backup Script
    By Mugato in forum Software
    Replies: 0
    Last Post: 31-08-2004, 01:43 PM
  5. Backup software
    By Shad in forum Software
    Replies: 11
    Last Post: 30-07-2003, 02:56 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •