News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Moving from one host to another

Started by user1234, August 17, 2010, 06:54:36 PM

Previous topic - Next topic

user1234

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?

kat

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.  :(

MrPhil

.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.

kat

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.  ;)

user1234

#124
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?

kat

I suspect that file's a hostmonster preferences database...

user1234

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

kat

Yeah. I think that pretty-well confirms it. :)

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

Did you get it done finally? :P I want to celebrate the achievement!! :)

MrPhil

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.

Advertisement: