Results 1 to 5 of 5

Thread: Fatal Error uploading txt file to MySQL
      
   

  1. #1
    Join Date
    Nov 2006
    Location
    Centurion, South Africa
    Posts
    586

    Question Fatal Error uploading txt file to MySQL

    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

  2. #2
    Join Date
    Apr 2006
    Location
    X marks the spot
    Posts
    8,332

    Default 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

    VodaHost

    Your Website People!
    1-302-283-3777 North America / International
    02036089024 / United Kingdom
    291916438 / Australia

    ------------------------

    Top 3 Best Sellers

    Web Hosting - Unlimited disk space & bandwidth.

    Reseller Hosting - Start your own web hosting business.

    Search Engine & Directory Submission - 300 directories + (Google,Yahoo,Bing)



  3. #3
    Join Date
    Nov 2006
    Location
    Centurion, South Africa
    Posts
    586

    Question 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?

  4. #4
    Join Date
    Apr 2006
    Location
    X marks the spot
    Posts
    8,332

    Default 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

    VodaHost

    Your Website People!
    1-302-283-3777 North America / International
    02036089024 / United Kingdom
    291916438 / Australia

    ------------------------

    Top 3 Best Sellers

    Web Hosting - Unlimited disk space & bandwidth.

    Reseller Hosting - Start your own web hosting business.

    Search Engine & Directory Submission - 300 directories + (Google,Yahoo,Bing)



  5. #5
    Join Date
    Nov 2006
    Location
    Centurion, South Africa
    Posts
    586

    Thumbs up 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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •