SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Oct 2005
    Posts
    47
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Import Error: stops right in the middle of a table

    Hi,

    Newbie here, so please have some patience. I'm working
    with a mysql dbase file which is about 8.4mb in size. Trying
    to import the data, it hangs right in the middle of the
    template table, which contains my CMS page includes. If
    I remove this table completely, the import works perfectly,
    but I'm without my page includes.

    Using phpmyadmin, I ran all of the optimizers and checked
    the table, but every report says that it's okay. Using mysql
    5.0.4, I imported the problem table seperately, which is about
    1.3mb, to see where it hangs, and it hangs or stops import at
    about halfway through, but I really don't know what to look for.

    Here is a link to the problem table, in hopes that someone
    might be able to tell me what the problem may be. It's viewable
    in your browser, or wordpad, and the breaking point seems to be
    right around this location; 'ezportal.list.calendar.footer'. The link
    to the table is
    http://doctoreast.com/wholives/db_de...ble%20only.sql

    Well, please and thanks,
    myst...

  2. #2
    SitePoint Enthusiast
    Join Date
    Oct 2005
    Posts
    47
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hello.
    Update: My hosting admin imported the database for me,
    and is telling me that the error is possibly with phpmyadmin
    not escaping certain characters correctly. He succeeded
    using different tools, and recommends that I use them instead
    of phpmyadmin: http://dev.mysql.com/downloads/gui-tools/5.0.html
    EAst


Bookmarks

Posting Permissions

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