Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved import database to new host failed
#1
Not Solved
When i try to import my exported databsase to my new host i get on some tables this error ?

I tried export each table but no luck
It crashes on big tables. (postings etc)
How do i import my database without errors  ??

Static analysis:
9035 errors were found during analysis.

  1. Unexpected character. (near "?" at position 211)

  2. Unexpected character. (near "?" at position 401)

  3. Unexpected character. (near "?" at position 624)

  4. Unexpected character. (near "?" at position 828)

  5. Unexpected character. (near "?" at position 1029)

  6. Unexpected character. (near "?" at position 1234)

  7. Unexpected character. (near "?" at position 1451)

  8. Unexpected character. (near "?" at position 1654)

  9. Unexpected character. (near ":" at position 1728)

  10. Unexpected character. (near " " at position 1807)

  11. Unexpected character. (near "?" at position 2460)

  12. Unexpected character. (near "," at position 2632)

  13. Unexpected character. (near "?" at position 2872)

  14. Unexpected character. (near "'" at position 3015)

  15. Unexpected character. (near "'" at position 3016)

  16. Unexpected character. (near "'" at position 3017)

  17. Unexpected character. (near "'" at position 3018)

  18. Unexpected character. (near "'" at position 3019)

  19. Unexpected character. (near "'" at position 3020)

  20. Unexpected character. (near "'" at position 3021)

  21. Unexpected character. (near "'" at position 3022)

  22. Unexpected character. (near "'" at position 3023)

  23. Unexpected character. (near "'" at position 3024)

  24. Unexpected character. (near "'" at position 3025)

  25. Unexpected character. (near "'" at position 3026)

  26. Unexpected character. (near "'" at position 3027)

  27. Unexpected character. (near "'" at position 3028)

  28. Unexpected character. (near "'" at position 3029)

  29. Unexpected character. (near "'" at position 3030)

  30. Unexpected character. (near "'" at position 3031)

  31. Unexpected character. (near "'" at position 3032)

  32. Unexpected character. (near "'" at position 3033)

  33. Unexpected character. (near "'" at position 3034)

  34. Unexpected character. (near "'" at position 3035)

  35. Unexpected character. (near "'" at position 3036)

  36. Unexpected character. (near "'" at position 3037)

  37. Unexpected character. (near "'" at position 3038)

  38. Unexpected character. (near "'" at position 3039)

  39. Unexpected character. (near "'" at position 3040)

  40. Unexpected character. (near "'" at position 3041)

  41. Unexpected character. (near "'" at position 3042)

  42. Unexpected character. (near "'" at position 3043)

  43. Unexpected character. (near "'" at position 3044)

  44. Unexpected character. (near "'" at position 3045)

  45. Unexpected character. (near "'" at position 3046)

  46. Unexpected character. (near "'" at position 3047)

  47. Unexpected character. (near "'" at position 3048)

  48. Unexpected character. (near "'" at position 3049)

  49. Unexpected character. (near "'" at position 3050)

  50. Unexpected character. (near "'" at position 3051)

  51. Unexpected character. (near "'" at position 3052)

  52. Unexpected character. (near "'" at position 3053)

  53. Unexpected character. (near "'" at position 3054)

  54. Unexpected character. (near "'" at position 3055)

  55. Unexpected character. (near "'" at position 3056)

  56. Unexpected character. (near "'" at position 3057)

  57. Unexpected character. (near "'" at position 3058)

  58. Unexpected character. (near "'" at position 3059)

  59. Unexpected character. (near "'" at position 3060)

  60. Unexpected character. (near "'" at position 3061)

  61. Unexpected character. (near "'" at position 3062)

  62. Unexpected character. (near "'" at position 3063)

  63. Unexpected character. (near "'" at position 3064)

  64. Unexpected character. (near "'" at position 3065)

  65. Unexpected character. (near "'" at position 3066)

  66. Unexpected character. (near "'" at position 3067)

  67. Unexpected character. (near "'" at position 3068)

  68. Unexpected character. (near "'" at position 3069)

  69. Unexpected character. (near "'" at position 3070)

  70. Unexpected character. (near "'" at position 3071)

  71. Unexpected character. (near "'" at position 3072)

  72. Unexpected character. (near "'" at position 3073)

  73. Unexpected character. (near "'" at position 3074)

  74. Unexpected character. (near "'" at position 3075)

  75. Unexpected character. (near "'" at position 3076)

  76. Unexpected character. (near "'" at position 3077)

  77. Unexpected character. (near "'" at position 3078)

  78. Unexpected character. (near "'" at position 3079)

  79. Unexpected character. (near "'" at position 3080)

  80. Unexpected character. (near "'" at position 3081)

  81. Unexpected character. (near "'" at position 3082)

  82. Unexpected character. (near "'" at position 3083)

  83. Unexpected character. (near "'" at position 3084)

  84. Unexpected character. (near "'" at position 3085)

  85. Unexpected character. (near "'" at position 3086)

  86. Unexpected character. (near "'" at position 3087)

  87. Unexpected character. (near "'" at position 3088)

  88. Unexpected character. (near "'" at position 3089)

  89. Unexpected character. (near "'" at position 3090)


