Unable Import Database larger than 32mb

Hi guys
Am trying to import a database that is around 100mb and when phpMyAdmin has a 32mb restriction.
I believe I need to you the sql command line since that wont have any size restrictions.
Can anyone help me with this.
Thanks
Dan

 

Make changes in Php.ini file set upload_max_filesize=100M and Post_max_size=100M

 

After that Restart server...

 

you need to use SSH or bigdump to import a big DB like that for best results.

 

Hello ,

You can use the SQL command line to restore the database . Before that edit the my.ini file and set the max_allowed_packet=100M . Also increase the wait_timeout and connect_timeout parameters .

 

Hi,

You need SSH access of your server to make changes in config file of MySQL my.cnf
But if you are on a shared hosting server then you can not modify its my.cnf
Its your server administrator who can get this done for you

 

Or,

You can do one thing, connect your database using tools like MySQL-Front, SQL-Yog etc. and here you can import your backup file even though its large in size

 

the best method is to use an sql splitter and upload the database individualy.
read more source: http://orangecopper.com/blog/how-to-import-large-sql-database-files-using-phpmyadmin

regards
Joshu