Migration of mydbr from one host to other

(2 posts) (2 voices)

Tags:

  1. adiquity, Member

    Hi

    We are trying to migrate Mydbr from one DB host to other . But facing some issue .

    Steps we took :

    1. Took the dump of mydbr database and dumped it into new host

    2. Gave all grants

    3. Changed the host ip in conf file

    It gets connected to new host no issues with installation .

    We can find our reports there as well , but no report code .

    The description and name of report is there but the report code / stored procs are not there itself .

    Where are the stored procs stored ?

    Thanks
    Adiquity

  2. myDBR Team, Key Master

    Assuming that you are using MySQL, when you make the dump of myDBR database, make sure you specify that the routines will be included in the database dump (see --routines paramerer for mysqldump).

    --
    myDBR Team


Reply

You must log in to post.