[Forum] No database backup option in Maintanance!

[sparkguru.com]

I upgraded cleanly from 3.8 to Suite 4.0 PL1 ...
disabled CMS and BLOG for now...
but i cant find DB backup option in the control panel... where is it?
in 3x it was under maintainance

[Loco.M]

I've never used that option because it usually would break the tables on the larger DB (at least im my experience)
I suggest backing up the database from MySQL or via SSH for best results.

[sparkguru.com]

my db is too small... and somehow i want this option coz i dont have access to ssh and i dont want to do it now with phpmyadmin for some reason

[Loco.M]

There are a few ways to get automatic DB backups as well, I know of at least 2 hacks at the Org that do this.
Have you thought about going that route?

[sparkguru.com]

thx for your attention... i think i will wait for 4.1.. as there are hell a lot of problems (DB error etc) comming even after a clean install.

[hqlman]

Db backup option has been removed from vb4 for a few reasons causing incomplete backups being made, so the best way as loco said is via ssh or if you have access to cpanel it is very easy

[kat00]

Cron it using CPanel. Thats your best bet, this will do the job for you, simple.

mysqldump --opt -Q -u xxxxx_xxxxx --password=xxxxxxxxxx xxxxx_xxxxxxxxx > /home/xxxxxxxx/backup/sun.sql

note the space between the u and the first letter of your CPanel username and > /

first xxxx CPanel Login Name
_
second xxxx DB Username
third xxxxx password
fourth xxxx CPanel Login name
_
fifthxxxx DB Name
Put a directory called backup in your root directory......
Can't go wrong.

[acwatts]

Does the above close your forums at the same time, so that the database is not having new data send from the forums.

[S1OPP]

Have a look in the ZIP file that was downloaded vB4.

In the do_not_upload directory, there's a PHP vb_backup

If you have no access to ssh or cpanel.

[kat00]

No, it doesn't close the forum........I do mine at 3am when its quite. I occasionally have the odd member online at that time but Ive never, not once had a currupt DB.......Even when I was using PHPMy admin I never closed my forums.

I read somewhere once that a cron job will stop the table being written to when its backing it up........don't know enough about that so don't take that as gospel.......My DB is about 800MB and takes about 1 miniute to backup