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 [url]http://www.fogproject.org/wiki/index.php/Manual_Migration_Upgrade_from_0.32_to1.0[/url] I was able to move the images, but can’t figure out how to get the host list into a CSV.
I’ve tried [FONT=Consolas]#mysqldump -u root -p[password] fog hosts > hosts.sql (on .32) and [/FONT][FONT=Consolas]#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.[/FONT]
[FONT=Consolas]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?[/FONT]
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”