Import and Phpmyadmin

Data

[malcolmcroucher]

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]

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

[FourDegreez]

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]

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]

Welcome to WebmasterWorld Kumera,

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