[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: OT: SQL database - some questions



On 06/28/2017 01:29 PM, Celejar wrote:
On Wed, 28 Jun 2017 10:00:00 +0200
Hans <hans.ullrich@loop.de> wrote:

Dear list,

this is a little offtopic, but maybe you can make things a little bit clearer
for me.

I had had a webserver hosted by a provider, which is switched off since a
year. From this server I got a backup of a sql database. The system that ran
that time, was wordpress, and the database is called something like
"bla_bla_wp2016018_911.sql.gz"

On this website I wrote some blogs, which I want to have back.

So my question: Are these blogs content in this database? And if yes, can I

WordPress database backups contain all the blog content (but not, IIUC,
files (such as media) that you may have uploaded in association with
the blog).

restore them without to setup a complete wordpress server with sql database?

Yes, as other posters have suggested, but you should think carefully
about your insistence on not setting up a WordPress installation. It's
actually not that difficult - mysql and wordpress can both be easily
installed the usual way via the package managment system, and while
there may be a little fussing necessary to get WP working properly and
import your database backup, it shouldn't be too difficult even for a
database novice. WordPress has great documentation for this sort of
thing, and the last time I did this (in a very similar situation to
yours - I was leaving one hosting provider for another, the former
account was shut down, and I had up to date database backups), I was
actually quite shocked by how simple it was - just open the WordPress
interface (dashboard), do "import database", and that's pretty much
it!


I agree. I'm a newbie my self. I did it with no problem under Jessie and setting up the server on localhost.

Under Stretch with Mariadb in place of Mysql there is a change that I've not comprehended yet.


Is there an easy way or only a hard way?

Would be nice, if someone could give me some points, I am not so experienced
with databases.

Thanks and regards

Hans

Celejar





Reply to: