How can I increase the Import Maximum Size for MySql

[Retheesh]

I have a requirement for importing a sql file in my local databse.I
have exported the file from the client database.That file is more than
50mb.I want to import this sql file into my local database.My Maximum
import file size showin as 8mb.I tried to change by editing the ini
file.But still it showing the same.I am using phpMyAdmin.Plea se tell me
the procedure to change the Maximum File Size for Importing sql file.

[Jerry Stuckle]

Retheesh wrote:

I have a requirement for importing a sql file in my local databse.I
have exported the file from the client database.That file is more than
50mb.I want to import this sql file into my local database.My Maximum
import file size showin as 8mb.I tried to change by editing the ini
file.But still it showing the same.I am using phpMyAdmin.Plea se tell me
the procedure to change the Maximum File Size for Importing sql file.

You'll probably have to do it from the command line instead of through
phpMyAdmin. See the MySQL doc for more info.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

[Armando Padilla]

Retheesh wrote:

I have a requirement for importing a sql file in my local databse.I
have exported the file from the client database.That file is more than
50mb.I want to import this sql file into my local database.My Maximum
import file size showin as 8mb.I tried to change by editing the ini
file.But still it showing the same.I am using phpMyAdmin.Plea se tell me
the procedure to change the Maximum File Size for Importing sql file.

Hey there Retheesh,

Actually youll have to tweek the php.ini file :-) since phpMyAdmin
(great mysql tool) uses php to do its processing you have to open up the
php.ini file it uses and change out the

upload_max_file size from 2MB to something much higher. I tend to change
it out ot 100MB :-)

Hope that helps.

Armando Padilla