Yes, that was an excellent suggestion.  My 1.5 GB file only has 4 tables…  L

 

Well, it’s off to see how to restore via the physical files (luckily, I have them!)

 

Thanks,
Charles

 

 

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.edu

--------------------------------------------------------------

---------------------------------------------------------------------

OTRS mailing list: otrs - Webpage: http://otrs.org/

Archive: http://lists.otrs.org/pipermail/otrs

To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs