mysqldump of mysql DB

[adam777]

I have some .sql files which are dumps of some databases I need to move to a new box.

Is it safe to upload the old mysql table from the old box to the new box to move all the users and their permissions or should I set up the new users manually. I dont have any users on the new box, I am simply moving to a new server.

I am concerened that if I execute these files the first thing they do is drop any existing tables and Im not sure how MySql will react to that in the mysql db.

Thanks

Adam

[gid]

I've moved directories in my mysql data directory to and from servers numerous times. Just make sure you back up the database that's getting modified before you do so in case you screw something up.

If you copy over the mysql (user perm) directory, then usually you'll want all the other directories as well as those are the various data sources that go with the users.