Fatal Error uploading txt file to MySQL

Rob (SA) · #1 08-23-2009, 12:33 PM

Hi Folks,

In trying to upload a txt file and build at able in a database I get the following error.

Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/string_mb.lib.php on line 47

Your inputs here would be appreciated

Karen Mac · #2 08-23-2009, 05:25 PM

Did you first create the database? and then i think it also has to be in excel format or csv format to import the values.

Karen

Rob (SA) · #3 08-23-2009, 05:32 PM

Hi Karin,

Thanks for the reply - most appreciated.

I have managed with George's good help to load the table.

His suggestion is to now load the csv onto the server and get a small script to read the csv file into the mySql table.

I am not sure if you can assist in this regard?

Karen Mac · #4 08-23-2009, 05:35 PM

Yes.. thats a mysql dump and usually included with scripts.. i dont write them just execute them ..lol. .. and hmm.. im trying to think off hand who has them, might try hotscripts.com

I have created tables then imported a csv file formated for those tables directly.. its a little bit of work tho.

Karen

Rob (SA) · #5 08-23-2009, 05:38 PM

Hi Karin,

Thanks for the prompt reply

I will look there - I have also found the SourceForge.net has some good free php info.

Please dont do to much "executing" - lol

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)