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
<edilista(a)intersite.com.br> 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