Backing up MySQL?

By golfing22
Dec 21, 2005
Topic Status:
Not open for further replies.
  1. I'm going to be moving to a new server soon and I want to backup everything in my MySQL server. I have phpmyadmin and I know how to back up the databases with it. What I really want to know is if it's possible to back up the user settings. Also is it possible to backup TeamSpeak2 user settings.
    Thanks,
    golfing22
  2. Nodsu

    Nodsu Newcomer, in training Posts: 9,431

    What user settings? For what program?

    If the user settings are kept in the SQL database then they will be backed up too. If the user settings are kept in a file then you will need to copy these files.
  3. golfing22

    golfing22 Newcomer, in training Topic Starter Posts: 33

    The program is MySQL 5. And I have a lot of username settings that I need backuped. Are the user settings stored in the normal database dump or do you have to back them up sepretly.
    Thanks
  4. Nodsu

    Nodsu Newcomer, in training Posts: 9,431

    MySQL users are kept in the "mysql" database. If you choose to back that one up then yes, your users are backed up too.
  5. golfing22

    golfing22 Newcomer, in training Topic Starter Posts: 33

    cool, that makes everything a lot easier
Topic Status:
Not open for further replies.


Add New Comment

TechSpot Members
Login or sign up for free,
it takes about 30 seconds.
You may also...


Get complete access to the TechSpot community. Join thousands of technology enthusiasts that contribute and share knowledge in our forum. Get a private inbox, upload your own photo gallery and more.