subject:"\[MediaWiki\-l\] Problem migrating from an old CentOS6\/MySQL5 to new CentOS7\/MariaDB5.5"

Re: [MediaWiki-l] Problem migrating from an old CentOS6/MySQL5 to new CentOS7/MariaDB5.5

2016-12-28 Thread Edilmar LISTAS

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:

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

Re: [MediaWiki-l] Problem migrating from an old CentOS6/MySQL5 to new CentOS7/MariaDB5.5

2016-12-28 Thread Edilmar LISTAS

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:

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

Re: [MediaWiki-l] Problem migrating from an old CentOS6/MySQL5 to new CentOS7/MariaDB5.5

2016-12-28 Thread Edilmar LISTAS


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:
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
 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 mysql4096 Mar  3  2014 .
drwxr-xr-x 10 mysql mysql4096 Dez 19 20:06 ..
-rw-rw  1 mysql mysql9188 Mar  3  2014 archive.frm
-rw-rw  1 mysql mysql8770 Mar  3  2014 category.frm
-rw-rw  1 mysql mysql8843 Mar  3  2014 categorylinks.frm
-rw-rw  1 mysql mysql8722 Mar  3  2014 change_tag.frm
-rw-rw  1 mysql mysql  65 Fev 28  2014 db.opt
-rw-rw  1 mysql mysql8636 Mar  3  2014 externallinks.frm
-rw-rw  1 mysql mysql8624 Mar  3  2014 external_user.frm
-rw-rw  1 mysql mysql9678 Mar  3  2014 filearchive.frm
-rw-rw  1 mysql mysql8562 Mar  3  2014 hitcounter.frm
-rw-rw  1 mysql mysql9294 Mar  3  2014 image.frm
-rw-rw  1 mysql mysql8598 Mar  3  2014 imagelinks.frm
-rw-rw  1 mysql mysql8754 Mar  3  2014 interwiki.frm
-rw-rw  1 mysql mysql9316 Mar  3  2014 ipblocks.frm
-rw-rw  1 mysql mysql8650 Mar  3  2014 iwlinks.frm
-rw-rw  1 mysql mysql8778 Mar  3  2014 job.frm
-rw-rw  1 mysql mysql8638 Mar  3  2014 l10n_cache.frm
-rw-rw  1 mysql mysql8640 Mar  3  2014 langlinks.frm
-rw-rw  1 mysql mysql9034 Mar  3  2014 logging.frm
-rw-rw  1 mysql mysql8646 Mar  3  2014 log_search.frm
-rw-rw  1 mysql mysql8642 Mar  3  2014 module_deps.frm
-rw-rw  1 mysql mysql8692 Mar

Re: [MediaWiki-l] Problem migrating from an old CentOS6/MySQL5 to new CentOS7/MariaDB5.5

2016-12-28 Thread Edilmar LISTAS



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
 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 mysql4096 Mar  3  2014 .
