Hello,

I have been reading the fine manual at
https://www.mediawiki.org/wiki/Manual:Restoring_a_wiki_from_backup

That ^ page suggests I might delete any dubious database before
restoring into it. My wiki seemed to be working fine. But I didn't
_feel_ fine. My imagination wove lots of imaginary oops into trying to
restore a MW1.31.1 database into itself after having run MW1.35.1
maintenance/update.php on it. So I did the following -- I moved the
old database, created new database, restored database, as follows:


I moved my database bilbo_teflpedia to bilbo_teflpedia_mush in cPanel
>> MySQL Databases. (I could move it back if oops, or delete it later
if all goes well.)

Then I created a new empty bilbo_teflpedia database in cPanel >> MySQL
Databases.

Then I restored my wiki1.31.1 database into that new database from the
command line with:
-$ gunzip < ~/bu/bilbo_teflpedia.20210130.MW1.31.1.sql.gz | mysql -p
bilbo_teflpedia


Wiki seems to be working fine. Have I done that restore correctly?

Roger

For reference
* production wiki v 1.31.1:   https://teflpedia.com/Special:Version
* test wiki v 1.35.1:              https://tp.rogerchrisman.com/Special:Version

_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Reply via email to