WordPress bundle WP Migrate DB – WordPress Migration Made Easy

the WordPress database is Central to any word press website content settings plug-in data theme data and a whole lot more there are several situations when you might need a copy of your database perhaps you wish to copy your website from one WordPress environment to another possibly from local to live or Between Two Hosts or maybe you’re about to install a major WordPress update and you want to ensure you have a local backup of your site’s data in either case exporting the database is a great start one of the most common method is to perform an export from within phpmyadmin or your database manager however in this video will utilize a totally free plugin called WP migrate DB here’s what I know and by the way if you want to skip right to the tutorial click the chapter marker below with the free WP migrate tv plug-in you can find and replace your site URL

open inside serialize data without corrupting that data you can export without ever needing to touch your database or database manager you can pause and cancel migrations you’re able to exclude unnecessary data like spam comments finally you can save migration profiles to speed up future exports and Beyond this it makes the whole process faster and less are prone to get started with navigate to the plug-in section of the WordPress dashboard from which will be exporting refer to this as the source site and click add new then we’ll type migrate DB in the search box now will install and activate the plug-in what’s active will navigate to the wp migrate TV admin page from HeroClix them migrate tab now let’s export the database to do so will click export data

if you intend to import this database into a different site and you know the site URL and root file path of the destination site to site where you’ll be importing the data into those values under replace in the find and replace field area

if you don’t know you can get those details from the destination site by installing an activating the wp migrate tv plug-in on the destination site just as we did on the source side now click the migrate Tab and then click export database copy the fields under the find field and paste them into the replaced field on the store site now scroll to the bottom and click export database if you plan to do this export often feel free to save this profile we won’t be saving in our case and that’s it you know him a complete export of your WordPress site safe as a backup or ready to be imported into your destination site if you would like to see the process for importing as well check out this video above also linked in the description it WP migrate DB Pro plugin makes this process even easier the pro version enables you to push and pull databases between a

select which tables to migrate exclude post types migrate media libraries migrate theme and plug-in files and a whole lot more check out the pro version at delicious frames.com as always if you found this video useful hit that like button describe if you’re not already and we look forward to seeing you in the next one

the theme fucking falls out on allows you to my great seeing some plug-ins when you make regular database to meet at Falls the major benefit of using the sides on versus other methods of transferring files he said it’s a 4 appointment in setting up the development environment

let’s take a look at how it works

with this add-on enabled the wp migrate DB Pro interface not include select the themes and plug-ins when you initiate a push or pull migration

we’ve also included and excluded files textbooks that allows you to use Kik no syntax to find grind control over which files are excluded from transfer

let me show you exactly how you do this out of them to migrate you seen and plugging files between environments

today we’re going to be migrating from a live production site to my local environment hey you can see my life-size plenty of plugins that my local version is missing quite a few and also have some older versions of some plug-ins

malaku sayaka a new pool migration on-site openings be migrated from the large site

now that migration pop-up shows the database and then the plug-in spin migrated and we can see a progress bar for each plug-in been transferred

Van Susteren you can see in the pug in space and now old installed

this whole process should just take a few minutes and you can repeat it needed

the same and plugging falls out on standardized your workflow across different environments was supposed to have SSH access or get deployment enabled quite a few thing in these cases the saddle makes transparency mean plug-in Falls a whole lot easier no need to search for FTP credentials have to install WP migrate TV pro and its atoms and you’re ready to go cuz we not advocating ditching a CPA or I’ll sink if you come through using those tools and said access is available we simply played the semen plucking falls out on provides a convenient way of getting your files to and from your WordPress Heist EP migrate TV pro any way to pull the lights by some media 10 describe the same and plucking phones at the same time

gazelle WP migrate TV pro page to find out more

everybody brought here let’s take a look at running a push migration so I’ve got two tabs open here I’ve got my death site here on the left and so damn depressed it at CIA and then on the right here at staging. Bret T. CX so pretty typical setup you have your Dub Side on all your local machine and then a staging site may be out on a server somewhere and usually staging sites for your clients so that he can take a look at things before putting the site live right so you can see as I switch between these tabs you can see the house numbers different in the comments numbers are different and on the right here you can see that the post different quite a bit so the recent recent posts are different in the comments were different so are we what we want to do is want to push all the changes from Dev up to staging so if we start on our death site and we go to tools migrate to the pro

and we’ll start with a fresh profile

and we slept push now we need a connection info so we’ll switch over to the staging site and what a tools Meyer TV pro and then we go to settings tab

and we find a connection and fell in here so the copy that and paste it in here and you see it when we pasted it just automatically tries to connect this just a little warning here at that SSL has been disabled so it’s we’ve removed we tried to connect over HTTP but didn’t work so it automatically tries already should you pee and it acted fine and but unfortunately we get an error message on here and it says that the license there is no license on staging. Brett has this little convenient like that we can just copy the license key to staging an activated license let’s just do that

and way it went and then we get an error message that says the connection succeeded but the remote site is configure to reject push connections

so if we go over to the staging site will see up here that we don’t have anything checked here so there’s no permissions enabled to allow push so if we check that one we should be able to do to connect now so we can act and away we go

so everything looks fine there we’re going to select just certain table to your I’m going to

do you select all of the search wptl was cuz they’re just way too big and

and I’ll check off a couple of advanced options here and let’s push this database to Stage a

guy looks like we’re finished up now if we take a look at our staging site It’ll ask is to login because we of course we migrated the users table so our session has been invalidated so we just log back in and now let’s go to the dashboard

and we’ll go to the dashboard over here on the death site as well

and let’s see let’s compare them so you can see that the posts are the same pretty much everything’s pretty much identical things over here switching because a certain plug in her neighbors on the website but not on the staging site which is fine