Moving from one host to another

[user1234]

Well, I've done everything I can, now.

If I delete everything in the smf directory and put it in the root, where all the other stuff is, it'll work.

But it's not, in that directory. Heaven knows why.

One for your host?

When I did the one button installation it created a database in the database section, and put a folder named smf containing 20 files, in section where all my other website files are.

[kat]

Well, if you want me to move the files out of the SMF directory and put them in the root, where they were, before, I can do that.

I thought you wanted a separate directory, though.

[user1234]

Well, if you want me to move the files out of the SMF directory and put them in the root, where they were, before, I can do that.

I thought you wanted a separate directory, though.

Please don't get the idea I am trying to direct you. I am clueless. What I want is what you believe is best.
I only mentioned that simply to convey that information. In case it was a reason it wasn't working.
By the way, I did find out that Fantastico loads it full of that language crap, and I got it in the hostmonster fantastico section.

I may have to move the site again some day.
Though unlike hostmonster my new host has dedicated servers that they could move me to if need be.
He accepted me with eyes wide open. I told him there were a thousand open connections to the forum when hostmonster started dumping them.

[kat]

OK. As I said, I copied a couple of iles into the root and they worked, so I'm assuming that the whole thing'll work, if I move everything over.

Just had a small thought about why it's not working, though.

I'll check that, first.

If it doesn't work, I'll move things over.

If I can get it done, now, all well and good.

It's getting quite close to bedtime, here, though. So, I might have to finish it in the morning.

[user1234]

OK. As I said, I copied a couple of iles into the root and they worked, so I'm assuming that the whole thing'll work, if I move everything over.

Just had a small thought about why it's not working, though.

I'll check that, first.

If it doesn't work, I'll move things over.

If I can get it done, now, all well and good.

It's getting quite close to bedtime, here, though. So, I might have to finish it in the morning.

