Hi,

Did I restore my database correctly?

Do I need to delete the database first?

Here's what happened:

I had trouble after upgrade of MW1.31.1 to MW1.35.1. I had had success
with this upgrade on the test version of my wiki, but ran into a
problem with the upgrade of the production version of my wiki. I may
post about that later. Meanwhile, to revert back to the 1.31.1 version
of my production wiki I moved the old files back in place:

-$  mv teflpedia teflpediaNEW; mv teflediaOLD teflpedia

And to revert the database and be rid of whatever changes I had done
when I had run MW1.35.1's maintenance/update.php, I did:

-$ gunzip < ~/bu/bilbo_teflpedia.20210130.MW1.31.1.sql.gz | mysql -p
bilbo_teflpedia

The database for the wiki is named bilbo_teflpedia, and I had created
that .sql.gz just prior to my upgrade attempt, with this:

-$  mysqldump -p --default-character-set=binary bilbo_teflpedia | gzip
> ~/bu/bilbo_teflpedia.20210130.MW1.31.1.sql.gz

Few!

Also, I had set my webhost to PHP 7.3.26 via cPanel, which both
MW1.31.1 and 1.35.1 are compatible with, before the upgade attempt.

Now I'm wondering, did I *combine* the new database with the old one
with that: -$ gunzip < ~/bu/bilbo_teflpedia.20210130.MW1.31.1.sql.gz |
mysql -p bilbo_teflpedia

Did I properly *replace* the bilbo_teflpedia database with the old one?

Do I need to delete the bilbo_teflpedia database first?


Thanks for any advice!

Roger Chrisman, venomous spider at teflpedia.com one bug at a time

For reference, here's my
* production wiki:   https://teflpedia.com/Special:Version
* test wiki:              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