Moving from one host to another

[kat]

Not your fault, mate.

Interwebz is such phun...

See you in a while...

[user1234]

Not your fault, mate.

Interwebz is such phun...

See you in a while...

I will be toiling away in your absence. May God bless you and may He comfort your wife.

[user1234]

Reviewing the steps again (For when you return if you have a little time. If it's a squeeze (even worse than I know it already has been!) please PM me).

How do I move my SMF board to a different the host?
The move consists in 2 steps:

Step 1: Move the public html files of the board (these are the files in your board install dir).

Is the "install dir" in the "database" area of new host? Or is that what they are calling the smf folder?

Either download them to your pc, then upload them again on the new host. In case the url or server path settings change, adapt all board settings to the new url and server path names. The repair_settings.php tool can do most of the work for you automatically.

Step 2: Move your db data from the old host to the new host. Use these FAQs for moving your db structure and data: How do I save my SMF board? and How do I restore the database data?
_________________

How do I save my SMF board?
The save consists in 2 steps:

Step 1: Save the public html files by downloading them to your PC. This can be done with an FTP program.

I presume this is what you already did from the old public_html to the new httpdocs/smf folder.
And the file sizes look about the same as at old host. I went back and detailed any differences in the files list on the prior page.

Step 2: Save the database. This can be done with the "Backup Database" option in the Administration Center of your SMF forum (Admin > Forum Maintenance).

I did this on 8-7 and it is the file I sent you the RapidShare link to (6.64 MB as stated, compressed, in my computer)

Make sure you save both structure and data of the database as well, either in two different steps or in one unique save.

I did mine in "one unique save" having checked all the boxes in the admin>maintenance>backup section of the forum on the 7th. It saved by the default name in my computer as 
mysitenameshortened3letters_smf2-complete_2010-08-07.sql.gz 
(the RapidShare file mentioned in the prior comment)

If you know how to do it, you can also backup your SMF's database with PhpMyAdmin.
_____________________

How do I restore the database data?
To restore a database backup you will need a program such as phpMyAdmin, which is used for MySQL database management. Most hosts provide this, however, if you are unsure of its location, please contact your host for guidance.

When you have successfully entered phpMyAdmin select the correct database from the left. If you have not created one there may be the option to create one on the phpMyAdmin home page. Name the database the same name as the old one and select to create it.

Could there be a conflict with the names of the old and new databases?

The new database suffix is  _smf  the old database suffix, as far as I can tell, is   _smf2   )

Note backup file names
smf2.sql.gz

Can a database be renamed, or is it best to be thrown out and uploaded to all over again?

If you do not have the option to create it inside phpMyAdmin, you may need to visit your control panel and use a tool such as MySQL Database Wizard to create it first. If you are having trouble creating a database you may wish to contact your host or the Official phpMyAdmin Homepage for help.

Once you have selected the correct database select the import tab and locate your file. Ensure you have the right character fileset (usually utf8 or ascii), and then select go.

Sometimes this will spark an error message stating that the file is too big. If this happens you may need to contact your host to change the limits for you, or you may wish to break up the .sql file using wordpad and import it in smaller pieces.

As it is again doing today. I am going to guess that the host maybe figured out what I was asking and did it himself yesterday, if you didn't send a service ticket.
If it is opened up and a DDoS attack just happened to happen then, would my host get pounded for bandwidth or is it unrelated?
But it looks like all the files are present anyway, doesn't it?

Might the "missing tables" you mentioned earlier be in the following RapidShare file?

Should this
mysitenameshortened3letters_smf2-complete_2010-08-07.sql.gz
6.64 MB "complete backup" file that I downloaded from the forum, be included at this point, or did you already?
___________________

Later addition
I just noticed that the following files

attachments   4
avatars   4
Packages   4
Smileys   4
Sources   4
Themes   4
.htaccess   4

also appear in the next directory up. In the httpdocs directory. Same sizes.
They arrived on the 20th so they must have gotten there through the stuff you uploaded.
Maybe they always appear in the root file and the smf extension both. Do you know?
__________________________

Later discovery.
This one was pretty exciting.
In the public_html folder of my former site there is one folder labeled the same as my website tucked right in among all the other folders at the top of the file.

