Results 1 to 4 of 4

Thread: MySQL backup?

  1. May 30th, 2002, 03:29 PM #1
    The Hobo
    The Hobo is offline

    Thread Starter
    Stuck in the 80s The Hobo's Avatar
    Join Date
    Jul 2001
    Location
    Michigan
    Posts
    7,256

    MySQL backup?

    How can I backup or download or whatever the MySQL databases on my webserver?
    My evil laugh has a squeak in it.

    kristopherwilson.com
    Reply With Quote Reply With Quote
  2. May 30th, 2002, 04:51 PM #2
    chrisjk
    chrisjk is offline
    PowerPoster
    Join Date
    Jul 1999
    Posts
    5,923
    use phpmyadmin...goto the database summary page

    Near the bottom it has a section "View dump (schema) of database"

    Click Select All, chose Structure and Data, tick Save As File

    Click go, save it somewhere on your HDD

    What you now have is an .sql file which contains the SQL queries needed to recreate the whole db...table creation and record insert SQL all there in one file.

    If you ever do need to restore it, just run the file through the execute query section by clicking Browse
    Reply With Quote Reply With Quote
  3. May 30th, 2002, 05:01 PM #3
    The Hobo
    The Hobo is offline

    Thread Starter
    Stuck in the 80s The Hobo's Avatar
    Join Date
    Jul 2001
    Location
    Michigan
    Posts
    7,256
    Sweet. I wonder if I could create a script to do this and make it run once every week?
    My evil laugh has a squeak in it.

    kristopherwilson.com
    Reply With Quote Reply With Quote
  4. May 30th, 2002, 05:04 PM #4
    chrisjk
    chrisjk is offline
    PowerPoster
    Join Date
    Jul 1999
    Posts
    5,923
    You could copy the relevent code from phpmyadmin
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width