Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2021-08-16 17:33:01

JimJoe
Member
From: United States
Registered: 2010-01-30
Posts: 525
Website

load mysql into Textpattern, how to load articles form that database ?

I had a site get wiped due to an intrusion from outside the web host.

I did have a mysql backup on my home computer for this particular Textpattern site. It reloaded with no errors.

Is there a way to go into myPHPAdmin panel and get the articles to repopulate ? Or do I have to do that by hand ?

Thanks.

Last edited by JimJoe (2021-08-16 17:34:10)

Offline

#2 2021-08-16 20:19:06

uli
Moderator
From: Cologne
Registered: 2006-08-15
Posts: 4,256

Re: load mysql into Textpattern, how to load articles form that database ?

JimJoe, not sure I understand.

What did your backup comprise, just your articles or the complete site? What exactly is the result now, empty articles or none at all? And: would you want your backup to replace existing articles or add them to the site?

(Also not unimportant, e.g. re plugins: what TXP version did you make your backup with?)


In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links

Offline

#3 2021-08-16 20:43:49

JimJoe
Member
From: United States
Registered: 2010-01-30
Posts: 525
Website

Re: load mysql into Textpattern, how to load articles form that database ?

the backup is the entire sub-domain. I do dump the entire domain as well, but I don’t need to restore all of my sites. Just 3 of them.

I import the mysql database using myphp admin, and no articles are added. There is data in the database as I checked.

Backup 2.8.2, and the web host updated everything to 2.8.7

Offline

#4 2021-08-16 21:24:55

JimJoe
Member
From: United States
Registered: 2010-01-30
Posts: 525
Website

Re: load mysql into Textpattern, how to load articles form that database ?

I tried again, as a double check. Only the 15 articles I have retyped in are there.

Offline

#5 2021-08-16 21:36:55

JimJoe
Member
From: United States
Registered: 2010-01-30
Posts: 525
Website

Re: load mysql into Textpattern, how to load articles form that database ?

Tried it a test sub-domain. https://testone.drivein-jim.net/

Looking at myphpadmin, the data is there, but no articles are filled body and subject lines.

Offline

#6 2021-08-16 22:08:18

uli
Moderator
From: Cologne
Registered: 2006-08-15
Posts: 4,256

Re: load mysql into Textpattern, how to load articles form that database ?

JimJoe wrote #331381:

Backup 2.8.2, and the web host updated everything to 2.8.7

You mean TXP, and v4.8.2 / 4.8.7, I presume.

  • Have you tried to log in already?
  • What happens in the TXP backend, can you see articles there?
    • If so: What happens on the public side when you save one of them?
  • Anything unusual from the Diagnostics page?
    • If so: Please post the diagnostics here.

In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links

Offline

#7 2021-08-16 22:27:03

JimJoe
Member
From: United States
Registered: 2010-01-30
Posts: 525
Website

Re: load mysql into Textpattern, how to load articles form that database ?

Sorry, yes, 4.8.2 and 4.8.7

Nothing unusual on diagnostics, says all checks passed.

I looked at both low and high detail, no error messages.

I logged into the cms, I see the upload articles in the mysql in myphpadmin, but not in the articles of Textpattern.

Saving them works fine.

I use my own front word on the database, I don’t use txp_. would that make a difference ?

edit. I don’t want to keep you up all night. I’ll check back on Tuesday, North America time.

Last edited by JimJoe (2021-08-16 22:48:03)

Offline

#8 2021-08-17 14:48:59

JimJoe
Member
From: United States
Registered: 2010-01-30
Posts: 525
Website

Re: load mysql into Textpattern, how to load articles form that database ?

I did a web search… lots of articles on backing up the mysql and the files. But nothing on how to restore from those backups. Some links said they did both, but when I read them… only backing up. Nothing on restoring the articles.

I would think there was a plugin or a tutorial on how to do it. I’m not a php expert, so I have no idea how to do accomplish this.

Offline

#9 2021-08-17 15:38:47

JimJoe
Member
From: United States
Registered: 2010-01-30
Posts: 525
Website

Re: load mysql into Textpattern, how to load articles form that database ?

Plugin: Restore, but it is from 2005 and the author’s home page gives a 404.

I did notice the Import of other blogs/cms is no longer available.

Any further suggestions ?

Thank you for your assistance.

Offline

#10 2021-08-17 16:30:46

JimJoe
Member
From: United States
Registered: 2010-01-30
Posts: 525
Website

Re: load mysql into Textpattern, how to load articles form that database ?

Well, I figured it out.

exporting the mysql creates tables like word_texptpattern. But it drops the front part and only keeps the textpattern part. i was told to use a specific word there, so I did.

Editing the mysql file such that I add that extra word and the underscore, all my articles show back up.

Hurrah, at a low volume.

Offline

#11 2021-08-18 05:14:24

uli
Moderator
From: Cologne
Registered: 2006-08-15
Posts: 4,256

Re: load mysql into Textpattern, how to load articles form that database ?

I’m glad you’ve managed to get your website back again.

You asked for some kind of plugin. rss_admin_db_manager lets you shift from any familiar Textpattern admin page to Extensions > DB Manager and click a link there for backing up, and that’s it. And loading a backup there isn’t any harder than backing up.

But it certainly wouldn’t have avoided your table prefix situation, the new table names must match the previous ones. The plugin is just simpler to operate than taking the phpMyAdmin path. And that way you’ll more often do a backup and have less data loss if the worst comes to the worst.


In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links

Offline

#12 2021-08-18 06:25:46

JimJoe
Member
From: United States
Registered: 2010-01-30
Posts: 525
Website

Re: load mysql into Textpattern, how to load articles form that database ?

Thanks.

I have access to myphpadmin rather easily.

Offline

Board footer

Powered by FluxBB