Database too large to import via phpMyAdmin?

Database too large to import via PHPMyadmin?
Database Timeout?

WP Provider

Waarom WordPress hosting?

Are you having trouble importing your database? If any of the following match, you can go through the step-by-step plan below from WP Provider.

– Exporting the database went fine but importing shows a timeout.
– The database is too large to import at once in the traditional way.

1. Create a clean database to import your database to.
Remember your database login credentials.

2. Download bigdump from https://www.ozerov.de/bigdump/

  1. Extract the downloaded zip file and then open the file: bigdump.php in notepad/notepad or an editor for code. Do not use Microsoft Office or a similar program because the file will be saved incorrectly.4. Scroll to the database configuration section and enter the information from step 1 here.
				
					// Database configuration

$db_server   = ‘localhost’;

$db_name     = ”;

$db_username = ”;

$db_password = ”;
				
			

Then save the changes.

  1. Using the control panel or FTP, upload the file bigdump.php along with the database you want to import to the “public_html” folder of your WordPress website.

6. As a final step, go to your domain name of your website and access the file. You can do this by going to www.jouwdomeinnaam.nl/bigdump.php you will now see an overview of files. Select your database and click Start Import.

7. If all goes well, your database is now imported.

Do you have questions or would you prefer us to do this for you? Then please contact us.