Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Aiheen aloitti: Aeroprism - kesäkuu 26, 2011, 11:33:44 AP

Otsikko: Backup question - data location
Kirjoitti: Aeroprism - kesäkuu 26, 2011, 11:33:44 AP
Hello all!

After half a year of usage, I'm backing my forum up (seems like a logical thing to do) and I'm looking at what I acquired from my server.  It's all a lot of very small php files, I don't seem to find the source files where all the posts from my forum are kept.  Where would I find this?  I want to make sure that the hard work of my forum members (roleplay community) is properly saved.

Also, my "backup" method is merely to download of all the directories that were installed when I first set the board, in their current state of course.  Is that a good backup method?  Are there any better, less crude ways to do a forum backup?

Thank you very much!
Otsikko: Re: Backup question - data location
Kirjoitti: Illori - kesäkuu 26, 2011, 11:40:08 AP
you also need a backup of your database, this is where all your data is stored, without this you have almost nothing.
Otsikko: Re: Backup question - data location
Kirjoitti: Aeroprism - kesäkuu 26, 2011, 11:46:10 AP
That's what I figured.  The problem is, I have no idea where it is or how to backup it.
Otsikko: Re: Backup question - data location
Kirjoitti: Illori - kesäkuu 26, 2011, 11:47:00 AP
if you have a cpanel from your host there is an option to backup then you can backup your database from there
Otsikko: Re: Backup question - data location
Kirjoitti: Aeroprism - kesäkuu 26, 2011, 12:04:30 IP
Ah yes, I found a smf1 database which I backed up.  It's only 5Megs but we're only about 12 active users so I imagine this is normal.

The content is a SQL database.  What could I use to parse it?

Thanks for all the help so far, you're been very kind!
Otsikko: Re: Backup question - data location
Kirjoitti: Illori - kesäkuu 26, 2011, 12:05:41 IP
if you just want to read it you can extract a .sql file from that archive and read it with a text editor.
Otsikko: Re: Backup question - data location
Kirjoitti: Aeroprism - kesäkuu 26, 2011, 12:24:40 IP
Apparently so. 

My archive has only one sql file and to be honest, after spending 5-6 mins looking at it through an editor, I have no idea what to make of it!

I wonder what it looks like in database format.