Transferring to Another Host

[keng_113]

Hi I'm planning transfer my website (www.pinoyshoegame.org) to another web host. I'm actually new at everything here so kindly let me know what I need to provide.

Here are my questions:

Is it easy?
What are the first thing I need to do?
Are there any chance that I may lose anything?

Thanks a lot, guys!

[kat]

Ta-da!

http://wiki.simplemachines.org/smf/Hosting_-_How_do_I_move_my_SMF_forum_to_a_different_host

[keng_113]

Ta-da!

http://wiki.simplemachines.org/smf/Hosting_-_How_do_I_move_my_SMF_forum_to_a_different_host

Hey, thank you! Do you have any suggestions, before I proceed with the transfer? Thanks..

[Kindred]

it's all pretty much answered there.

Without SPECIFIC questions from you, we can't make any further suggestions
(other than, always, always, always take backups)

[MrPhil]

Back up (files and database). Double check that you have a good and complete backup, sitting on your PC. Watch out for SMF attachments and avatars -- FileZilla will corrupt them unless you explicitly tell it to transfer in binary. Don't burn your bridges to your old host until your new site is confirmed up and running (check the attachments and avatars too).

[keng_113]

Thanks, everyone! BTW, are there any techniques on how to check if transfer is 110% successful? Thanks again.

[a10]

are there any techniques on how to check if transfer is 110% successful?

maybe not 110%, but checking for same exact filesize is a good start.

[Kindred]

well, The first thing is to learn basic mathematics, since 110% success is impossible    (I am joking!)

if your system works on the new host, then it was successful.

[Storman™]

Moving the files is pretty straightforward but the database can present the odd issue to the unwary. Have a read of point 6 under the General Notes:

http://wiki.simplemachines.org/smf/Backup

Seen several instances recently where people move host but have a mismatch with the database encoding of the old and new db's. If you don't make sure you have the same encoding then it might initially seem ok until you start seeing weird characters appearing.

So check that the encoding is the same on both sides and do a series of test posts to make sure the text appears as you'd expect it to appear. Also check the text in existing posts.

[rd]

You can't have 110% success while transferring host but you can be 100% certain that you don't lose data!

How?

Simple, download all your files and folders to a secure location in your computer. Also, don't forget to download the .sql file for you database using phpmyadmin!

Good luck!

[keng_113]

Hello guys,

thanks for all your replies. Although I have a couple more questions left:

• I'm worried that changing hosts might affect the forum and I might encounter random errors. Especially when my forum has different mods installed.
• I tried downloading the database file and the forum files and tried to upload it somewhere (free hosting) This is the result (attached)

I really need to change host soon

[Storman™]

I'm worried that changing hosts might affect the forum and I might encounter random errors. Especially when my forum has different mods installed.

As long as your new host provides you with a suitable and adequate amount of resources then your mods will not be affected.

I tried downloading the database file and the forum files and tried to upload it somewhere (free hosting) This is the result (attached)

Looks like the image files for the theme are not showing. Did you upload them ? Do they have the correct permissions (i.e. 644) ?

I wouldn't advise you choose a "free" host, your just asking for trouble generally.

[keng_113]

Looks like the image files for the theme are not showing. Did you upload them ? Do they have the correct permissions (i.e. 644) ?

What i did was I downloaded the entire content of the htdocs where my fourm files are uploaded. Then I just reuploaded again to a separate host. I'm not sure if I have to manually set permissions after reuploading.

I wouldn't advise you choose a "free" host, your just asking for trouble generally.

Actually, I was just testing it out before I entirely take down the original site and transfer to the new one.

[Tony Reid]

After moving host use the repair settings file to make sure all paths are correct.....

http://download.simplemachines.org/index.php?thanks;filename=repair_settings.php

[keng_113]

After moving host use the repair settings file to make sure all paths are correct.....

http://download.simplemachines.org/index.php?thanks;filename=repair_settings.php

Hi Toni,

Thanks for the info. May I know how to use it? Or where to upload the file? Thanks..

[Illori]

What is repair_settings.php?

[keng_113]

Hi guys,

I proceed with transferring of host. The website's files are now on the server and i'm the importing now the sql file. But i'm encountering this error whenever I import the SQL file:

Code Select Expand

Error
SQL query:

--
-- Database: `b7_13485051_pinoyshoegame`
--
-- --------------------------------------------------------
--
-- Table structure for table `pinoyshoegame_admin_info_files`
--
CREATE TABLE IF NOT EXISTS  `pinoyshoegame_admin_info_files` (

`id_file` TINYINT( 4 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`filename` VARCHAR( 255 ) NOT NULL DEFAULT  '',
`path` VARCHAR( 255 ) NOT NULL DEFAULT  '',
`parameters` VARCHAR( 255 ) NOT NULL DEFAULT  '',
`data` TEXT NOT NULL ,
`filetype` VARCHAR( 255 ) NOT NULL DEFAULT  '',
PRIMARY KEY (  `id_file` ) ,
KEY  `filename` (  `filename` ( 30 ) )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =8;

MySQL said: Documentation

#1046 - No database selected

Thanks.

[Storman™]

Please be more specific, how are you importing the SQL file, are you using phpmyadmin ?

Have you already created the empty database, created a database user, and given that user permissions ? If you did create the database did you select it before attempting importing the file ?

[keng_113]

Please be more specific, how are you importing the SQL file, are you using phpmyadmin ?

Have you already created the empty database, created a database user, and given that user permissions ? If you did create the database did you select it before attempting importing the file ?

what i did was just click import in the phpMyAdmin. Not sure if that was the right thing to do.

[Illori]

you need to select a database first on the left side before you can import your database tables.