Akshay Hartalkar

    Akshay Hartalkar

    1 month ago
    Hi, i have 2 aws instances running questDB using the questDB marketplace AMI i want to move/copy one table from instance A and add to existing DB in instance B. can i use questDB Backup functionality here? if so please let me know how, also any suggestions are welcome to migrate this table.
    j

    javier ramirez

    1 month ago
    Is it a very large table?
    Akshay Hartalkar

    Akshay Hartalkar

    1 month ago
    about 70M rows
    j

    javier ramirez

    1 month ago
    since 70M rows seems still manageable, a possible solution would be exporting your data via the exp API endpoint, then moving the data to the other instance and importing using COPY. We just released version 6.5 which makes copy more efficient https://questdb.io/docs/guides/importing-data