Hey, Olly Connelly here and only at guvnr.com if you want to drop me an email. Today I’m going to show your how to use PHP my admin to back up a database or import a database if you have managed to cook up a database there is something you need to bring in. I know backup, I’ll show you how to that. How do I export and how do import. So first of all well let's have a look at over what were playing with, I’m going to be using Word press database for this example with this I already rather appalling blog that I couple together just for example such as this. But this refer to any database that is mysql database. So you go to this thing PHP MyAdmin and you got you various databases over here and then the one I’m going to be hitting on with today is word press.
So what your going do is if you want to backup this database app. Is to export it and say just click on that and automatically all of your tables are chosen for you and you can if you want just chose which ever you like. Just select the lot or whatever I’m going to save that as a file and go. And you do you want to save it as Word press.sql, save file and if you if you down just complete and that it.
Now the prove that, that works I’m going to do something little bit radical and I'm going to go back to my database and I'm going to drop all of my tables on this beautiful blog. And so when go to here, if will refresh the page we have got anything we got nothing. Okay, so we want to re import our backup cause you find some kind of fatal error, fatal program. So back to PHPMyAdmin and you want to go import and then you want to browse to that file and let's called wordpress.sql here we go. Open that and just go. And as simple as that. And if you go back, well we can have a look at it, look at the database you see a tables of back. If we go back to the sites itself and refresh, we have got this red full blog backed up and running.
Now there's another thing that you can do, this is more specific for a word press people but that will not applied up to now to any kind of MySql database backing it up be it from your server, be it with your ISP or locally or if your using Xamp. But now just for a word press people something you old say you can use rather than going to here and you got an extra login and all that sort of thing.
You can actually do all this from your dash board. If your going to the old Admin function as you seen in my plug ins department I got a sum total of one plug in here the moment activated and that is code wpphpmyadmin now you can find that plug ihn on this web site here. Word press don’t design practice.apphpmyadmin in that address and there is other company notes will add the guvnr.com to a company.
This video if you guys are checking this out from you tube and you can download this plug in here so the difference with this plug in well there is no difference except that you put one left. One left login and one left window I want to tab have had bother about because you once you’ve activated this plug in, if your looking at tools section down here there it is. Just click on PhpMyAdmin and you do all the same staff here, you could import, you can export exactly as I did using the PhpMyAdmin free standing client as opposed to the word press plug in so there you go.
Hope that is been useful, you should have learned how to back up rather you database and indeed if you have some sort of fatal database program. How to get it back, thanks a lot. You can come to guvnr.com for source of videos, tips, tutorials and staff about surfing making the experience better here at guvnr.com and hope that’s been useful.
Transcription by:
Scribe4you Transcription Services