It sounds like you migrated the mysql/mariadb server incorrectly (MariaDB is basically just a higher version of mysql). You should take a db dump from your old wiki (using something like mysqldump) and then re-import it on your new wiki.
-- Brian On Mon, Dec 19, 2016 at 8:24 PM, Edilmar LISTAS <[email protected]> wrote: > Hi, > > I already migrated other times from an old server to a new server, but > always from MySQL to MySQL, after format and configure a new machine/OS. > > Today, I installed CentOS7 that comes with MariaDB5.5. > > I typed my wiki URL (that other times I migrated appeared the page to > initiate installation), but it showed me this error: > A database error has occurred. Did you forget to run maintenance/update.php > after upgrading? See: > https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script > Query: SELECT lc_value FROM `l10n_cache` WHERE lc_lang = 'pt-br' AND lc_key > = 'deps' LIMIT 1 > Function: LCStore_DB::get > Error: 1146 Table 'wiki.l10n_cache' doesn't exist (localhost) > > I have all the database files in /var/lib/mysql/wiki subdir, with right user > permissions: > [root@websaf edilmar]# cd /var/lib/mysql/wiki > [root@websaf wiki]# l > total 2816 > drwx------ 2 mysql mysql 4096 Mar 3 2014 . > drwxr-xr-x 10 mysql mysql 4096 Dez 19 20:06 .. > -rw-rw---- 1 mysql mysql 9188 Mar 3 2014 archive.frm > -rw-rw---- 1 mysql mysql 8770 Mar 3 2014 category.frm > -rw-rw---- 1 mysql mysql 8843 Mar 3 2014 categorylinks.frm > -rw-rw---- 1 mysql mysql 8722 Mar 3 2014 change_tag.frm > -rw-rw---- 1 mysql mysql 65 Fev 28 2014 db.opt > -rw-rw---- 1 mysql mysql 8636 Mar 3 2014 externallinks.frm > -rw-rw---- 1 mysql mysql 8624 Mar 3 2014 external_user.frm > -rw-rw---- 1 mysql mysql 9678 Mar 3 2014 filearchive.frm > -rw-rw---- 1 mysql mysql 8562 Mar 3 2014 hitcounter.frm > -rw-rw---- 1 mysql mysql 9294 Mar 3 2014 image.frm > -rw-rw---- 1 mysql mysql 8598 Mar 3 2014 imagelinks.frm > -rw-rw---- 1 mysql mysql 8754 Mar 3 2014 interwiki.frm > -rw-rw---- 1 mysql mysql 9316 Mar 3 2014 ipblocks.frm > -rw-rw---- 1 mysql mysql 8650 Mar 3 2014 iwlinks.frm > -rw-rw---- 1 mysql mysql 8778 Mar 3 2014 job.frm > -rw-rw---- 1 mysql mysql 8638 Mar 3 2014 l10n_cache.frm > -rw-rw---- 1 mysql mysql 8640 Mar 3 2014 langlinks.frm > -rw-rw---- 1 mysql mysql 9034 Mar 3 2014 logging.frm > -rw-rw---- 1 mysql mysql 8646 Mar 3 2014 log_search.frm > -rw-rw---- 1 mysql mysql 8642 Mar 3 2014 module_deps.frm > -rw-rw---- 1 mysql mysql 8692 Mar 3 2014 msg_resource.frm > -rw-rw---- 1 mysql mysql 8620 Mar 3 2014 msg_resource_links.frm > -rw-rw---- 1 mysql mysql 8634 Mar 3 2014 objectcache.frm > -rw-rw---- 1 mysql mysql 9360 Mar 3 2014 oldimage.frm > -rw-rw---- 1 mysql mysql 9030 Mar 3 2014 page.frm > -rw-rw---- 1 mysql mysql 8650 Mar 3 2014 pagelinks.frm > -rw-rw---- 1 mysql mysql 8648 Mar 3 2014 page_props.frm > -rw-rw---- 1 mysql mysql 8790 Mar 3 2014 page_restrictions.frm > -rw-rw---- 1 mysql mysql 8826 Mar 3 2014 protected_titles.frm > -rw-rw---- 1 mysql mysql 8688 Mar 3 2014 querycache.frm > -rw-rw---- 1 mysql mysql 8616 Mar 3 2014 querycache_info.frm > -rw-rw---- 1 mysql mysql 8796 Mar 3 2014 querycachetwo.frm > -rw-rw---- 1 mysql mysql 13762 Mar 3 2014 recentchanges.frm > -rw-rw---- 1 mysql mysql 8740 Mar 3 2014 redirect.frm > -rw-rw---- 1 mysql mysql 9040 Mar 3 2014 revision.frm > -rw-rw---- 1 mysql mysql 8640 Mar 3 2014 searchindex.frm > -rw-rw---- 1 mysql mysql 1336796 Nov 17 19:53 searchindex.MYD > -rw-rw---- 1 mysql mysql 924672 Nov 17 19:56 searchindex.MYI > -rw-rw---- 1 mysql mysql 8944 Mar 3 2014 site_stats.frm > -rw-rw---- 1 mysql mysql 8684 Mar 3 2014 tag_summary.frm > -rw-rw---- 1 mysql mysql 8650 Mar 3 2014 templatelinks.frm > -rw-rw---- 1 mysql mysql 8642 Mar 3 2014 text.frm > -rw-rw---- 1 mysql mysql 8644 Mar 3 2014 transcache.frm > -rw-rw---- 1 mysql mysql 8602 Mar 3 2014 updatelog.frm > -rw-rw---- 1 mysql mysql 9281 Mar 3 2014 uploadstash.frm > -rw-rw---- 1 mysql mysql 8608 Mar 3 2014 user_former_groups.frm > -rw-rw---- 1 mysql mysql 9244 Mar 3 2014 user.frm > -rw-rw---- 1 mysql mysql 8604 Mar 3 2014 user_groups.frm > -rw-rw---- 1 mysql mysql 8662 Mar 3 2014 user_newtalk.frm > -rw-rw---- 1 mysql mysql 8648 Mar 3 2014 user_properties.frm > -rw-rw---- 1 mysql mysql 8564 Mar 3 2014 valid_tag.frm > -rw-rw---- 1 mysql mysql 8720 Mar 3 2014 watchlist.frm > > If I try to connect directly in my wiki database: > Welcome to the MariaDB monitor. Commands end with ; or \g. > Your MariaDB connection id is 187 > Server version: 5.5.52-MariaDB MariaDB Server > > Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others. > > Type 'help;' or '\h' for help. Type '\c' to clear the current input > statement. > > MariaDB [(none)]> use wiki > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > Database changed > > MariaDB [wiki]> show tables; > +--------------------+ > | Tables_in_wiki | > +--------------------+ > | archive | > | category | > | categorylinks | > | change_tag | > | external_user | > | externallinks | > | filearchive | > | hitcounter | > | image | > | imagelinks | > | interwiki | > | ipblocks | > | iwlinks | > | job | > | l10n_cache | > | langlinks | > | log_search | > | logging | > | module_deps | > | msg_resource | > | msg_resource_links | > | objectcache | > | oldimage | > | page | > | page_props | > | page_restrictions | > | pagelinks | > | protected_titles | > | querycache | > | querycache_info | > | querycachetwo | > | recentchanges | > | redirect | > | revision | > | searchindex | > | site_stats | > | tag_summary | > | templatelinks | > | text | > | transcache | > | updatelog | > | uploadstash | > | user | > | user_former_groups | > | user_groups | > | user_newtalk | > | user_properties | > | valid_tag | > | watchlist | > +--------------------+ > 49 rows in set (0.00 sec) > > MariaDB [wiki]> select * from user; > ERROR 1146 (42S02): Table 'wiki.user' doesn't exist > > I think the real problem is this... > > _______________________________________________ > MediaWiki-l mailing list > To unsubscribe, go to: > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
