Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
missing 'textpattern' table in database?
hi ~ i have a feeling i’m going to have to take this up with the hosting company but maybe it’s something i’m doing absolutely wrong that will be obvious to more expert txp users. if so, thank you so much for any insight/help!!
i set up three different txp installations a few years ago for a friend. since then, registration for the domains has expired though the hosting contract (via dreamhost) still existed.
i’m now trying to download all the old site info and then my friend will cancel the hosting contract. we downloaded via FTP all the old installation files – the txp version being used was 4.0.2.
since phpMyAdmin was not available to download the MySql databases, as the domains had expired and that’s how dreamhost allows access to phpMyAdmin (i.e. mysql.domain.com), i connected to the server via SSH and did a mysqldump for all three databases.
so far, so good. or so i thought. using MAMP, i set up all three databases on my computer. i used the old txp files i’d downloaded via FTP and tried to view the sites on my browser using localhost. one worked so far, the other two nothing. i’ll figure out the other two (i hope).
so here’s the problem: there are no articles. in fact, the entire table ‘textpattern’, in which the articles should live, doesn’t exist. i have a total of 18 tables in each database. ‘discuss’ is there, ‘logs’, ‘lang’, etc but no ‘textpattern’. in the txp admin section for the comments, there’s lots of comments but next to each one it says “Article deleted!”. i’ve checked the original sql files i SSHed and there’s no ‘textpattern’ table there either.
i can’t understand what’s gone wrong. the weird thing is that this happened with each of the three databases. i can understand one database getting corrupted and losing (the most important!) table but ALL 3?? makes me think i must be doing something wrong. but then i look at the original mysqldump files and there’s nothing there. any ideas??
thank you!
Offline
Re: missing 'textpattern' table in database?
Can you still access the database where it was originally hosted and check if the textpattern table did exist there?
Offline
Re: missing 'textpattern' table in database?
the only way i can access the databases is by SSH, which i don’t have much of any experience with. i tried to access one of them via SSH again and just do a mysqldump of that one missing ‘textpattern’ table but it said the table didn’t exist. that seems pretty clear, huh.
but what i don’t get at all is why all three databases are missing the same table. i hate to think all those posts are just gone.
i know the articles DID exist before, but that was years ago. the site has been inactive for at least two years, the domain names expired probably that far back, which makes me think that the hosting company somehow lost those tables. hard to imagine and very odd but i can’t figure out what else it could be.
Offline
Re: missing 'textpattern' table in database?
or there might be a corruption in one of the tables… Do you have access to phpmyadmin?
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: missing 'textpattern' table in database?
as far as i know, i don’t as the domain names expired a while back and that is the default way to get to phpmyadmin. i’m going to try emailing dreamhost and ask them if access to phpMyAdmin is available some other way.
if i did have access, how would i check to see if it’s a table that’s corrupting the databases?
thanks.
Offline
#6 2011-02-20 21:56:01
- uli
- Moderator
- From: Cologne
- Registered: 2006-08-15
- Posts: 4,315
Re: missing 'textpattern' table in database?
Download a copy of Adminer and FTP it to your server. It’s like a slimmed version of phpmyadmin. Open the textpattern table and from there export it.
In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links
Offline
Re: missing 'textpattern' table in database?
Connecting To Your Database (Dreamhost0
The linked page explains how to access your database using a third party app (I use sequel pro). If you use ssh in conjunction with with a 3rd app you are supposed to be able to access the database w/out a domain name (you use localhost instead)
Last edited by maverick (2011-02-20 23:18:23)
Offline
Re: missing 'textpattern' table in database?
thanks for the responses. i was finally able to access after all the old sites using phpMyAdmin but the tables are missing there as well. i’m hoping i have a backup somewhere on one of my old external hard drives but they’re back in the u.s. (i’m in south america) and that’ll have to wait until april at the earliest. i’ve also asked dreamhost to send me the oldest backups they have of the databases – which i believe would be from 5 days ago – just to make sure i didn’t corrupt the dbs myself when accessing them via SSH somehow. before yesterday, these dbs hadn’t been touched in at least three years.
the only other two options that come to mind in terms of missing tables (since i know there were there three years ago or so), is that someone hacked in and deleted them or dreamhost somehow lost them. the first seems pretty impossible, and anyhow why get rid of one table and not just the whole database? the second option seems more possible but still, why THAT specific table? and how does an error like that happen equally in all three databases? is there something special about that table (the ‘textpattern’ one) that makes it more vulnerable in some way?
thanks again for any input. i really appreciate it.
Offline
Re: missing 'textpattern' table in database?
andrea wrote:
the only other two options that come to mind in terms of missing tables (since i know there were there three years ago or so), is that someone hacked in and deleted them or dreamhost somehow lost them. the first seems pretty impossible…
Improbable but not impossible. Maybe it is time to change your login/passwords for your ftps dbs.
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline