Menu

combining two mysql databases as 1

RFP
2025-08-30
2025-08-30
  • RFP

    RFP - 2025-08-30

    Hello all,

    we have 2 seeddms databases in our human resource department, database 1 contains the rank and file and database 2 contains the middle and senior management.

    the direction of IT is to combined the 2 database into just 1 seeddms database and frontend.

    is it possible to dump database 2 into database 1 as both have exact identical tables and fields? will this mess up the indexing of database 1 if database 2 is dump into it ?

    Any thoughts how to go about this task? Suggestions are welcome.

    Tks,

    RJN

     
  • Uwe Steinmann

    Uwe Steinmann - 2025-08-30

    This will not work, because the internal id for each record will conflict. Did you use workflows or custom attributes? If not, you could try to just copy the content of one seeddms installation into the other one by webdav. You will loose some meta data, but maybe that's not a problem in your case.
    The other way would be to use the utilities xmldump and xmlimport in the utils directory.

     

Log in to post a comment.