Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

** Richard to distribute SQLGenerator code to team.

...