Wordpress - opening a backup
Discussion
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.
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.
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. What software do you suggest for doing that?
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.
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...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.
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
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?
Will the backup only have the text or will it bring back the entire site including themes and stuff?
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff


