Database migration question.

[discore]

I need to take all users, posts, and forums from one board to another. Both are running 2.2.8 so this shouldn't be too painful. I'm just going to post my plan.. I guess I'm asking if anyone sees any obvious flaws with this

1: Dump these tables: forum, poll, pollvote, post, privatemessage, user, and userfield to a MySQL schema file from the original database. (via mysqldump)

2: Edit the schema do it doesn't CREATE any tables, only INSERTs information. The columns in, for example, the user table aren't going to be the same since there are hack differences between the two. This is my biggest concern.

3: Load the schema into the new database.

Is this going to work as planned? I'm trying to leave behind a totally broken database that I hacked to hell and now is a mess and move onto a fresh one, without losing accounts or posts.