Topic on Project:Support desk

Baruchgu (talkcontribs)

Hi, I'd like to migrate my wiki DB from old server to new one

old: CentOS 5, MySQL Distrib 5.1.30, for pc-linux-gnu (i686), MediaWiki 1.17

new CentOS 7, MySQL Distrib 5.5.56-MariaDB, for Linux (x86_64), MediaWiki 1.29.2

I ran on old server: mysqldump -u root -pxxx DB > DB.dump.sql

on new : mysql -u root -pxxx -D DB < DB.dump.sql ; withour errors and warnings!

And the Wiki system was down - present some XML or SQL errors.

I succeed to restore the original DB from older backup.

Any suggestions, please!?

Baruchgu (talkcontribs)

Added and $wgShowDBErrorBacktrace = true;

see an see Error: 1054 Unknown column 'page_links_updated' in 'field list'

Ciencia Al Poder (talkcontribs)
Baruchgu (talkcontribs)

No. I installed new MediWiki on new server from scratch. If I still need update script ?

Ciencia Al Poder (talkcontribs)

You UPGRADED from MediaWiki 1.17 to MediaWiki 1.29.2, so yes, you need to run the update script!

Malyacko (talkcontribs)

New versions = new database schemes. Yes, obviously.

Baruchgu (talkcontribs)

also Error: 1054 Unknown column 'page_content_model' in 'field list'

Baruchgu (talkcontribs)

After run php update.php and restore again I got

Error: 1054 Unknown column 'ug_expiry' in 'field list'

Baruchgu (talkcontribs)

Rerun php update.php solved the issue! Thanks ALL!