Zo kun je een hele grote MySql database importeren

Zo kun je een hele grote MySql database importeren
datum-geschreven 5 Jan 2024

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 PhpMyAdmin since it can only import files up to 9 MB through the browser.

wordpress database import

Step 1 – Download BIGdump

Bigdump is a script that you can download here.
(Or here if their site is not working)

Step 2 – Connect BIGdump to your database

You have just used the link to download the file, and you have extracted it to get a php file.

Open the file bigdump.php with your favorite editor (even Notepad on Windows will do) and enter the database information where the data needs to go.

database gegevens

Save the file and place the bigdump.php file on the server of the website where you want to import the database.

Step 3 – Upload the large database to the server

Place the database, the SQL file, in the same folder as the BIGdump.php file. (You can use an FTP program like FileZilla)

Step 4 – Use the file

Next, go to the following URL in your browser:

IF you have entered the database information correctly, you will see this:
database importeren

And if you have done Step 3 correctly, you will also see this:Voorbeeld

This means that it has found a file that you can import!

Click on ‘Start import’ to import your large database!

If you encounter any errors on your screen, check the FAQ from the developer of BIGdump.

De meeste artikelen worden geschreven door Mathieu Scholtes, de eigenaar van WPBeveiligen. Op de hoogte blijven van het laatste WordPress nieuws? WordPress tips? WordPress aanbiedingen?
Connect dan op Linked-in!

Heb je een vraag? Tip of gedachte? Deel die!

Breng me op de hoogte
0 Reacties
Inline Feedbacks
Bekijk alle reacties