2

I know exactly how to move the users from one server to another, but I'm not too sure about how to move the tables that I already have along with it.

FYI this is a Kaltura server so I need to be extremely careful about it, no "oops" allowed.

How do I to move my MySQL server to another computer?

MDMarra
  • 100,734
  • 32
  • 197
  • 329
ebolton
  • 143
  • 4
  • 1
    Check the official MySQL documentation for mysqldump. It's tool #1 for doing simple backup/restores. – pauska Nov 08 '12 at 19:48

1 Answers1

3

Do a mysqldump from your existing server and import it on the new server.

man mysqldump should give examples of the various syntax options available. The mysql.com page for it has plenty of useful info as well.

This will leave all of your data right where it is, just in case there is an "oops", you can quickly roll back to using your old server.

MDMarra
  • 100,734
  • 32
  • 197
  • 329