You can do a backup of the mysql database that FOG uses and restore that file to your new server. See the link below for an example.

[url]http://fogproject.org/forum/threads/how-to-backup-database-where-is-the-sql-file-located.481/#post-2850[/url]

I have two hard drives inside my server. One is for my primary CentOS partition and the other is for Files/Images. I have up to two full backups of my CentOS partition using Clonezilla at all times.

Other backups - Cron script ran weekly (unless stated otherwise)
[LIST]
[]MySQL - using mysqldump (see the link below)
[LIST]
[][url]http://fogproject.org/forum/threads/how-to-backup-database-where-is-the-sql-file-located.481/#post-2931[/url]
[/LIST]
[]FOG Folders - /var/www/html/fog and /opt/fog - tar all files
[]Images - Whenever an image is added or changes, I copy it to an external hard drive (keeping old images for a period of time)
[*]My tftpboot folder has not changed in over a year (I keep one backup of it, including text files on anything I modified)
[/LIST]

Might be late in this post. I just recently tried installing FOG on CentOS 6.2. To get htmldoc to pass, you need to download/install the latest latest rpm for the OS.
[LIST]
[]wget [url]http://pkgs.repoforge.org/rpmforge-release/[/url][URL=‘http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm’]rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm[/URL]
[]rpm -i [URL=‘http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm’]rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm[/URL]
[*]yum install htmldoc
[/LIST]
[INDENT=1] [/INDENT]

You can use MySQL Workbench and cancel the task under “scheduledTasks.”

I submitted a bug sometime at the end of last year. It will be fixed in version 0.33.

Not sure if the link below will help. Since there has not been a FOG version in a while, installing on newer OS’s can have issues.

[url]http://fogproject.org/forum/threads/nfs-server-unrecognized-on-fedora-16.542/[/url]

Glad you figured it out.

[FONT=Arial][COLOR=#111111]Try the below. I would also look at “/var/www/fog/commons/config.php” and “/opt/fog/service/etc/config.php” to make sure your mysql info is defined. Since fog uses MySQL, the user and passwords are stored there. You can also install “phpmyadmin” and see if your fog user is there. If you can log into root, you should be able to change the password and assign permissions to that user.[/COLOR][/FONT]
[LIST=1]
[][FONT=Arial][COLOR=#111111]mysql -u root -p[/COLOR][/FONT]
[][FONT=Arial][COLOR=#111111]mysql> use mysql;[/COLOR][/FONT]
[*][FONT=Arial][COLOR=#111111]mysql> update user set password=PASSWORD(“NEW-PASSWORD-HERE”) where User=‘fog’;[/COLOR][/FONT]
[/LIST]

“sudo” basically means run as root under this user. If you only used “sudo mysql” it should ask you for a root password. I would use the command “mysql -u root -p” to log into root and then try the link you posted.

Have you tried logging into MySQL using root and changing the password for the fog user?

[LEFT]You can restore a single database from a mysqldump of all-databases.[/LEFT]
[LIST]
[*]mysql -u root -p[I]PASSWORD[/I] --one-database [I]DB[/I] < [I]DBfilename[/I].sql
[/LIST]
[INDENT=1][LEFT][url]http://dev.mysql.com/doc/refman/5.1/en/mysql-command-options.html#option_mysql_one-database[/url][/LEFT][/INDENT]