Why am I not getting all my data and how car I restore my 24. DB into a 3.0 system? Is there any DBUpgrade log file? I think I probably lost my complete DB during the upgrade.
New system 3.0
Old system 2.4mysql> select * from users;
+----+----------------+------------------------------------+-------+------------+-------------+----------+---------------------+-----------+---------------------+-----------+
| id | login | pw | title | first_name | last_name | valid_id | create_time | create_by | change_time | change_by |
+----+----------------+------------------------------------+-------+------------+-------------+----------+---------------------+-----------+---------------------+-----------+
| 1 | root@localhost | $1$root@loc$vlRo2lnu2XO/R1.Pkv. | | Admin | OTRS | 1 | 2010-07-15 14:13:51 | 1 | 2010-07-15 19:29:51 | 2 |
| 2 | patoil | $1$patoil$FRz3Abxgr91OSQ6cjZRe | | Patricio | xx | 1 | 2010-07-15 16:10:26 | 1 | 2010-07-15 16:10:26 | 1 |
| 3 | andreal | $1$andreal$aZCk.LVtXstoYo5DNaa. | | Andrea | xx | 1 | 2010-07-15 19:03:39 | 2 | 2010-07-15 19:03:39 | 2 |
| 4 | oscard | $1$oscard$SfTsyKZvmgV1Uorj/HW0 | | Oscar | De xx | 1 | 2010-07-15 19:06:20 | 2 | 2010-07-15 19:06:20 | 2 |
| 5 | rubent | $1$rubent$wMtvis4tVGPZrCFGb3y9 | | Ruben | xx | 1 | 2010-07-15 19:07:22 | 2 | 2010-07-15 19:07:22 | 2 |
| 6 | fabiani | $1$fabiani$KsJUEeHyU4N5xQ5zXJJL | | Fabian | xx | 1 | 2010-07-15 19:07:57 | 2 | 2010-07-15 19:07:57 | 2 |
| 7 | mariop | $1$mariop$0CLDtG7nIi3ngWYydNL/ | | Mario | xx | 1 | 2010-07-22 10:44:31 | 4 | 2010-07-22 10:44:31 | 4 |
+----+----------------+------------------------------------+-------+------------+-------------+----------+---------------------+-----------+---------------------+-----------+
7 rows in set (0.00 sec)
mysql> select * from users;
+----+------------------+------------------------------------+------------+------------+-------------+----------+---------------------+-----------+---------------------+-----------+
| id | login | pw | salutation | first_name | last_name | valid_id | create_time | create_by | change_time | change_by |
+----+------------------+------------------------------------+------------+------------+-------------+----------+---------------------+-----------+---------------------+-----------+
| 1 | root@localhost | $1$root@loc$vlRo2lnu2XO/R1.Pkv.M | | Admin | OTRS | 1 | 2010-07-15 14:13:51 | 1 | 2010-07-15 19:29:51 | 2 |
| 2 | patoil | $1$patoil$FRz3Abxgr91OSQ6cjZRe | | Patricio | xx | 1 | 2010-07-15 16:10:26 | 1 | 2010-07-15 16:10:26 | 1 |
| 3 | andreal | $1$andreal$aZCk.LVtXstoYo5DNaaI | | Andrea | xx | 1 | 2010-07-15 19:03:39 | 2 | 2010-07-15 19:03:39 | 2 |
| 4 | oscard | $1$oscard$SfTsyKZvmgV1Uorj/HW0 | | Oscar | De xx | 1 | 2010-07-15 19:06:20 | 2 | 2010-07-15 19:06:20 | 2 |
| 5 | rubent | $1$rubent$wMtvis4tVGPZrCFGb3y9 | | Ruben | xx | 1 | 2010-07-15 19:07:22 | 2 | 2010-07-15 19:07:22 | 2 |
| 6 | fabiani | $1$fabiani$KsJUEeHyU4N5xQ5zXJJL | | Fabian | xx | 1 | 2010-07-15 19:07:57 | 2 | 2010-07-15 19:07:57 | 2 |
| 7 | mariop | $1$mariop$0CLDtG7nIi3ngWYydNLW | | Mario | xx | 1 | 2010-07-22 10:44:31 | 4 | 2010-07-22 10:44:31 | 4 |
| 8 | bruno.caldarella | $1$bruno.ca$RlkliwQo37/FYreUx4p9 | | Bruno | xx | 2 | 2010-10-12 07:15:13 | 2 | 2010-10-12 07:15:45 | 2 |
| 9 | eduardoa | $1$eanzello$uubrYu0DLL3nk7DOfiCH | Sr | Eduardo | xx | 1 | 2010-10-12 07:28:00 | 7 | 2010-10-20 08:53:09 | 7 |
| 10 | pablor | $1$pablor$Ll/buQpy8Im75CBMV3Ht | | Pablo | xx | 1 | 2010-10-14 05:02:53 | 2 | 2010-10-14 05:02:53 | 2 |
| 11 | cesark | $1$cesark$gNKtbdtaiCqVpxho9uF1 | | Cesar | xx | 1 | 2010-10-20 02:21:21 | 10 | 2010-10-20 02:21:21 | 10 |
| 12 | joseg | $1$joseg$YLR5EbAUNY0j4pKTQhdu | | Jose Luis | xx | 1 | 2010-10-28 15:04:03 | 10 | 2010-10-28 15:04:03 | 10 |
| 13 | facundoc | $1$facundoc$2NwBY8njISi59hvj6n6r | | Facundo | xx | 1 | 2010-10-28 15:04:45 | 10 | 2010-10-28 15:04:45 | 10 |
| 14 | marcosf | $1$marcosf$y.XmajMTnOYiIkvvSg6l | | Marcos | xx | 1 | 2010-10-28 15:39:49 | 10 | 2010-10-28 15:39:49 | 10 |
| 15 | pablok | $1$pablok$OyxBe5eL.icv/Yc0eMUW | | Pablo | xx | 1 | 2010-11-11 03:48:47 | 10 | 2010-11-11 03:48:47 | 10 |
+----+------------------+------------------------------------+------------+------------+-------------+----------+---------------------+-----------+---------------------+-----------+
15 rows in set (0.00 sec)