attachments   4
avatars   4
mywebsitename 4
Packages   4
Smileys   4
Sources   4
Themes   4

Could this be where the missing tables are? Or why the site isn't functioning right?
It is 4 kb just as was the smf2.sql.gz file

I am dying to create a folder at the new account, labeled my website name, and then click on the "add new file" button and put the contents of the smf2.sql.gz file in it. Would that do anything? Could it hurt or corrupt something?

[kat]

Really sorry.

It's serious.

I could be a while.


Sorry sorry sorry....

[user1234]

Really sorry.

It's serious.

I could be a while.

Sorry sorry sorry....

I'm the one sorry my friend. So sorry to hear the news. I'll continue to pray for her.
Do you or your wife have cholesterol issues (no I'm not selling the stuff, I just use it.)?

[Adish - (F.L.A.M.E.R)]

Take a chill K@, don't stress too much. Take care.

If you need anything, give me a shout.

[kat]

Ta, mate.

Just got her back.

Suspected heart-attack. 

After zillions of tests, an ECG and all that lovely stuff, it looks like it may be angina.

Phew...

Head's all over the place and I'm not gonna be able to concentrate, today, really.

I'll definitely get back, to this, on the morrow, though.

[Adish - (F.L.A.M.E.R)]

That cools a few things Take care!!

[user1234]

Ta, mate.

Just got her back.

Suspected heart-attack. 

After zillions of tests, an ECG and all that lovely stuff, it looks like it may be angina.

Phew...

Head's all over the place and I'm not gonna be able to concentrate, today, really.

I'll definitely get back, to this, on the morrow, though.

That's great news! At least she didn't have a heart attack! An acquaintance of mine has lived with angina for maybe the last 35 years.

Your absence had the added benefit of inspiring me to force myself to learn what this is all about.
Please express to your wife how thankful I am to her for that!
I Downloaded FileZilla and used it just fine and I think I may be capable of doing the whole process now (though I might find out differently).
In summary I would like to .....

1.  delete the database at the new host named username_smf (that you thought might be missing some tables) and create a new one named the same name as my old one    username_smf2

2. Then upload my fresh copy of the database that I got from my old host using phpMyAdmin   

Is it because I am running Windows 7 Ultimate that the file size is only 22 MB? - (contains 41 tables)
A gal at hostmonster did the very same download, from the very same place, and it was 40 MB.
When I called with concerns later, a guy told me it was because they run Linux. Would that explain the disparity, as he suggested it did?

3. Next I would like to move all the files out of the smf folder at the new host, and up one level to my httpdocs area, the way they were at hostmonster.
Not only to be uniform with the way it was, but a friend said that he thought his regular type website performed better, after he moved it out of a folder and directly into his public_html area.
Also it would automatically restore the former URL that did not contain the /smf/

Sound like a plan? Do I have your blessing to go ahead, even after all your toil on it?
I would like to do it myself so I know I can make it all work if I need to do this again. OK? (I'm usually at my computer by at about 4-5 AM EDT)

PS You can skip the PMs, if they even made it to your mailbox. I hope you read this first.

[kat]

OO! I replied to your PM, before I saw this.

The database I got, name_smf2-complete_2010-08-07.sql is about seven meg.

That's about what mine is.

That's compressed, though. In-situ, it's more like twenty-four meg.

I'm on 7 Ultimate, too. It shows as the same on XP.

The "name" directory I have, too. As we were just trying to get the forum up'n'running, I left that, for later.

By the way, if you use Filezilla, make sure the transfers are set to "binary", NOT auto. Filezilla has a bug and if you upload files, some get corrupted, in auto.

If you don't have any mods, upping files from the SMF install archive/package would definitely work. As the ones I upped were the ones I got from your old site, they should be OK.

Yes, there IS an SMF directory, there. I put them all in the root, too. I never got round to deleting the smf directory, before I had to go, I'm afraid.

Odd thing was, I couldn't get the database to connect, which is where I left it.

Running repair_settings.php should fix that, but it hadn't, when I left it. That was what I was trying to do, when I had to run.

The database that I have is named "name_smf2".

Not sure how Plex handles databases.

If you had that in CPanel, I believe that the database NAME is "smf2" and the prefix is "name".

Normally, the database would be "smf2_name", you see.

Things are mellowing-out, here, now. My wife's feeling OK, apart from a headache. We're going to have an early night, to recuperate (Just off now, as it 'appens). As soon as I get going, tomorrow, I'll get back on this, for you.

Basically, we have everything backed-up.

Try whatever you like, coz if anything gets screwed, we're covered! 

[user1234]

OO! I replied to your PM, before I saw this.

The database I got, username_smf2-complete_2010-08-07.sql is about seven meg.

That's about what mine is.

That's compressed, though. In-situ, it's more like twenty-four meg.

I thought your file was bigger than 50 meg and that's why the phpMyAdmin kept warning.

Some files I noticed in the old host public_html are.....

Folder of website name right in with other folders  742 kb

Files labeled ....

install_1-1.sql   40 kb
news_readme.html   4
readme.html   12

Do those matter or are they irrelevant? Should I upload them to the smf folder?

I'm on 7 Ultimate, too. It shows as the same on XP.

The "webname" directory I have, too. As we were just trying to get the forum up'n'running, I left that, for later.

By the way, if you use Filezilla, make sure the transfers are set to "binary", NOT auro. Filezilla has a bug and if you upload files, some get corrupted, in auto.

I remembered you saying something about a bug but forgot what it was.
Little late for that. Worth a redownload? My version is

2010-08-16 - FileZilla Client 3.3.4.1 released
Bugfixes and minor changes:

    * Set a minimum size for column widths in directory lists and transfer queue
    * Fix build-time check for system TinyXML

If you don't have any mods, upping files from the SMF install archive/package would definitely work. As the ones I upped were the ones I got from your old site, they should be OK.

Yes, there IS an SMF directory, there. I put them all in the root, too. I never got round to deleting the smf directory, before I had to go, I'm afraid.

Odd thing was, I couldn't get the database to connect, which is where I left it.

Running repair_settings.php should fix that, but it hadn't, when I left it. That was what I was trying to do, when I had to run.

The database that I have is named "username_smf2".

Not sure how Plax handles databases.

The phpMyAdmin looks identical to the utility in my CPanel at the old host when launched, if this is related to what you are mentioning.

If you had that in CPanel, I believe that the database NAME is "smf2" and the prefix is "username".

Normally, the database would be "smf2_username", you see.

Things are mellowing-out, here, now. My wife's feeling OK, apart from a headache. We're going to have an early night, to recuperate (Just off now, as it 'appens). As soon as I get going, tomorrow, I'll get back on this, for you.

Basically, we have everything backed-up.

Try whatever you like, coz if anything gets screwed, we're covered! 

Yeaaaaa!

[user1234]

A little problem with phpMyAdmin - Error message
____________________

Error

SQL query:

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

--
-- Database: `username_smf2`
--
CREATE DATABASE `username_smf2` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation
#1007 - Can't create database 'username_smf2'; database exists
___________________________

Because I named it the same as the old database, which I thought, smf instructions dictate.

"When you have successfully entered phpMyAdmin select the correct database from the left. If you have not created one there may be the option to create one on the phpMyAdmin home page. Name the database the same name as the old one and select to create it."

(PS, while chatting with the gal at hostmonster yesterday I think she mentioned that I wouldn't be allowed to create a database the same name as the old one.)

Anybody got any ideas?
There must be some place in phpMyAdmin to import an existing database, if you know the username and password, or something like that but I can't find it.

[user1234]

I think I figured it out.
I went ahead and named the database the same as the old database and then uploaded as per the SMF instructions not the 22 MB database file downloaded with phpMyAdmin from my old host, but rather the IN FORUM 6 MB "complete backup" I did on the 7th of August through forum admin>maintenance>backup  having checked all boxes for "one unique save".

But as I uploaded it with the phpMyAdmin, I got a

"Documentation
#1153 - Got a packet bigger than 'max_allowed_packet' bytes"  message.

The last table showing is   smf_message_icons   (12.3 KB)  (29th table out of 41 total)
And the next table that isn't showing is supposed to be   smf_moderators   (4.0 KB)


I asked the host if it could be temporarily accommodated and the first reply is not on a shared server.
It's probably not the end of the world if I have to go on a dedicated server because that's where I'd probably wind up after my next DDoS attack anyway.

Any ideas how to fix the packet problem?

If I hadn't done the in forum backup as "one unique save" but rather backed up the table structure separately, maybe things would have uploaded differently.

[kat]

They MIGHT be trying to get more money, from you, for having a non-shared environment.

If you tell them that you might as well close the account, because that database isn't what you'd call big, by any standards, they might come-up with a temporary fix, for you.

If they purport to be "Christian", I'd expect them to try to help you out, with this.

[user1234]

They MIGHT be trying to get more money, from you, for having a non-shared environment.

If you tell them that you might as well close the account, because that database isn't what you'd call big, by any standards, they might come-up with a temporary fix, for you.

The guy said they can't do anything about it, but suggested I download the backup file to httpdocs or somewhere, and then direct the phpMyAdmin there, but I think he was just floating ideas.
I don't see

1. How I would access that file with the phpMyAdmin utility and
2. Wouldn't the suspect packet get caught in it's craw anyway?
3. Does this make a compelling argument to back up tables separately from data rather than "one unique save"?

VPS is 28 a month and it would upload fine.
Then my site wouldn't affect any other websites next time I get attacked. While one of the guys originally said they could handle the attack, I have my doubts.
_____________________________

Edit later
The guy told me to upload the file to a folder in the httpdocs section, and then ask tec to put it in the database.
When I uploaded it, it opened about half the files then it sat for a long time on "opening BINARY mode data connection for - (backup file name). While it sat there the percentage bar kept going. Then

Command:   STOR (backup file name)
Response:   150 Opening BINARY mode data connection for (backup file name)
Response:   421 No transfer timeout (300 seconds): closing control connection
Error:   Connection closed by server
Response:   226 Transfer complete
Status:   File transfer successful, transferred 6,967,861 bytes in 210 seconds
Status:   Disconnected from server

[kat]

1: No idea. You only get the option, with "Import", to locate a file on your computer.
2: You'd've though so, wouldn't you?
3: I've no idea how you'd import them all, separately, I'm afraid.

As they've told you that these things can be done, it's be nice if they expanded, on that, and gave you a clue, at least, on how you'd do it, wouldn't you think?

[user1234]

Check my "later edit" in the post above first.
The guy tried the data base dump from the folder that I put in my httpdocs section and it now does contain all 41 tables but he wrote

"We have imported the sql dump into your database, but the restrictions still apply to your user so there is a chance your application is not going to work correctly. Thanks"

And the site is not online.
Should I first download all the program files from the former host public_html section, with FileZilla set on binary, and then upload and "overwrite" all of the files in my httpdocs file, including the ones you put in there?
Would it matter that the data base is there first?

I added these to httpdocs from my former host public_html files today

install_1-1.sql   40
news_readme.html   4
readme.html   12
schema_41.sql   36

3: I've no idea how you'd import them all, separately, I'm afraid.

1. yes indeed. only goes to one's own computer
3. I meant have it separated in 2 pieces that it allows you to download them in. Then first the table structure could be uploaded, and then the data, oui?

[kat]

There's something seriously wrong, with that site.

I went to http://yourwebsite.com/repair_settings.php AND  http://www.yourwebsite.com/repair_settings.php

and I'm getting a 500 error.

Have a look. That file's definitely there and it's totally read/write-enabled (CHMOD 777).

So, how the Hell can there be a 500 error?

Your index.html file's there, in EXACTLY the same place, and it's finding that, OK.

This really doesn't make any sense...

[MrPhil]

and I'm getting a 500 error.

Have a look. That file's definitely there and it's totally read/write-enabled (CHMOD 777).

So, how the Hell can there be a 500 error?

Probably the new site is running suPHP, which forbids "world writable" directories or files (e.g., 777) under pain of 500 error. There is no reason to make a file or directory 666 or 777 unless SMF complains that it can't write to the file or directory, and you've already tried lesser permissions (664/775).

[kat]

Tried those and got squat.

Oddly enough, though, repair_settings has just decided to work....

Just got to figure-out the details, for that, now.

Ta, Mr. P!