Announcement

Collapse
No announcement yet.

Moving servers, with 7gb attachments in files

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

  • The Dude
    replied
    OK. If I move the database to the new server without the old attachments being there, will it screw up anything if I allow the members to post attachments. I will later un-tar the attachments in the right directories?

    Leave a comment:


  • Steve Machol
    replied
    From 'man rsync':

    DESCRIPTION
    rsync is a program that behaves in much the same way that rcp does, but has many more options and uses the rsync remote-update protocol to greatly speedup file transfers when the destination file already exists.

    The rsync remote-update protocol allows rsync to transfer just the differences between two sets of files across the network link, using an efficient checksum-search algorithm described in the technical report that accompanies this package.

    Leave a comment:


  • The Dude
    replied
    Thanks for the tips, what is rsync ?

    Leave a comment:


  • George L
    replied
    tar has a 2GB max file size limit, you might need to use rsync to move them

    Leave a comment:


  • Floris
    replied
    Very good advice.

    Make a .sql dump of your database through shell and TAR and GZIP the .sql dump.
    Then login on the other server through ssh and start up FTP (point it to the old server and get the file.tgz)

    Leave a comment:


  • Steve Machol
    replied
    I would not put that many attachments in the database. You'd be aslking for trouble. Just tar and gzip them. Also if you have scp on both servers you can use this to transfer the filese directly.

    Leave a comment:


  • raxafarian
    replied
    tar your entire attachments directory and copy it server to server (one way... tar the directory, move that tar file to html root, ssh into new server, wget www.yoursite.com/filename.tar. Move the file to where you had it on the old server (hopefully above webroot) and untar it.

    You should be downloading them once in a while for backup purposes anyways. I tar them once a week or so and download them.

    Leave a comment:


  • The Dude
    started a topic Moving servers, with 7gb attachments in files

    Moving servers, with 7gb attachments in files

    Hello,

    I plan on moving my forum to a new server, but I'm faced with a small? problem. Moving the database is pretty easy and I have done that many times with success, but right now the forums have 7gb worth of attachments in files. With the way the files are stored by VB, I don't even want to attempt to get them as files. So the question is, is it possible to get the attachments in the database again, without the risk of ruining the db and the attachments? The server is 2.0 Dual Xeon, so I'm quite confident that won't cause much of a problem.

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