I am soooo sorry. I forgot it was your evening you were burning.
Would it help anything, or be of any use, if hostmonster allowed me to redirect the DNS back, and put the site online for a day, or something like that?
(I called. They won't risk it.)

[kat]

Neh. It's only 21:00, so it should be OK. 

[user1234]

My whole website is down now.
That must be why you were not getting the link you were trying, ahead of the whole thing going down.

[kat]

The host's down, too.

I can't get into the control panel, or anything.

I've literally just finished uploading everything, too!

All I need to do, now, is set the database settings and I can't, without getting into the control panel.

[kat]

Hang on... I think it's back.

[kat]

Nope. I can't access the control panel, at all. I'm getting a 404.

Looks like I'll have to finish it in the morning.

Possibly just as well, coz my vision's going funny, after all this...

[kat]

I get a page, for a brief nano-second, asking me for a PIN, but the page just vanishes and I get the 404.

Sorry, but I'm bloody knackered, after all this.

I'm gonna get some sleep.

Maybe, with a clear head, I can get it finished, in the morning.

[user1234]

The host's down, too.

I can't get into the control panel, or anything.

I've literally just finished uploading everything, too!

All I need to do, now, is set the database settings and I can't, without getting into the control panel.

I read this at about 8 EDT last night and had no trouble logging into the control panel, but my site was still offline.

[kat]

I can get to your site OK. It needs .index.html in the URL, though.

I'm making some progress, but something's weird.

Will report back as soon as I get anywhere.

[kat]

Repair_Settings.php is working and it says everything's OK. Yet, when I go to the forum, I'm getting "Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later."

So, I'm somewhat confused...

[user1234]

Repair_Settings.php is working and it says everything's OK. Yet, when I go to the forum, I'm getting "Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later."

So, I'm somewhat confused...

Could it be a file in the smf folder in httpdocs that has replaced or overwritten the regular database of the website (if there is such a thing)?
Something has definitely changed, since my uploaded regular website pages were working fine from Monday until last night, but disappeared and were replaced by the smf error message.

I am comparing files in the smf file with

1. the virgin install I did at new host
2. smf files that appear in there now
3. I haven't taken both lists to hostmonster to compare there.

[kat]

I think I know what the problem is, with the forum.

I checked the database and it looked like some of the tables were missing.

So, I tried to restore the database, again.

Guess what? I got that bloody message, again.

#1153 - Got a packet bigger than 'max_allowed_packet' bytes

Can you get onto your host and explain what's happening and ask them to run that query that I mentioned?

Namely:

SET GLOBAL max_allowed_packet=1000000000;

Until that gets sorted, we're stymied, I'm afraid.

I've got to go out, for a couple of hours, now. Can't get out of it, I'm afraid. 

I'll check back, here, as soon as I get back.

[user1234]

smf folder with file size kb - virgin install with one-button at new host (I think I made the list after I installed all updates from 1.1.3 to 1.1.11)
(I installed it, updated it, messed around with it, and threw it out - 3 times - the day before yesterday.)
..
attachments   4
avatars   4
Packages   4
Smileys   4
Sources   4
Themes   4
agreement.txt   4
changelog.txt   432
index.php   16
index.php~   16
license.txt   4
news_readme.html   4
readme.html   12
schema_41.sql   36
Settings.php   4
Settings_bak.php   4
SSI.php   64
SSI.php~   64
ssi_examples.php   8
ssi_examples.shtml   8

3 files that appeared in the smf folder, new-host-provided-one-button install, that do not appear in your httpdocs/smf folder were

news_readme.html   4   (this appeared in the virgin install and also in my old host public_html file (2.53 kb)
readme.html   12  (this appeared in the virgin install and also in my old host public_html file (8.38 kb)
schema_41.sql   36  (appeared in the virgin install, but not your httpdocs/smf folder, and not in my old host public_html file)
________________________

smf folder presently at new host httpdocs/smf folder that you imported

attachments   4
avatars   4
Packages   4
Smileys   4
Sources   4
Themes   4
.htaccess   4
500.php   4
agreement.txt   4
changelog.txt   436  (old host 431.3)
index.php   16        (old host 14.66)
index.php~   16       (old host 14.66)
license.txt   4
fantastico_fileslist.txt   4        (old host 274 Bytes)
fantversion.php   4               (old host 36 Bytes)
index.php   16           (old host 14.66)
index.php~   16          (old host 14.66)
license.txt   4
repair_settings.php  20   
Settings.php   4
Settings0.php  4
Settings_bak.php   4
SSI.php   64          (old host 56.63)
SSI.php~   64         (old host 56.64)
ssi_examples.php   8       (old host 5.37)
ssi_examples.shtml   8       (old host 5.12) 
TlxTransfer.txt  4       (old host 2.89)

I was able to spot all of the files in the httpdocs/smf folder at new host, scattered throughout the public_html files at my former host (some of slightly smaller file sizes) except

repair_settings.php  20 
Settings0.php  4

Here are the additional files that are in the httpdocs/smf folder now, that did not appear in the smf folder with the one button installation.

.htaccess   4
500.php    4
fantastico_fileslist.txt   4
fantversion.php   4
install_1-1.sql   40
repair_settings.php  20
Settings0.php  4
TlxTransfer.txt  4

(as an aside, I did happen to notice a file in former host public_html - error_log at 188.73 kb type text/x-generic - however it doesn't appear in the present httpdocs/smf file)

[user1234]

I think I know what the problem is, with the forum.

I checked the database and it looked like some of the tables were missing.

1. Is there a specific file or folder within the httpdocs/smf folder that the tables are generally found in (like the "Themes" folder or something like that)?
(edit - whoops I just read your post again and presume they go in the "database" section rather than http/docs ... duuh.)

2. Could there be a file in the httpdocs/smf folder that has somehow replaced/overwritten/or otherwise dominated the other files in httpdocs?
Something has definitely changed because my regular website pages were working fine from Monday when I ftp'd the site, until last night, when they disappeared and were replaced by the smf "connection problems" message.

[kat]

The settings0.php is a backup I made of Settings.php and repair_settings.php I put there, to... er... repair the settings.

The problem with your webby might be because browsers look for index.php, first. Before they look for index.html.

index.html is your actual website, whilst index.php is the forum.

Maybe your old site had something in place to override that.

I'm still looking at things.

Unfortunately, my wife's ill and I'm going to have to take her to the hospital, PDQ.

I'm really, really sorry. But, obviously, that's got to come first, particularly as we're talking "Chest pains".

I'll get back on it as soon as I can, I promise you.

[user1234]

The settings0.php is a backup I made of Settings.php and repair_settings.php I put there, to... er... repair the settings.

Excellent! All accounted.

The problem with your webby might be because browsers look for index.php, first. Before they look for index.html.

index.html is your actual website, whilst index.php is the forum.

I see.

Maybe your old site had something in place to override that.

I'm still looking at things.

Unfortunately, my wife's ill and I'm going to have to take her to the hospital, PDQ.

I'm really, really sorry. But, obviously, that's got to come first, particularly as we're talking "Chest pains".

I'll get back on it as soon as I can, I promise you.

Unfortunately, my wife's ill and I'm going to have to take her to the hospital, PDQ.

I'm really, really sorry. But, obviously, that's got to come first, particularly as we're talking "Chest pains".

I'll get back on it as soon as I can, I promise you.

Again I am soooo sorry to be such a pain in the arse when you've got too much else going on in your life. Please wish her well for me. I will be praying for her.