New subject: Problem migrating from an old CentOS6/MySQL5 to new CentOS7/MariaDB5.5

19 Dec 2016

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

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...