zohab Posted May 26, 2008 Share Posted May 26, 2008 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 zohaib. Quote Link to comment https://forums.phpfreaks.com/topic/107276-phpmyadmin-related-problem/ Share on other sites More sharing options...
mushroom Posted May 26, 2008 Share Posted May 26, 2008 Unless you have root access to the server you will have to break the file into several smaller files. Quote Link to comment https://forums.phpfreaks.com/topic/107276-phpmyadmin-related-problem/#findComment-550282 Share on other sites More sharing options...
zohab Posted May 27, 2008 Author Share Posted May 27, 2008 i have full access to server can u tell me which setting i have to change/modify i which file i have to do the changes Quote Link to comment https://forums.phpfreaks.com/topic/107276-phpmyadmin-related-problem/#findComment-550576 Share on other sites More sharing options...
mushroom Posted May 27, 2008 Share Posted May 27, 2008 i have full access to server can u tell me which setting i have to change/modify i which file i have to do the changes if you can find "php.ini" ;;;;;;;;;;;;;;;;;;; ; Resource Limits ; ;;;;;;;;;;;;;;;;;;; max_execution_time = 60 ; Maximum execution time of each script, in seconds max_input_time = 60 ; Maximum amount of time each script may spend parsing request data memory_limit = 32M ; Maximum amount of memory a script may consume (16MB) That is from my test server, the "memory_limit" is what you need to increase. Quote Link to comment https://forums.phpfreaks.com/topic/107276-phpmyadmin-related-problem/#findComment-550753 Share on other sites More sharing options...
zohab Posted May 28, 2008 Author Share Posted May 28, 2008 hi i have change following settings max_execution_time = 100 ; Maximum execution time of each script, in seconds max_input_time = 100 ; Maximum amount of time each script may spend parsing request data memory_limit = 100M ; Maximum amount of memory a script may consume (16MB) still when i am uploading big file around 20-30mb it is giving following error message "You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.' Quote Link to comment https://forums.phpfreaks.com/topic/107276-phpmyadmin-related-problem/#findComment-551447 Share on other sites More sharing options...
mushroom Posted May 28, 2008 Share Posted May 28, 2008 Did you restart apache? The php.ini file is only read when apache starts. I do not use phpmyadmin for very large db's, I prefer to use the command line utilities in mysql "mysql" and "mysqldump". Some the stuff I work with runs into gigs. Quote Link to comment https://forums.phpfreaks.com/topic/107276-phpmyadmin-related-problem/#findComment-551680 Share on other sites More sharing options...
zohab Posted May 29, 2008 Author Share Posted May 29, 2008 yes i have restarted apache. still i am getting same error message. "You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit." can u tell me how to import 20-50 mb file in mysql DB with "mysqldump" one example Quote Link to comment https://forums.phpfreaks.com/topic/107276-phpmyadmin-related-problem/#findComment-552360 Share on other sites More sharing options...
mushroom Posted May 29, 2008 Share Posted May 29, 2008 "mysqldump" is for making an sql mysql -u user_name -p password -h host_name_or_address data_base_name < /complete_path_and_name_file if you transfer the file to the server mysql -u user_name -p password data_base_name < /complete_path_and_name_file Quote Link to comment https://forums.phpfreaks.com/topic/107276-phpmyadmin-related-problem/#findComment-552479 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.