The Best and Easyst program to backup you MySql databse

Discussion in 'Technology' started by sammykinzz, Apr 13, 2012.

  1. sammykinzz

    sammykinzz
    Regular Member

    529
    0
    558
    +0
    0
    -0
    What is the most easyst way to backup your mysql database?

    Any programs that can do it ??
     
    #1
  2. Brujahpriest

    Brujahpriest
    Jedi Hunter

    6,583
    0
    693
    +0
    0
    -0
    Wow... now that is a blast from the past. Haven't needed to do this in a while. There is of course the mysqldump way of doing things (if you are running any kind of admin software interface, they will have an interface to doing this as well.)


    There does seem to be some software packages out there, but it looks like they all just use MySQL's built in. Of course if you wanted something custom you could always write something in .Net or PHP to do a backup.
     
    #2
  3. Francis

    Francis
    Sarcasm is me :)

    8,367
    1
    765
    +1
    0
    -0
    What are you backing it up from ?

    Most software AND host servers have a back up feature in the built in.

    In the software it's usually found in your maintenance part, while in your server in the C-Panel / SQL Options..

    I would imagine if you are running it on your own private server, you can just do what I did from a host server and copied it to my desktop..
     
    #3
  4. sammykinzz

    sammykinzz
    Regular Member

    529
    0
    558
    +0
    0
    -0
    Yeah it is a my own private server...

    Think i broke it...

    Cannot get MYSQL installed now...

    Just says installing and sits there.... hmmm Oh well...
     
    #4
  5. Brujahpriest

    Brujahpriest
    Jedi Hunter

    6,583
    0
    693
    +0
    0
    -0
    Windows server? Are you trying to install from a WAMP/LAMP installer or just mysql base?
     
    #5
  6. Francis

    Francis
    Sarcasm is me :)

    8,367
    1
    765
    +1
    0
    -0
    I agree... Maybe Ubuntu for servers ?
     
    #6
  7. Darrell

    Darrell
    Banned per User's Request

    12,926
    2
    0
    +2
    0
    -0
    Access the database using MyPHPAdmin, and run the back up through there.
     
    #7
  8. Francis

    Francis
    Sarcasm is me :)

    8,367
    1
    765
    +1
    0
    -0
    I think his problem is that MySQL might already be corrupted. If so and his software / server was not set to do auto-backups he maybe fucked..
     
    #8
  9. sammykinzz

    sammykinzz
    Regular Member

    529
    0
    558
    +0
    0
    -0
    Yeah i have fixed this problem....

    Im not sure how i did it but manage to get it installed. worked, created database and it worked, and set it up using the workbench.... Backuped and all good!

    Thanks for all the comments! :)
     
    #9