Forum being shut down by Hosting Company Again!

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Pinkolyn
Registered User
Posts: 13
Joined: Mon Jan 13, 2020 8:36 pm

Re: Forum being shut down by Hosting Company Again!

Post by Pinkolyn »

My site is about 40 GB.

Just a quick question....

I am going to go back to the former hosting site (ipage) because my account is still active there until June... so I have some time to figure things out.
I transferred to Hostgator Dec 20, so there have been forum posts since then up until Jan 12th so I would like to save those.

I have FTP access to both hosts... and just need to transfer a couple weeks of forum posts back to the old server.

In my forum folder (FTP) that has all the php stuff... which folders or files in there contain the actual posts and images that I need to copy or transfer over to save the last couple weeks of postings? The images seem to be in the "files" folder... not the images folder. I don't know where the text files for posts are located.

thanks

User avatar
warmweer
Registered User
Posts: 3501
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Forum being shut down by Hosting Company Again!

Post by warmweer »

Pinkolyn wrote:
Tue Jan 14, 2020 4:01 pm
...
I don't know where the text files for posts are located.
There are no text files for post.
The database you had to make to instal phpBB contains some 70 tables among which a posts_table containing who wrote what, where and when (simply put).
It's that database which contains all the information from your board, the files are nothing more than means to get the information and to export that data into a "viewable" format.
Brexit and Trump are old news and currently I have no inspiration for a new signature.
Ow, wait: 3.3 has been released.

Pinkolyn
Registered User
Posts: 13
Joined: Mon Jan 13, 2020 8:36 pm

Re: Forum being shut down by Hosting Company Again!

Post by Pinkolyn »

Ok, so where are the databases located? I would assume somewhere inside the forum folder? A folder or file inside a folder somewhere?

User avatar
warmweer
Registered User
Posts: 3501
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Forum being shut down by Hosting Company Again!

Post by warmweer »

Pinkolyn wrote:
Tue Jan 14, 2020 4:42 pm
Ok, so where are the databases located? I would assume somewhere inside the forum folder? A folder or file inside a folder somewhere?
The database.
You should know where that database resides as that would be on the databaseserver your host has given you access to.
Did you install your board yourself or did you use a 1click installation from your host (softalicious or something similar)?
Just for clarity's sake, access to the database is through phpMyAdmin (or a similar program) and if you need to transfer your board, you will need to either use that to make a database- export, or use the phpBB Backup feature which will write the database backup to your /store folder. (considering your question I suggest the latter). I also suggest you read through the phpBB Documentation
Brexit and Trump are old news and currently I have no inspiration for a new signature.
Ow, wait: 3.3 has been released.

User avatar
KevC
Support Team Member
Support Team Member
Posts: 69536
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Forum being shut down by Hosting Company Again!

Post by KevC »

The database holds all of the information on the site. All the users, posts, forums, permissions, settings, PMs. That is on the host server and accessed by phpmyadmin. The database IS your site.

The files control all of the functionality of the site; how it looks and operates. These are on a different part of your hosting server and accessed by FTP.

We could still do with the Support Request Template (SRT) being filled out.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

Pinkolyn
Registered User
Posts: 13
Joined: Mon Jan 13, 2020 8:36 pm

Re: Forum being shut down by Hosting Company Again!

Post by Pinkolyn »

My site is shut down.. so I don't have access to the admin on my site. So I assume I don't have access to the database there. So I would have to access the databases through the Cpanel on the server? I was under the impression that the entirety of my site would be contained somewhere within my FTP account. So what I am hearing is... not true.
Last edited by Pinkolyn on Tue Jan 14, 2020 5:10 pm, edited 1 time in total.

User avatar
warmweer
Registered User
Posts: 3501
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Forum being shut down by Hosting Company Again!

Post by warmweer »

As per KevC, you need to post the filled in Support Request Template because (reading through this topic) there are a lot of information holes.
You mention 40 GB but that can't be the database: I suspect more than 39 GB of that are files you uploaded.
Also, you mention having transferred everything from you previous host: everything would include the database but that doesn't rhyme well with your question about where to the find the database (as a file).

As extra information you should also include how your transferred the data from your previous host.
And does your current board include all the posts from your previous board? I'm asking this because you mention wanting to transfer the new posts, implying that your current board does not include the old posts.
Brexit and Trump are old news and currently I have no inspiration for a new signature.
Ow, wait: 3.3 has been released.

Pinkolyn
Registered User
Posts: 13
Joined: Mon Jan 13, 2020 8:36 pm

Re: Forum being shut down by Hosting Company Again!

Post by Pinkolyn »

I had Hostgator do the transfer. Then it took them another two weeks to get it working as they didn't have tech people experienced with phpbb, mysql etc. Yes, the site is about 40 gigs, a lot of that is stuff I uploaded. I think one of the tech people said my database was about 4 gigs, but can't confirm that for certain.

I would like to save a couple weeks of posts .... is there a way to do that without having to copy 40 gigs of information?

User avatar
bubbathegimp
Registered User
Posts: 81
Joined: Tue Sep 25, 2018 8:02 pm
Location: Bronston
Name: Robert Anderson
Contact:

Re: Forum being shut down by Hosting Company Again!

Post by bubbathegimp »

