facing trouble on desaster recovery

recently I have installed Gibbon on windows PC (Xampp) , for testing purpose, I’m playing around to learn more about Gibbon, by the mean time I decided to install Gibbon on Ubuntu server, finally installed but I wanted to migrate those data from windows PC to Ubuntu server,
the problem I’m facing is I exported MySQL data from windows PC using phpmyadmin tools, and I try to import that MySQL data using Phpmyadmin, I’m getting this error. this is not production data though, I wanted to learn what if really disaster happened.


SQL query:

– – Dumping data for table gibboni18n – INSERT INTO gibboni18n (gibboni18nID, code, name, active, systemDefault, maintainerName, maintainerWebsite, dateFormat, dateFormatRegEx, dateFormatPHP, rtl) VALUES (0001, ‘en_GB’, ‘English - United Kingdom’, ‘Y’, ‘N’, ‘Gibbon’, ‘http://gibbonedu.org’, ‘dd/mm/yyyy’, ‘/^(0[1-9]|[12][0-9]|3[01])- /.- /.\\d\\d$/i’, ‘d/m/Y’, ‘N’), (0002, ‘en_US’, ‘English - United States’, ‘Y’, ‘Y’, ‘Gibbon’, ‘http://gibbonedu.org’, ‘mm/dd/yyyy’, ‘/(0[1-9]|1[012])- /.- /./’, ‘m/d/Y’, ‘N’), (0003, ‘es_ES’, ‘Español’, ‘Y’, ‘N’, ‘Guillermo Bautista Fuerte’, ‘’, ‘dd/mm/yyyy’, ‘/^(0[1-9]|[12][0-9]|3[01])- /.- /.\\d\\d$/i’, ‘d/m/Y’, ‘N’), (0004, ‘zh_CN’, ‘汉语 - 中国’, ‘N’, ‘N’, ‘International College Hong Kong (ICHK)’, ‘http://www.ichk.edu.hk’, ‘yyyy-mm-dd’, ‘/^[0-9]{4}-(0[1-9]|1[0-2])-(0[1-9]|[1-2][0-9]|3[0-1])$/’, ‘Y-m-d’, ‘N’), (0005, ‘zh_HK’[…]

MySQL said: Documentation
#1062 - Duplicate entry ‘0001’ for key ‘PRIMARY’

Khadka .


The best way to perform this migration would to be:

a) copy all files from the current server to the new server, but do not run the installer on the new server
b) export your database from phpmyadmin on your current server, and import it into a new, blank database. If your address is changing in the meantime, you will need to update absoluteURL and absolutePath in the table gibbonSettings.

I hope this helps.