How to transfer archives from one disk to the other
Différence entre versions
imported>Rdal (Created page with "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 di...") |
imported>Admin m (1 révision importée) |
(Aucune différence)
|
Version actuelle datée du 6 mars 2019 à 09:11
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:%";