The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Database Backup Problem
so since i have installed vb 3.7 RC 3 everytime i try to backup the database to my server it seems to stop everytime at this:
Processing: vbposthash and it goes no further...i have left it processing for over an hour and it still sits there. Anyone else have this problem or know how to fix it? |
#2
|
||||
|
||||
How big is that table? Have you ever optimized it? Is this your own server or a shared server?
|
#3
|
|||
|
|||
its a shared server thru godaddy, i have never optimized it. Data length is 11.6 KB, Index Length is 9.0 KB
--------------- Added [DATE]1208883511[/DATE] at [TIME]1208883511[/TIME] --------------- i have just ran an optimization of the tables and it still stops at the vbposthash even tho the file is waaaayyyyy smaller now....314 bytes |
#4
|
||||
|
||||
are you backing up using the adminCP?
because you shouldn't, i dont even know why that feature is there. use SSH to perform backups. |
#5
|
|||
|
|||
yeah i was thru the admin cp....i dunno what ssh is or how to use it tho
|
#6
|
||||
|
||||
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 |
#7
|
|||
|
|||
godaddy dont allow ssh on a vhost account
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|