How to backup MySQL database using PHPMyAdmin

[SilkWebConsulting]

Great video, thanks for the help.

[phototristan]

@SilkWebConsulting Yep, you're welcome. 

[xBIOHZRDx]

Love it, thanks... and @IDrinkBatUrine is a dumb ass hah!

[maxxsinner]

Thanks for this. Walk in the park to do much needed backups

[webduncetv]

Thanks. It was a big help. :-)

[Sergii852]

Wow. I can say just these words. I use dbForge Studio for MySQL and it also looks good but we need more references like this to understand how does it work.

If you can to review MySQL back up in dbForge Studio it will be good. Thanks.

[Riflemanm16a2]

Wow, who knew it's that easy? I took a rather rigorous database course this past semester and we never went over this.

[danplat13]

thanks alot man. this truly helped

[socialpuzzle]

WOW actually this is very professional and GREAT INFO and very simple. Thanks for sharing Tristan! GREAT JOB!

Jeff

[RoastCat]

nice one, thanks. Saved me having to phone someone and ask.

[tomtmj]

Thanks.

[ETUDEinC]

"The official way to pronounce “MySQL” is “My Ess Que Ell” (not “my sequel”)

[maxxas2000]

Thanks m8 nice tutorials.

[RevRJBrink]

Thank you so much for the help!

[IDrinkBatUrine]

Dear God, stop talking and just spit out the information. Why on Earth does everyone get so self-absorbed recording one of these videos that they pause excessively and drone on for unnecessary amounts of time. Just describe to us how to back up the MySQL database. Good God.

[phototristan]

@IDrinkBatUrine Good job, very entertaining LMAO.

[timbaker491]

@IDrinkBatUrine For someones who's user name is ' I drink Bat Urine' bit strong I think - yeah wasn't to the point but one of the best tutorials out there

[tienefuego]

@IDrinkBatUrine Just do as I did. Fast forward to the important bits.

Thanks for a great video. Much appreciated.

[MCOEWR]

Thanks... This will work with Vbuletin Right?

[phototristan]

@MCOEWR I'm not sure actually.

[88whitetiger]

thank goodness for keeping this video online. I got a WordPress version 2.6.5 blog due for an upgrade and this video helped me getting step 1 done. Thanks.

[CarnivoreConfidence]

thanks Tristan

that was useful

[AWentertainments]

Thanx for you for best Teaching

[judyinspokane]

Thank you so much for this video. Very nice of you to share!

[davorfasaic]

just watched it, done those exports before, but needed to refresh my memory Thanks

[HANGER187]

Hellz yeah man, I wish I can give you a hug or buy you some beer...that was dope. My files are big and when I export SQL its only in the 300 KB range, is that okay? Normal in other words? SQL files saves all that information to such a low file? Interesting...just want to make sure I did save everything.

[TheOriginalVessalius]

Hmmm it worked but I only have 99 MB instead of 130 MB....

[Audioforge]

Thank you Mr. Rogers.

[jenish4]

good job mate, well done!

[active120]

THanks good tutorial!

[fourblogger]

Still your tutorials working when i try.

Good tutorial.

[makingfilmthings]

Very useful and succinct many thanks

[zubertish]

Most EXCELLENT!

Perhaps a 'tute' on how to back up tables as well? I lost my entire site due to a hack. My CMS needs everything to run. Or perhaps I just don't understand.

[ponydownturbo]

thanx for the info....big thumbs up

[phototristan]

No prob. I'm glad this is helpful.

[shuujin008]

Epic

[KSSOUK]

You're awesome.

thanks a bunch!

[CrossTrainerToo]

Thanks a million!!!

I just had a scare with all my databases missing for multiple sites, all wp, so I decided it was time to back everything up. After reading pages of info I found your video and I am so thankful I did.

Thanks again for such a simple but very much needed video!!

10 stars!

[phototristan]

Thanks.

Keep in mind that if you are using WordPress, there are plugins that can automatically back up your database for you at specified intervals. I use one called WP-DBManager.

[elletricity]

THANK YOU SO MUCH. I don't understand MySQL at ALL and I needed to backup, and this totally saved my life! (:

[phototristan]

Great! I'm glad you found it helpful.

[phototristan]

I'm glad this video is helpful!

[BenHogansSwing]

I'm new to programming, but I want to back up a forum i created and post everything to a new folder on my hosting. Would this work for that, or is there another step?

[phototristan]

I'm not sure. There may be additional steps to back up the forum however the procedure for backing up the MySQL database (or databases) should be the same as long as your provider uses PHPMyAdmin.

[xXxMoMo1994xXx]

Perfect Guide.

Thanks Alot!

You Deserve 6 Stars.

[BobbyFrother]

Thank you so much. My site got hacked and im trying to reinstate it. THANK YOU!

[TruckerAnthony]

i am thankful for folks like you Tristan until a year ago i was computer illiterate and now i am a still learning C# programmer but some things still elude me thx bro if you got any for ubuntu those are much needed too lol

[fatsotomuscles]

Awesome! Clear, simple, and straight to the point.

[stevepohlit]

Very nicely done. My cpanel for most of my blogs has a backup icon. Not so for one key blog and this answered the question on how to do it Thank you.

[TeRRaSoL]

Hello, thanks for the video..

one question... what do you select

SQL compatibility mode? (none)

when you back up

thanks :)

[phototristan]

I leave that that 'none'.

[tapkcir]

Thanks a lot, this video was seriously a life saver! And now I can properly pronounce MySQL too!

[phototristan]

Actually, I'm not sure I'm pronouncing it correctly myself. It might be "My S Q L".

[anang5]

wow... nice tutorials. very easy to understand. i have been using flat file database only because it was easy to backup. SQL here i come. :)

[wiretotheear]

Thanks for the video. I watch it each time I backup/upgrade my Wordpress blogs.

[workpress]

Nice video Tristan! .... I loved the way you illustrated everything, feels so simple. Just a question, I am moving some of my sites from one hosting to another and some of them includes ecommerce. For example, for one site I can logon to ftp and download everything and upload it to new hosting. Then do I need to export each database and import each one on the new hosting the same way?... Is there any one click solution through which I can restore all my databases? ... Thanks once again.

[phototristan]

There may be a one click MySQL DB transfer solution, however this would probably depend on the web host's offerings. I am not familiar with any myself.

[workpress]

Ok, thank you Tristan. By the way, you have perfect training voice. Well done! - What are you expertise?

[phototristan]

Thanks!

I'm a photographer and techie, with a degree in Filmmaking.

[workpress]

Photographer, I have a digital camera and I like taking snap shots often. Filmmaking, sounds yummy! .... so you can do great work via Youtube only. I like to ask a few questions regarding you tube video recording only. If you like, we can chat via msgr!

[phototristan]

Sure, use the contat area on my website.

[marcohaber]

Nicely done Tristan. Thanks much for the tutorial.

[phototristan]

Thanks for watching!

[SandyStepien]

Excellent video! Thanks so much, Tristan. Everything worked exactly as you instructed. GREAT!

[phototristan]

It's okay. It crashes on my Mac more than Safari and is still slower than Safari.

[Arley2011]

So how do you like Firefox 3 Beta 5?