Hello, Last Friday, I took an OTRS backup throgh backup.pl. Over the weekend, the sys drive on the ticket server died. It was decided to move OTRS to a new server and not fix the current one. I installed OTRS 2.4.7 on a Red Hat 5 server and got everything working - all the way through running installer.pl and could log in via root@localhost. Now, (I drop otrs database and create otrs database first) I run restore.pl and can get through the entire restore process without errors. However, only the first four tables are present: mysql> show tables; +--------------------+ | Tables_in_otrs | +--------------------+ | article | | article_attachment | | article_flag | | article_plain | +--------------------+ 4 rows in set (0.03 sec) I have combed the mysql settings with the data drive on the old server and can't find any difference. I know these tables were a character set of latin1 so here are the settings before I do the restore: mysql> show variables like "character_set_database"; +------------------------+--------+ | Variable_name | Value | +------------------------+--------+ | character_set_database | latin1 | +------------------------+--------+ 1 row in set (0.00 sec) mysql> show variables like "collation_database"; +--------------------+-------------------+ | Variable_name | Value | +--------------------+-------------------+ | collation_database | latin1_swedish_ci | +--------------------+-------------------+ 1 row in set (0.00 sec) I've extractd the sql file and done [root@ 2013-10-11_15-46]# mysql -u otrs -p otrs < DatabaseBackup.sql It completed without any errors, but only the first four tables are present. What should I do next to debug ? Thanks, Charles -------------------------------------------------------------- Charles Lambrecht Computer Operations Manager University of Tennessee College of Veterinary Medicine Email: cgl@utk.edumailto:cgl@utk.edu --------------------------------------------------------------