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

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

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

here is screen shot


its only importing 13.8 mb and only 85 tables instead of 80+ mb and 180+ tables. :(

can any one help plzz

My guess is that you have an incomplete backup.

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

Please read the first line of my post (#2 in this thread).

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.

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.