Data BackUp settings

  • Resolved measy

    (@measy)


    4 years, 3 months ago

    Hi Peter,
    I need to move WPDA and my CUSTOM_WPDA_DB onto a new WP installation for testing.
    But I’m having problem with Data Export, when defining the required Storage Device for BackUp:

    1 – with Local file system option I get ERROR: Invalid folder, though I tried several folder address syntax: http:// , /myRoot/myFolder,…: what’s the right one? (I granted full access via filezilla to myDestination folder, under WP root directory)

    2 – with DropBox option (I have a valid account), when I Try to “Get DropBox authorization” , after login, I get the following message “This app is unable to link additional users because it has been frozen pending review.”

    Can you please help?
    Thanks,
    Marco

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    4 years, 3 months ago

    Hi Marco,

    I wonder if you neeed the Data Backup tool for this. It might be easier to export your publications and projects on your old server and import them on your new server. WP Data Access will automatically rename your old WordPress database name to your new WordPress database name. Only remote and local databases will not be renamed. So you need to make sure the databases on the new server have the same name they had on your old server. You can export your tables interactively. There is no need to use Data Backup.

    Does this help?
    Peter

    Thread Starter measy

    (@measy)

    4 years, 3 months ago

    Hi Peter,
    thanks a lot for your quick reply.

    Due to my provider settings, both server and databases are different also in names.

    Thus my situation is:
    Server A, WPdb A_1 , myCustomWPDAdb A_2 + WP_filesystem (Linux, mySql Host)
    Server B, Wpdb B_1, myCustomWPDAdb B_2 (mySql host)
    Both databases on Server B were copied from Server A by the Provider.

    I was also asked to update wp-config.php on ServerA, to point to ServerB, and it’s OK.

    BUT, as expected, DataAccess repository is misaligned (still refers to Server A per tables Designer, Projects Templates and Projects).
    —
    I tried to exp/imp as per your suggestion, but got an import error.

    Should I drop tables in Server_B?
    Am i wrong in the procedure at all?
    Clearly my aim is to replicate what I developed on Server A onto Server B with no or minor manual updates.

    Any help more than appreciated,
    Marco.

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    4 years, 3 months ago

    Hi Marco,

    This question has been asked before so I thought it would be a good idea to write a small SQL script to help you (and others) out. You can find the script file here:
    https://wpdataaccess.com/docs/documentation/data-explorer/transfer-to-other-wordpress-database/

    See section: Manually updating database names

    Can you please try if this works for you?

    Thanks,
    Peter

    Thread Starter measy

    (@measy)

    4 years, 3 months ago

    Hi Peter,
    IT WORKED!!!

    I just had to change prefixes on table names (I have ml_wpda instead of wp_wpda, maybe due to the installation of WP itself).

    I’m really grateful and admired by your dedication to your WPDA community.
    Grazie 1000!

    Cheers,
    Marco
    —

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    4 years, 3 months ago

    Great! 😊

    Thank you for letting me know,
    Peter

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Data BackUp settings’ is closed to new replies.