drwxr-xr-x 10 mysql mysql4096 Dez 19 20:06 ..
-rw-rw  1 mysql mysql9188 Mar  3  2014 archive.frm
-rw-rw  1 mysql mysql8770 Mar  3  2014 category.frm
-rw-rw  1 mysql mysql8843 Mar  3  2014 categorylinks.frm
-rw-rw  1 mysql mysql8722 Mar  3  2014 change_tag.frm
-rw-rw  1 mysql mysql  65 Fev 28  2014 db.opt
-rw-rw  1 mysql mysql8636 Mar  3  2014 externallinks.frm
-rw-rw  1 mysql mysql8624 Mar  3  2014 external_user.frm
-rw-rw  1 mysql mysql9678 Mar  3  2014 filearchive.frm
-rw-rw  1 mysql mysql8562 Mar  3  2014 hitcounter.frm
-rw-rw  1 mysql mysql9294 Mar  3  2014 image.frm
-rw-rw  1 mysql mysql8598 Mar  3  2014 imagelinks.frm
-rw-rw  1 mysql mysql8754 Mar  3  2014 interwiki.frm
-rw-rw  1 mysql mysql9316 Mar  3  2014 ipblocks.frm
-rw-rw  1 mysql mysql8650 Mar  3  2014 iwlinks.frm
-rw-rw  1 mysql mysql8778 Mar  3  2014 job.frm
-rw-rw  1 mysql mysql8638 Mar  3  2014 l10n_cache.frm
-rw-rw  1 mysql mysql8640 Mar  3  2014 langlinks.frm
-rw-rw  1 mysql mysql9034 Mar  3  2014 logging.frm
-rw-rw  1 mysql mysql8646 Mar  3  2014 log_search.frm
-rw-rw  1 mysql mysql8642 Mar  3  2014 module_deps.frm
-rw-rw  1 mysql mysql8692 Mar  3  2014 msg_resource.frm
-rw-rw  1 mysql mysql8620 Mar  3  2014 msg_resource_links.frm
-rw-rw  1 mysql mysql8634 Mar  3  2014 objectcache.frm
-rw-rw  1 mysql mysql9360 Mar  3  2014 oldimage.frm
-rw-rw  1 mysql mysql9030 Mar  3  2014 page.frm

Re: [MediaWiki-l] Problem migrating from an old CentOS6/MySQL5 to new CentOS7/MariaDB5.5

2016-12-19 Thread Edilmar LISTAS


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
 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 mysql4096 Mar  3  2014 .
drwxr-xr-x 10 mysql mysql4096 Dez 19 20:06 ..
-rw-rw  1 mysql mysql9188 Mar  3  2014 archive.frm
-rw-rw  1 mysql mysql8770 Mar  3  2014 category.frm
-rw-rw  1 mysql mysql8843 Mar  3  2014 categorylinks.frm
-rw-rw  1 mysql mysql8722 Mar  3  2014 change_tag.frm
-rw-rw  1 mysql mysql  65 Fev 28  2014 db.opt
-rw-rw  1 mysql mysql8636 Mar  3  2014 externallinks.frm
-rw-rw  1 mysql mysql8624 Mar  3  2014 external_user.frm
-rw-rw  1 mysql mysql9678 Mar  3  2014 filearchive.frm
-rw-rw  1 mysql mysql8562 Mar  3  2014 hitcounter.frm
-rw-rw  1 mysql mysql9294 Mar  3  2014 image.frm
-rw-rw  1 mysql mysql8598 Mar  3  2014 imagelinks.frm
-rw-rw  1 mysql mysql8754 Mar  3  2014 interwiki.frm
-rw-rw  1 mysql mysql9316 Mar  3  2014 ipblocks.frm
-rw-rw  1 mysql mysql8650 Mar  3  2014 iwlinks.frm
-rw-rw  1 mysql mysql8778 Mar  3  2014 job.frm
-rw-rw  1 mysql mysql8638 Mar  3  2014 l10n_cache.frm
-rw-rw  1 mysql mysql8640 Mar  3  2014 langlinks.frm
-rw-rw  1 mysql mysql9034 Mar  3  2014 logging.frm
-rw-rw  1 mysql mysql8646 Mar  3  2014 log_search.frm
-rw-rw  1 mysql mysql8642 Mar  3  2014 module_deps.frm
-rw-rw  1 mysql mysql8692 Mar  3  2014 msg_resource.frm
-rw-rw  1 mysql mysql8620 Mar  3  2014 msg_resource_links.frm
-rw-rw  1 mysql mysql8634 Mar  3  2014 objectcache.frm
-rw-rw  1 mysql mysql9360 Mar  3  2014 oldimage.frm
-rw-rw  1 mysql mysql9030 Mar  3  2014 page.frm
-rw-rw  1 mysql mysql8650 Mar  3  2014 pagelinks.frm
-rw-rw  1 mysql mysql8648 Mar  3  2014 page_props.frm
-rw-rw  1 mysql mysql8790 Mar  3  2014 page_restrictions.frm
-rw-rw  1 mysql mysql8826 Mar  3  2014 protected_titles.frm
-rw-rw  1 mysql mysql8688 Mar  3  2014 querycache.frm
-rw-rw  1 mysql mysql8616 Mar  3  2014 querycache_info.frm
-rw-rw  1 mysql mysql8796 Mar  3  2014 querycachetwo.frm
-rw-rw  1 mysql mysql   13762 Mar  3  2014 recentchanges.frm
-rw-rw  1 mysql mysql8740 Mar  3  2014 redirect.frm
-rw-rw  1 mysql mysql9040 Mar  3  2014 revision.frm
-rw-rw  1 mysql mysql8640 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 mysql8944 Mar  3  2014 site_stats.frm
-rw-rw  1 mysql mysql8684 Mar  3  2014 tag_summary.frm
-rw-rw  1 mysql mysql8650 Mar  3  2014 templatelinks.frm
-rw-rw  1 mysql mysql8642 Mar  3  2014 text.frm
-rw-rw  1 mysql mysql8644 Mar  3  2014 transcache.frm
-rw-rw  1 mysql mysql8602 Mar  3  2014 updatelog.frm
-rw-rw  1 mysql mysql9281 Mar  3  2014 uploadstash.frm
-rw-rw  1 mysql mysql8608 Mar  3  2014 user_former_groups.frm
-rw-rw  1 mysql mysql9244 Mar  3  2014 user.frm
-rw-rw  1 mysql mysql8604 Mar  3  2014 user_groups.frm
-rw-rw  1 mysql mysql8662 Mar  3  2014 user_newtalk.frm
-rw-rw  1 mysql mysql8648 Mar  3  2014 user_properties.frm
-rw-rw  1 mysql mysql8564 Mar  3  2014 valid_tag.frm
-rw-rw  1 mysql mysql8720 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

