I am considering buying BackupBuddy for migrations. My main concern is a requirement that users are not migrated from our test environment to our production environment. If we "Exclude" the user tables during a migration, will the users of the production site persist or will the user table be lost?
0
Persisting Excluded Tables During Migration
Started by
Guest_Harley_*
, Feb 05 2013 12:28 PM
migration exclude tables
2 replies to this topic
#2
Dustin Akers
-
- Moderators
- Others: All Plugins, All Themes
-
- 9,572 posts
Moderator
Posted 06 February 2013 - 10:09 AM
Hi Harley,
That description should work fine. Excluding any table(s) from being backed up will not modify the production (source) site in any way. It will exclude that entire table and its contents so it will not end up in the database dump file that stores the backed up contents.
You will have to recreate the users table on the destination site somehow/make a new one for WordPress to work though. I'm not sure if WordPress will attempt to auto-generate one if it's missing. BackupBuddy will not fill in missing data that is required but was excluded.
During ImportBuddy, it might get mad about the lack of a users table. I don't think it interrupts the process but I know it at least displays error messages/warnings.
Thanks,
-Akers
That description should work fine. Excluding any table(s) from being backed up will not modify the production (source) site in any way. It will exclude that entire table and its contents so it will not end up in the database dump file that stores the backed up contents.
You will have to recreate the users table on the destination site somehow/make a new one for WordPress to work though. I'm not sure if WordPress will attempt to auto-generate one if it's missing. BackupBuddy will not fill in missing data that is required but was excluded.
During ImportBuddy, it might get mad about the lack of a users table. I don't think it interrupts the process but I know it at least displays error messages/warnings.
Thanks,
-Akers
Welcome to the forums. Be sure to post your questions in the correct forum and don't forget about the new and improved search function located in the top right of the forum pages. The gear/wheel symbol next to the search box will give you more options for advanced searching. Thank you and have a nice day.
#3 Guest_Guest_*
Guest_Guest_*
-
- Guests
Posted 06 February 2013 - 12:53 PM
Thank you for your response Akers. It sounds like during ImportBuddy, all the tables from the DB are dropped then recreated from the backup. If that is the case, it might be easier in my situation to do this manually.
Thanks again!
Harley
Thanks again!
Harley
Reply to this Topic
ATTENTION
If this topic is marked RESOLVED or INFORMATION, or if you are NOT experiencing EXACTLY the same issue, please start a new topic to provide the details of your problem. If the solution provided doesn't work for you, you should start a new topic. If you feel this thread contains relevant information, you may include a link to it in your new topic. To ensure that we can process your support request efficiently, ALWAYS include a link to your site, and/or the page your request is related to. When posting your question or request on the forum, please be as concise and specific as possible. The shorter and more to the point you can make your request, the better.
For BackupBuddy related issues, be sure to include the status log from your most recent backup.
CLICK HERE to start a new topic in the Pre-sales and other inquiries forum.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
