somehow download the SQL dump

If you only have FTP access, I'll guess you need to change the PHP files so that some hook launched a DB dump? But will it finish within the timeout? It might also be enough to use the XML export, which should carry all (text) content but may miss some configuration. That might be easier to import back into the existing installation too. (The existing installation had some draft or recent articles which were not migrated to the non-WMI installation.)

In T276206#6874314, @Nemo_bis wrote:

somehow download the SQL dump

If you only have FTP access, I'll guess you need to change the PHP files so that some hook launched a DB dump? But will it finish within the timeout? It might also be enough to use the XML export, which should carry all (text) content but may miss some configuration. That might be easier to import back into the existing installation too. (The existing installation had some draft or recent articles which were not migrated to the non-WMI installation.)

Yup. Here we go:

<?php
exec( "mysqldump --user=omissis --password=omissis --host=localhost DB_NAME > very-secret-omissis-very-long-very-wow-very-omissis-and-secret-really-trust-me-its-omissis.sql" );

FYI, some issues I encountered:

$ mysql WMDB < WMDB.sql
ERROR 1273 (HY000) at line 30: Unknown collation: 'utf8mb4_unicode_520_ci'
$ sed -i 's/utf8mb4_unicode_520_ci/utf8mb4_unicode_ci/g' WMIDB.sql

$ mysql WMDB < WMDB.sql
ERROR 1273 (HY000) at line 17983: Unknown collation: 'utf8mb4_0900_ai_ci'
$ sed -i 's/utf8mb4_0900_ai_ci/utf8mb4_unicode_ci/g' WMIDB.sql

$ mysql WMDB < WMDB.sql
ERROR 1153 (08S01) at line 139970: Got a packet bigger than 'max_allowed_packet' bytes

So also increased max_allowed_packet from 1M to 16M for this session:

$ mysql
$  SELECT @@GLOBAL.max_allowed_packet;
+-----------------------------+
| @@GLOBAL.max_allowed_packet |
+-----------------------------+
|                     1048576 |
+-----------------------------+
1 row in set (0.00 sec)

$ SET GLOBAL max_allowed_packet=16777216;

Everyone could try the website locally with:

# WMI Migration
# TODO: remove
# https://phabricator.wikimedia.org/T276206
# fabula.wikimedia.it
54.38.36.173 www.wikimedia.it

Hey, it's blazing fast now.

In the meanwhile I'm also disabling some unused features for additional hardening and speedup.

For example, these plugins were just disabled because they are not in use. Confirmed by Erica Pedone. Here the list:

• Add-On PayPal Standard di Gravity Forms
• Gravity Forms