Re: [MediaWiki-l] Problem migrating from an old CentOS6/MySQL5 to new CentOS7/MariaDB5.5

2016-12-19 Thread Brian Wolff

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
 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 mysql4096 Mar  3  2014 .
> drwxr-xr-x 10 mysql mysql4096 Dez 19 20:06 ..
> -rw-rw  1 mysql mysql9188 Mar  3  2014 archive.frm
> -rw-rw  1 mysql mysql8770 Mar  3  2014 category.frm
> -rw-rw  1 mysql mysql8843 Mar  3  2014 categorylinks.frm
> -rw-rw  1 mysql mysql8722 Mar  3  2014 change_tag.frm
> -rw-rw  1 mysql mysql  65 Fev 28  2014 db.opt
> -rw-rw  1 mysql mysql8636 Mar  3  2014 externallinks.frm
> -rw-rw  1 mysql mysql8624 Mar  3  2014 external_user.frm
> -rw-rw  1 mysql mysql9678 Mar  3  2014 filearchive.frm
> -rw-rw  1 mysql mysql8562 Mar  3  2014 hitcounter.frm
> -rw-rw  1 mysql mysql9294 Mar  3  2014 image.frm
> -rw-rw  1 mysql mysql8598 Mar  3  2014 imagelinks.frm
> -rw-rw  1 mysql mysql8754 Mar  3  2014 interwiki.frm
> -rw-rw  1 mysql mysql9316 Mar  3  2014 ipblocks.frm
> -rw-rw  1 mysql mysql8650 Mar  3  2014 iwlinks.frm
> -rw-rw  1 mysql mysql8778 Mar  3  2014 job.frm
> -rw-rw  1 mysql mysql8638 Mar  3  2014 l10n_cache.frm
> -rw-rw  1 mysql mysql8640 Mar  3  2014 langlinks.frm
> -rw-rw  1 mysql mysql9034 Mar  3  2014 logging.frm
> -rw-rw  1 mysql mysql8646 Mar  3  2014 log_search.frm
> -rw-rw  1 mysql mysql8642 Mar  3  2014 module_deps.frm
> -rw-rw  1 mysql mysql8692 Mar  3  2014 msg_resource.frm
> -rw-rw  1 mysql mysql8620 Mar  3  2014 msg_resource_links.frm
> -rw-rw  1 mysql mysql8634 Mar  3  2014 objectcache.frm
> -rw-rw  1 mysql mysql9360 Mar  3  2014 oldimage.frm
> -rw-rw  1 mysql mysql9030 Mar  3  2014 page.frm
> -rw-rw  1 mysql mysql8650 Mar  3  2014 pagelinks.frm
> -rw-rw  1 mysql mysql8648 Mar  3  2014 page_props.frm
> -rw-rw  1 mysql mysql8790 Mar  3  2014 page_restrictions.frm
> -rw-rw  1 mysql mysql8826 Mar  3  2014 protected_titles.frm
> -rw-rw  1 mysql mysql8688 Mar  3  2014 querycache.frm
> -rw-rw  1 mysql mysql8616 Mar  3  2014 querycache_info.frm
> -rw-rw  1 mysql mysql8796 Mar  3  2014 querycachetwo.frm
> -rw-rw  1 mysql mysql   13762 Mar  3  2014 recentchanges.frm
> -rw-rw  1 mysql mysql8740 Mar  3  2014 redirect.frm
> -rw-rw  1 mysql mysql9040 Mar  3  2014 revision.frm
> -rw-rw  1 mysql mysql8640 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 mysql8944 Mar  3  2014 site_stats.frm
> -rw-rw  1 mysql mysql8684 Mar  3  2014 tag_summary.frm
> -rw-rw  1 mysql mysql8650 Mar  3  2014 templatelinks.frm
> -rw-rw  1 mysql mysql8642 Mar  3  2014 text.frm
> -rw-rw  1 mysql mysql8644 Mar  3  2014 transcache.frm
> -rw-rw  1 mysql mysql8602 Mar  3  2014 updatelog.frm
> -rw-rw  1 mysql mysql9281 Mar  3  2014 uploadstash.frm
> -rw-rw  1 mysql mysql8608 Mar  3  2014 user_former_groups.frm
> -rw-rw  1 mysql mysql9244 Mar  3  2014 user.frm
> -rw-rw  1 mysql mysql8604 Mar  3  2014 user_groups.frm
> -rw-rw  1 mysql mysql8662 Mar  3  2014 user_newtalk.frm
> -rw-rw  1 mysql mysql8648 Mar  3  2014 user_properties.frm
> -rw-rw  1 mysql mysql8564 Mar  3  2014 valid_tag.frm
> -rw-rw  1 mysql mysql8720 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

