vb.org Archive - Database Backups

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Database Backups (https://vborg.vbsupport.ru/showthread.php?t=201744)

Aadil

01-14-2009 01:10 PM

Database Backups

Hey I do backups via VB and they come out like 40MB but the database is like 76MB big?

does this mean I have some sort of problem?

Thanks

PAKIDIL

01-14-2009 01:14 PM

yeah its mean you are not getting it 100% are u trying to download it from myphpadmin ?

markbolyard

01-14-2009 01:16 PM

Depending on the size of your database, backing up through the admincp in vBulletin is probably timing out.

You are best to either use phpmyadmin and the export function, or if you have SSH access follow these instructions: http://www.vbulletin.com/docs/html/m...nce_ssh_backup

Phaedrus

01-14-2009 01:37 PM

Quote:

Originally Posted by Aadil (Post 1712057)

Hey I do backups via VB and they come out like 40MB but the database is like 76MB big?

does this mean I have some sort of problem?

Thanks

It is possible that you are getting your backup compressed.

Does it end with tar.gz?

If so, it is simply compressed and you are likely backing up just fine.

Marco van Herwaarden

01-14-2009 03:07 PM

The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/m...nce_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/m...ce_ssh_restore

P.S. If you don't have shell access, some people have also reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showt...t=mysqlhotcopy

Bigdump:
http://www.ozerov.de/bigdump.php

Aadil

01-15-2009 07:49 PM

sorry for late reply and thanks all for replying.

Its not a tar.gz its mysql file, I do have phpadmin and root ssh, but i would like the normal way to do it via VB to work..

Dismounted

01-16-2009 07:35 AM

Backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file.

All times are GMT. The time now is 02:59 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01080 seconds Memory Usage 1,720KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: