Quick summary

I have tried to dump SQLite to .sql file and then import with Adminer at my host, and it doesn't work. I also tried SQLstudio as it is written in the docs.

I also tried popular migration plugins which doesn't work at all ─ UpDraft Plus, WP Vivid Backup, WP All in one migration, Duplicator.

So I am currently lost, because I can't move the site from localhost to the production.

Steps to reproduce

1. Install Studio, create website
2. Go to wp-content/database
3. run sqlite3 .ht.sqlite .dump > dump.sql
4. upload adminer.php to running host
5. import dump.sql
   --> FAIL

What you expected to happen

The database should be migrated to MySQL host.

What actually happened

It crashed with error. I tried to debug with chatGPT, but It was too much errors.

Impact

All

Available workarounds?

No but the app is still usable

Platform

Windows

Logs or notes

Here are some of the errors:
1.
Chyba v dotazu (1064): Syntax error near 'PRAGMA foreign_keys=OFF' at line 1

CREATE TABLE _mysql_data_types_cache (
table TEXT PRIMARY KEY NOT NULL,
column_or_index TEXT PRIMARY KEY NOT NULL,
mysql_type TEXT NOT NULL
)
Chyba v dotazu (1068): Multiple primary key defined

INSERT INTO wp_posts (ID, post_author, post_date, post_date_gmt, post_content, post_title, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_content_filtered, post_parent, guid, menu_order, post_type, post_mime_type, comment_count) VALUES ('30', '1', '2024-05-21 21:39:20', '2024-05-21 19:39:20', '{
"show_on_front": {
"value": "page",
"type": "option",
"user_id": 1,
"date_modified_gmt": "2024-05-21 19:39:20"
},
"page_on_front": {
"value": "28",
"type": "option",
"user_id": 1,
"date_modified_gmt": "2024-05-21 19:39:20"
}
}', '', '', 'trash', 'closed', 'closed', '', '82761ffc-3f43-4d73-b3c1-841aa22039b5', '', '', '2024-05-21 21:39:20', '2024-05-21 19:39:20', '', '0', 'https://proka.alessykora.cz:8881/?p=30', '0', 'customize_changeset', '', '0')
Chyba v dotazu (1406): Data too long for column 'post_content' at row 1

INSERT INTO wp_actionscheduler_actions (action_id, hook, status, scheduled_date_gmt, scheduled_date_local, priority, args, schedule, group_id, attempts, last_attempt_gmt, last_attempt_local, claim_id, extended_args) VALUES ('115', 'instawp_send_heartbeat', 'complete', '2024-05-27 12:15:19', '2024-05-27 14:15:19', '10', '[]', 'O:32:"ActionScheduler_IntervalSchedule":5:{s:22:"…
Chyba v dotazu (1406): Data too long for column 'schedule' at row 1