Not signed in (Sign In)

SkillShare - A place to discuss Web Standards and Web Design topics

Categories

Vanilla 1.1.9 is a product of Lussumo. More Information: Documentation, Community Support.

    • CommentAuthormista3
    • CommentTimeMar 27th 2007 edited
     permalink
    So, how would you go about this?

    An option under consideration: Use http://samba.anu.edu.au/rsync/ to keep the flat file structure updated, and then automate some mysql commands to keep the databases in sync.

    Maybe there are some non freeware solutions out there that are more reliable?

    Your thoughts most appreciated!
  1.  permalink
    rsync works beautifully. I used this for years doing backups for my server.
    • CommentAuthordhayes
    • CommentTimeMar 27th 2007 edited
     permalink

    mysqldump is also very useful for populating databases by copying data from one MySQL server to another:
    shell> mysqldump --opt db_name | mysql --host=remote_host -C db_name


    mysqldump .. might take a few tries to get what you want out of it, but it's free :) .. you can run rsync and mysql commands via cron, so it'd be pretty transparent and painless to go that route.

    good luck,
    -d
    • CommentAuthorknitcore
    • CommentTimeMar 31st 2007 edited
     permalink
    i've done this several times this year (including making snapshots):

    tar -cvf snapshot.tar ./* (or you could list specific subdirectories)
    gzip -9 snapshot.tar
    mysqldump -u user [-h host] -p db_name > db_name.sql
    gzip -9 db_name.sql

    then download/transfer the .tar and .gz to the new server and

    gzip -d snapshot.tar.gz
    tar -xvf snapshot.tar
    gzip -d db_name.sql.gz
    mysql -u user -p
    [in mysql now]
    \. db_name.sql


    gzip might take some time to compress, but it could save you from transferring a few hundred megs. decompression is much faster.
Add your comments
    Username Password
  • Format comments as (Help)