[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.19.1″ custom_margin=”0px||0px||true|false” custom_padding=”0px||0px||true|false” global_colors_info=”{}”][et_pb_row admin_label=”row” _builder_version=”4.19.2″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” width=”100%” custom_margin=”0px|0px|0px|0px|true|false” custom_padding=”0px|0px|0px|0px|true|false” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.19.2″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n
Button\u00a0<\/span>Import data\/Execute script(s)<\/strong>\u00a0<\/span>can be used to execute SQL script files. It allows DCL (grant or revoke access), DDL (e.g. create table, drop table) and DML (select, insert, update, delete) statements, presuming the connected user has the proper privileges (works for remote databases as well).<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.19.2″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n SQL script files may contain multiple SQL statements. There is one important rule:<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.19.2″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.19.2″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n If you receive a message that your SQL file was successfully processed and you are not seeing any results, this is mostly because one or more SQL statements do not end with a ; and a new line.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.19.2″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n If your SQL file is too long, you might not be able to upload it. Instead, you can add your SQL file to a ZIP file and upload the ZIP file.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.19.2″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n You can also bundle multiple SQL files in a ZIP. This can be very useful, for example, if you want to copy tables, projects and\/or publications from your development machine to a production environment. Be aware, that you have no influence on the order in which SQL files are processed. Make sure there are no dependies between SQL file within one ZIP file.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.19.2″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n Be\u00a0<\/span>CAREFUL<\/strong>! Know what you do! Do what you know! If you have never written any SQL before, don’t start experimenting here. If you corrupt a WordPress table, you might need to restore your backup… (Do you have one?\u00a0<\/span>Right now?<\/strong>)<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Button\u00a0Import data\/Execute script(s)\u00a0can be used to execute SQL script files. It allows DCL (grant or revoke access), DDL (e.g. create table, drop table) and DML (select, insert, update, delete) statements, presuming the connected user has the proper privileges (works for remote databases as well).SQL script files may contain multiple SQL statements. There is one important […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"\n Button Import data\/Execute script(s)<\/strong> can be used to execute SQL script files. It allows DCL (grant or revoke access), DDL (e.g. create table, drop table) and DML (select, insert, update, delete) statements, presuming the connected user has the proper priveleges (works for remote databases as well).<\/p>\n\n\n\n SQL script files may contain multiple SQL statements. There is one important rule:<\/p>\n\n\n\n every SQL statement must end with a ; and a new line<\/p>\n\n\n\n If you receive a message that your SQL file was succesfully processed and you are not seeing any results, this is mostly because one or more SQL statements do not end with a ; and a new line.<\/p>\n\n\n\n If your SQL file is too long, you might not be able to upload it. Instead, you can add your SQL file to a ZIP file and upload the ZIP file.<\/p>\n\n\n\n You can also bundle multiple SQL files in a ZIP. This can be very useful, for example, if you want to copy tables, projects and\/or publications from your development machine to a production environment. Be aware, that you have no influence on the order in which SQL files are processed. Make sure there are no dependies between SQL file within one ZIP file.<\/p>\n\n\n\n Be CAREFUL<\/strong>! Know what you do! Do what you know! If you have never written any SQL before, don't start experimenting here. If you corrupt a WordPress table, you might need to restore your backup... (Do you have one? Right now?<\/strong>)<\/p>\n","_et_gb_content_width":"","footnotes":""},"doc_category":[4],"doc_tag":[],"knowledge_base":[],"class_list":["post-75","docs","type-docs","status-publish","hentry","doc_category-data-explorer-manage"],"year_month":"2026-11","word_count":462,"total_views":"167","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"peterschulz.nl@gmail.com","author_nicename":"peterschulz-nlgmail-com","author_url":"https:\/\/wpdataaccess.com\/author\/wpdataaccess_admin\/"},"doc_category_info":[{"term_name":"Data Management","term_url":"https:\/\/docs.legacy.wpdataaccess.com\/docs\/non-knowledgebase\/data-explorer-manage\/"}],"doc_tag_info":[],"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/docs\/75","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/comments?post=75"}],"version-history":[{"count":0,"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/docs\/75\/revisions"}],"wp:attachment":[{"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/media?parent=75"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/doc_category?post=75"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/doc_tag?post=75"},{"taxonomy":"knowledge_base","embeddable":true,"href":"https:\/\/docs.legacy.wpdataaccess.com\/wp-json\/wp\/v2\/knowledge_base?post=75"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Every SQL statement must end with a ; and a new line<\/h4>\n