Web Hosting Talk







View Full Version : Cannot import 15mb data with phpMyAdmin


tmax100
07-17-2007, 01:24 PM
I need to upload 15mb data.
So far the only thing I know is phpMyAdmin.
I just hit the wall because phpMyAdmin will not handle 15mb data.
I just asked my hosting company if they can increase the allowance.

Anyway... is there any other way for me to upload this data without using phpMyAdmin?.. there must be.

thank you very much.

:) Geeks Helping Geeks :)

WorldCom
07-17-2007, 01:32 PM
Hi tmax,


You may want to do a quick search for Bigdump.
I haven't used in it a while, but I know it handles large upoads for you ;)

marblehost
07-18-2007, 08:35 AM
I think make sure everything is ok(a small database has work)
you just use the ftp to upload the big database to replace the little.
Can it work??!!

juangake
07-18-2007, 09:31 AM
Try through ssh console:

# mysql -p
password: *****

mysql> source /path/to/your/sqldumpfile.sql

That will import massive amount of data... If you made the dump using "extended inserts", it will be faster.

Regards,

Juan

Kareeser
07-19-2007, 09:54 AM
www [dot] phpmyadmin.net/documentation/#faq1_16

For more info and other possible workarounds