Importing database error !
Posted by: QMFU (82.114.72.---)
Date: July 05, 2010 02:41AM

When i'm trying to import a database from phpMyAdmin, it's showing me this error:


=====================================================
The connection was reset

The connection to the server was reset while the page was loading.

* The site could be temporarily unavailable or too busy. Try again in a few
moments.

* If you are unable to load any pages, check your computer's network
connection.

* If your computer or network is protected by a firewall or proxy, make sure
that Firefox is permitted to access the Web.
=====================================================

What should i do ??

Thanks in advance !

Options: ReplyQuote
Re: Importing database error !
Posted by: QMFU (82.114.72.---)
Date: July 05, 2010 08:22PM

Any reply here ??

Options: ReplyQuote
Re: Importing database error !
Posted by: yfastud (Moderator)
Date: July 05, 2010 10:09PM

you need to change some settings to make it work

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: ReplyQuote
Re: Importing database error !
Posted by: QMFU (82.114.72.---)
Date: July 06, 2010 11:07PM

Which settings bro ?? Could u help me ??

Options: ReplyQuote
Re: Importing database error !
Posted by: QMFU (82.114.72.---)
Date: July 07, 2010 05:44PM

Any reply here ?? Help please...

Options: ReplyQuote
Re: Importing database error !
Posted by: QMFU (82.114.72.---)
Date: July 08, 2010 06:15PM

bump...

Options: ReplyQuote
Re: Importing database error !
Posted by: toumimi (---.50.80-79.rev.gaoland.net)
Date: July 08, 2010 11:19PM

Hi,
You can add the following configurations in phpmyadmin alias.

It will increase your memory available for it (for big files)

Add it after "Allow from localhost" in wamp/alias/phpmyadmin.conf
  php_admin_value upload_max_filesize 20M
  php_admin_value post_max_size 20M
  php_admin_value max_execution_time 360
  php_admin_value max_input_time 360

Then you need to modify PhpMyAdmin configuration to extends its execution time
$cfg['ExecTimeLimit'] = 0;

Else you can use another solutions, like BigDump or Mysql CLI
mysql -u username -p databasename < mysqlfile.sql

Good luck winking smiley

Florian

WampServer Patch (Screenshots)
Topic EN : www.wampserver.com
Topic FR : www.wampserver.com

Options: ReplyQuote


Sorry, only registered users may post in this forum.