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.
Error
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’
Regard
Khadka .