restore.pl. doesn't restore all data
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 --------------------------------------------------------------
What should I do next to debug ?
Make sure the DatabaseBackup.sql file contains more than 4 tables Cyr Le 16/10/2013 12:14, Lambrecht, Charles (Charles) a écrit :
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 mailto: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
Yes, that was an excellent suggestion. My 1.5 GB file only has 4 tables... :( Well, it's off to see how to restore via the physical files (luckily, I have them!) Thanks, Charles -------------------------------------------------------------- Charles Lambrecht Computer Operations Manager University of Tennessee College of Veterinary Medicine Email: cgl@utk.edumailto:cgl@utk.edu -------------------------------------------------------------- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Cyrille Bollu Sent: Wednesday, October 16, 2013 6:36 AM To: otrs@otrs.org Subject: Re: [otrs] restore.pl. doesn't restore all data
What should I do next to debug ?
Make sure the DatabaseBackup.sql file contains more than 4 tables Cyr Le 16/10/2013 12:14, Lambrecht, Charles (Charles) a écrit : 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 -------------------------------------------------------------- --------------------------------------------------------------------- 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
From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Lambrecht, Charles (Charles) Sent: Wednesday, October 16, 2013 8:18 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] restore.pl. doesn't restore all data 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!) _____ An unverified back-up process is a potential heart ache. I run through all of my back-ups at least once a year to assure they function as expected.
participants (3)
-
Cyrille Bollu -
Lambrecht, Charles (Charles) -
LQ Marshall