Versions Compared

Key

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

...

This will split the very large DatabaseBackup.sql into seperate .sql files in the /msr/datafiles directory. The script takes about 3 minutes to complete.


This next bit may not work properly as it may run out of disk space when trying to dump the tables to otrs.sql; in which case you will need to delete the expanded DatabaseBackup.sql file and export the tables manually:

sudo mysqldump-as-root otrs dynamic_field_value ticket ticket_history ticket_state ticket_type > otrs.sql

Now run the script /msr/dataload.sh

...