Jump to content

phpmyadmin related problem


zohab

Recommended Posts

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.

 

 

 

 

 

 

Link to comment
Share on other sites

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.

 

 

Link to comment
Share on other sites

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.'

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

"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

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.