25454

Fatal Error while trying to export a result of a query in mysql

Question:

I execute this query :

SELECT `COD_AG`, `NUM_CONJ`, `SIT_CONJ`, `PRF_CONJ`, `NAT_CONJ`, `NOM_PR_CONJ`, `DOTI_CONJ`, `CIN_A_CONJ`, `CIN_N_CONJ`, `DAT_SIT_CONJ` FROM `gipeord_conjoint`, `gestion_delegation`.`dataidentifpersonnel` WHERE `gipeord_conjoint`.`COD_AG`=`gestion_delegation`.`dataidentifpersonnel`.`PPR`

and then I have 2363 results and i select all records then click on export button to get the results in a sql file but i get this error :

<blockquote>

<b>Fatal error</b>: Maximum execution time of 300 seconds exceeded in <b>C:\wamp\apps\phpmyadmin3.2.0.1\libraries\sqlparser.lib.php</b> on line <b>271</b><br />

</blockquote>

I changed parameters in the file php.ini but no change. What's the wrong here?

I applied that in phpmyadmin. (mysql)

Answer1:

Apart from changing the max_execution time in php.ini, you also need to change it in PHPMyAdmin's configs.

Locate C:\wamp\apps\phpmyadmin3.2.0.1\libraries\config.default.phpand change $cfg['ExecTimeLimit'] as needed.

Make sure you restart Apache.

Recommend

  • rewrite ElementTree code in lxml
  • Deploying pre-encrypted configuration files to a production environment
  • Instanciate service on startup in Angular2
  • get passwords from chrome
  • SQL: Getting the physical size of a subset of a table
  • How do I remove all but some records based on a threshold?
  • How do I get the list of bad records that didn't load in Bigquery?
  • Bash if statement with multiple conditions
  • How to remove a SwiftyJSON element?
  • Create Instant using a negative year
  • Sequential (transactional) API calls in angular 4 with state management
  • Does it make sense to call System.gc() and Thread.sleep() when working on Bitmaps?
  • onBackPressed() not being executed
  • Is there a way to do normal logging with EureakLog?
  • Swift: Switch statement fallthrough behavior
  • Alert pop up with LWUIT
  • Android fill_parent issue
  • Get one-time binding to work for ng-if
  • PHPUnit_Framework_TestCase class is not available. Fix… - Makegood , Eclipse
  • Insert into database using onclick function
  • Why ng-show works with ng-repeat but ng-if doesn't? [duplicate]
  • PHP - How to update data to MySQL when click a radio button
  • Fetching methods from BroadcastReceiver to update UI
  • Counter field in MS Access, how to generate?
  • How to recover from a Spring Social ExpiredAuthorizationException
  • Does CUDA 5 support STL or THRUST inside the device code?
  • Knitr HTML Loop - Some HTML output, some R output
  • Can a Chrome extension content script make an jQuery AJAX request for an html file that is itself a
  • ORA-29908: missing primary invocation for ancillary operator
  • jquery mobile loadPage not working
  • How to get next/previous record number?
  • Properly structure and highlight a GtkPopoverMenu using PyGObject
  • Data Validation Drop Down Box Arrow Disappearing
  • How can I get HTML syntax highlighting in my editor for CakePHP?
  • How do you join a server to an Active Directory (domain)?
  • Can Visual Studio XAML designer handle font family names with spaces as a resource?
  • How does Linux kernel interrupt the application?
  • How can I remove ASP.NET Designer.cs files?
  • Are Kotlin's Float, Int etc optimised to built-in types in the JVM? [duplicate]
  • Observable and ngFor in Angular 2