phpmyadmin problem

nikee posted this at 03:37 — 15th January 2009.

They have: 7 posts

Joined: Jan 2009

hi all

i have 20 mb sql file.

in this file i have all tables and data.

i have exported it with phpmyadmin.

now

when i trying to import it with phpmyadmin

it shows me following error messages

"
You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.
";

where i have do the changes to solve this problem.

any ideas?

thanks in advance

pr0gr4mm3r posted this at 04:14 — 15th January 2009.

Joined: Sep 2006

Your max_upload_size in your php.ini file needs to be adjusted to allow this larger file to be uploaded.

Importing a large database using the command line would be easier:

mysql --host=localhost --user=[user] --pass=[password] < /path/to/sql/file.sql