Title: Data BackUp settings
Last modified: March 8, 2022

---

# Data BackUp settings

 *  Resolved [measy](https://wordpress.org/support/users/measy/)
 * (@measy)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/data-backup-settings/)
 * 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](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/data-backup-settings/#post-15437748)
 * 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](https://wordpress.org/support/users/measy/)
 * (@measy)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/data-backup-settings/#post-15437996)
 * 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](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/data-backup-settings/#post-15442521)
 * 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/](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](https://wordpress.org/support/users/measy/)
 * (@measy)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/data-backup-settings/#post-15442682)
 * 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](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/data-backup-settings/#post-15444550)
 * 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.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * Last activity: [4 years, 3 months ago](https://wordpress.org/support/topic/data-backup-settings/#post-15444550)
 * Status: resolved