Wed Jul 15 14:02:47 UTC 2026
=== fix: drop tables one at a time, then import the SQL file from inside the container ===
---
=== first copy SQL to mariadb container (already done) ===
-rw-r--r-- 1 root root 15134199 Jul 15 02:46 /tmp/oscar-real.sql
---
=== drop all wpjo_ tables (one at a time) ===
139 /tmp/_drops.sql
first 5 drops:
CONCAT('DROP TABLE IF EXISTS `', table_name, '`;')
DROP TABLE IF EXISTS `wpjo_tutor_quiz_attempt_answers`;
DROP TABLE IF EXISTS `wpjo_edd_customer_addresses`;
DROP TABLE IF EXISTS `wpjo_edd_customermeta`;
DROP TABLE IF EXISTS `wpjo_nx_posts`;
---
=== execute drops ===
DROP TABLE IF EXISTS `wpjo_tutor_quiz_attempt_answers`
--------------

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONCAT('DROP TABLE IF EXISTS `', table_name, '`;')
DROP TABLE IF EXISTS `wpjo...' at line 1
---
=== verify tables are gone ===
COUNT(*)
150
---
=== now import the SQL file from inside the container ===