phpmyadmin import sql problem - large file size |
| |
|
|
|
New Poster Posts: 11 Topics: 8
|
|
|
November 12, 2009, 04:54:16 AM
|
|
hello everyone
I have exported 20 mb sql file with phpmyadmin and when i trying to import that file with phpmyadmin it shows me this error
You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.
any one can please give me suggestion how can i solve this error?
thanks in advance
« Last Edit: December 15, 2011, 05:54:09 AM by Admin »
|
|
| |
|
Computer Head in 'da House! Activity
|
|
Regular Coder Posts: 85 Topics: 9
|
|
|
January 07, 2010, 09:26:14 PM
|
|
With something of that size, you usually have to only download a few tables at a time and then import each file one at a time, observing any upload size limit. Hopefully you can still export the data. Don't know what else you can do about that.
|
|
| |
|
|
|
New Poster Posts: 2 Topics: 0
|
|
|
June 27, 2010, 10:51:24 AM
|
|
Goto PHP. INI file and edite these values
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)
« Last Edit: December 15, 2011, 05:53:32 AM by Admin »
|
|
| |
|
|
|
|
Regular Coder Posts: 50 Topics: 19
|
|
|
August 16, 2010, 09:11:28 PM
|
|
Virgil Green wrote:
> Since the instance of phpMyAdmin will only run on the one server, what
> difference to you expect to see when accessing it from intranet versus
> internet? The path in question is the path that the server on which
> phpMyAdmin is running must use to access the database. Little to do with who
> happens to be accessing phpMyAdmin or how.
Not in this case, PmaAbsoluteUri is the base of the phpMyadmin
installation while the parameter in $cfg['Servers'][$i]['host'] is the
host of the MySql Server
« Last Edit: March 17, 2011, 10:24:03 PM by Admin »
|
|
| |
|
|
|
|
Skilled Coder Posts: 149 Topics: 0
|
|
|
July 13, 2011, 05:29:19 AM
|
|
i am using Windows XP SP2.
When I am executing xampp_start.exe file,it gives the following exact message:
Diese Eingabeforderung nicht waehrend des Runnings beenden ...
Zum stoppen bitte die xampp_stop benutzen!
Please do not close this window while running ...
Use the xampp_stop for shutdown!
Please wait [Bitte warten] (OS 10048)Only one usage of each socket address (prot
ocol/network address/port) is normally permitted. : make_sock: could not bind
to address 0.0.0.0:80
no listening sockets available, shutting down
Unable to open logs
.
Though it is clear that its port conflict problem,but how to solve it.
|
|
| |
