Categories

Myphpadmin-import-max limit 51200KB. What to do, if it exceeds?

Aug

12

2010

The max allowable size of importing file in Myphpadmin is 51200KB only. If it is more than that, how can we import that sql file?

In: Tech Support Asked By: [417 Blue Star Level]
Answer #1


You should use http://www.ozerov.de/bigdump.php

1. Enter database/login info into BigDump PHP script
2. Upload script file and MySQL datafile to writable, web-accessible directory on your website.
3. Run the script by navigating to your website URL containing the BigDump script.

Result: Script loads data by breaking the large file into smaller chunks and loading each chunk separately into the database. Very smooth.

GD Star Rating
loading...
Answers Answered By: Amit Bhawani [ Grey Star Level]

Answer this Question

You must be Logged In to post an Answer.

Not a member yet? Sign Up Now »

Star Points Scale

Earn points for Asking and Answering Questions!

Grey Sta Levelr [1 - 25 Grey Star Level]
Green Star Level [26 - 50 Green Star Level]
Blue Star Level [51 - 500 Blue Star Level]
Orange Star Level [501 - 5000 Orange Star Level]
Red Star Level [5001 - 25000 Red Star Level]
Black Star Level [25001+ Black Star Level]