Scenario: I have installed a moodle site and have it backed up as per the upgrade installations. I have copied all the site files, I have copied the data directory and have created a backup file using mysqldump as per the instructions.
Now, I want to move that site and build it back up. How do I do that? I have looked at the mysqlimport command but it seems to want to only install data in one table and is giving me an error because I have not renamed the backup file as one of the table names? How do I rebuild the entire database from the backup so I can restart the site somewhere else?
... and ... is this documented somewhere? I know Moodle's site was changed recently to a different server, was there documentation created that we can learn from?
Thanks,