Recent Topics

1 Jun 29, 2005 23:41    

I've been burned before by bad webhosts, and I'd like a duplicate copy of all the posts I've made on my site.

Is there a simple way to do this? If I log in using FTP, what files do I download to my home computer? I'd like to do this on a regular basis.

2 Jun 30, 2005 00:04

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

3 Jun 30, 2005 00:28

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?

4 Jun 30, 2005 00:52

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.

5 Jun 30, 2005 01:21

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.


Form is loading...