On 31 Jan 2021, at 00:39, rogerchrisman(a)gmail.com
-$ mysqldump -p --default-character-set=binary bilbo_teflpedia | gzip
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
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.
Write a DROP TABLE statement before each CREATE TABLE statement.