SitePoint Sponsor |
|
User Tag List
Results 1 to 2 of 2
-
Feb 18, 2007, 02:54 #1
- 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...
-
Feb 18, 2007, 12:03 #2
- 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