Reply
#2
Not Solved
What database engine did you use to export and into what database are you importing?
Are you using MySQL, PgSQL, Sqllite, or ???, and what versions?
Reply
#3
Not Solved
OK this is what i find out

it keeps stopping on te same entry

Static analysis:

3 errors were found during analysis.

Unexpected character. (near "'" at position 856)
Ending quote ' was expected. (near "" at position 72059)
17 values were expected, but found 34698. (near "(" at position 881)
SQL query:

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Helaas ben ik ook, na de Genesis update, het XBMC icoon kwijtgeraakt. Ook ik be' at line 1

This is the code
(205,44,185,9,'RE: XBMC Icoon weg',0,108,'Rob',1442948461,'Helaas ben ik ook, na de Genesis update, het XBMC icoon kwijtgeraakt. Ook ik bezit de V1 afstbed.\r\nOok onder de applicaties niet terug te vinden.\r\n\r\nBest wel jammer aangezien ik voor de update totaal geen problemen had.\r\n\r\nIn hoopvolle afwachting;\r\nRob','M¯’¹',0,0,0,0,'',1),(206,44,185,9,'RE: XBMC Icoon weg',0,1,'Forum Support',1442948629,'Ik email u beiden morgen wat informatie hoe dat op te lossen','^Ò\Z]',0,0,0,0,'',1),(207,44,206,9,'RE: XBMC Icoon weg',0,107,'Tess',1442948781,'[quote=\'Forum Support\' pid=\'206\' dateline=\'1442948629\']\r\nIk email u beiden morgen wat informatie hoe dat op te lossen\r\n[/quote]\r\n\r\nDankjewel alvast! Vol verwachting klopt mijn hart :-)','WÓÔ\\',0,0,0,0,'',1),(208,38,148,9,'RE: Genesis streams',0,1,'Forum Support',1442950536,'Daar zijn we nog over aan het nadenken hoe we het gaan aanbieden.','^Ò\Z]',0,0,0,0,'',1),
Reply
#4
Not Solved
I can see a few possible problems. It depends on what the target server is expecting. More recent versions of SQL have stopped using a \ to escape single quotes and instead have made a '' (repeated single quote) mean the same as an escaped single quote (\'). If that's the case, then the empty fields that have '' will look like an escaped single quote, which would screw up the syntax.

You can do one of several things.
a) re-export the data from the source database with different syntax, if you have that option
b) adjust the import settings on the target database to not use doubled single quotes as escaped single quotes
c) do a search and replace on the ''. Maybe you could replace them with NULL?

The other possible problem could be a difference in character-sets. Make sure you're using the correct encoding for importing on the new server.

I'm not as familiar with MySQL as I am with some other database engines, so I can't be really specific. I hope this helps.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)