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?
Thanks,
Charles
Restore.pl won't recreate all tables - stumped
Moderator: crythias
-
- Znuny newbie
- Posts: 10
- Joined: 15 Oct 2013, 23:37
- Znuny Version: 4.0.23
- Real Name: Charles Lambrecht
- Company: University of Tennessee College of Vet Med
Restore.pl won't recreate all tables - stumped
----------
Charles Lambrecht
IT Manager
UT CVM
OTRS 3.2.17
Perl 5.10
MySQL 5.1.73
Charles Lambrecht
IT Manager
UT CVM
OTRS 3.2.17
Perl 5.10
MySQL 5.1.73
-
- Znuny newbie
- Posts: 10
- Joined: 15 Oct 2013, 23:37
- Znuny Version: 4.0.23
- Real Name: Charles Lambrecht
- Company: University of Tennessee College of Vet Med
Re: Restore.pl won't recreate all tables - stumped
Hello,
I've solved the problem. My backup file only had those four tables in it. I don't why the backup failed. Perhaps a percursor to the hard drive problem?
However, I managed to get the mysql files for the otrs database and have restored all my data using those files - so a happy ending...
I've solved the problem. My backup file only had those four tables in it. I don't why the backup failed. Perhaps a percursor to the hard drive problem?
However, I managed to get the mysql files for the otrs database and have restored all my data using those files - so a happy ending...
----------
Charles Lambrecht
IT Manager
UT CVM
OTRS 3.2.17
Perl 5.10
MySQL 5.1.73
Charles Lambrecht
IT Manager
UT CVM
OTRS 3.2.17
Perl 5.10
MySQL 5.1.73