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