+ Reply to Thread
Results 1 to 5 of 5

Thread: Fatal Error uploading txt file to MySQL
      
   

  1. #1
    Rob (SA)'s Avatar
    Rob (SA) is offline Lieutenant Colonel
    Join Date
    Nov 2006
    Location
    Centurion, South Africa
    Posts
    580

    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
    Karen Mac's Avatar
    Karen Mac is offline General
    Join Date
    Apr 2006
    Location
    X marks the spot
    Posts
    8,354

    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
    07031847328 / United Kingdom

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

    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
    Rob (SA)'s Avatar
    Rob (SA) is offline Lieutenant Colonel
    Join Date
    Nov 2006
    Location
    Centurion, South Africa
    Posts
    580

    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
    Karen Mac's Avatar
    Karen Mac is offline General
    Join Date
    Apr 2006
    Location
    X marks the spot
    Posts
    8,354

    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
    07031847328 / United Kingdom

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

    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
    Rob (SA)'s Avatar
    Rob (SA) is offline Lieutenant Colonel
    Join Date
    Nov 2006
    Location
    Centurion, South Africa
    Posts
    580

    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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49