Moving Database Objects New Server Host

[redrum.fk]

  OK i have seem to be able to move everything over to the new host but none of my server objects appear on the map, im taking it cause the instance for the objects are different but i do not have any idea how i am going to

be able to change 9k objects instances to the new instance. I know it works cause i changed one of the bases to the new instance and it shows up on the map now , but like i said is there a easy way to change all instances on all objects all at once? Help would be greatly appreciated.

[bFe]

You could try and execute this query using Navicat or some other MySQL tool.

 

UPDATE `Object_DATA` SET Instance=X;

Replace the X with the instance you require.
 

[redrum.fk]

Yes exactly what i needed Ty very much bFe.