Simple Machines Community Forum

General Community => Scripting Help => Aiheen aloitti: gatek33per - kesäkuu 22, 2008, 02:07:16 IP

Otsikko: Mysql Script for changing servers?
Kirjoitti: gatek33per - kesäkuu 22, 2008, 02:07:16 IP
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?

Otsikko: Re: Mysql Script for changing servers?
Kirjoitti: rsw686 - kesäkuu 22, 2008, 04:13:23 IP
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.
Otsikko: Re: Mysql Script for changing servers?
Kirjoitti: gatek33per - kesäkuu 22, 2008, 05:01:20 IP
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.

Otsikko: Re: Mysql Script for changing servers?
Kirjoitti: rsw686 - kesäkuu 22, 2008, 05:03:56 IP
Lainaus käyttäjältä: gatek33per - kesäkuu 22, 2008, 05:01:20 IP
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.
Otsikko: Re: Mysql Script for changing servers?
Kirjoitti: gatek33per - kesäkuu 22, 2008, 05:11:14 IP
Ahhh. gotcha!
Thanks!