[jffnms-users] backup 0.7.9-mysql-database mysqldump

[johan30]

Javier,   I have something very weard and strange. It is not my day. For testing the new version (0.8) , I tryto backup the old database to another name. Let's say the original database of 0.7.9 = jffnms and i want to duplicate it to jffnmsx. I do the following :  mysqldump -p jffnms > jffnms.sql and  mysqldump -p jffnmsx < jffnms.sql   what is notice between jffnms.sql and the second dump is something in the zones : jffnms.sql : <cut> -- Dumping data for table `zones` --   INSERT INTO zones VALUES (1,'Unknown','UNK','unknown.png','',1,'',86400,0); INSERT INTO zones VALUES (4,'leased lines','leased lin','unknown.png','',2,'',86400,0); INSERT INTO zones VALUES (9,'tickets','tickets','unknown.png','',2,'',86400,0); </cut>   and in the second dump :   -- -- Dumping data for table `zones` --   INSERT INTO zones VALUES (1,'Unknown','UNK','unknown.png','',1,'',86400,0,1); INSERT INTO zones VALUES (2,'New Zone','NewZone','unknown.png','',1,'',86400,0,1);   and here the dump stops. So I guess he is looking for id number 2, which doesnt exist. In the database, the real id's of the zones are 1-4-9, ..... Has this something to do with the dump or with the zones-part in the sql-database ? I know this is perhaps not completely jffnms-related, so if you have an idea, let me know   Greetings, Johan