Announcement

Collapse
No announcement yet.

transferring servers, transferring SQL without telnet/ssh

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

  • MoH672
    replied
    Disregard...

    I forgot to include the old database prefixes so all the database names were wrong :P Oopsies! :P

    Leave a comment:


  • MoH672
    replied
    ok so I did all of the above... unfortunately the install still comes back with an error.

    Database error in vBulletin :

    Invalid SQL:

    SELECT *
    FROM startrekdatastore
    WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','la nguagecache','products','pluginlist','cron','profilefield','userstats','birthdaycache','ma xloggedin','iconcache','eventcache','mailqueue');

    MySQL Error : Table 'startrek_vbulletin.startrekdatastore' doesn't exist
    Error Number : 1146
    Date : Thursday, May 29th 2008 @ 08:08:38 PM
    Script : http://startrek-horizons.com/forums/
    Referrer :
    IP Address : 72.200.174.100
    Username :
    Classname : vB_Database

    Leave a comment:


  • Steve Machol
    replied
    No. It has the same potential timeout problems as with any PHP based backup option.

    Leave a comment:


  • MoH672
    replied
    Thanks, Steve.

    I just realized.... wouldn't it be easier to backup using the vBulletin backup feature in Maintenance?

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

    Or will this not work switching across servers?

    Leave a comment:


  • Steve Machol
    replied
    Instructions for moving servers are in the online manual here:

    http://www.vbulletin.com/docs/html/moving_servers

    If you do not 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

    Bigdump (restore only):
    http://www.ozerov.de/bigdump.php

    Leave a comment:


  • MoH672
    started a topic transferring servers, transferring SQL without telnet/ssh

    transferring servers, transferring SQL without telnet/ssh

    Hi, I have a really *bleeeeeep* server host who keeps crashing. I'm transferring servers by tomorrow... right now, I'm reading the manual on how to transfer servers, and I'm copying all the physical FTP files in their entirety, however I do not have Telnet/SSH access. Is there another way I can get the SQL files?

    i.e. backing them up through cPanel's backup system?

    Thanks...
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X