patrickb

Im in the backup business and I can't answer that one! :disgust:

The phpMyAdmin backup will do a perfect backup for your database. Should be no reason for doing it through the backup function of Cpanel, unless you just want to. I like to break down the tables and back them up in different sets, because I have a lot of tables that don't change very often.

I tested the Cpanel and it seems to work just fine. It generates the exact same thing that phpMyAdmin does (only less steps, which is a plus I guess). It does a full backup of the database, structuce and all, and even creates the database, this being the only difference.

As for the website backup, someone else is going to have to answer that. I get errors on my site when trying to do that, and I think it is because the backups under Cpanel claim to be disabled. It would not make sense for the backup to be content only, as the structure is a very critical part of a backup in the first place. Not sure, but I have plenty of copies of my website anyways

__________________
Patrick

Warnings: The program(s) might crash unexpectedly or behave otherwise strangely. (But of course, so do many commercial programs on Windows.) --www.gimp.org

Panama

Patrick, I think there is some confusion in this thread because we are talking about two different backup functions, the Cpanel website backup, and the Cpanel SQL backup (and we were talking about the PhpMyAdmin backup so that makes three but that is off topic for this section of the board so we can drop it)(inhales).

The "content, not structure" I was talking about was for the Cpanel Db (SQL) backup. I now see that I was wrong, when I compare the complete backup from PhPMyAdmin to the Cpanel backup they are the same (except for odd differences in the comments, one of them used dashed lines for comments and one use # marks). The Cpanel backup is compressed, which is good for lame dialups like mine. Because it doesn't need to be uncompressed for the restore, it seems to be the better method to me - both faster and less steps.

Since you tested the Cpanel SQL backup and it worked I consider that topic closed. I will probably do periodic backups with PMA but I think I can rely on the Cpanel.

Now - topic two - the Cpanel website backup. I didn't try to use it as a backup to a ftp site, I used the backup to home directory. I haven't gotten time to check if it worked but something doesn't look right. How could a 23 Meg site have been crushed down to 5 Megs? I suspect something didn't work (but I didn't get the error messages that occured the first try). Unless someone wants to experiment, I will have to leave that part of the Cpanel backup in the "unknown" catagory. I'm not going to test it on my live website, I have enought to do without having to restore the whole thing because of a glitch.

Anybody had success with the backup to home?

__________________
www.grandviewwatch.org
Pico