MySQL: Fatal error: Maximum execution time of 300 seconds exceeded in

#1 Hallo,

ich möchte ein sehr grossen MySQL Dump mit PHPMYADMIN in meine MySQL Datenbank importieren und bekomme immer folgenden Error:

Zitat

Fatal error: Maximum execution time of 300 seconds exceeded in C:\Programme\xampp\phpMyAdmin\libraries\import\sql.php on line 60

was muss ich wo ändern um dieses Timeout zu verhindern?

vielen Dank
Felicee

#2 Hallo,

stelle in Deiner php.ini mal an folgenden Werten speziell "max_execution_time" herum bzw. erhöhe die Werte!

Zitat

max_execution_time = 60000 ; Maximum execution time of each script, in seconds
max_input_time = 60000 ; Maximum amount of time each script may spend parsing request data
memory_limit = 1600M ; Maximum amount of memory a script may consume (1600MB)

ansonsten importiere ich Datenbanken meistens per SSH:

Zitat

These are the steps :
1. FTP the .sql file to your account, write down the path where you uploaded it.

2. Find a SSH client, like PuTTY

3. Install the SSH client, and then run it

4. Enter in your server details (like your server's name)

5. Login with the username/password that's provided to you by your host

6. Type:
mysql -u yourmysqlusername -p mysqldatabasename < /path/to/your/file.sql
replace yourmysqlusername with the username for MySQL
replace mysqldatabasename with the actual name of the database you want to populate with the sql file
replace /path/to/your/file.sql with the location that you wrote down in step 1.

If you can't follow those steps, hire someone to do it.

oder probiere mal: http://www.ozerov.de/bigdump.php

Greetz Lp