How to transfer archives from one disk to the other

This article relates to MapOut / MapWeb 5.2 and higher when used in conjunction with a MySQL database.

Follow these steps to transfer your MapOut archival records from one disk to the other e.g. if you are changing servers. As a requirement, you will need to have the same structure on both disks. For example, if the archives were in C:\mapout\archives\, you will now transfer them to D:\mapout\archives\ (where C: is the source disk and D: the new disk).

Run the following commands:

UPDATE accessvolume SET NomVolume = REPLACE(NomVolume, "C:", "D:") WHERE NomVolume like "C:%";

UPDATE criteres SET Volume = REPLACE(Volume, "C:", "D:") WHERE volume like "C:%";

UPDATE groupcritere SET Volume = REPLACE(Volume, "C:", "D:") WHERE Volume like "C:%";

UPDATE spools SET Volume = REPLACE(Volume, "C:", "D:") WHERE Volume like "C:%";

UPDATE usercritere SET Volume = REPLACE(Volume, "C:", "D:") WHERE Volume like "C:%";

UPDATE volumes SET Volume = REPLACE(Volume, "C:", "D:") WHERE Volume like "C:%";