UPDATE ......From Tuesday 8 April 2025 we have changed the way that Single Sign-on works on this wiki. Please see here for more information:
Update
...
Run the Java Batch Program called SQLGenerator. This will take the very large .sql file and split it up into it's separate table files and store them in the c:\otrs\database\datafiles directory.
An For an alternative way of extracting the relevant tables is to use the following command swapping in the table names needed:sed -n -e '/CREATE TABLE.*`mytable`/,/CREATE TABLE/p' source_file > mytable.dumpsee https://stackoverflow.com/questions/1013852/can-i-restore-a-single-table-from-a-full-mysql-mysqldump-file
** Richard to distribute SQLGenerator code to team.
...