Exporting Host Info to CSV
I’ve built a new 1.0.1 server (ubuntu 12.04 LTS) and am migrating our images and hosts over from our .32 server. Using the info here http://www.fogproject.org/wiki/index.php/Manual_Migration_Upgrade_from_0.32_to1.0 I was able to move the images, but can’t figure out how to get the host list into a CSV.
I’ve tried #mysqldump -u root -p[password] fog hosts > hosts.sql (on .32) and #mysql -u root -p[password] fog < hosts.sql (on 1.0.1) but I get and “ERROR 1064: You have an error in your SQL syntax…” when trying to import.
So, is there way to get the data into a CSV to import through the new GUI, or can anyone point me in the right direction regarding the syntax error?
For future readers: https://wiki.fogproject.org/wiki/index.php?title=Migrate_FOG
Brilliant! That’s the stuff.
Thanks for your help.
oh, sorry, i didn’t realize that was a new feature
there still should be a way to export the host list from the Reports page
an example file of how the CSV file should be formatted can be downloaded from the 1.0+ Hosts->Import Hosts page
Sorry, I’m not seeing it…
on the hosts page “export hosts”