slider

c_parser doesn't write sql file

  1. Backup and Data Recovery for MySQL
  2. c_parser doesn't write sql file
0
0

Hello

I found my table and did every steps on this link (my innodb_file_per_table is ON on the server).

UPDATE: Problem about output to dumps/default solved by changing > to the > sign in bash.

Now when i want to import recovered data to mysql i got some errors like this :

ERROR 1265 (01000): Data truncated for column 'col5' at row 58

Should i alter all of this columns to varchar? How can i handle this ?

UPDATE: this is the first line of dumps/default/users

-- Page id: 25297, Format: COMPACT, Records list: Valid, Expected records: (34 34)
000002B8317A    AE0000010D218A  users   512656  "xxxxx"      "xxxx@gmail.com<80>\0\0\0<80><80>\0\0\0xxxx"       "0e076" -446536138      -31     -71     -429704903      ""      ""      ""      ""      ""      ""      -1335741135     ""      "84c8150470"    ""      NULL    100     "96ra"  "xxx\0\0\0\0^B1371"     "-02-21اÙ<87>Ù<84>"    "Û<8c>ساÙ<86>"        "سÙ<81>Ù<88>تباÙ"   "<84>آزاØ"   "¯Ø±Ù<81>تÙ<87> اÙ<85>"       "تÙ"   "<86>Ù" "<87>اخاÙ<86>Ù<88>ادÙ<87>1717"     "0خراساÙ"  "<86> رضÙ<88>Û<8c>"   "س"    "بزÙ<88>ا"   "ر206تÛ<8c>Ù¾"        "5lgعشÙ<82>Û" "<8c>Ù<85>Û<8c> Ú©Ø´Ù<85>935671365"     "7Ø"    "®Ø±Ø§Ø³Ø§Ù<86>"        ""      ""      ""      -1596411432     920226011       208036161       1936285999      1415932018      -512884736      -9223372036854743040    -2147483648     -9223372036854753322    -373587968      -2147428175     5724118 -373587968      ""      -2147428175     128     87      0       -2147483648     -2147483648     -2147483648     -2147483648     -2147483647     -2147450880     -2147450880     -2147450880     -2147450880     -2147450880     -2147450880     -2147450880     -2147450880     -2147450880     -2147450880     -128    -2139095040     -2139095040     0       0       0       0       0       128     0       0       0       128     0       "\0\0<80><80>\0\0\0<80>\0\0\0"  ""      ""      NULL    0       -128    "\0\0\0^A^A"    0       NULL    1       -127    ""      "d"     "efault.jpg^A<80>\0\0<81>posts0<80>\0\0\0<80>\0\0\0\0\0\0\0\0\0\0\0^B\0\0\0^A\0\0\0\0\0\0\0\0^A<80>\0\0\0<80>\0\0\0<80>\0\0\0\0\0\0\0\0^GÏ<82>^A\0^E\0^K\0\0\0\0^K^B\0\0\0\0\0\0\0\0\0\0\0^U \t#\0\0^Bÿÿ\0\0x^A<9b>\0^GÒ<91>\0\0^B¸1z®\0\0^A\r!<98>www.h"       -277646487      -445749400      0.000000        109     1630615104      1735221609      1814979439      109     0       8388608 -2142420658
    • Guest
    • 1 year ago
    • 1
    No, you shouldn’t modify the schema of the table. Most probably the row 58 is corrupt. Can you add it to the question?
  • mark.aragon
    Actually it was a mistake in create table syntax that i fixed it, now that i’m sure everything is okay error changed to : ERROR 1265 (01000): Data truncated for column ‘col7’ at row 1 I know before dropping table my row 1 was a record including “Admin” but right now the first line of “dumps/default/users” has not any “Admin”. is it important ? also i Added the first line of “dumps/default/users” to the question,
  • You must to post comments
Showing 0 results
Your Answer

Please first to submit.