how to backup sugarcrm database mysql stack

[bapon]

hi,
i'm using sugarcrm 6.1.4 mysql win stack locally on my pc.
How do i backup the sugarcrm database?

What i've tried so far (windows!):

started command line:
cd to sugarcrm-6.1.4\mysql\bin

entered: .\mysqldump -u root -p ****

i get:

mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

btw: don't know the name of my sugarcrm database.
1. how do i find out the name?
2. how do i correctly enter the mysqldump. password is correct, i know.

thanks for helping.

bapon

[marklark]

All you have to do is find where MySQL keeps the databases, locate yours and copy all the files in its directory to another (new) directory.

It's very similar to what you would do to back up your Sugar app.

Doing both at the same time makes it very easy to revert any changes.

To use both, you'll have to point the moved Sugar's config.php at the moved database. Failing to do so can cause errors like "I can't use that database, it's too old."

[bapon]

Hi,

thanks for replying.

I found out how to backup the database(s):

"c:\program files\sugarcrm-6.1.4\mysql\bin\mysqldump" -u root --password=***** --port=3307 --all-databases --complete-insert --create-options > C:\Users\...\Documents\sugarcrm-dbdump\sugarcrm-db.sql

It's the port name!

Hope restore will work once i have my system crash.

Bapon