The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
database error
Hi all
i had just finished merging 2 sites in to one every thing was working find for 1 week then some one hacked the forum n delete the whole forum ... i make back up of my database every day so i had my bk up i was using bigdumb.php to upload the 120 mb database when it was in text sql form its 26 mb but for some reason it says its done but when i go to mysql admin its onyly 85 tables there and only 13.8 mb imported but in the status file it says its finished every thing so i contacted my hosting they said it has special characters and attachments thats y its skipping this i had vbimage hosting installed and i was using vb 3.7.1 can any one help to get my database start working ? or any advice that can help me out |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
ty for your prompt reply
i don't have ssh access .. i also tried bigdump.php not wokring now i am trying MySQLDumper i will reply and let you know how it went. --------------- Added [DATE]1215187436[/DATE] at [TIME]1215187436[/TIME] --------------- ok i have a back up of my database which i made through vb admin panel ... that bk up is 28.3 mb i am using MySQLDumper to import it it only imports 85 tables ... its not importing rest of the 128 tables.. but it says its finished importing i really need help |
#4
|
|||
|
|||
here is screen shot
its only importing 13.8 mb and only 85 tables instead of 80+ mb and 180+ tables. |
#5
|
|||
|
|||
can any one help plzz
|
#6
|
||||
|
||||
My guess is that you have an incomplete backup.
|
#7
|
|||
|
|||
bro i contacted my hosting they had a week old database back up when they tried to upload it they sad same errors !!! also i made my bkups form vb admin page .. so u r saying those back ups r not worth any thing ?.. :S |
#8
|
||||
|
||||
Please read the first line of my post (#2 in this thread).
|
#9
|
|||
|
|||
yes i got it now but i am on shared hosting i can't make ssh or telnet bk ups bro...
... thanks for your help any how ...usually ppl don't help in here except few ppl that r in here .. n u r one of em so ty again. |
#10
|
||||
|
||||
I am also on shared hosting and my host does not provide the facility of ssh/telnet access.
Thus, I use a program called SQLYog (community edition) that takes backup and restore your mysql db. It would work if you're host allows external db connections. Its an excellent software and is worth a try. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|