Are you trying to clone your live wordpress site to localhost (local computer)? For the very first time when you clone your site manually you will face some issues. Usually you will end up in a situation where you cannot import your database (SQL file). Due to the file upload limit you cannot import large database files and if you do so then you will see an error message like this.

Here is a simple solution to import large database files from phpMyAdmin.

Note: This is a solution for WAMP server.

The default file import size in phpMyAdmin is 2mb (2,048KiB). Let us assume that your database file size is 4mb. You can simply compress the file (zip) and import it which will hugely reduce the size of your original database file. But what if your database file size is huge as 300mb, 400mb, 500mb like that. All you have to do is increase the file import size limit.

How to increase file import size in phpMyAdmin (WAMP server)

Step 1: Go to the folder destination where you have installed WAMP. (Usually it is C:\)

Step 2: Now locate and open php.ini files from both these locations. (C:\wamp\bin\apache\Apache2.4.4\bin and C:\wamp\bin\php\php5.4.16)

Step 3: Now in both the documents press CTRL+F and find out the following settings.

post_max_size

upload_max_filesize

memory_limit

For example you will see upload_max_filesize = 2m where m is MB. Change 2m to 500m or more as you like.

Free SEO Tools

About Us

Hi, Welcome to blogtimenow.com, a blog and a community based website that mainly focuses on providing quality articles and inspirational stuff constantly to users which is founded on July 2013 by Sureyea. This weblog is dedicated for designers, developers, bloggers, internet marketers, web and computer enthusiasts.