This article explains how to do a mysqldump of your ehd data. These dump files can be useful for routine backups, when upgrading eHD versions, or for technical support.

To get a mysqldump of your eHD database, the following information is required:
- the database user (often 'root')
- password
- eHD database name (often 'ehelpdesk')


Open a command prompt or terminal window. The basic command takes the following form:

mysqldump -u <db-user> -p result-file=<filetocreate> <database-name>

If no password is set for the user, the -p option can be omitted. The dump file will be created in the current directory with the name passed to the --result-file argument.

Examples:

For database user 'root', no password, and database name 'ehelpdesk':
mysqldump -u root --result-file=ehelpdesk-dump.sql ehelpdesk

For database user 'ehd', with password, and database name 'ehd';
mysqldump -u ehd -p --result-file=ehd-dump.sql ehd



For more info, check out the mysqldump docs:
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html