Forum Moderators: coopster

Message Too Old, No Replies

Import and Phpmyadmin

Data

         

malcolmcroucher

3:00 pm on Apr 30, 2008 (gmt 0)

10+ Year Member



I am trying to import data to a new database in mysql.

This is the error i am getting :

Fatal error: Maximum execution time of 300 seconds exceeded in C:\xamp\xampp\phpMyAdmin\libraries\string_mb.lib.php on line 47

The data is in text format .

like the following :

x
x
x
x
x
x

does anyone have any solutions ?

Regards.

RonPK

3:13 pm on Apr 30, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Perhaps temporarily remove any indexes on the table(s)? If the index is rebuilt after every insert, things may indeed take a while...

FourDegreez

3:00 am on May 1, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



If you have access to the command line on the server, you can use the mysql command to import the data. However I think it may need to be in SQL INSERT format, not CSV or whatever.

From the command line, importing data is insanely fast.

Kumera

2:01 am on May 7, 2008 (gmt 0)

10+ Year Member



I have the same problem with the 300 second timeout in phpmyadmin. If I use the command line instead, the one million records all show up, but are unreadable. The utf-8 encoding gets scrambled, despite the database being specified as using UTF-8, and having "collate utf8_unicode_ci" on all relevant fields. Phpmyadmin, on the other hand, is able to load the records in in readable (unscrambled) form, but will get only about a third of them before timing out.

jatar_k

2:20 am on May 7, 2008 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



Welcome to WebmasterWorld Kumera,

try chopping the file into seperate pieces so it doesn't time out