SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Wizard Mincer's Avatar
    Join Date
    Mar 2001
    Location
    London | UK
    Posts
    1,140
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    creating a mysql backup regime..

    I have a couple of questions regarding setting up a backup regime for a local mysql database running on Win2K Server.
    1. What mysqldump switches should I use for an optimum (complete) database backup?
    2. Seen as I can't trigger a backup from mysql itself, what the the most reliable way people have found to run a scheduled backup on a 2K Server?

    Thanks a million,

    Matt.

  2. #2
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    Location
    UK
    Posts
    7,168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    1) Try --opt!

    2) Create a batch file with your dump command in it and run it whenever you want using Task Scheduler

    Sean
    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature

  3. #3
    SitePoint Wizard Mincer's Avatar
    Join Date
    Mar 2001
    Location
    London | UK
    Posts
    1,140
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by seanf
    1) Try --opt!

    2) Create a batch file with your dump command in it and run it whenever you want using Task Scheduler

    Sean
    We're on the same wavelength then, 'cos that's exactly then method I've just been testing.

  4. #4
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    Location
    UK
    Posts
    7,168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)


    If you need to use PHP (say to create a unique file name) you can create a PHP script and set Task Scheduler to run a web browser and use the appropriate switch to get the browser to run your PHP file

    Sean
    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature

  5. #5
    morphine for a wooden leg randem's Avatar
    Join Date
    Jun 2002
    Location
    .chicago.il.us
    Posts
    957
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by seanf
    If you need to use PHP (say to create a unique file name) you can create a PHP script and set Task Scheduler to run a web browser and use the appropriate switch to get the browser to run your PHP file
    What a pain in the ****! Why not just use the PHP-CLI?
    ----Adopt-a-Sig----
    Your message here!

  6. #6
    SitePoint Wizard Mincer's Avatar
    Join Date
    Mar 2001
    Location
    London | UK
    Posts
    1,140
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by seanf


    If you need to use PHP (say to create a unique file name) you can create a PHP script and set Task Scheduler to run a web browser and use the appropriate switch to get the browser to run your PHP file

    Sean
    Nah, it's going to get backed-up to tape every night along with all the script files half an hour after the mysqldump takes place, so I can use the same filename.


Bookmarks

Posting Permissions

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