TXP crashed - Want to get blog info. Where can i get this?

JasonUK · 2011-04-23 21:04:06

My Textpattern blog completely crashed about 7 months ago. I think it was due to my ISP updating the PHP version. Not sure, anyway-

I can’t get to the admin so i wanted to collect all my blog posts. I assumed they were stored on the database but i can’t seem to find them there and i can find them in the textpattern folder.

Does anyone know where this info is kept?

Many thanks

Jason

ruud · 2011-04-23 21:24:28

Articles are stored in the database in the main ‘textpattern’ table.

JasonUK · 2011-04-23 21:52:09

thanks for the reply. The only problems is that the ‘textpattern’ says ‘in use’ and I can’t access it as you can see below. I can’t even export it as it always crashes. I’ve never come across this ‘in use’ before. Does anyone know how i get into this?

calwilson · 2011-04-23 22:02:25

Did you attempt to repair the table? You can do this via phpMyAdmin.

JasonUK · 2011-04-23 22:19:53

I didn’t know about the repair table but i’ve just tried it and I get a Corrupt message. So I guess that’s the end of that and i’ve lost the data.

I’ve managed to find the last 7 posts stored in my RSS feed. I guess i’ll have to just stick with this and forget the rest.

Thanks for the reply

joebaich · 2011-04-23 23:14:06

Hello Jason,

You should talk to your host about this issue and ask them to see if they can resolve it for you. The ‘in use’ message can mean that there is a lock on the Textpattern table in the TXP database. That can usually be resolved by your host tracing and then killing the processes acting on that table. It’s not something a user can do but should not be a big deal for the sys admins.

Your posts are stored in the Textpattern table, and I think it most likely that they can be retrieved if that’s what you have to do. However, I think they likely they can get you back on the road completely.

Good luck

Last edited by joebaich (2011-04-23 23:17:23)

calwilson · 2011-04-23 23:18:36

It might be worth contacting your Web site host to see if they are able to repair it, or perhaps they have a backup taken from before they performed the server upgrade?

JasonUK · 2011-04-30 23:56:14

Thanks joebaich and calwilson

I took your advice and sent an email to my website host (Lunar pages). They found out the problem. They say that when they upgraded from MySQL 5.0 to MySQL 5.1 this error happened on all my Textpattern databases. So other people should be cautious when when upgrading to MySQL 5.1. This problem must have happened to others. Anyway. They say they have backups and they are in the middle of sending me the backed up sql files.

Thanks again otherwise i wouldn’t have thought about asking my host. But they have so far been very helpful.

Jason

Last edited by JasonUK (2011-04-30 23:59:02)

visualpeople · 2011-08-25 18:38:44

I’ve searched the forum and can’t find anyone else with this problem, but I’ve have it three or four times now — all on sites that were fairly recently upgraded from MySQL 5.0 to 5.1.

I have so far been able to fix it by just rebuilding the db table. But I’d like to be proactive about it if there’s anything else I can do. Clients pretty much freak out when they’re updating their site and suddenly it looks as though they’ve crashed the whole thing.

Any suggestions on what I could do to my other Textpattern databases?

- Ryan

Gocom · 2011-08-25 19:33:15

visualpeople wrote:

Any suggestions on what I could do to my other Textpattern databases?

Unfortunately it’s hard to suggest anything when it doesn’t happen to others. We (like I we, us, not the community as all — I couldn’t answer for everyone) haven’t had any problems with anything on any MySQL version (from early 4 all to way to 5.5). Not anything that is related to Textpattern itself. Under 1% of failed writes, but that’s MySQL itself and some drive/server issue contributing to it.

There shouldn’t be anything wrong with TXP itself that would make tables break. But just to be sure, what Textpattern extensions are you using?

How much is written to the database? How reliable is the hosting you are using? Might you tell who is the provider? If you are hosting the database yourself (using VPS etc), how are you doing it exactly? If the issues are happening at the same hosting provider’s end, I would ask them. Not necessarily blaming them upfront, but asking if they have had server issues, or reports about MySQL failures.

If I completely understood you, and you have issues with the actual MySQL updating, and it breaking databases then I would suggest dumping the database before updating MySQL and loading the database back after updating is done. You can do dumping with mysqldump application, and put the data back with mysql CLI tool. Like so, i.e.

mysqldump --opt --host="localhost" --user="username" --password="password" --result-file="/path/to/my/dump/mysqldump.sql" DatabaseName
mysql --host="localhost" --user="username" --password="password" DatabaseName < /path/to/my/dump/mysqldump.sql

Any suggestions on what I could do to my other Textpattern databases?

I would try different hosting environment, different MySQL version and making frequent backups. Things just do break from time to time, the most unexpected times, sometimes for no apparent reason.

joebaich · 2011-08-25 19:59:03

It’s likely that it’s not a Textpattern issue per se and perhaps not even a MySQL 5.0 to MySQL 5.1 upgrade issue either so much as a product of how the upgrade is carried out, so do talk to your web site hosts and ask them why they think it is happening. It’s also true that if you don’t tell them about the problem, they will remain unaware of it. If they can’t give you satisfaction in this regard, it’s probably time to seek another host.

I understand what you say about the users freaking out and that you would wish to avoid that. I think you can work towards that by letting them know beforehand that a MySQL upgrade is about to take place and that ‘in the unlikely event’ that there is an issue, it can be rectified fairly quickly.

We put that message up front by running a daily cron job on each Textpattern site that backs up the database and emails it to our client and to us. It doesn’t matter that they don’t have the first clue what to do with it. It provides them with daily evidence that their data is being backed up and if their website ‘breaks’ for whatever reason, we can quickly restore it for them. It also provides them with some insurance in the event that your business is taken out by a tsunami, illness, bankruptcy or whatever, they still have the essential components for their web site. We keep at least a weeks worth of backups and ask them to do the same.

Textpattern CMS

Textpattern CMS support forum

#1 2011-04-23 21:04:06

TXP crashed - Want to get blog info. Where can i get this?

#2 2011-04-23 21:24:28

Re: TXP crashed - Want to get blog info. Where can i get this?

#3 2011-04-23 21:52:09

Re: TXP crashed - Want to get blog info. Where can i get this?

#4 2011-04-23 22:02:25

Re: TXP crashed - Want to get blog info. Where can i get this?

#5 2011-04-23 22:19:53

Re: TXP crashed - Want to get blog info. Where can i get this?

#6 2011-04-23 23:14:06

Re: TXP crashed - Want to get blog info. Where can i get this?

#7 2011-04-23 23:18:36

Re: TXP crashed - Want to get blog info. Where can i get this?

#8 2011-04-30 23:56:14

Re: TXP crashed - Want to get blog info. Where can i get this?

#9 2011-08-25 18:38:44

Re: TXP crashed - Want to get blog info. Where can i get this?

#10 2011-08-25 19:33:15

Re: TXP crashed - Want to get blog info. Where can i get this?

#11 2011-08-25 19:59:03

Re: TXP crashed - Want to get blog info. Where can i get this?

Board footer