Announcement

Collapse
No announcement yet.

Importing a backup but incomplete?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Christian8a
    replied
    thanx
    Yea for backing up the database I will start using mysqldumper, but now that the backup is done I need to restore it and even with mysqldumper there are some incomplete forums, but when I open the database file on wordpad I see them there complete

    I really dont understand why, it sux but probably what I could do is open the database and restore each forum myself by copy/paste content...?

    Leave a comment:


  • Steve Machol
    replied
    As Trevster said the only consistently 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 timeout 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

    If you don't have telnet or SSH access, some people have reported success with these scripts:

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

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

    Leave a comment:


  • Christian8a
    replied
    Well I see the information on the database is there, I opened the file on word and I can see everything but on the import I cant... What way can I use to import it with no interruption?

    Please help, my site is down still

    Leave a comment:


  • Trevor Hannant
    replied
    How have you been backing the data up? If it's through a PHP script then the chances are your backups are incomplete as it may have timed out during the operation.

    A more reliable way to backup is via SSH?Telnet access. See here for more info:

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

    Leave a comment:


  • Christian8a
    started a topic Importing a backup but incomplete?

    Importing a backup but incomplete?

    I have been making backups thinking I have nothing to worry about. I tried to import some extra members from other of my sites and at the end I didnt end up keeping them, so I deleted that database and im trying to import the one I made before and alot of information is missing. Is only 11mb, but those 11mb were only good information so Im trying to figure out what is the problem. I also made 3 backups during that week and I've tried all 3 and they all have the same information missing, is it that the backups are ruined or the import is not importing all information? what is the best way to import it when is only 11mb? ive been doing it through my plesk panel just upload the normal database backup...
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X