> On 31 Jan 2021, at 00:39, rogerchris...@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. https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html#option_mysqldump_add-drop-table Best wishes Jonathan
_______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
