My forum got DDoS attacked again and so hostmonster suspended my site.
I still have access to files for a limited time in my file manager.
A week ago I downloaded an SMF backup directly from my forum, and checked the box so it includes both structure and data of the database in one download (I think).
The file name ends with _smf2-complete_2010-08-07.sql.gz
I discovered today (in spite of the unhelpful new host phone help yesterday) that my new host does indeed have SMF available with one click installation.
It is version 1.1.2
I believe I had been running 1.1.11
Do I install 1.1.2, and then do all the necessary updates to 1.1.11, and then will I be able to use the forum itself to directly upload my
_smf2-complete_2010-08-07.sql.gz file?
My old forum was completely default with no custom stuff (at least not intentionally!)
I can't explore the old forum for an answer on restoring, because it is shut down and offline.
Quote from: akabugeyes on October 23, 2005, 07:51:43 PM
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). 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 (http://docs.simplemachines.org/index.php?topic=663.0) tool can do most of the work for you automatically.
New host but same .com URL as last host. Just repointed DNS.
But I am to ignorant regarding what "server path settings" this is inquiring about. Or how to find that out about my former installation, or it's prospective new home. Is that path this?
http:/ /sitename.com/index.php
Quote from: akabugeyes on October 23, 2005, 07:51:43 PM
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? (http://docs.simplemachines.org/index.php?topic=491.0) and How do I restore the database data? (http://docs.simplemachines.org/index.php?topic=490.0)
So then that step is the one I already did, and have the 6.65 mb file from whose file name ends with
_smf2-complete_2010-08-07.sql.gz
Sorry for bumping my own post, but I extremely edited the OP after discovering that my new host does have one click installation of SMF
If I were you, I'd upload the database and install SMF v1.1.11, pointing the install to your current database.
Quote from: K@ on August 18, 2010, 06:01:47 AM
If I were you, I'd upload the database
Thanks for the reply and please excuse my ignorance.
Do you mean I do indeed click on the new installation of SMF at my new host?
Quote from: K@ on August 18, 2010, 06:01:47 AMand install SMF v1.1.11,
Meaning then I do the updates in the freshly installed 1.1.2 until it becomes 1.1.11?
Quote from: K@ on August 18, 2010, 06:01:47 AMpointing the install to your current database.
To what "current database" are you referring, since my former host yanked the forum and suspended the account?
Is the "current database" the backup file that I downloaded to my computer from my old forum?
Point what to what?
Or
how do I point?
They didn't even let you have the database?
NAME NAMES! What an awful host!
To ensure that you have the latest versions of SMF, I'd ignore the install they give you and do a fresh install from here.
Have a read through this and see if it switches any lights on, for you.
http://docs.simplemachines.org/
Quote from: K@ on August 18, 2010, 06:22:10 AM
They didn't even let you have the database?
NAME NAMES! What an awful host!
Hostmonster (a host that I have absolutely adored) did allow me 15 days before the door hits me on the way out. So I do have access to my cpanel and files for a few more days.
Can I find what you are referring to in there? When I go to the "backup wizard" and go to "Download a MySQL Database Backup", under that heading there is a single link under "databases" with the suffix _smf2
It's 20 bites and downloads in an eye-blink. The file name as defaulted to my computer is smf2.sql.gz
Is that what you are referring to?
If so how do I upload it to my new host?
Can I install the SMF 1.1.2,
go to my new install and update to 1.1.11,
then is there a way within the forum itself that allows me to upload that "Database Backup" file to the forum,
then a way to upload the _smf2-complete_2010-08-07.sql.gz also within the newly uploaded forum itself?
Quote from: K@ on August 18, 2010, 06:22:10 AM
To ensure that you have the latest versions of SMF, I'd ignore the install they give you and do a fresh install from here.
That's what you'd do. And you enjoy doing that kind of stuff. For me, mucking about in the mystery of zipping/unzipping files that I am lucky to find on my computer after downloading them, is sheer torture.
So if you hated this stuff, and were completely ignorant as to how to do a fresh install "from here" to my new host, and you were looking for the easiest way to do it, and your new host does not "support" 3rd party software, would you one-click install the 1.1.2 and then update to 1.1.11?
I'll review the installation instructions which I haven't done yet.
Edit additionI did confront my fears and downloaded the "zip" file, then clicked on "extract" and it saved itself into my documents as smf_1-1-11_install
I presume it's ready to go.
I may be able to utilize my host help from here to put it in the right place.Quote from: K@ on August 18, 2010, 06:22:10 AMHave a read through this and see if it switches any lights on, for you.
http://docs.simplemachines.org/
I did spend time there yesterday searching moving hosts but there wasn't much.
OK I downloaded SmartFTP and made the connection.
I dragged the smf_1-1-11_install
file into the correct folder on the left.
The transfer is still zinging along, but when I look at the "server log" it shows "server closed almost 10 minutes ago.
Is this normal?
Since the transfer is still taking place according to the bottom panel of SmartFTP does that mean it is still taking place in spite of the last entry on the server log?
edit addition
It finished. It says 4.79 kb and the file at my host has it rounded to 4.00 so I guess it transferred OK.
2nd edit
OK so here's where my stupidity really paid off.
The file originally extracted itself and put itself into my documents as
smf_1-1-11_install
So I dragged it over to the "httpdocs" file at my host, on the left side of my SmartFTP window (I called to make sure this was the right place)
and so I obviously wound up with a file of the same name. smf_1-1-11_install
I didn't make a folder for it first.
So now I guess I would have to go to the installer as
http://www.mydomainname.tfl/smf_1-1-11_install/install.php
But I don't get jack squat when I visit there. I presume the hyphens make it invalid.
Can I just rename the folder?
Are you beginning to see why I favored the one click installation of 1.1.2 from my host?
3rd addition
I renamed the folder smf but still nothing but broken link message from firefox when I go to
http://www.mydomainname.tfl/smf/install.php
Am I just screwed?
Usually, the root of your forum will be in public_html (If you have one).
First, you need the database.
The way I do that, is go to your site's cpanel>Files>backups.
There, you have the facility to restore, as well as backup.
You'll see "Download a MySQL Database Backup" and, to the right, "Restore a MySQL Database".
(This is assuming that your cpanel's the same as mine).
Click "Choose" and navigate to your database, click "Upload" and your database should... er... upload! ;)
Then, if you have a backup of the forum, too, you can do it on the same page, where it says "Restore a Home Directory Backup".
Once you've done that, you should be good to go.
If not, you might need to run this:
http://www.simplemachines.org/community/index.php?topic=18096.0
Once that's all done, you can upgrade to v1.1.11.
Quote from: K@ on August 18, 2010, 11:46:06 AM
Usually, the root of your forum will be in public_html (If you have one).
First, you need the database.
The way I do that, is go to your site's cpanel>Files>backups.
There, you have the facility to restore, as well as backup.
You'll see "Download a MySQL Database Backup" and, to the right, "Restore a MySQL Database".
(This is assuming that your cpanel's the same as mine).
I had this function at hostmonster.
I don't have it at my new host unless it comes as part of an uploaded SMF.
I called and asked if there is a "Restore a MySQL Database" function anywhere in my account and tec said no.
Quote from: K@ on August 18, 2010, 11:46:06 AM
Click "Choose" and navigate to your database, click "Upload" and your database should... er... upload! ;)
Then, if you have a backup of the forum, too, you can do it on the same page, where it says "Restore a Home Directory Backup".
I have a full backup of the forum that I did directly from the forum before it was shut down.
Default saved itself as
_smf2-complete_2010-08-07.sql.gz file? zipped file size shows 187 mb under "properties"
I have a backup of the database from hostmonster default name saved as
smf2.sql.gz 20 bites
Are these all I need, to know that somehow, somewhere, I will be able to restore the forum?
Can I get at least
one decent night's sleep?
Is phpmyadmin something I can install in my own account, or something my host has to install on the server?
http://www.phpmyadmin.net/home_page/index.php
I am beginning to think that the phone guys at my new host aren't so hot.
I may have found what I needed in the help menu.
I will start fresh in the morning.
I created an smf forum 1.1.3 with the convenient button provided at my NEW host, to see where it would install.
1. It is listed in the "database" section, and
2. it created a folder the same that you recommended - smf - and put it in where my other home files are.
I found the new install online by adding /smf/ to my old URL as in .com/smf/index.php
For the heck of it I updated it up to 1.1.11 , by going in and out of admin and clicking on the update link each time. It doesn't find any bugs.
Is this of any value, or is it worthless, since it was created from scratch with a new admin user and password?
Also worthless because it includes an /smf/ in the URL unilke my old URL .com/index.php ?
At OLD host hostmonster the default installation scattered smf throughout my home files, rather than put it in a tidy folder, so my URL for the last 2 years, and all links from websites, youtubes, internal post to post links in the forum, search engine cataloging, etc. are to
.com/index.php without the /smf/
I don't suppose there a way I can change the URL back to the way it was, by using the admin section in the forum itself?
Some one click kind of thing?
(I went to "admin" then "server settings" then in "core configuration" I erased the /smf suffix on the "Forum URL" and clicked "save" - bad idea. Only the home page loads. To go to any other admin function it goes to the new URL and says bad link. When I add the /smf/ it takes me to where I want to go EXCEPT restoring the /smf to put it back the way it was.)
Should I just throw out what I have as useless and try another clean upload?
I don't suppose there is a file within the 19 files in the folder, that would accept the old downloaded database file, that I have in my computer?
Or a file in the new folder that I could replace with it?
Woah!
You've been busy!
I'm a bit confused, to be honest, with all these versions and stuff, along with things like "Also worthless because it includes an /smf/ in the URL unlike my old URL .com/smf/index.php "
which seems to contradict itself.
Plus "I called and asked if there is a "Restore a MySQL Database" function anywhere in my account and tec said no." is amazing. If you go to your site's cpanel, is there a section labelled "Files"? If so, isn't there an icon, there, labelled "Backup"?
He reckons that you can't restore a database? That has just got to be utter bollox. (To use a technical term)
You can do that in phpmyadmin, for a start.
In there, just select the database, then "Import".
If you have the database and the forum backed up, it should be really easy, this, if a little time-consuming.
1: Import the database to the site.
2: Restore the backup of the forum that you have.
3: Upgrade to v1.1.11, using the large upgrade.
4: Done!
It may be that you'll need to run this:
http://www.simplemachines.org/community/index.php?topic=18096.0
to correct any path problems that MIGHT crop-up.
I nearly suggested installing v1.1.11, instead of restoring your old 1.1.3, but I'm not sure if there were any changes made to the way it communicates with the database, to be honest. I mean, v1.1.3 is WELL back, so there may well be.
The only way that I can think of, to put SMF in a different directory, yet retain the old URL, is to setup redirects and all that stuff.
I'd suspect that could get a bit flaky, though.
I got your PM. I could help you out, in that way, possibly. Except, of course, I don't have your backups. (I don't charge for my services, here, coz I think it's wrong to charge, to be honest)
Problem is time. I have so much going-on, at the moment, that finding a continuous block of time to do all this is gonna be difficult, I'm afraid.
Have a fiddle around, as I've described, to see if you can get things sorted.
If not, I'll have to try and find a bit of time, when we can get this done.
I can't promise, though. :(
I don't make promises unless I know, 100%, that I can keep them. ;)
Quote from: K@ on August 19, 2010, 08:43:58 AM
Woah!
You've been busy!
I'm a bit confused, to be honest, with all these versions and stuff, along with things like "Also worthless because it includes an /smf/ in the URL unlike my old URL .com/smf/index.php "
which seems to contradict itself.
That did contradict itself and sorry for adding confusion.
I later wrote
At OLD host hostmonster the default installation scattered smf throughout my home files, rather than put it in a tidy folder,
so my URL for the last 2 years, and all links from websites, youtubes, internal post to post links in the forum, search engine cataloging, etc. are to.com/index.php without the /smf/
So my first question is, is there a way that I can get back to my old URL without the /smf/?
I would hate to loose 2 years of search engines meticulously cataloging my forum.
Maybe remove the folder and dump the 19 folders directly into my home file the way they were at hostmonster?
Quote from: user1234 on August 19, 2010, 09:29:25 AMremove the folder and dump the 19 folders directly into my home file the way they were at hostmonster?
That's what I'd do, to be honest.
Less hassle. ;)
Quote from: K@ on August 19, 2010, 09:35:34 AM
Quote from: user1234 on August 19, 2010, 09:29:25 AMremove the folder and dump the 19 folders directly into my home file the way they were at hostmonster?
That's what I'd do, to be honest.
Less hassle. ;)
Is there a chance they could do something like merge with other files in there inadvertently?
Like combine without asking questions like to "replace" an existing file?
"They" being your host?
Why would they need to get involved?
You can just move everything, yourself, using FTP.
Doddle. ;)
Quote from: K@ on August 19, 2010, 10:50:03 AM
"They" being your host?
Why would they need to get involved?
You can just move everything, yourself, using FTP.
Doddle. ;)
No "they" being the files. Could the files screw up other files in my home folder.
I just printed out the list of 20 files in the /smf/ folder at my NEW host, and found each one in my home files at my OLD host - hostmonster, except for the largest one - schema_41.sql which is the biggest at 36 kb.
But I don't think it would likely be productive for me to much about in there any more.
As long as you don't overwrite anything crucial to something else, you'll be OK.
When you upload them, you'll be asked before you overwrite anything, anyway.
I think the chances of there being duplicate files is nigh-on zero.
By the way, if you use Filezilla, make sure the transfers are set to "Binary", not "Auto".
Bug in Filezilla, unfortunately.
Quote from: user1234 on August 19, 2010, 07:29:12 AM
For the heck of it I updated it up to 1.1.11 , by going in and out of admin and clicking on the update link each time. It doesn't find any bugs.
Is this of any value, or is it worthless, since it was created from scratch with a new admin user and password?
If you had a working 1.1.3 with your data, the best path would have been to upgrade to 1.1.11, not forgetting to run "upgrade.php" at each step, to bring your database up to 1.1.11 format.
Quote
Also worthless because it includes an /smf/ in the URL unilke my old URL .com/index.php ?
At OLD host hostmonster the default installation scattered smf throughout my home files, rather than put it in a tidy folder, so my URL for the last 2 years, and all links from websites, youtubes, internal post to post links in the forum, search engine cataloging, etc. are to
.com/index.php without the /smf/
Leave it in /smf/. That's the best structure -- to have your forum in its own subtree, so that you can add and delete other applications at will, without fear that they're going to step on each other. It also leaves your root directory uncluttered. If you're on an Apache server (any Linux, some Windows installations), you can use
URL rewriting in your
.htaccess file to have visitors "see" .com/ as your site location, while visits are transparently rerouted to .com/smf/. If you're on an IIS server, I don't know what the equivalent is. Don't forget that your Settings.php file has to show .com/ as the URL to get to the forum, but ...public_html/smf/ (or whatever) to get to the
files.
OO! I didn't know about that .htaccess thing!
Ta, Mr. P!
Quote from: K@ on August 19, 2010, 11:00:02 AM
As long as you don't overwrite anything crucial to something else, you'll be OK.
When you upload them, you'll be asked before you overwrite anything, anyway.
I think the chances of there being duplicate files is nigh-on zero.
By the way, if you use Filezilla, make sure the transfers are set to "Binary", not "Auto".
Bug in Filezilla, unfortunately.
I just realized all I have to do is highlight the individual file and click on "move" and direct it to move up one level.
I moved one up to my root httpdocs (main) file and moved it back to smf folder without a problem.
Quote from: MrPhil on August 19, 2010, 11:09:10 AMIt also leaves your root directory uncluttered. If you're on an Apache server (any Linux, some Windows installations), you can use URL rewriting in your .htaccess file to have visitors "see" .com/ as your site location, while visits are transparently rerouted to .com/smf/.
Would "visitors" include search engines "seeing" it the same way they have for the last 2 years?
Quote from: MrPhil on August 19, 2010, 11:09:10 AM
Quote from: user1234 on August 19, 2010, 07:29:12 AM
For the heck of it I updated it up to 1.1.11 , by going in and out of admin and clicking on the update link each time. It doesn't find any bugs.
Is this of any value, or is it worthless, since it was created from scratch with a new admin user and password?
If you had a working 1.1.3 with your data, .....
I had a working 1.1.11 with my data.
The version that is uploadable with a button at my host is 1.1.3
I think the one at hostmonster is an old version too.
Quote from: MrPhil on August 19, 2010, 11:09:10 AM..... the best path would have been to upgrade to 1.1.11, not forgetting to run "upgrade.php" at each step, to bring your database up to 1.1.11 format.
It seemed to work just fine. All I had to do was jump into administration, then jump out. When I came back there was another message to update. All 10 or so updates only took a few minutes to do.
But to create the database with the magic button to begin with, I started with a new username, password, etc.
Should I use my old admin username and password, or doesn't it matter once the database backup is uploaded?
As long as your Settings.php knows the new user name and password, all will be well. They are only used to get access to the database by SMF.
And yes, search engine spiders are "visitors".
I finally found the mySQL database upload place. There is a "database" section in my account that I had .... shall we say underappreciated! :P
I was looking in the wrong place, and then later when I mucked around a little in it, it wasn't opening the window mySQL offsite window because of popup blocking that I didn't notice.
OK, my excitement is growing.
Please excuse all the stupidity I displayed and time of yours I have wasted K@
Now I have a shiny new updated to 1.1.11 version of the forum in my files.
Admin name and password are the same as my old forum
But I can throw it out easily as I already have twice before.
So do I try to go into that database to upload the dinky 20 kb "database" backup first?
Then do I try to do it again with the full forum backup next?
Then maybe do the little trick to change the URL of the site?
The following instructions at my host don't include installing the forum with a button click.
Is the whole installation already in the backups I have?
Should I throw out the smf forum that I installed before beginning?
To import an existing database:
1. On your Home page, click Databases.
2. Click Add New Database.
3. Enter a name for the database.
We recommend that you choose a name that starts with a Latin alphabet symbol and comprises only alphanumeric and underscore symbols (up to 64 symbols).
4. Select the database type that you are going to use: MySQL, PostgreSQL or Microsoft SQL Server. Click OK.
5. To set up database administrator's credentials, click Add New Database User.
6. Type a user name and a password that will be used for accessing the contents of the database. Click OK.
7. Click the DB WebAdmin icon in the Tools group.
An interface to phpMyAdmin, phpPgAdmin, or ASPEnterpriseManager database management tool will open in a separate browser window.
If you have a MySQL database:
1. Click Query window in the left frame, click the Import files tab,
2. Select the text file that contains the data and click Go.
3. Click the Insert data from a text file link.
If you have a MS SQL database:
1. Click the name of your database in the left frame
2. Click Query (the magnifying glass button)
3. Copy the text of your script into the text area and click Run Query.
To manage your databases and their contents, use your favorite MySQL, PostgreSQL, or Microsoft SQL Server client or the Web based database management tool accessible from Parallels Plesk Panel (Home > Databases > database name > DB WebAdmin).
Either way round should work.
As long as the database name and login details are correct, you should be good to go!
Quote from: K@ on August 19, 2010, 01:56:25 PM
Either way round should work.
As long as the database name and login details are correct, you should be good to go!
Is the forum installation included in the data backups and forum backup that I saved?
Er... without looking I wouldn't have a clue.
You can always use your archiver to look at what's in them.
The sql one will be your database.
Quote from: K@ on August 19, 2010, 02:05:50 PM
Er... without looking I wouldn't have a clue.
You can always use your archiver to look at what's in them.
The sql one will be your database.
I later realized what you meant when you said I had a 10 PM limit in here.
Since I ran out of PMs do you want to contact me or have me contact you some other way? Like replying back and forth in my yahoo email account?
Do you think you calling the host with questions might help?
Now an ignorant question. Regarding the password, is "@" an acceptable character to use in one?
Yep.
It accepted it, so all's good.
That 10 PM thing can be a right pain in the arse, at times.
Do you have an IRC client? (Opera has one, built-in) :)
There's an SMF support chatroom, if you have.
Ask your host about that restore thing, first, though.
Quote from: K@ on August 20, 2010, 09:32:34 AM
Yep.
It accepted it, so all's good.
That 10 PM thing can be a right pain in the arse, at times.
Do you have an IRC client? (Opera has one, built-in) :)
There's an SMF support chatroom, if you have.
Ask your host about that restore thing, first, though.
Did you get the popup window with the links in it in this step?
7. Click the DB WebAdmin icon in the
Tools group.
The Help files don't seem to bear any similarity to what I can see.
For example, it says "Go to Home > Backup Manager."
I click "Home" and there IS no backup manager!
"Tools" group?
There isn't one! There is, inside "databases". That just let's me create a new db, nothing else.
What I've done, thus far, is create a directory, inside "httpdocs" named "smf". At the moment, I'm upping the contents of your actual forum, into that.
I hope that's the right place. With CPanel, it's public_html. Anyway, even if it's the wrong place, we have another backup. ;)
OO! Hang on!
Progress!!!
Quote from: K@ on August 20, 2010, 09:51:48 AM
What I've done, thus far, is create a directory, inside "httpdocs" named "smf". At the moment, I'm upping the contents of your actual forum, into that.
I hope that's the right place. With CPanel, it's public_html. Anyway, even if it's the wrong place, we have another backup. ;)
"httpdocs" is the equivalent of "public_html" or at least that's where all my website files are currently.
Their tec support answers the phone very quickly.
I tried restoring the database and get an error.
#1153 - Got a packet bigger than 'max_allowed_packet' bytes
I'm trying, again.
These bloody hosts all seem to think we all have 50 meg upload speeds... **Rolls eyes**.
Fancy them using popups. My popup blocker was killing it.
Gotta lurve Plesk...
Quote from: K@ on August 20, 2010, 10:06:03 AM
I tried restoring the database and get an error.
#1153 - Got a packet bigger than 'max_allowed_packet' bytes
I'm trying, again.
I got that message twice with the file that I sent you, that I presume is smaller than the file you are trying to upload.
Quote from: K@ on August 20, 2010, 10:06:03 AMThese bloody hosts all seem to think we all have 50 meg upload speeds... **Rolls eyes**.
Fancy them using popups. My popup blocker was killing it.
Gotta lurve Plesk...
Exact same thing happened to me as I reported yesterday.
I kept waiting for it to pop up and didn't notice the little pop-up blocker warning on my browser right away.
I tried running SET GLOBAL max_allowed_packet=1000000000; to get around that error.
I got "#1227 - Access denied; you need the SUPER privilege for this operation"
Might need to contact your host, if my retry fails.
Quote from: K@ on August 20, 2010, 10:11:57 AM
I tried running SET GLOBAL max_allowed_packet=1000000000; to get around that error.
I got "#1227 - Access denied; you need the SUPER privilege for this operation"
Might need to contact your host, if my retry fails.
If I clean install SMF with their button and run updates to 1.1.11 like I did on the 3 installations I installed and played with and then removed yesterday, is there a different backup that can be downloaded from hostmonster that may somehow go on top of that?
I tried it yesterday with that backup file I sent you, and it uploaded, but the two didn't marry.
Like you found, it seemed like I had to create a separate database, in order to get to the tools button available to launch the pop-up window to function.
Or is the full backup I did directly from my forum (that I sent you) sufficient, once the forum is in place?
The backup I have is of the entire site, not just the forum.
Let's see how this database restore goes, first.
Quote from: K@ on August 20, 2010, 10:11:57 AM
Might need to contact your host, if my retry fails.
Their answer will be that they don't support 3rd party applications.
Though that can't be their answer as to where the "backup" and "restore" section of the control panel is.
All you need to tell them, is that you need to run that query, in MySQL, so that you can import the database.
It only needs to be temporary, after all.
Most of it seems to be there.
I stopped the forum upload, to let this have all my bandwidth.
Once that's done, I'll finish upping the forum and we'll see what happens, ay?
Quote from: K@ on August 20, 2010, 10:25:12 AM
All you need to tell them, is that you need to run that query, in MySQL, so that you can import the database.
It only needs to be temporary, after all.
Most of it seems to be there.
I stopped the forum upload, to let this have all my bandwidth.
Once that's done, I'll finish upping the forum and we'll see what happens, ay?
I dialed, then pressed 2.
Brad answered immediately. He offered to walk me through it.
Since I don't know what you have where it is impossible for me to be in the middle of this.
Could you please, please, please call?
Brad said that anyone there could help, but if you get a guy that doesn't seem real swift, you maybe should ask for Brad.
Heh... From here, in England, that call would cost me megabucks!
If you just tell him that you need to run this query:
SET GLOBAL max_allowed_packet=1000000000;
in mysql, you'll be laughing.
Not yet, though. I'm still retrying and it's got further than before, already. So, we MIGHT be OK.
Quote from: K@ on August 20, 2010, 10:41:15 AM
Heh... From here, in England, that call would cost me megabucks!
I thought you were domestic when you inquired about "across the pond" I thought you thought I was English. Toll free here.
I called and didn't get any further than last time
Quote from: K@ on August 20, 2010, 10:41:15 AM
If you just tell him that you need to run this query:
SET GLOBAL max_allowed_packet=1000000000;
in mysql, you'll be laughing.
Not yet, though. I'm still retrying and it's got further than before, already. So, we MIGHT be OK.
Can you go to the "support" while inside the account and request what you need on a ticket?
Yeah, probably.
If this fails, again, I'll give it a go.
Mind you, a 500 meg database is pretty huge.
Maybe you have ******loads of stuff in your error logs, or something.
Quote from: K@ on August 20, 2010, 10:55:12 AM
Maybe you have ******loads of stuff in your error logs, or something.
If that is something I was supposed to empty or do something about, it's got 2 years worth.
If it generates an email announcing every database error, over 2 years there were only a dozen or so such messages sent to me.
There aren't that many images in the forum either, if that matters.
If you did a full backup of my entire hostmonster account, it includes my website too. I don't think the website is all that big, and it is in antique software with no bells or whistles.
Yeah, if you're moving to a new host (new server), this might be a good time to clear out the log, particularly the error log, tables. That might cut your database down quite a bit in size, and preferably should have been done before backing up the database (unless you had no opportunity to do so). Worst case, you can manually edit the .sql file and delete all the INSERT INTO smf_log_errors commands. Incidentally, if your .sql file is too big to import all at once, feel free to use an editor to break it up into smaller pieces (so long as you CREATE a table before you INSERT data into it). Once you're settled in and running again, keep an eye on the error log for a while, as the change in PHP levels and configuration details (not to mention file corruption from the move) could cause lots of errors to pop up.
Well, it's still upping, so keep fingers crossed, eh? :)
Quote from: MrPhil on August 20, 2010, 11:04:24 AM
Yeah, if you're moving to a new host (new server), this might be a good time to clear out the log, particularly the error log, tables. That might cut your database down quite a bit in size, and preferably should have been done before backing up the database (unless you had no opportunity to do so). Worst case, you can manually edit the .sql file and delete all the INSERT INTO smf_log_errors commands. Incidentally, if your .sql file is too big to import all at once, feel free to use an editor to break it up into smaller pieces (so long as you CREATE a table before you INSERT data into it). Once you're settled in and running again, keep an eye on the error log for a while, as the change in PHP levels and configuration details (not to mention file corruption from the move) could cause lots of errors to pop up.
Thank you Mr. Phil, though a little discouraging regarding your "file corruption" note. :'(
Unfortunately my host canceled my account during the DDoS attack and took my site down. I did a full in-forum backup the week before.
I still have access to the my CPanel files but won't for very much longer.
I'm afraid I migrated to the wrong host because they use Plesk.
Seems incomplete or at least difficult.
Quote from: K@ on August 20, 2010, 11:11:58 AM
Well, it's still upping, so keep fingers crossed, eh? :)
I still am.
What is the in-forum, full-backup function for, if it isn't useful?
When and/or how is it applied?
(whoops sorry, I should have searched the subject first)
I've never worked that out, myself.
I think it's just the database.
Still going...
Quote from: K@ on August 20, 2010, 11:36:59 AM
I've never worked that out, myself.
I think it's just the database.
Still going...
Your cat icon aptly describes what's going on.
I just found this description of the "too big" upload message
http://docs.simplemachines.org/index.php?topic=490.msg5447#msg5447
Since it's still going do you think that Brad figured out what we needed, or did you fill out a ticket?
I think we have a database!
Just going to up the rest of the forum.
This could take a while...
Quote from: K@ on August 20, 2010, 11:46:02 AM
I think we have a database!
Just going to up the rest of the forum.
This could take a while...
I just found this subject described a little differently than I didn't before. Did you ever get the
3. Select the Restore database from backup file check box.
selection?
_________________
If the database does not exist and you need to recreate it from scratch:
1. Go to Home > Databases and click Add New Database.
2. Specify the database name, type and server for the database you are restoring.
Note. You can specify a new database name, but you must choose the correct database type: for example, if you are trying to restore a MySQL database, choose MySQL database type.
3. Select the Restore database from backup file check box.
4. Specify the location of the database backup file. You can upload a backup file from your local machine or specify a file located on the server.
5. Provide the default username and password for the restored database.
6. Click OK.
If you are restoring MS SQL database, there is a possibility that some database users will be orphaned. In order to provide the ability to access and use the database for these users, you need to repair them. Refer to Recovering Orphaned Database Users section for more information.
Yeah, I waded through most of that.
Still I got there, in the end.
Just upping the actual forum, now.
It's gonna take a while, coz you have billions of different languages and things, there.
It's gonna take an hour, at least.
Quote from: K@ on August 20, 2010, 10:55:12 AM
Maybe you have ******loads of stuff in your error logs, or something.
It just dawned on me. Would 4 DDoS attacks over the last year have caused it to log a gillion errors?
The little "most online today" meter had counts of 700 and 800 before the site went into dysfunction.
I think that "most ever online at one time" count is something like 850
No idea, to be honest.
When we've got this up'n'running, maybe we can empty some of the logs out.
It's still only 1% done, so we're gonna have to sit tight and wait, for this.
5% **Yawns**
Quote from: K@ on August 20, 2010, 01:19:42 PM
5% **Yawns**
Does 4% in an hour mean it will take 25 hours?
I bloody hope not!
My upload speed's terrible, though. Always has been.
What's taking all the time is all those damned language files. They seem to be everywhere and it seems that you have every language on Earth installed.
Quote from: K@ on August 20, 2010, 01:25:26 PM
I bloody hope not!
My upload speed's terrible, though. Always has been.
What's taking all the time is all those damned language files. They seem to be everywhere and it seems that you have every language on Earth installed.
That is the default installation. I do everything default. Even the forum itself. Nothing fancy.
I just went to "MySQL Databases" in my old account and it says the database is 45.81 MB
Is there a reason for the disparity?
Oh, the database is up and ready.
This is all of the actual forum files that I'm putting up, at the moment.
There's just shy of five hundred meg going up.
500 megaBYTES of files, going up at something like 6 megaBITS per second is bound to take a while...
13%, now.
Quote from: K@ on August 20, 2010, 01:32:54 PM
Oh, the database is up and ready.
But until the rest of the files go on, nothing will appear online?
Nope.
I'm gonna streamline it, a bit.
There're zillions of files, in the backup, that aren't really forum files.
I'm going to omit those and just get the forum up, for now.
I can always up the other stuff, later.
Quote from: K@ on August 20, 2010, 01:38:16 PM
Nope.
I'm gonna streamline it, a bit.
There're zillions of files, in the backup, that aren't really forum files.
I'm going to omit those and just get the forum up, for now.
I can always up the other stuff, later.
If you did an entire backup of my whole account, it also includes my website pages.
Yeah, there's a ton of other stuff, here.
Loads of html files and stuff.
As I said, I'll leave those, for now.
I just created an "smf" directory and I'm sticking everything SMF in there.
You can let me know what you want doing with the other stuff, when I'm done.
ehm, if I may interrupt. You can actually compress them and upload them.
.zip's and .tar.gz's are normally extractable by hosts. So just confirm about it with the host and you can upload the compressed file instead of files one after another. (I think you are doing it this way already, but just if you aren't, try doing that)
I've got it finished, now, ta!
Just got to figure-out paths and stuff, now.
Has your URL been switched over to the new host, yet?
I'm trying to run http://smf/repair_settings.php and I'm getting a 500 error.
Quote from: K@ on August 20, 2010, 02:30:07 PM
Has your URL been switched over to the new host, yet?
I'm trying to run http: .com/smf/repair_settings.php and I'm getting a 500 error.
Cut the URL back to the m in .com but please erase the link from your post
OK, done.
Has the URL been switched?
Quote from: K@ on August 20, 2010, 02:41:13 PM
OK, done.
Has the URL been switched?
Now, when you erased the URL from right to left, back to the
m in the .com and pushed enter, didn't you see the website?
OOPS! I thought you just meant here.
What do I need, then?
Ah... The rest of your site's not got the www at the front.
Odd. I point my browser to the URL, with /smf/repair_settings.php and I'm getting:
QuoteInternal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Weird.
Quote from: K@ on August 20, 2010, 03:05:49 PM
Ah... The rest of your site's not got the www at the front.
The URL reads like this on my Firefox browser http://www.b
And on Internet Explorer http://www.b
But on my Google Chrome browser http://b
I just tried them and it works both ways, on all 3 search engines.
If you type it in without the http:// all 3 engines give it without the w's
Most browsers, if you go to http://simplemachines.org/community/index.php, will try http://www.simplemachines.org/community/index.php automatically.
I'm not sure if the reverse is true, though.
Maybe your host can change it to www if you ask them?
I still can't get this finished, though, coz of the internal server error.
If your site at http://yourwebsite.com is working, http://yourwebsite/smf/repair_settings.php should be working and it's not. :(
If I put files in the root of httpdocs, they work.
Odd, huh?
Quote from: K@ on August 20, 2010, 03:18:09 PM
Most browsers, if you go to http://simplemachines.org/community/index.php, will try http://www.simplemachines.org/community/index.php automatically.
I'm not sure if the reverse is true, though.
Maybe your host can change it to www if you ask them?
I still can't get this finished, though, coz of the internal server error.
If your site at http://yourwebsite.com is working, http://yourwebsite/smf/repair_settings.php should be working and it's not. :(
If I put files in the root of httpdocs, they work.
Odd, huh?
My website URLs always had the www. in front
but my forum link URLs were always absent the www.
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?
Quote from: K@ on August 20, 2010, 03:29:57 PM
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.
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.
Quote from: K@ on August 20, 2010, 03:37:27 PM
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.
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.
Quote from: K@ on August 20, 2010, 03:58:54 PM
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.)
Neh. It's only 21:00, so it should be OK. :)
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.
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.
Hang on... I think it's back.
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...
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. :)
Quote from: K@ on August 20, 2010, 04:54:27 PM
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.
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.
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...
Quote from: K@ on August 21, 2010, 05:04:30 AM
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.
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.
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)
Quote from: K@ on August 21, 2010, 05:22:17 AM
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.
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.
Quote from: K@ on August 21, 2010, 07:30:26 AM
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.
Quote from: K@ on August 21, 2010, 07:30:26 AM
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.
Quote from: K@ on August 21, 2010, 07:30:26 AM
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.
Not your fault, mate. :)
Interwebz is such phun... ;)
See you in a while...
Quote from: K@ on August 21, 2010, 07:39:53 AM
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.
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).
Quote from: user1234 on August 21, 2010, 08:02:19 AM
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?
Quote from: user1234 on August 21, 2010, 08:02:19 AMEither 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.
Quote from: user1234 on August 21, 2010, 08:02:19 AM
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)
Quote from: user1234 on August 21, 2010, 08:02:19 AM
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)
Quote from: user1234 on August 21, 2010, 08:02:19 AM
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.gzCan a database be renamed, or is it best to be thrown out and uploaded to all over again?Quote from: user1234 on August 21, 2010, 08:02:19 AMIf 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 additionI 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 4Packages 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?
Really sorry.
It's serious.
I could be a while.
Sorry sorry sorry....
Quote from: K@ on August 21, 2010, 10:29:18 AM
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 (http://search.lef.org/cgi-src-bin/MsmGo.exe?grab_id=0&page_id=1693&query=integralean&hiword=integralean) (no I'm not selling the stuff, I just use it.)?
Take a chill K@, don't stress too much. Take care. :)
If you need anything, give me a shout.
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 cools a few things :) Take care!!
Quote from: K@ on August 22, 2010, 01:42:49 PM
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_smf22. 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.
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! :)
Quote from: K@ on August 22, 2010, 04:32:45 PM
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 12Do those matter or are they irrelevant? Should I upload them to the smf folder?
Quote from: K@ on August 22, 2010, 04:32:45 PM
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
Quote from: K@ on August 22, 2010, 04:32:45 PM
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.
Quote from: K@ on August 22, 2010, 04:32:45 PM
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!
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.
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. :(
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.
Quote from: K@ on August 23, 2010, 09:04:43 AM
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 laterThe 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
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?
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
Quote from: K@ on August 23, 2010, 09:53:05 AM
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?
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...
Quote from: K@ on August 23, 2010, 12:02:00 PM
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).
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!
Quote from: K@ on August 23, 2010, 12:22:01 PM
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!
I put these files (from my former host public_html, into the new host httpdocs area today
install_1-1.sql 40
news_readme.html 4
readme.html 12
schema_41.sql 36
Could they be messing things up?
Also when I was downloading "Packages" with FileZilla, I noticed what looked like old copies of the forum saved, or something like that. Were the default saved?
Could this folder have gotten some stuff in it by accident by sharing a name with another program?
Are these the backups you were talking about?
If so could you save a copy, and clean some junk out if that could be creating some conflicts?
They're not gonna cause any problems.
I'd leave everything alone, now, until we figure a way of getting the database up.
Frustratin', innit?
You've definitely got some weird files, in weird places, I have to say. cab files and all sorts.
They won't stop the forum connecting to the database, though.
That's the problem that we have to solve.
No database=No forum. :(
.cab files? Those shouldn't be on a webserver. They are Microsoft Windows installation "cabinet" files, and belong only on a PC (or maybe a Windows server?). Perhaps someone who didn't know what they were doing uploaded a bunch of junk from their PC, and messed up their site in the process?
Ta to K@ too. Hope your wife is doing better.
Yeah, she's doing much better, ta, Mr. P. :)
Those cab files just contain an .tlx file, whatever they are. Dictionary Files?
They've been there for over a year, so maybe he forgot they were there.
The website and the forum both share the root of the site and those files are just laying around, in the root.
As they're named after the website owner, I suspect that he may have put theme there, sometime. ;)
Somthing I noticed from the virgin one button install I did earlier last week was a file named
schema_41.sql 36
that it put in my httpdocs smf file (I installed and deleted the one-button install last week)
However I find it as a separate list of 34 items in my former site phpMyAdmin database.
Listed as information_schema (34)
It is not in my new database
Could this be the missing link?
The excitement builds..... (once again.....)
I downloaded it.
Can I do a simple default import to the database with phpMyAdmin and it will know how to put itself in the database?
I suspect that file's a hostmonster preferences database...
Quote from: K@ on August 23, 2010, 04:52:45 PM
I suspect that file's a hostmonster preferences database...
A file of the same name came with the virgin install at my new host but in the smf folder.
I boldly tried to upload it to my new database and answered my earlier question.
Error
SQL query:
-- --------------------------------------------------------
--
-- Table structure for table `COLUMN_PRIVILEGES`
--
CREATE TEMPORARY TABLE `COLUMN_PRIVILEGES` (
`GRANTEE` varchar( 81 ) NOT NULL DEFAULT '',
`TABLE_CATALOG` varchar( 512 ) DEFAULT NULL ,
`TABLE_SCHEMA` varchar( 64 ) NOT NULL DEFAULT '',
`TABLE_NAME` varchar( 64 ) NOT NULL DEFAULT '',
`COLUMN_NAME` varchar( 64 ) NOT NULL DEFAULT '',
`PRIVILEGE_TYPE` varchar( 64 ) NOT NULL DEFAULT '',
`IS_GRANTABLE` varchar( 3 ) NOT NULL DEFAULT ''
) ENGINE = MEMORY DEFAULT CHARSET = utf8;
MySQL said: Documentation
#1163 - The used table type doesn't support BLOB/TEXT columns
Yeah. I think that pretty-well confirms it. :)
Did you get it done finally? :P I want to celebrate the achievement!! :)
No, you don't want to transfer a "schema" file from one database to another. It's not part of SMF. The new database will build one if it's needed.