Jump to content
Sign in to follow this  
roberto_one

Baza danych problem

Recommended Posts

Witam

 

Chcę reaktywować starego bloga tyle, że mam mały problem bo kopia bazy danych(tego bloga z 2014r) jest kopią bazę danych + wszystkie ustawienia serwera MySQL wraz z konfiguracją systemową i dlatego nie mogę jej importować na nowy serwer bo wywala błąd:

Zapytanie SQL: CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

MySQL zwrócił komunikat: #1044 - Access denied for user 'adminXXXX'@'%' to databas 'information_schema'"

bok serwera powiedział mi abym sobie wyłuskał sobie z tego zrzutu kopię bazy związanej z samym blogiem. Dobrze jest mówić ale inaczej jest kiedy ktoś nie ma pojęcia o bazach danych. Przepatrzyłem sobie tą bazę w KED ale nie mam pojęcia co z niej usunąć aby pozostały tylko wpisy, komentarze i kategorie(czyli te podstawowe dane na blogu)

 

Pomoże ktoś?

Share this post


Link to post
Share on other sites

Zrobiłem tak jak w poradniku tylko że nic mi nie zaimportowała tylko wysypały się takie błędy:

 

Static analysis:

224 błędów zostało znalezionych podczas analizy.

  1. Unexpected character. (near "" at position 1)
  2. Unexpected character. (near "" at position 3)
  3. Unexpected character. (near "" at position 5)
  4. Unexpected character. (near "" at position 7)
  5. Unexpected character. (near "" at position 9)
  6. Unexpected character. (near "" at position 11)
  7. Unexpected character. (near "" at position 13)
  8. Unexpected character. (near "" at position 15)
  9. Unexpected character. (near "" at position 17)
  10. Unexpected character. (near "" at position 19)
  11. Unexpected character. (near "" at position 21)
  12. Unexpected character. (near "" at position 23)
  13. Unexpected character. (near "" at position 25)
  14. Unexpected character. (near "" at position 27)
  15. Unexpected character. (near "" at position 29)
  16. Unexpected character. (near "" at position 31)
  17. Unexpected character. (near "" at position 33)
  18. Unexpected character. (near "" at position 35)
  19. Unexpected character. (near "" at position 37)
  20. Unexpected character. (near "" at position 39)
  21. Unexpected character. (near "" at position 41)
  22. Unexpected character. (near "" at position 43)
  23. Unexpected character. (near "" at position 45)
  24. Unexpected character. (near "" at position 47)
  25. Unexpected character. (near "" at position 49)
  26. Unexpected character. (near "" at position 51)
  27. Unexpected character. (near "" at position 53)
  28. Unexpected character. (near "" at position 55)
  29. Unexpected character. (near "" at position 57)
  30. Unexpected character. (near "" at position 59)
  31. Unexpected character. (near "" at position 61)
  32. Unexpected character. (near "" at position 63)
  33. Unexpected character. (near "" at position 65)
  34. Unexpected character. (near "" at position 67)
  35. Unexpected character. (near "" at position 69)
  36. Unexpected character. (near "" at position 71)
  37. Unexpected character. (near "" at position 73)
  38. Unexpected character. (near "" at position 75)
  39. Unexpected character. (near "" at position 77)
  40. Unexpected character. (near "" at position 79)
  41. Unexpected character. (near "" at position 81)
  42. Unexpected character. (near "" at position 83)
  43. Unexpected character. (near "" at position 85)
  44. Unexpected character. (near "" at position 87)
  45. Unexpected character. (near "" at position 89)
  46. Unexpected character. (near "" at position 91)
  47. Unexpected character. (near "" at position 93)
  48. Unexpected character. (near "" at position 95)
  49. Unexpected character. (near "" at position 97)
  50. Unexpected character. (near "" at position 99)
  51. Unexpected character. (near "" at position 101)
  52. Unexpected character. (near ":" at position 102)
  53. Unexpected character. (near "" at position 103)
  54. Unexpected character. (near "" at position 105)
  55. Unexpected character. (near "" at position 107)
  56. Unexpected character. (near "" at position 109)
  57. Unexpected character. (near "" at position 111)
  58. Unexpected character. (near "" at position 113)
  59. Unexpected character. (near "" at position 115)
  60. Unexpected character. (near "" at position 117)
  61. Unexpected character. (near "" at position 119)
  62. Unexpected character. (near "" at position 121)
  63. Unexpected character. (near "" at position 123)
  64. Unexpected character. (near "" at position 125)
  65. Unexpected character. (near "" at position 127)
  66. Unexpected character. (near "" at position 129)
  67. Unexpected character. (near "" at position 131)
  68. Unexpected character. (near "" at position 133)
  69. Unexpected character. (near "" at position 135)
  70. Unexpected character. (near "" at position 137)
  71. Unexpected character. (near "" at position 139)
  72. Unexpected character. (near "" at position 141)
  73. Unexpected character. (near "" at position 143)
  74. Unexpected character. (near "" at position 145)
  75. Unexpected character. (near "" at position 147)
  76. Unexpected character. (near "" at position 149)
  77. Unexpected character. (near "" at position 151)
  78. Unexpected character. (near "" at position 153)
  79. Unexpected character. (near "" at position 155)
  80. Unexpected character. (near "" at position 157)
  81. Unexpected character. (near "" at position 159)
  82. Unexpected character. (near "" at position 161)
  83. Unexpected character. (near "" at position 163)
  84. Unexpected character. (near "" at position 165)
  85. Unexpected character. (near "" at position 167)
  86. Unexpected character. (near "" at position 169)
  87. Unexpected character. (near ":" at position 170)
  88. Unexpected character. (near "" at position 171)
  89. Unexpected character. (near "" at position 173)
  90. Unexpected character. (near "" at position 175)
  91. Unexpected character. (near "" at position 177)
  92. Unexpected character. (near "" at position 179)
  93. Unexpected character. (near "" at position 181)
  94. Unexpected character. (near "" at position 183)
  95. Unexpected character. (near "" at position 185)
  96. Unexpected character. (near "" at position 187)
  97. Unexpected character. (near "" at position 189)
  98. Unexpected character. (near "" at position 191)
  99. Unexpected character. (near "" at position 193)
  100. Unexpected character. (near "" at position 195)
  101. Unexpected character. (near "" at position 197)
  102. Unexpected character. (near "" at position 199)
  103. Unexpected character. (near "" at position 201)
  104. Unexpected character. (near "" at position 203)
  105. Unexpected character. (near "" at position 205)
  106. Unexpected character. (near "" at position 207)
  107. Unexpected character. (near "" at position 209)
  108. Unexpected character. (near "" at position 211)
  109. Unexpected character. (near "" at position 213)
  110. Unexpected character. (near "" at position 215)
  111. Unexpected character. (near "" at position 217)
  112. Unexpected character. (near "" at position 219)
  113. Unexpected character. (near "" at position 221)
  114. Unexpected character. (near "" at position 223)
  115. Unexpected character. (near "" at position 225)
  116. Unexpected character. (near "" at position 227)
  117. Unexpected character. (near "" at position 229)
  118. Unexpected character. (near "" at position 231)
  119. Unexpected character. (near "" at position 233)
  120. Unexpected character. (near "" at position 235)
  121. Unexpected character. (near "" at position 237)
  122. Unexpected character. (near ":" at position 238)
  123. Unexpected character. (near "" at position 239)
  124. Unexpected character. (near "" at position 241)
  125. Unexpected character. (near "" at position 243)
  126. Unexpected character. (near "" at position 245)
  127. Unexpected character. (near "" at position 247)
  128. Unexpected character. (near "" at position 249)
  129. Unexpected character. (near "" at position 251)
  130. Unexpected character. (near "" at position 253)
  131. Unexpected character. (near "" at position 255)
  132. Unexpected character. (near "" at position 257)
  133. Unexpected character. (near "" at position 259)
  134. Unexpected character. (near "" at position 261)
  135. Unexpected character. (near "" at position 263)
  136. Unexpected character. (near "" at position 265)
  137. Unexpected character. (near "" at position 267)
  138. Unexpected character. (near "" at position 269)
  139. Unexpected character. (near "" at position 271)
  140. Unexpected character. (near ":" at position 272)
  141. Unexpected character. (near "" at position 273)
  142. Unexpected character. (near "" at position 275)
  143. Unexpected character. (near "" at position 277)
  144. Unexpected character. (near "" at position 279)
  145. Unexpected character. (near "" at position 281)
  146. Unexpected character. (near "" at position 283)
  147. Unexpected character. (near "" at position 285)
  148. Unexpected character. (near "" at position 287)
  149. Unexpected character. (near "" at position 289)
  150. Unexpected character. (near "" at position 291)
  151. Unexpected character. (near "" at position 293)
  152. Unexpected character. (near "" at position 295)
  153. Unexpected character. (near "" at position 297)
  154. Unexpected character. (near "" at position 299)
  155. Unexpected character. (near "" at position 301)
  156. Unexpected character. (near "" at position 303)
  157. Unexpected character. (near "" at position 305)
  158. Unexpected character. (near "" at position 307)
  159. Unexpected character. (near "" at position 309)
  160. Unexpected character. (near "" at position 311)
  161. Unexpected character. (near "" at position 313)
  162. Unexpected character. (near "" at position 315)
  163. Unexpected character. (near ":" at position 316)
  164. Unexpected character. (near "" at position 317)
  165. Unexpected character. (near "" at position 319)
  166. Unexpected character. (near "" at position 321)
  167. Unexpected character. (near "" at position 323)
  168. Unexpected character. (near "" at position 325)
  169. Unexpected character. (near "" at position 327)
  170. Unexpected character. (near "" at position 329)
  171. Unexpected character. (near "" at position 331)
  172. Unexpected character. (near "" at position 333)
  173. Unexpected character. (near "" at position 335)
  174. Unexpected character. (near "" at position 337)
  175. Unexpected character. (near "" at position 339)
  176. Unexpected character. (near "" at position 341)
  177. Unexpected character. (near "" at position 343)
  178. Unexpected character. (near "" at position 345)
  179. Unexpected character. (near "" at position 347)
  180. Unexpected character. (near "" at position 349)
  181. Unexpected character. (near "" at position 351)
  182. Unexpected character. (near "" at position 353)
  183. Unexpected character. (near "" at position 355)
  184. Unexpected character. (near "" at position 357)
  185. Unexpected character. (near "" at position 359)
  186. Unexpected character. (near "" at position 361)
  187. Unexpected character. (near ":" at position 362)
  188. Unexpected character. (near "" at position 363)
  189. Unexpected character. (near "" at position 365)
  190. Unexpected character. (near "" at position 367)
  191. Unexpected character. (near "" at position 369)
  192. Unexpected character. (near "" at position 371)
  193. Unexpected character. (near "" at position 373)
  194. Unexpected character. (near "" at position 375)
  195. Unexpected character. (near "" at position 377)
  196. Unexpected character. (near "" at position 379)
  197. Unexpected character. (near "" at position 381)
  198. Unexpected character. (near "" at position 383)
  199. Unexpected character. (near "" at position 385)
  200. Unexpected character. (near "" at position 387)
  201. Unexpected character. (near "" at position 389)
  202. Unexpected character. (near "" at position 391)
  203. Unexpected character. (near "" at position 393)
  204. Unexpected character. (near "" at position 395)
  205. Unexpected character. (near "" at position 397)
  206. Unexpected character. (near "" at position 399)
  207. Unexpected character. (near "" at position 401)
  208. Unexpected character. (near "" at position 403)
  209. Unexpected character. (near "" at position 405)
  210. Unexpected character. (near "" at position 407)
  211. Unexpected character. (near "" at position 409)
  212. Unexpected character. (near "" at position 411)
  213. Unexpected beginning of statement. (near "" at position 1)
  214. Unexpected beginning of statement. (near "" at position 3)
  215. Unexpected beginning of statement. (near "" at position 5)
  216. Unexpected beginning of statement. (near "p" at position 6)
  217. Unexpected beginning of statement. (near "" at position 7)
  218. Unexpected beginning of statement. (near "h" at position 8)
  219. Unexpected beginning of statement. (near "" at position 9)
  220. Unexpected beginning of statement. (near "p" at position 10)
  221. Unexpected beginning of statement. (near "" at position 11)
  222. Unexpected beginning of statement. (near "M" at position 12)
  223. Unexpected beginning of statement. (near "" at position 13)
  224. Unrecognized statement type. (near "y" at position 14)

Zapytanie SQL:

-- phpMyAdmin SQL Dump -- version 3.5.8.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Czas wygenerowania: 02 Sty 2014, 20:47 -- Wersja serwera: 5.5.30 -- Wersja PHP: 5.3.27 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"

MySQL zwrócił komunikat: dot.gif

#1064 - Something is wrong in your syntax obok '-' w linii 1

Share this post


Link to post
Share on other sites

Information_schema to tabela, która przechowuje informacje nt. wszystkich baz danych i użytkowników na utrzymywanym serwerze MySQL. Nie potrzebujesz tego importować. Usuń tabele information_schema z zrzutu bazy danych i zaimportuj. Ewentualnie użyj -force jeżeli masz uprawnienia: http://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html#option_mysql_force (wypluje błędy, ale Twoje dane zostaną zaimportowane).

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×