Fatal Error uploading txt file to MySQL

[Rob (SA)]

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]

Re: Fatal Error uploading txt file to MySQL

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)]

Re: Fatal Error uploading txt file to MySQL

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]

Re: Fatal Error uploading txt file to MySQL

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)]

Re: Fatal Error uploading txt file to MySQL

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