backing up mysql physical files

Discussion in 'MySQL' started by dethfire, Apr 8, 2009.

  1. #1
    instead of doing a mysqldump can I just backup the physical files in /var/lib/mysql ? if it crashes, I just copy and replace the folder?
     
    dethfire, Apr 8, 2009 IP
  2. modulecart

    modulecart Peon

    Messages:
    99
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #2
    This is possible but you need to have access to your server and it is a drag to do manual copy and paste with the permission issues and stuff like that, I suggest you download mysqlyog (search google) and this is free, this can download your mysql even if it is more than 500mb, and you can also restore your database with a dump more than 500mb (I used to own a forum with about 800mb sql data and it did upload it without a problem)
     
    modulecart, Apr 8, 2009 IP
  3. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #3
    You can copy the files but only for MyISAM tables. But chances are there you run into permissions problem if you don't have much experience with Linux.
     
    mwasif, Apr 11, 2009 IP