[SAC] [OSGeo] #2533: Set up debian11 for grasswiki

[OSGeo]

#2533: Set up debian11 for grasswiki
----------------------------+----------------------------------------
 Reporter:  robe            |       Owner:  sac@…
     Type:  task            |      Status:  new
 Priority:  normal          |   Milestone:  Sysadmin Contract 2021-II
Component:  Systems Admin   |  Resolution:
 Keywords:  Mediawiki, lxd  |
----------------------------+----------------------------------------

Comment (by robe):

 FYI running into a little issue with restoring the mysql db.

 Getting this error:


 {{{
 ERROR 1062 (23000) at line 393: Duplicate entry '4140' for key 'PRIMARY'
 }}}

 Looking at the number of tables restored:

 with this query:

 -- I have 11 tables restored
 {{{
 SELECT table_name, table_rows
    FROM INFORMATION_SCHEMA.TABLES
   WHERE TABLE_SCHEMA = 'grass_wiki'
 ORDER BY table_name;
 }}}

 -- but osgeo6 has 58 rows

 I suspect it crapped out at the hit_counter table since osgeo6 has 2943
 rows and the restore has 0 for that table.  I'm checking that table on
 osgeo6 to see if it has dupes.

-- 
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2533#comment:12>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.