Mysql Script for changing servers?

[gatek33per]

I'm using a shared server environment and I just purchased a dedicated server. I'd like to transfer everyone from my previous host to my new one. Is there a script out there that would  make this easier?

**Note**I"ve used the backup tool in SMF to create backups. If in any case I installed a fresh version of SMF and used the backup would it work?

[rsw686]

The backup tool in SMF just backups up the database. I've had some issues with it not setting the default values correctly and will give an error on import. I would just backup the database and files via your web hosting panel. On your dedicated server you can restore the files and database. Since it is a dedicated box it is as simple as using tar and mysql to do this. You'll need to use the restore settings php file to change the SMF file location.

[gatek33per]

Hmm, That doesn't sound to complicated. I'll give it a shot and see what happens. I just wanted to make sure there wasn't an easier way. Just incase I had two different versions of Mysql.

[rsw686]

Hmm, That doesn't sound to complicated. I'll give it a shot and see what happens. I just wanted to make sure there wasn't an easier way. Just incase I had two different versions of Mysql.

Different versions of mySQL is only a big deal if you are copying the physical database files. When you make a backup of the database with mysqldump or a similar tool it puts it into a standardized sql file that can be imported into almost any mySQL version.

[gatek33per]

Ahhh. gotcha!
Thanks!