Transferring all images & all host info from (1.2.0) to (1.2.0)

[Tom Elliott]

@dcorpening Try importing the sql file from the GUI? (FOG Configuration Page->FOG Settings->Configuration Save->Import) You will have to download the db file you need to the system so you can import it.

[dcorpening]

@Tom-Elliott Correct. I’ve copied the fogdb.sql from the old server to the new one. Then I import via (FOG Configuration Page->FOG Settings->Configuration Save->Import). It says successfully completed, but nothing gets imported. The fogdb.sql is not empty; it seems full of the correct info. So I followed the instructions to manually import it and got the same results: Nothing gets imported even though no errors are returned.

[Tom Elliott]

Trying to hit you on chat.

[dcorpening]

@Tom-Elliott Thanks for all of your help! Can you reply to this thread with how we (you) fixed this issue? I think it may be very helpful to anyone having this or a similar issue. Again, thanks much!!

[Wayne Workman]

For future readers: https://wiki.fogproject.org/wiki/index.php?title=Migrate_FOG

[Tom Elliott]

The older export system (1.2.0 and earlier back to 1.0.0 when it was introduced) didn’t take into account the tables existing. The way this would typically work, though, would be to simply clear out all of the tables in the fog database and apply what was being passed in.

For whatever reason, the exported backup file was not dropping the fog database when the import was being kicked off.

The fix, as we already had the original exported db, was to drop the fog database, recreate it, and let the sql file import the rest back in.

We did this via command line just to ensure all was well.

mysql -u root fog < fogdb.sql

[Wayne Workman]

@Tom-Elliott said in Transferring all images & all host info from (1.2.0) to (1.2.0):

The older export system (1.2.0 and earlier back to 1.0.0 when it was introduced) didn’t take into account the tables existing.

@Moderators important tid-bit of info there.