[susapra]

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
_____________________________
Hotels in Barcelona iced tea

[healdem]

out of curiosity waht did the documentation suggest?
I don't know if thats a PHPMyAdmin issue or a MySQL issue.. I'd guess its a PHPMyAdmin, and I'd guess it may be to do with the limit your PHP environment in the config file

when I've hit these sort of issues before I've broken the file into several sections and uploaded those. whether that will work in PHPMyAdmin I don't know.. I tend to use MySQL Query browser, or upload using a PHP script

[maGGot_H]

I believe one of the solutions of the problem - if i understand the situation right - is to make an inquiry to your hosting provider. They will insert the necessary data into the db locally.

[renan.cuoghi]

you can try copy the sql script and paste in sql commands of the phpmyadmin and execute.