Moving Server

[JayBachatero]

DId you try bigdump to import the database information into godaddy?

[phishinfool]

I have been sitting here at the computer since around 8:30 this morning, its now 9:27 pm and I have gotten noplace.

I dont know how to run nor edit these files to work on godaddy's fikked up hosting. But I have a year prepaid already to figure it out.

I am busting my butt trying to learn all this as fast as i can, but I give up. im a plumber not a programming person & in a real hurry to drop the secondary hosting i have that always crashes just about daily. im at witts end.

[Uzbekistan]

I am moving my site to dreamhost to a third-level domain forum.boo.uz (before changing DNS on old one), i put the old one to maintenance, uploaded the new one. I am running SMF 1.1 RC2... so I changed all the paths accordingly. However, attachements & some avatars are not shown. I tried repair_settings.php, did optimise/repair from forum maintenance - no help. Than tried "File maintenance"... but it removed all attachements from the board! Had to reset the sql to the backup and reupload all the files again.

attachment dir's permissions are set to 777 (i also set the files to it as well, just in case).

I've spent a lot of time with this. Anyone, faced this sort of problem? Please help.

[Uzbekistan]

You all were really helpful but may be someone knows any other solution?

[JayBachatero]

Umm check your attachments dir and see if the attachments are there.

[Uzbekistan]

Heh, thanks... Found the problem.

My FTP clients (SmrtFTP, FlashFXP) were showing as if there were 2,000 attachements. In reality there were a looot more... I noticed it by checking the dates the files were modified. My attachements dir grew to 17 000 files totaling 1 Gig. For some reason FTP clients woulnd't show more than 2000 files (on Hostgator) so I was not actually moving all the files. Had to do Full Backup through Cpanel. Regards for your help anyways!

I hope it would be useful for someone else.

[sawz]

DId you try bigdump to import the database information into godaddy?

that bigdump is pretty cool, it moved a 304mb database into my phpmyadmin, real slick.

[CuTe_MaN]

I have moved my website to another server and i have done every thing it was said in the topic.

When i go to my forum I get this error message:

Unknown column 'art.ID_THEME' in 'field list'

any body can help?

thx

CuTe_MaN

[I.L.F]

pls help in finding the solution for cute problem. we need the forum to return back to life,

this is the massege:

hxxp:uaeu.org/smf/index.php [nonactive]

and this is the site before the problem.

hxxp:uaeu.org/smf/index.php?action=forum [nonactive]

-

I L F

[JayBachatero]

Seems like some tables were not imported properly.  Download a backup and reimport it on the new site.

[Roadwolf]

I am following this advice, but am having issues.   I am transfering from a linux machine on hxxp:gate.com [nonactive] to a windows machine at 1and1.com   ...    i really don't know what the built in Dump feature does in the hxxp:gate.com [nonactive]'s SQL manager..  but whatever it does, it seems to stick in random text into the dump file which causes myPhpAdmin to not read it properly.  I keep on getting bad syntax errors when trying to upload...   and yes, I am seperating the file at the end of the lines and only uploading a small section at a time.   

I am currently going to try to install myPhpAdmin on the hxxp:gate.com [nonactive] host to see if i can maybe use that instead of the built in Dumping process.

anyone else ever run into this?

[bbmtalk]

I am moving my forum from Xsorbit to SMF and using Bigdump to upload more than 200MB SQL to Godaddy.

After running bigdump.php, I got the following error.


-------------------------------------
Error at the line 26: ) TYPE=;

Query: <br />
<b>Notice</b>: Undefined index: Type in <b>/home/xsorbit/public_html/users5/brokebackmountain/Sources/DumpDatabase.php</b> on line <b>303</b>CREATE TABLE `brokebackmountain_attachments` (
ID_ATTACH int(11) unsigned NOT NULL auto_increment,
ID_MSG int(10) unsigned NOT NULL default 0,
ID_MEMBER int(10) unsigned NOT NULL default 0,
filename tinytext NOT NULL default '',
size mediumint( unsigned NOT NULL default 0,
downloads mediumint( unsigned NOT NULL default 0,
PRIMARY KEY (ID_ATTACH),
KEY ID_MSG (ID_MSG),
KEY ID_MEMBER (ID_MEMBER)
) TYPE=;


MySQL: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '
Notice: Undefined index: Type in /home/xsorbi

-------------------

Can anyone help please?

[CuTe_MaN]

Any Body Can help me in my problem?

I have changed my domain now

it is www.uaeuclub.com/smf/index.php

please help

my website is off now for few weeks

I have moved my website to another server and i have done every thing it was said in the topic.

When i go to my forum I get this error message:

Unknown column 'art.ID_THEME' in 'field list'

any body can help?

thx

CuTe_MaN

[JayBachatero]

Seems like some tables are missing.  Try restoring the backup again.

[CuTe_MaN]

I have restored it more than one time and always the same problem


I have fixed the problem by uploading new files and running the upgrade.php file

then i reinstalled the Tiny portal again and at that point i got the error message

so any body can help??


thx

CuTe_MaN

[dodgy]

Sorry for butting in on this post, but I can't find the "repair_settings.php" file anywhere. Is there somewhere I can get it directly. I'm running 1.1 Final.
Many thanks

[sawz]

http://docs.simplemachines.org/index.php?topic=663

[dodgy]

Thank you. You're a star

[kichu]

I Moved my websites server to new server. I used repair_setting.php and made some changes. Everything works fine but, in Arcade Section games are opening but score is not submitting. Can  any one Solve this Problem.

[Sir Perigrin]

Just Curious, but to save time with FTP, would it work to just install a brand new forum, Use the SQL from the old forum, and replace the settings.php and settings_bak.php Files on the new install with the old ones?