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