{"id":4496,"date":"2025-12-08T19:24:40","date_gmt":"2025-12-08T19:24:40","guid":{"rendered":"https:\/\/www.itersdesktop.com\/?p=4496"},"modified":"2025-12-08T19:37:44","modified_gmt":"2025-12-08T19:37:44","slug":"how-to-improve-database-import-with-mysql-and-mariadb","status":"publish","type":"post","link":"https:\/\/www.itersdesktop.com\/fr\/2025\/12\/08\/how-to-improve-database-import-with-mysql-and-mariadb\/","title":{"rendered":"How to improve database import with MySQL and MariaDB"},"content":{"rendered":"In this post, I want to emphasise the approach to speed up importing data to a MySQL or MariaDB database using the exported file. <br \/><br \/>To remind how to export the data from MySQL database, we can use mysqldump. In contrast, using mysql command to import the exported data to the database.<br \/><br \/>","protected":false},"excerpt":{"rendered":"<p>In this post, I want to emphasise the approach to speed up importing data to a MySQL or MariaDB database using the exported file. To remind how to export the&hellip; <\/p>\n","protected":false},"author":2,"featured_media":4502,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[440,603],"tags":[879,880,79],"class_list":["post-4496","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-mysql","tag-import","tag-mariadb","tag-mysql"],"_links":{"self":[{"href":"https:\/\/www.itersdesktop.com\/fr\/wp-json\/wp\/v2\/posts\/4496","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itersdesktop.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itersdesktop.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itersdesktop.com\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itersdesktop.com\/fr\/wp-json\/wp\/v2\/comments?post=4496"}],"version-history":[{"count":5,"href":"https:\/\/www.itersdesktop.com\/fr\/wp-json\/wp\/v2\/posts\/4496\/revisions"}],"predecessor-version":[{"id":4503,"href":"https:\/\/www.itersdesktop.com\/fr\/wp-json\/wp\/v2\/posts\/4496\/revisions\/4503"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itersdesktop.com\/fr\/wp-json\/wp\/v2\/media\/4502"}],"wp:attachment":[{"href":"https:\/\/www.itersdesktop.com\/fr\/wp-json\/wp\/v2\/media?parent=4496"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itersdesktop.com\/fr\/wp-json\/wp\/v2\/categories?post=4496"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itersdesktop.com\/fr\/wp-json\/wp\/v2\/tags?post=4496"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}