Whats the best way to mov the database?

[BigJohnny]

Im moving my board to a different domain, and instead of being at domain.com/Board it's going to be at domain.ca/Forums

Well I downloaded the DB and manually replaced all instances of domain.com with domain.ca respectively (I have done this before numerous times successfully) and imported the data to the new domains database.

now ive noticed some strange things, one of which being that the "Admin" in my "adminstrator" title is censored, so my user title is showing as "*****istrator" even though i actually am the admin.

The settings to exempt mods from the censor is exactly the same as on domain.com except on domain.com it's working properly, so I obviously need a better way to import my database from one server to another.