{"id":21904,"date":"2024-01-05T09:24:48","date_gmt":"2024-01-05T07:24:48","guid":{"rendered":"https:\/\/wpbeveiligen.nl\/?p=21904"},"modified":"2023-07-27T09:25:56","modified_gmt":"2023-07-27T07:25:56","slug":"zo-kun-je-een-hele-grote-mysql-database-importeren-2","status":"publish","type":"post","link":"https:\/\/wpbeveiligen.nl\/en\/zo-kun-je-een-hele-grote-mysql-database-importeren-2\/","title":{"rendered":"Zo kun je een hele grote MySql database importeren"},"content":{"rendered":"

Dealing with a large database, such as a WordPress website with hundreds of products or pages, can result in a database size of 10-50 up to even 600 MB.<\/p>\n

Sometimes, you may need to restore your database backup<\/a> or import it after switching hosting providers.<\/p>\n

A database larger than 100 MB cannot be imported using PhpMyAdmin since it can only import files up to 9 MB through the browser.<\/p>\n

\"wordpress<\/p>\n

Step 1 – Download BIGdump<\/h2>\n

Bigdump is a script that you can download here<\/a><\/span>.
\n(Or here<\/a> if their site is not working)<\/p>\n

Step 2 – Connect BIGdump to your database<\/h2>\n

You have just used the link to download the file, and you have extracted it to get a php file.<\/em><\/p>\n

Open the file bigdump.php<\/strong> with your favorite editor (even Notepad on Windows will do) and enter the database information<\/strong> where the data needs to go.<\/p>\n

\"database<\/p>\n

Save the file<\/strong> and place the bigdump.php file on the server of the website<\/em> where you want to import the database.<\/p>\n

Step 3 – Upload the large database to the server<\/h2>\n

Place the database, the SQL file, in the same folder as the BIGdump.php file. (You can use an FTP program like FileZilla)<\/p>\n

Step 4 – Use the file<\/h2>\n

Next, go to the following URL in your browser:
\nwww.yourwebsite.com\/bigdump.php<\/p>\n

IF you have entered the database information correctly, you will see this:
\n\"database<\/p>\n

And if you have done Step 3 correctly, you will also see this:\"Voorbeeld\"<\/p>\n

This means that it has found a file that you can import!<\/strong><\/p>\n

Click on ‘Start import’ to import your large database!<\/p>\n

If you encounter any errors on your screen, check the FAQ<\/a> from the developer of BIGdump.<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

Dealing with a large database, such as a WordPress website with hundreds of products or pages, can result in a database size of 10-50 up to even 600 MB. Sometimes, you may need to restore your database backup or import it after switching hosting providers. A database larger than 100 MB cannot be imported using […]<\/p>\n","protected":false},"author":4,"featured_media":1198,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[198],"tags":[],"_links":{"self":[{"href":"https:\/\/wpbeveiligen.nl\/wp-json\/wp\/v2\/posts\/21904"}],"collection":[{"href":"https:\/\/wpbeveiligen.nl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wpbeveiligen.nl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wpbeveiligen.nl\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/wpbeveiligen.nl\/wp-json\/wp\/v2\/comments?post=21904"}],"version-history":[{"count":1,"href":"https:\/\/wpbeveiligen.nl\/wp-json\/wp\/v2\/posts\/21904\/revisions"}],"predecessor-version":[{"id":22948,"href":"https:\/\/wpbeveiligen.nl\/wp-json\/wp\/v2\/posts\/21904\/revisions\/22948"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wpbeveiligen.nl\/wp-json\/wp\/v2\/media\/1198"}],"wp:attachment":[{"href":"https:\/\/wpbeveiligen.nl\/wp-json\/wp\/v2\/media?parent=21904"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wpbeveiligen.nl\/wp-json\/wp\/v2\/categories?post=21904"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wpbeveiligen.nl\/wp-json\/wp\/v2\/tags?post=21904"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}