For programatically building the same thing based on a working system, is the easiest way to do something like:
- mysqldump -uUSER -pPASS zm Filters > Filters.dump
- and similarly for Monitors and Zones
- mysql -uUSER -pPASS zm < dumpfilename.txt
- and so on for the other tables
There's of course no way to know long in advance of a system rebuild which version of zm will be current, so I was a little concerned about compatibility of an old (1.25) database dump versus some future version to be restoring to. Is table-by-table best practice, or just dump/restore the whole zm db ?