-
Notifications
You must be signed in to change notification settings - Fork 14
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Impossible to move to the MySQL #172
Comments
WP CLI ( |
Spent hours yesterday trying to convert the db without success. So +1 on this! Here's the debug.log entry after activating duplicator:
|
Thanks for the report! @sejas is looking into a better solution for this. |
Thank you very much! |
@AlkoKod I had a positive experience with the All in One WP Migration plugin for importing and exporting Studio sites. I see you mentioned that it didn't work for you. Could you share more details? |
Hello @wojtekn unfortunatelly, I already deleted the site a start the develop process with other solution. It cost me a lot of time and money (i know, it is beta, it shouldn't be used for agency work lol). So I am not able to tell anymore. |
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
--> 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
The text was updated successfully, but these errors were encountered: