How to restore rt4.sessions table

RT Users
1

I used following command to create database backup:

MySQL
( mysqldump rt4 --tables sessions --no-data --single-transaction;
mysqldump rt4 --ignore-table rt4.sessions --single-transaction )
| gzip > rt-date +%Y%m%d.sql.gz

Today, my database got crashed and I reinstalled mysql. I restored to previous backup file. Now the problem is, RT creating issue without rt4.sessions table. How can I fix this.

Thanks,
Ravi

2

Have a look at
rt/schema.mysql at stable · bestpractical/rt · GitHub and
recreate the table.

Regards,

Joop

3

Thanks Joop, It worked.