are my sql backups working right?

[andrea]

If you have shell access then you can use the shell commands or the shell scripts which are listed in this thread:

http://www.yabbse.org/community/index.php?thread=15902

[bluevoodu]

I have been backing up my database via my ssh now.... but I have moved to a dedicated server with 1 gig of ram.... and I am still encountering the same problem with trying to download the SQL file from the SMF admin panel.  I only get about 1 meg done and then it quits.

Can this still be a ram issue?

†B†V†

[[Unknown]]

It could be a max_execution_time/memory_limit issue.

-[Unknown]

[andrea]

It is *not* an issue. A 50 MB database usually cannot be dumped any longer with the admin menu or phpMyAdmin because of timeout problems. That is why it *must* be dumped with ssh or crontab.

[[Unknown]]

It is *not* an issue. A 50 MB database usually cannot be dumped any longer with the admin menu or phpMyAdmin because of timeout problems. That is why it *must* be dumped with ssh or crontab.

If I were to set all my timeouts hugely high in my browser, Apache, MySQL, PHP, and increase the memory limits for all of the above, it would go through.  This combination of settings, however, is hard to coax together, so that's why I prefer ssh myself as well.

-[Unknown]

[bluevoodu]

yeah... I almost prefer the ssh now anyway lol

but... my DB is only 20 megs.. and I am on a ded server with 1024 memory...
I just wanted to report back that I didn't think it was a mem issue because I am on my own server with more than enough ram... 80 gig hard drive..etc

I appreciate your help

Thanks,
BV

[[Unknown]]

It's not a memory issue, it's a memory limit issue.  PHP, Apache, and MySQL all have hard limits you can set to make it such that they don't use too much memory.... and if those limits are too low, it's nearly impossible to generate backups the way the administration center does currently.

-[Unknown]