On 31 Jan 2021, at 00:39, rogerchrisman(a)gmail.com
wrote:
-$ 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?
I’m not an expert by any means but I think add-drop-table is included by default in the
mysqldump command:
--opt
This option, enabled by default, is shorthand for the combination of --add-drop-table
--add-locks --create-options --disable-keys --extended-insert --lock-tables --quick
--set-charset. It gives a fast dump operation and produces a dump file that can be
reloaded into a MySQL server quickly.
--add-drop-table
Write a DROP TABLE statement before each CREATE TABLE statement.