can I move crm database to another clean install

[baydreamer]

I know this has been covered so I appologise, I've searched the forum and have to be honest struggled wiht some of the technical terms used.

I have the Bitrock WAMPSTACK installed on my windows xp home pC, I wish to access this off site on my laptop while away from the office, can I:

A) copy just to database to my laptop with the same version installed and then use it and copy it back when I'm finished.
B) How can I access it remotely bearing in mind that I use Windows XP home edition?

Help much appreciated

Tracey

[stevec]

if you have a broadband connection, you could allow access to the home PC from the outside world. However, this would be a bit of a risk and you'll need to know about setting up firewalls.

Yes - you could swap databases. Provided the installations are the same (database usernames, passwords and table types (miisam, innodb etc) you can swap. The simplest way to swap if you are using myisam tables (usually the default) is to stop the mysql server (services), copy the whole contents of the \program files\mysql\mysql server\data\sugarcrm directory into the same location on the laptop (while mysql is stopped on the laptop too).

Alternatively, sugar do an offline sync tool but that might only be available for the pro and enterprise versions.

[baydreamer]

if you have a broadband connection, you could allow access to the home PC from the outside world. However, this would be a bit of a risk and you'll need to know about setting up firewalls.

Yes - you could swap databases. Provided the installations are the same (database usernames, passwords and table types (miisam, innodb etc) you can swap. The simplest way to swap if you are using myisam tables (usually the default) is to stop the mysql server (services), copy the whole contents of the \program files\mysql\mysql server\data\sugarcrm directory into the same location on the laptop (while mysql is stopped on the laptop too).

Alternatively, sugar do an offline sync tool but that might only be available for the pro and enterprise versions.

I've give this ago, thanks for that