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.
Posts made by sam-white
-
RE: Transferring FOG to a new server
-
RE: Backing up?
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] -
RE: Htmldoc failed to load on new FOG install
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] -
RE: Scheduled Tasks
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.
-
RE: Error installing fog .32 on fedora: cannot start service nfs
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]
-
RE: How to change webui passwords w/o using webui
[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] -
RE: How to change webui passwords w/o using webui
“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.
-
RE: How to change webui passwords w/o using webui
Have you tried logging into MySQL using root and changing the password for the fog user?
-
RE: How to Backup Database - Where is the SQL file located?
[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] -
RE: How to Backup Database - Where is the SQL file located?
You need to install FOG before you restore. The IP address should not matter when restoring a backup. You might have to go to the webpage and change the IP address under Other Info > FOG Settings. I have never changed IP’s when moving FOG so I am not sure if you need to do that.
-
RE: Misspelling In Task Management
I am sure they know about it. I submitted a bug for that typo in September of last year.
[url]http://sourceforge.net/tracker/?func=detail&aid=3415416&group_id=201099&atid=976199[/url]
-
RE: How to Backup Database - Where is the SQL file located?
[FONT=Verdana][COLOR=#333333]mysql -u USERNAME -pPASSWORD < filename.sql[/COLOR][/FONT]
[FONT=Verdana][COLOR=#333333]Where “filename.sql” is the backup file you created. Make sure to unzip the file before restoring the database if you used gzip from my earlier post.[/COLOR][/FONT]
-
RE: How to Backup Database - Where is the SQL file located?
I use “root” to backup all my databases. That or you will need to “GRANT” permissions to the FOG user. Also make sure your PASSWORD has no space after “-p”.
-
RE: Fog 0.32 upgrade on Red Hat 5.6
When I installed FOG 0.32 on my CentOS 6.2 server I installed php53 first and did not make any changes to config.sh. Everything passed for me.
-
RE: How to Backup Database - Where is the SQL file located?
I usually keep my backups separate, especially with all my images. I take great care with those since I believe they are the most important. I copy my images as is to 2 different locations for backup purposes. You can get by with my post above with mysqldump. I do a backup of my Apache websites. You can use the command below.
tar -czPf /***/Apache2/apache2_
date '+%Y-%m-%d'
.tar /var/www/ -
RE: How to Backup Database - Where is the SQL file located?
I use mysqldump to take a backup of all my MySQL databases. Run the command below, changing USERNAME and PASSWORD to your MySQL info. *** = a directory somewhere. It will save all your databases in a gzip file. Filename will look like this if done today “database_2012-03-09”.
mysqldump -u USERNAME -pPASSWORD --all-databases | gzip > /***/MySQLBackups/database_
date '+%Y-%m-%d'
.sql.gz -
RE: Slow computers
I learned something new. It has been a while since I had WinXP and did not know IE9 was incompatible. Firefox has a separate installation for Adobe Flash. You will have to install it after adding Firefox to the system. Install all the security patches for IE8 that you can.