[MediaWiki-l] Problem migrating from an old CentOS6/MySQL5 to new CentOS7/MariaDB5.5

2016-12-19 Thread Edilmar LISTAS


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 mysql4096 Mar  3  2014 .
drwxr-xr-x 10 mysql mysql4096 Dez 19 20:06 ..
-rw-rw  1 mysql mysql9188 Mar  3  2014 archive.frm
-rw-rw  1 mysql mysql8770 Mar  3  2014 category.frm
-rw-rw  1 mysql mysql8843 Mar  3  2014 categorylinks.frm
-rw-rw  1 mysql mysql8722 Mar  3  2014 change_tag.frm
-rw-rw  1 mysql mysql  65 Fev 28  2014 db.opt
-rw-rw  1 mysql mysql8636 Mar  3  2014 externallinks.frm
-rw-rw  1 mysql mysql8624 Mar  3  2014 external_user.frm
-rw-rw  1 mysql mysql9678 Mar  3  2014 filearchive.frm
-rw-rw  1 mysql mysql8562 Mar  3  2014 hitcounter.frm
-rw-rw  1 mysql mysql9294 Mar  3  2014 image.frm
-rw-rw  1 mysql mysql8598 Mar  3  2014 imagelinks.frm
-rw-rw  1 mysql mysql8754 Mar  3  2014 interwiki.frm
-rw-rw  1 mysql mysql9316 Mar  3  2014 ipblocks.frm
-rw-rw  1 mysql mysql8650 Mar  3  2014 iwlinks.frm
-rw-rw  1 mysql mysql8778 Mar  3  2014 job.frm
-rw-rw  1 mysql mysql8638 Mar  3  2014 l10n_cache.frm
-rw-rw  1 mysql mysql8640 Mar  3  2014 langlinks.frm
-rw-rw  1 mysql mysql9034 Mar  3  2014 logging.frm
-rw-rw  1 mysql mysql8646 Mar  3  2014 log_search.frm
-rw-rw  1 mysql mysql8642 Mar  3  2014 module_deps.frm
-rw-rw  1 mysql mysql8692 Mar  3  2014 msg_resource.frm
-rw-rw  1 mysql mysql8620 Mar  3  2014 msg_resource_links.frm
-rw-rw  1 mysql mysql8634 Mar  3  2014 objectcache.frm
-rw-rw  1 mysql mysql9360 Mar  3  2014 oldimage.frm
-rw-rw  1 mysql mysql9030 Mar  3  2014 page.frm
-rw-rw  1 mysql mysql8650 Mar  3  2014 pagelinks.frm
-rw-rw  1 mysql mysql8648 Mar  3  2014 page_props.frm
-rw-rw  1 mysql mysql8790 Mar  3  2014 page_restrictions.frm
-rw-rw  1 mysql mysql8826 Mar  3  2014 protected_titles.frm
-rw-rw  1 mysql mysql8688 Mar  3  2014 querycache.frm
-rw-rw  1 mysql mysql8616 Mar  3  2014 querycache_info.frm
-rw-rw  1 mysql mysql8796 Mar  3  2014 querycachetwo.frm
-rw-rw  1 mysql mysql   13762 Mar  3  2014 recentchanges.frm
-rw-rw  1 mysql mysql8740 Mar  3  2014 redirect.frm
-rw-rw  1 mysql mysql9040 Mar  3  2014 revision.frm
-rw-rw  1 mysql mysql8640 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 mysql8944 Mar  3  2014 site_stats.frm
-rw-rw  1 mysql mysql8684 Mar  3  2014 tag_summary.frm
-rw-rw  1 mysql mysql8650 Mar  3  2014 templatelinks.frm
-rw-rw  1 mysql mysql8642 Mar  3  2014 text.frm
-rw-rw  1 mysql mysql8644 Mar  3  2014 transcache.frm
-rw-rw  1 mysql mysql8602 Mar  3  2014 updatelog.frm
-rw-rw  1 mysql mysql9281 Mar  3  2014 uploadstash.frm
-rw-rw  1 mysql mysql8608 Mar  3  2014 user_former_groups.frm
-rw-rw  1 mysql mysql9244 Mar  3  2014 user.frm
-rw-rw  1 mysql mysql8604 Mar  3  2014 user_groups.frm
-rw-rw  1 mysql mysql8662 Mar  3  2014 user_newtalk.frm
-rw-rw  1 mysql mysql8648 Mar  3  2014 user_properties.frm
-rw-rw  1 mysql mysql8564 Mar  3  2014 valid_tag.frm
-rw-rw  1 mysql mysql8720 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

Re: [MediaWiki-l] Problem migrating from an old CentOS6/MySQL5 to new CentOS7/MariaDB5.5

Re: [MediaWiki-l] Problem migrating from an old CentOS6/MySQL5 to new CentOS7/MariaDB5.5

Re: [MediaWiki-l] Problem migrating from an old CentOS6/MySQL5 to new CentOS7/MariaDB5.5

Re: [MediaWiki-l] Problem migrating from an old CentOS6/MySQL5 to new CentOS7/MariaDB5.5

Re: [MediaWiki-l] Problem migrating from an old CentOS6/MySQL5 to new CentOS7/MariaDB5.5

Re: [MediaWiki-l] Problem migrating from an old CentOS6/MySQL5 to new CentOS7/MariaDB5.5

[MediaWiki-l] Problem migrating from an old CentOS6/MySQL5 to new CentOS7/MariaDB5.5

7 matches

Site Navigation

Mail list logo

Footer information