slider

Cparser Don't write sql file

  1. Backup and Data Recovery for MySQL
  2. Cparser Don'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 ):

recover-after-drop-table-innodb_file_per_table-is-on/

UPDATE : Problem about output to dumps/default solved by changing > to > 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\0\0\0\0\0\0xxxx" "0e076" -446536138 -31 -71 -429704903 "" "" "" "" "" "" -1335741135 "" "84c8150470" "" NULL 100 "96ra" "xxx\0\0\0\0^B1371" "-02-21اÙÙ" "ÛساÙ" "سÙÙتباÙ" "آزاØ" "¯Ø±Ùت٠اÙ" "تÙ" "Ù" "اخاÙÙادÙ1717" "0خراساÙ" " رضÙÛ" "س" "بزÙا" "ر206تÛÙ¾" "5lgعشÙÛ" "ÙÛ Ú©Ø´Ù935671365" "7Ø" "®Ø±Ø§Ø³Ø§Ù" "" "" "" -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\0\0\0\0\0\0" "" "" NULL 0 -128 "\0\0\0^A^A" 0 NULL 1 -127 "" "d" "efault.jpg^A\0\0posts0\0\0\0\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\0\0\0\0\0\0\0\0\0\0\0\0\0\0^GÏ^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\0^GÒ\0\0^B¸1z®\0\0^A\r!www.h" -277646487 -445749400 0.000000 109 1630615104 1735221609 1814979439 109 0 8388608 -2142420658

    • Guest
    • 3 months 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?
    • Guest
    • 3 months ago
    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.