Wordpress - opening a backup
Author
Discussion

Mojooo

Original Poster:

13,291 posts

211 months

Sunday 23rd September 2018
quotequote all
Few years back I saved a backup of a Wordpress site - I have the SQL file.

I want to re-open that file so I can copy out some of the text - anyone know the easy way to do this on a PC as opposed to having to set up a new Wordpress site?

I opened the SQL file in wordpad and I can see the text is in there but its laid out in a way that will make it difficult to copy and paste out numerous postings.


Derek Smith

50,032 posts

279 months

Sunday 23rd September 2018
quotequote all
Have you considered localhosting? Free and a bit of fun.


AndrewEH1

4,922 posts

184 months

Sunday 23rd September 2018
quotequote all
Derek Smith said:
Have you considered localhosting? Free and a bit of fun.
I've been looking at this today and it's been making my head hurt!

What software do you suggest for doing that?

Derek Smith

50,032 posts

279 months

Monday 24th September 2018
quotequote all
AndrewEH1 said:
I've been looking at this today and it's been making my head hurt!

What software do you suggest for doing that?
XAMPP. There's a fair bit on wordpress.org (I think) as well as XAMPP download site. Is there any particular part you don't understand? Is is what localhosting is or the technical setup? Taking the latter bit first, I followed documents for method rather than YouTube and it was remarkably straightforward. I didn't bother to discover the technical side of it until I had a play. It's really quite fun. I now find it a tempting way to waste a few hours.

Localhosting is simple enough. The problem lies with thinking it is complex, like most things in life.

I use it to try various things for my two WP websites. It's a great way to make a mistake in, for instance, coding. I try out themes to see if there's any conflict, that sort of thing.

akirk

5,778 posts

145 months

Monday 24th September 2018
quotequote all
Mojooo said:
Few years back I saved a backup of a Wordpress site - I have the SQL file.

I want to re-open that file so I can copy out some of the text - anyone know the easy way to do this on a PC as opposed to having to set up a new Wordpress site?

I opened the SQL file in wordpad and I can see the text is in there but its laid out in a way that will make it difficult to copy and paste out numerous postings.
As suggested above - you basically need a My-SQL database - so you either need to set one up on your machine, or find some hosting with an available database... then just import the database and it will magically appear in the correct table structures... depending on what tools you use to view a mysql database, you will possibly then be able to export to csv etc. So we use SQLyog which is great and works well... and would simply find an empty database on one of our test servers - import the sql and export the table... just depends on the setup you have / your technical knowledge...

the other thing to note is that the table structure may not be the structure you actually want / need - so at that point, you either have to re-setup the original wordpress, or look at rebuilding the structure - depends on what you are trying to achieve

ManicMunky

715 posts

151 months

Monday 24th September 2018
quotequote all

buggalugs

9,297 posts

268 months

Monday 24th September 2018
quotequote all
Just take the pain of doing it in notepad, it’s gonna be the easiest option.

HantsRat

2,411 posts

139 months

Monday 24th September 2018
quotequote all
Give me a shout if need a hand. Can give you free hosting for a day or 2.

strain

419 posts

132 months

Monday 24th September 2018
quotequote all
I would just open the SQL in notepad (++) or sumblime, find the text and copy it out, easiest way

Mojooo

Original Poster:

13,291 posts

211 months

Tuesday 25th September 2018
quotequote all
I actually saved all of the original wording in a Word document so I have most of it but I was hoping the SQL file would givem ethings like hyperlinks that were added once the text was in the Wordpress editor.

Will the backup only have the text or will it bring back the entire site including themes and stuff?

akirk

5,778 posts

145 months

Tuesday 25th September 2018
quotequote all
A sql backup is simply a small part of the story - you need the ftp backup as well to give the full site - that has Wordpress itself plus theme / etc

All graphics you uploaded will be in the ftp backup

SQL backup has text content and Wordpress settings