The Bluehost Plus plan, and InMotion Power plans both look interesting, and they both rank above hostgator..
Also There's a special for Tech radar readers....
Old enough to remember when Water was free, and you had to pay for Porn :o

User avatar
JoshyPHP
Code Contributor
Posts: 1075
Joined: Mon Jul 11, 2011 12:28 am

Re: Forum being shut down by Hosting Company Again!

Post by JoshyPHP »

Still not posting the SRT... I'm unsubscribing from this topic but for the record, my best bet is they copied the database without creating the relevant indexes. Good luck.
I wrote the thing that does BBCodes in 3.2.

User avatar
Lumpy Burgertushie
Registered User
Posts: 67046
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Forum being shut down by Hosting Company Again!

Post by Lumpy Burgertushie »

if you are talking about moving the whole site then you have to copy it all and move it all.

it is not simple or suggested that you try to only add some of the database to the old one etc.

all of the database tables are interconnected and everything has an ID number.

if you try to add new posts to the old posts table you will most likely have conflicts with forum IDs, topic IDs, post ID, possibly user IDs etc. etc.

best to backup the whole board, files and database and transfer it to the new host at one time.

if your board has a lot of attachments then you may not be able to get them all by backing up the "files" folder from ftp. many, if not most, ftp programs will only show 9998 files in any single folder.
I am not sure if is the ftp programs or the server software, but using ftp you will not see any files or be able to download them if there are more than 9998 files in the folder.

so, you have to do it from your host control panel. it would be best to ask the host exactly how to do this.

if your host support does not know what you are talking about be sure to ask for level two support or a manager etc.


luck,
robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

User avatar
warmweer
Registered User
Posts: 3501
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Forum being shut down by Hosting Company Again!

Post by warmweer »

Pinkolyn wrote:
Tue Jan 14, 2020 5:13 pm
...
I would like to save a couple weeks of posts .... is there a way to do that without having to copy 40 gigs of information?
Extracting only the latest posts from your database isn't all that difficult, adding them to an existing database is difficult because it's not only the posts_table that is affected, also, topics_, forums_ notifications_, members_ and others. And that alone would be nothing more than a small fraction of the database.
The load is that 36 remaining GB of which most was on your old server already, so if you want to limit the transfer you'll have to identify the new files you uploaded.

But again, without an SRT there is no way anyone here can evaluate the situation.
If you have no access to your board and no Control panel access, all you can hope for is that you made a database backup and that you can download it from /store using FTP.
Brexit and Trump are old news and currently I have no inspiration for a new signature.
Ow, wait: 3.3 has been released.

User avatar
obfuscated
Registered User
Posts: 34
Joined: Tue Dec 17, 2019 5:20 pm

Re: Forum being shut down by Hosting Company Again!

Post by obfuscated »

Pinkolyn wrote:
Tue Jan 14, 2020 4:42 pm
Ok, so where are the databases located? I would assume somewhere inside the forum folder? A folder or file inside a folder somewhere?
In order to relocate the forum to a different server you would have had to back up the database from the maintenance tab in the ACP.

Do you recall doing that the last time you moved your forum?

Did you download it or save it locally in your account?

You'll need to do that again if you want to move your forum unless you want to lose any new posts.
Pinkolyn wrote:
Tue Jan 14, 2020 5:13 pm
I think one of the tech people said my database was about 4 gigs, but can't confirm that for certain.
If that is the case then it's no wonder you are having problems.. that is extraordinarily large imo for a forum that only has 40 users or whatever.

If you telnet/ssh into your account you can run this command to dump your database to a file instead of using ACP.. the db_username, db_password , host and db_name are all in your config.php

mysqldump --opt --user=db_username --password=db_password --host=mysql.yourhost.com db_name > db_backup_filename.sql

Pinkolyn
Registered User
Posts: 13
Joined: Mon Jan 13, 2020 8:36 pm

Re: Forum being shut down by Hosting Company Again!

Post by Pinkolyn »

Hi all,

For starters I want to thank all of you for helping out and with so much great advice and suggestions. A few of you have PM'ed me but I am not allowed to respond because I am a new member.. so please excuse me for that... not much I can do.

As far as the SRT, I looked at it and I really didn't know the answers to the questions. I wish I did... as I am sure that might be helpful.

Obviously my view of the posts and pics, jpegs, etc is overly simplistic. I just assumed the text and image files were stored in a folder. Clearly it doesn't work that way.

I might just copy the posts myself into a text file, download the pics and re submit them manually using the "users" permissions to do it. Sounds easier. There might be 20 or 30 posts total.

The problem with the database files causing issues with the hosting company seems out of my area of expertise and theirs (hosting) as well. I think I just need to buy some time for now. I can go back to the old host until June. Drop this one (hostgator) and get my money back. I have to do this by the end of tomorrow.

User avatar
KevC
Support Team Member
Support Team Member
Posts: 69536
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Forum being shut down by Hosting Company Again!

Post by KevC »

Pinkolyn wrote:
Tue Jan 14, 2020 7:07 pm
As far as the SRT, I looked at it and I really didn't know the answers to the questions. I wish I did... as I am sure that might be helpful.
Just answer what you can.
Even the URL of the site would help.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

Post Reply

Return to “[3.2.x] Support Forum”