how to backup mysql?

Discussion in 'MySQL' started by izlik, Jul 17, 2007.

0
  1. #1
    Hey.

    I have a mysql server running on my windows 2003 server here in my room. i dont have any control panel, nor do i have phpmyadmin. i wonder how i can make a backup of the mysql database wich i later could use to restore it on a webhost's mysql server if im moving over to one ?
     
    izlik, Jul 17, 2007 IP
  2. kcammandc

    kcammandc Peon

    Messages:
    17
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    if i was you i would download some free software such as sqlyog this is a high class bit of kit to deal with everyday mysql tasks
     
    kcammandc, Jul 17, 2007 IP
  3. gibex

    gibex Active Member

    Messages:
    1,060
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    95
    #3
    you can use mysqldump
     
    gibex, Jul 17, 2007 IP
  4. tbe

    tbe Peon

    Messages:
    15
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Use this...it is free and very very easy to use.

    http://www.mysql.com/products/tools/administrator/
     
    tbe, Jul 18, 2007 IP
  5. Bryce

    Bryce Peon

    Messages:
    1,235
    Likes Received:
    93
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I use Navicat software and do a mysqldump...

    http://www.navicat.com/

    I highly recommend this software to anybody using mysql. It's a GUI based interface to mysql. I've been using it for over 4 years.
     
    Bryce, Jul 18, 2007 IP