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...
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@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
The old server crashed but I had a backup from /var/lib/mysql directory. I will try to install an old MySQL in other machine to run a dump.
Em 19-12-2016 17:33, Brian Wolff escreveu:
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@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
MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
I try to do this: 1) backup LocalSettings.php and wiki database from MySQL 2) remove LocalSettings.php and wiki database to start a "new installation" 3) run http://mydomain.com/wiki//mw-config/index.php 4) error: MediaWiki 1.19.0 A criar as tabelas...Ocorreu um erro de sintaxe de busca no banco de dados. Isto pode indicar um problema com o ''software''. A última tentativa de busca no banco de dados foi:
CREATE TABLE `l10n_cache` ( lc_lang varbinary(32) NOT NULL, lc_key varchar(255) NOT NULL, lc_value mediumblob NOT NULL ) ENGINE=InnoDB, DEFAULT CHARSET=binary
na função "DatabaseBase::sourceFile( /var/www/wiki/maintenance/tables.sql )". O banco de dados retornou o erro "1146: Table 'wiki.l10n_cache' doesn't exist (localhost)".
Backtrace:
#0 /var/www/wiki/includes/db/Database.php(885): DatabaseBase->reportQueryError('Table 'wiki.l10...', 1146, 'CREATE TABLE `l...', 'DatabaseBase::s...', false) #1 /var/www/wiki/includes/db/Database.php(3187): DatabaseBase->query('CREATE TABLE `l...', 'DatabaseBase::s...') #2 /var/www/wiki/includes/db/Database.php(3099): DatabaseBase->sourceStream(Resource id #75, false, false, 'DatabaseBase::s...') #3 /var/www/wiki/includes/installer/DatabaseInstaller.php(169): DatabaseBase->sourceFile('/var/www/wiki/m...') #4 [internal function]: DatabaseInstaller->createTables(Object(MysqlInstaller)) #5 /var/www/wiki/includes/installer/Installer.php(1389): call_user_func(Array, Object(MysqlInstaller)) #6 /var/www/wiki/includes/installer/WebInstallerPage.php(1142): Installer->performInstallation(Array, Array) #7 /var/www/wiki/includes/installer/WebInstaller.php(254): WebInstaller_Install->execute() #8 /var/www/wiki/mw-config/index.php(50): WebInstaller->execute(Array) #9 /var/www/wiki/mw-config/index.php(18): wfInstallerMain() #10 {main}
[root@websaf www]# rpm -qa | grep mariadb mariadb-server-5.5.52-1.el7.x86_64 mariadb-libs-5.5.52-1.el7.x86_64 mariadb-5.5.52-1.el7.x86_64
Em 19-12-2016 17:38, Edilmar LISTAS escreveu:
The old server crashed but I had a backup from /var/lib/mysql directory. I will try to install an old MySQL in other machine to run a dump.
Em 19-12-2016 17:33, Brian Wolff escreveu:
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@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
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
1) stopped/started mariadb 2) made a complete new installation 3) stopped mariadb 4) restored the wiki DB backup in /var/lib/mysql 5) restored LocalSettings.php 6) started mariadb But the WIKI showed a clean new wiki, not my complete original wiki.
Em 28-12-2016 10:33, Edilmar LISTAS escreveu:
I try to do this:
- backup LocalSettings.php and wiki database from MySQL
- remove LocalSettings.php and wiki database to start a "new installation"
- run http://mydomain.com/wiki//mw-config/index.php
- error:
MediaWiki 1.19.0 A criar as tabelas...Ocorreu um erro de sintaxe de busca no banco de dados. Isto pode indicar um problema com o ''software''. A última tentativa de busca no banco de dados foi:
CREATE TABLE `l10n_cache` ( lc_lang varbinary(32) NOT NULL, lc_keyvarchar(255) NOT NULL, lc_value mediumblob NOT NULL ) ENGINE=InnoDB, DEFAULT CHARSET=binary
na função "DatabaseBase::sourceFile( /var/www/wiki/maintenance/tables.sql )". O banco de dados retornou o erro "1146: Table 'wiki.l10n_cache' doesn't exist (localhost)".
Backtrace:
#0 /var/www/wiki/includes/db/Database.php(885): DatabaseBase->reportQueryError('Table 'wiki.l10...', 1146, 'CREATE TABLE `l...', 'DatabaseBase::s...', false) #1 /var/www/wiki/includes/db/Database.php(3187): DatabaseBase->query('CREATE TABLE `l...', 'DatabaseBase::s...') #2 /var/www/wiki/includes/db/Database.php(3099): DatabaseBase->sourceStream(Resource id #75, false, false, 'DatabaseBase::s...') #3 /var/www/wiki/includes/installer/DatabaseInstaller.php(169): DatabaseBase->sourceFile('/var/www/wiki/m...') #4 [internal function]: DatabaseInstaller->createTables(Object(MysqlInstaller)) #5 /var/www/wiki/includes/installer/Installer.php(1389): call_user_func(Array, Object(MysqlInstaller)) #6 /var/www/wiki/includes/installer/WebInstallerPage.php(1142): Installer->performInstallation(Array, Array) #7 /var/www/wiki/includes/installer/WebInstaller.php(254): WebInstaller_Install->execute() #8 /var/www/wiki/mw-config/index.php(50): WebInstaller->execute(Array) #9 /var/www/wiki/mw-config/index.php(18): wfInstallerMain() #10 {main}
[root@websaf www]# rpm -qa | grep mariadb mariadb-server-5.5.52-1.el7.x86_64 mariadb-libs-5.5.52-1.el7.x86_64 mariadb-5.5.52-1.el7.x86_64
Em 19-12-2016 17:38, Edilmar LISTAS escreveu:
The old server crashed but I had a backup from /var/lib/mysql directory. I will try to install an old MySQL in other machine to run a dump.
Em 19-12-2016 17:33, Brian Wolff escreveu:
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@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
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
MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Now I restored the file /var/lib/mysql/ibdata1 and almost all the wiki pages were there. However, for some pages, Mediawiki arises this error:
MediaWiki internal error.
Original exception: exception 'DBConnectionError' with message 'DB connection error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) (localhost)' in /var/www/wikisup/includes/db/Database.php:746 Stack trace: #0 /var/www/wikisup/includes/db/DatabaseMysql.php(146): DatabaseBase->reportConnectionError(' Can't connect ...') #1 /var/www/wikisup/includes/db/DatabaseMysql.php(469): DatabaseMysql->open('localhost', 'root', 'pass', 'wikisup') #2 /var/www/wikisup/includes/db/Database.php(868): DatabaseMysql->ping() #3 /var/www/wikisup/includes/db/Database.php(1358): DatabaseBase->query('SELECT value,e...', 'SqlBagOStuff::g...') #4 /var/www/wikisup/includes/db/Database.php(1444): DatabaseBase->select('objectcache', Array, Array, 'SqlBagOStuff::g...', Array, Array) #5 /var/www/wikisup/includes/objectcache/SqlBagOStuff.php(124): DatabaseBase->selectRow('objectcache', Array, Array, 'SqlBagOStuff::g...') #6 /var/www/wikisup/includes/resourceloader/ResourceLoader.php(149): SqlBagOStuff->get('wikisup:resourc...') #7 /var/www/wikisup/includes/resourceloader/ResourceLoader.php(785): ResourceLoader->filter('minify-js', 'mw.loader.imple...') #8 /var/www/wikisup/includes/OutputPage.php(2599): ResourceLoader->makeModuleResponse(Object(ResourceLoaderContext), Array) #9 /var/www/wikisup/includes/OutputPage.php(2688): OutputPage->makeResourceLoaderLink(Array, 'combined') #10 /var/www/wikisup/includes/OutputPage.php(2408): OutputPage->getHeadScripts() #11 /var/www/wikisup/includes/SkinTemplate.php(461): OutputPage->headElement(Object(SkinVector)) #12 /var/www/wikisup/includes/OutputPage.php(1982): SkinTemplate->outputPage() #13 /var/www/wikisup/includes/Wiki.php(406): OutputPage->output() #14 /var/www/wikisup/includes/Wiki.php(594): MediaWiki->finalCleanup() #15 /var/www/wikisup/includes/Wiki.php(503): MediaWiki->main() #16 /var/www/wikisup/index.php(58): MediaWiki->run() #17 {main}
Exception caught inside exception handler: exception 'DBConnectionError' with message 'DB connection error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) (localhost)' in /var/www/wikisup/includes/db/Database.php:746 Stack trace: #0 /var/www/wikisup/includes/db/DatabaseMysql.php(146): DatabaseBase->reportConnectionError(' Can't connect ...') #1 /var/www/wikisup/includes/db/DatabaseMysql.php(469): DatabaseMysql->open('localhost', 'root', 'pass', 'wikisup') #2 /var/www/wikisup/includes/db/Database.php(868): DatabaseMysql->ping() #3 /var/www/wikisup/includes/db/Database.php(1358): DatabaseBase->query('SELECT lc_valu...', 'LCStore_DB::get') #4 /var/www/wikisup/includes/db/Database.php(1444): DatabaseBase->select('l10n_cache', Array, Array, 'LCStore_DB::get', Array, Array) #5 /var/www/wikisup/includes/LocalisationCache.php(892): DatabaseBase->selectRow('l10n_cache', Array, Array, 'LCStore_DB::get') #6 /var/www/wikisup/includes/LocalisationCache.php(339): LCStore_DB->get('pt-br', 'messages:dberr-...') #7 /var/www/wikisup/includes/LocalisationCache.php(240): LocalisationCache->loadSubitem('pt-br', 'messages', 'dberr-problems') #8 /var/www/wikisup/languages/Language.php(1974): LocalisationCache->getSubitem('pt-br', 'messages', 'dberr-problems') #9 /var/www/wikisup/includes/db/DatabaseError.php(104): Language->getMessage('dberr-problems') #10 /var/www/wikisup/includes/db/DatabaseError.php(133): DBConnectionError->msg('dberr-problems', 'Sorry! This sit...') #11 /var/www/wikisup/includes/Exception.php(190): DBConnectionError->getHTML() #12 /var/www/wikisup/includes/db/DatabaseError.php(185): MWException->reportHTML() #13 /var/www/wikisup/includes/Exception.php(209): DBConnectionError->reportHTML() #14 /var/www/wikisup/includes/Exception.php(490): MWException->report() #15 /var/www/wikisup/includes/Exception.php(569): MWExceptionHandler::report(Object(DBConnectionError)) #16 /var/www/wikisup/includes/Wiki.php(506): MWExceptionHandler::handle(Object(DBConnectionError)) #17 /var/www/wikisup/index.php(58): MediaWiki->run() #18 {main}
Em 28-12-2016 11:43, Edilmar LISTAS escreveu:
- stopped/started mariadb
- made a complete new installation
- stopped mariadb
- restored the wiki DB backup in /var/lib/mysql
- restored LocalSettings.php
- started mariadb
But the WIKI showed a clean new wiki, not my complete original wiki.
Em 28-12-2016 10:33, Edilmar LISTAS escreveu:
I try to do this:
- backup LocalSettings.php and wiki database from MySQL
- remove LocalSettings.php and wiki database to start a "new
installation" 3) run http://mydomain.com/wiki//mw-config/index.php 4) error: MediaWiki 1.19.0 A criar as tabelas...Ocorreu um erro de sintaxe de busca no banco de dados. Isto pode indicar um problema com o ''software''. A última tentativa de busca no banco de dados foi:
CREATE TABLE `l10n_cache` ( lc_lang varbinary(32) NOT NULL, lc_keyvarchar(255) NOT NULL, lc_value mediumblob NOT NULL ) ENGINE=InnoDB, DEFAULT CHARSET=binary
na função "DatabaseBase::sourceFile( /var/www/wiki/maintenance/tables.sql )". O banco de dados retornou o erro "1146: Table 'wiki.l10n_cache' doesn't exist (localhost)".
Backtrace:
#0 /var/www/wiki/includes/db/Database.php(885): DatabaseBase->reportQueryError('Table 'wiki.l10...', 1146, 'CREATE TABLE `l...', 'DatabaseBase::s...', false) #1 /var/www/wiki/includes/db/Database.php(3187): DatabaseBase->query('CREATE TABLE `l...', 'DatabaseBase::s...') #2 /var/www/wiki/includes/db/Database.php(3099): DatabaseBase->sourceStream(Resource id #75, false, false, 'DatabaseBase::s...') #3 /var/www/wiki/includes/installer/DatabaseInstaller.php(169): DatabaseBase->sourceFile('/var/www/wiki/m...') #4 [internal function]: DatabaseInstaller->createTables(Object(MysqlInstaller)) #5 /var/www/wiki/includes/installer/Installer.php(1389): call_user_func(Array, Object(MysqlInstaller)) #6 /var/www/wiki/includes/installer/WebInstallerPage.php(1142): Installer->performInstallation(Array, Array) #7 /var/www/wiki/includes/installer/WebInstaller.php(254): WebInstaller_Install->execute() #8 /var/www/wiki/mw-config/index.php(50): WebInstaller->execute(Array) #9 /var/www/wiki/mw-config/index.php(18): wfInstallerMain() #10 {main}
[root@websaf www]# rpm -qa | grep mariadb mariadb-server-5.5.52-1.el7.x86_64 mariadb-libs-5.5.52-1.el7.x86_64 mariadb-5.5.52-1.el7.x86_64
Em 19-12-2016 17:38, Edilmar LISTAS escreveu:
The old server crashed but I had a backup from /var/lib/mysql directory. I will try to install an old MySQL in other machine to run a dump.
Em 19-12-2016 17:33, Brian Wolff escreveu:
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@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
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
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
Now, after to run server with innodb_force_recovery = 1 (http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html) I got to recover all the database.
Em 28-12-2016 14:23, Edilmar LISTAS escreveu:
Now I restored the file /var/lib/mysql/ibdata1 and almost all the wiki pages were there. However, for some pages, Mediawiki arises this error:
MediaWiki internal error.
Original exception: exception 'DBConnectionError' with message 'DB connection error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) (localhost)' in /var/www/wikisup/includes/db/Database.php:746 Stack trace: #0 /var/www/wikisup/includes/db/DatabaseMysql.php(146): DatabaseBase->reportConnectionError(' Can't connect ...') #1 /var/www/wikisup/includes/db/DatabaseMysql.php(469): DatabaseMysql->open('localhost', 'root', 'pass', 'wikisup') #2 /var/www/wikisup/includes/db/Database.php(868): DatabaseMysql->ping() #3 /var/www/wikisup/includes/db/Database.php(1358): DatabaseBase->query('SELECT value,e...', 'SqlBagOStuff::g...') #4 /var/www/wikisup/includes/db/Database.php(1444): DatabaseBase->select('objectcache', Array, Array, 'SqlBagOStuff::g...', Array, Array) #5 /var/www/wikisup/includes/objectcache/SqlBagOStuff.php(124): DatabaseBase->selectRow('objectcache', Array, Array, 'SqlBagOStuff::g...') #6 /var/www/wikisup/includes/resourceloader/ResourceLoader.php(149): SqlBagOStuff->get('wikisup:resourc...') #7 /var/www/wikisup/includes/resourceloader/ResourceLoader.php(785): ResourceLoader->filter('minify-js', 'mw.loader.imple...') #8 /var/www/wikisup/includes/OutputPage.php(2599): ResourceLoader->makeModuleResponse(Object(ResourceLoaderContext), Array) #9 /var/www/wikisup/includes/OutputPage.php(2688): OutputPage->makeResourceLoaderLink(Array, 'combined') #10 /var/www/wikisup/includes/OutputPage.php(2408): OutputPage->getHeadScripts() #11 /var/www/wikisup/includes/SkinTemplate.php(461): OutputPage->headElement(Object(SkinVector)) #12 /var/www/wikisup/includes/OutputPage.php(1982): SkinTemplate->outputPage() #13 /var/www/wikisup/includes/Wiki.php(406): OutputPage->output() #14 /var/www/wikisup/includes/Wiki.php(594): MediaWiki->finalCleanup() #15 /var/www/wikisup/includes/Wiki.php(503): MediaWiki->main() #16 /var/www/wikisup/index.php(58): MediaWiki->run() #17 {main}
Exception caught inside exception handler: exception 'DBConnectionError' with message 'DB connection error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) (localhost)' in /var/www/wikisup/includes/db/Database.php:746 Stack trace: #0 /var/www/wikisup/includes/db/DatabaseMysql.php(146): DatabaseBase->reportConnectionError(' Can't connect ...') #1 /var/www/wikisup/includes/db/DatabaseMysql.php(469): DatabaseMysql->open('localhost', 'root', 'pass', 'wikisup') #2 /var/www/wikisup/includes/db/Database.php(868): DatabaseMysql->ping() #3 /var/www/wikisup/includes/db/Database.php(1358): DatabaseBase->query('SELECT lc_valu...', 'LCStore_DB::get') #4 /var/www/wikisup/includes/db/Database.php(1444): DatabaseBase->select('l10n_cache', Array, Array, 'LCStore_DB::get', Array, Array) #5 /var/www/wikisup/includes/LocalisationCache.php(892): DatabaseBase->selectRow('l10n_cache', Array, Array, 'LCStore_DB::get') #6 /var/www/wikisup/includes/LocalisationCache.php(339): LCStore_DB->get('pt-br', 'messages:dberr-...') #7 /var/www/wikisup/includes/LocalisationCache.php(240): LocalisationCache->loadSubitem('pt-br', 'messages', 'dberr-problems') #8 /var/www/wikisup/languages/Language.php(1974): LocalisationCache->getSubitem('pt-br', 'messages', 'dberr-problems') #9 /var/www/wikisup/includes/db/DatabaseError.php(104): Language->getMessage('dberr-problems') #10 /var/www/wikisup/includes/db/DatabaseError.php(133): DBConnectionError->msg('dberr-problems', 'Sorry! This sit...') #11 /var/www/wikisup/includes/Exception.php(190): DBConnectionError->getHTML() #12 /var/www/wikisup/includes/db/DatabaseError.php(185): MWException->reportHTML() #13 /var/www/wikisup/includes/Exception.php(209): DBConnectionError->reportHTML() #14 /var/www/wikisup/includes/Exception.php(490): MWException->report() #15 /var/www/wikisup/includes/Exception.php(569): MWExceptionHandler::report(Object(DBConnectionError)) #16 /var/www/wikisup/includes/Wiki.php(506): MWExceptionHandler::handle(Object(DBConnectionError)) #17 /var/www/wikisup/index.php(58): MediaWiki->run() #18 {main}
Em 28-12-2016 11:43, Edilmar LISTAS escreveu:
- stopped/started mariadb
- made a complete new installation
- stopped mariadb
- restored the wiki DB backup in /var/lib/mysql
- restored LocalSettings.php
- started mariadb
But the WIKI showed a clean new wiki, not my complete original wiki.
Em 28-12-2016 10:33, Edilmar LISTAS escreveu:
I try to do this:
- backup LocalSettings.php and wiki database from MySQL
- remove LocalSettings.php and wiki database to start a "new
installation" 3) run http://mydomain.com/wiki//mw-config/index.php 4) error: MediaWiki 1.19.0 A criar as tabelas...Ocorreu um erro de sintaxe de busca no banco de dados. Isto pode indicar um problema com o ''software''. A última tentativa de busca no banco de dados foi:
CREATE TABLE `l10n_cache` ( lc_lang varbinary(32) NOT NULL, lc_keyvarchar(255) NOT NULL, lc_value mediumblob NOT NULL ) ENGINE=InnoDB, DEFAULT CHARSET=binary
na função "DatabaseBase::sourceFile( /var/www/wiki/maintenance/tables.sql )". O banco de dados retornou o erro "1146: Table 'wiki.l10n_cache' doesn't exist (localhost)".
Backtrace:
#0 /var/www/wiki/includes/db/Database.php(885): DatabaseBase->reportQueryError('Table 'wiki.l10...', 1146, 'CREATE TABLE `l...', 'DatabaseBase::s...', false) #1 /var/www/wiki/includes/db/Database.php(3187): DatabaseBase->query('CREATE TABLE `l...', 'DatabaseBase::s...') #2 /var/www/wiki/includes/db/Database.php(3099): DatabaseBase->sourceStream(Resource id #75, false, false, 'DatabaseBase::s...') #3 /var/www/wiki/includes/installer/DatabaseInstaller.php(169): DatabaseBase->sourceFile('/var/www/wiki/m...') #4 [internal function]: DatabaseInstaller->createTables(Object(MysqlInstaller)) #5 /var/www/wiki/includes/installer/Installer.php(1389): call_user_func(Array, Object(MysqlInstaller)) #6 /var/www/wiki/includes/installer/WebInstallerPage.php(1142): Installer->performInstallation(Array, Array) #7 /var/www/wiki/includes/installer/WebInstaller.php(254): WebInstaller_Install->execute() #8 /var/www/wiki/mw-config/index.php(50): WebInstaller->execute(Array) #9 /var/www/wiki/mw-config/index.php(18): wfInstallerMain() #10 {main}
[root@websaf www]# rpm -qa | grep mariadb mariadb-server-5.5.52-1.el7.x86_64 mariadb-libs-5.5.52-1.el7.x86_64 mariadb-5.5.52-1.el7.x86_64
Em 19-12-2016 17:38, Edilmar LISTAS escreveu:
The old server crashed but I had a backup from /var/lib/mysql directory. I will try to install an old MySQL in other machine to run a dump.
Em 19-12-2016 17:33, Brian Wolff escreveu:
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@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
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
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
MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org