Backup of Fog_1.2.0 especially sql database

[SteveB689]

The wiki is out of date for backup process?
Has anyone documentd the process for my version?

I have a second fog server with some images on it… they fail to push because I havent copied over the sql table from the original Fog server.

So just need
copy sql from first FOG copy over to second Fog

cheers
all

Just need the commands to copy

[Wayne Workman]

You can take an older DB and place it into newer FOG, but not the reverse. The below I think will overwrite everything in your DB.

You should be able to export the DB from 1.2.0 into fog trunk using the web interface. It’s here:
Web Interface -> FOG Configuration -> Configuration Save -> Export

You can expect to change the IP address and credentials in several places in the web interface after you do this.

Here’s how to do it manually.
https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL#Manually_export_.2F_import_Fog_database

And just in case you lock yourself out of the web interface, there’s this:
https://wiki.fogproject.org/wiki/index.php?title=Password_Central#Web_Interface

[Sebastian Roth]

@SteveB689 What about your other post?? https://forums.fogproject.org/topic/8050/images-table

I think you are looking for the mysqldump command. Check out the man page for options (e.g. mysqldump [options] db_name [tbl_name ...] > dump.sql) and only export the images table.

[SteveB689]

@Sebastian-Roth
Yes, very much under time pressure in the business at the moment… I had to rebuild another Fog server… and I uploaded my 2 main images onto it manually… so I didnt use any of the backup procedure.
This is all a consequence of being forced by company circumstances to run things into production without any testing time…
the joy of decisions being made above your head and you just being told to get on with it!