The posts are stored in a mySQL database table called "evo_posts", but you might want to back up comments, usernames, passwords, and a bunch of other settings too! All twelve of the database tables (or more, if you've added more).

Easy ... just back up the entire database.

It can be done manually from the myPhpAdmin interface. I do it (automatically) every night at 3:28AM and email myself the results. I've got a php script set up so that the backed up DB can be restored directly into an empty database.

If you search the boards here for "backup and database", you'll see [url=http://forums.b2evolution.net/viewtopic.php?t=4211&highlight=backup+database]this post[/url] and [url=http://forums.b2evolution.net/viewtopic.php?t=3108]this post[/url], which should assist.

Rots of ruck.

-stk :D

Thanks, but I think I'm in over my head.

I've never even been to the MySQL section of my cPanel before.

So, I go to MySQL Databases and click on phpMyAdmin. It brings up a new window with http://mydomainname.com:2082/3rdparty/phpMyAdmin/index.php as the address.

Now what? I suppose I go to "export" and check "save as file" and click "go."

Now I have a file called "localhost.sql."

So I guess my questions are this:

1) If I ever lose my stuff off the server, how do I upload this "localhost.sql" file again.

2) How do I set up that once a day email backup you mentioned?

1)

go back into phpMyAdmin, adn click on "Run SQL".
Upload localhost.sql.
It'll crunch away while it does its thing, and then it'll be back to the way it was when you backed up.

Thanks!

From what I could determine from the other threads, it takes a lot of code crunching to get the email function to work... I think. If that's the case, I'm not interested.

If there's a simple way to set it up in the admin interface, I'm all for it though.