How to copy the DB of sugarcrm from one computer and use it on another one?

[nedbanguilan]

Good day. I would like to know if there is a way to copy the contents or the DB of sugarcrm from one computer and use it on another one.I want to do this so that I can continue my work at home during weekends where there is no office. I Already searched the net and couldn't find any. Please help. Thanks.

OS at Office - OS at Home
WIndows Server 2003 Windows Vista Ultimate

Sugar version and edition
Both Computers have Sugarcrm 5.2c Community Edition

[salesagility]

Simplest way is to do a dump of the database and to restore it ... it's not very elegant

Alternatively, if you're using mysql (don't know the mssql capabilities), you could sync the database while you are connected ...

[leowolff]

Even more simple is to copy the folders and replace them at your house.

To copy the database:
\mysql\data
To copy the whole Sugar:
\htdocs\sugarcrm

Only one thing, to make this work both installations must have the same password.

I use this metod to load the info on my local machine for tests.

[nedbanguilan]

OK thanks for the tips and guides, will try this out immediately.

[Gyro.Gearless]

Good day. I would like to know if there is a way to copy the contents or the DB of sugarcrm from one computer and use it on another one.I want to do this so that I can continue my work at home during weekends where there is no office. I Already searched the net and couldn't find any. Please help. Thanks.

OS at Office - OS at Home
WIndows Server 2003 Windows Vista Ultimate

Sugar version and edition
Both Computers have Sugarcrm 5.2c Community Edition

Hi,
i'd prefer a dump/restore as a canonical way to deal with databases.

Here is how to backup MySQL on Linux:

mysqldump -u root -p --databases sugarcrm | bzip2 > /tmp/backup-mysql-sugarcrm.dump.bz2

And how to restore:

bzcat /tmp/backup-mysql-sugarcrm.dump.bz2 | mysql -u root -p

Of course it is safest to shutdown HTTPD before making the backup. And BTW, this is also a good method for backing up your MySQL data....

Cheers
Gyro