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.
- Friends
Server Side Scripting / Coding: Mirroring a php/mysql site from one Linux server to another
Bottom of Page1 to 4 of 4
-
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! -
-
CommentAuthorstrugglefish
- CommentTimeMar 27th 2007
rsync works beautifully. I used this for years doing backups for my server. -
-
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 -
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.
1 to 4 of 4