mysql recover backup error on data with tinyint(1)

Asked Nov 30 '15 at 08:06

Active Nov 30 '15 at 08:43

Viewed 48 times

I've a mysterious problems and i'm asking you a little help.

When i recover a db from r1soft all the data > 1 contained in a table with tinyint(1) is converted to 1

example:

mytable_user

+----+-------+--------------------+
| ID | data1 | data2 (tintint(1)) |
+----+-------+--------------------+
|  1 |    55 |     4              |
|  1 |    44 |     6              |
+----+-------+--------------------+

When i recover the backup all the values in data2 is recovered with value 1

How this happens??

Thanks

edited Nov 30 '15 at 08:43

deceze

510,633
85
743
889

asked Nov 30 '15 at 08:06

Armauz

How exactly are you "recovering the backup"? – deceze Nov 30 '15 at 08:33
Automatically from the r1soft menu. Thanks – Armauz Nov 30 '15 at 08:41
So basically, this r1soft does something and nobody knows what, and something goes wrong? You may be better off contacting their support, not sure you'll get a lot of help here. – deceze Nov 30 '15 at 08:44
Ok thanks, i was wondering that the problem is tinyint(1) error – Armauz Nov 30 '15 at 08:56

mysql recover backup error on data with tinyint(1)

0 Answers0