How to backup MySQL database using PHPMyAdmin

January 11th, 2010

How to backup your MySQL database using PHPMyAdmin. This will apply to anyone with a custom blog or website that uses MySQL including Wordpress blogs, Expression Engine and more.

Note- if you are looking for reliable and fast hosting, I recommend and use Hostgator – http://tristantom.com/hostgator.php

Also see my blog here:
http://tristantom.com/video-tutorial-how-to-back-up-your-mysql-database/

Duration : 0:4:55


Technorati Tags: , , , , , , , , , , ,

25 Responses

  1. phototristan Says:

    No prob. I’m glad …
    No prob. I’m glad this is helpful.

  2. ponydownturbo Says:

    thanx for the info. …
    thanx for the info….big thumbs up

  3. shuujin008 Says:

    Epic
    Epic

  4. KSSOUK Says:

    You’re awesome.


    You’re awesome.

    thanks a bunch!

  5. phototristan Says:

    Thanks.

    Keep in …
    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.

  6. CrossTrainerToo Says:

    Thanks a million!!! …
    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!

  7. phototristan Says:

    Great! I’m glad you …
    Great! I’m glad you found it helpful.

  8. elletricity Says:

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

  9. phototristan Says:

    I’m glad this video …
    I’m glad this video is helpful!

  10. phototristan Says:

    I’m not sure. There …
    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.

  11. BenHogansSwing Says:

    I’m new to …
    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?

  12. xXxMoMo1994xXx Says:

    Perfect Guide.

    Perfect Guide.
    Thanks Alot!
    You Deserve 6 Stars.

  13. BobbyFrother Says:

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

  14. TruckerAnthony Says:

    i am thankful for …
    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

  15. fatsotomuscles Says:

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

  16. stevepohlit Says:

    Very nicely done. …
    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.

  17. phototristan Says:

    I leave that that ‘ …
    I leave that that ‘none’.

  18. TeRRaSoL Says:

    Hello, thanks for …
    Hello, thanks for the video..
    one question… what do you select
    SQL compatibility mode? (none)
    when you back up

    thanks :)

  19. phototristan Says:

    Actually, I’m not …
    Actually, I’m not sure I’m pronouncing it correctly myself. It might be “My S Q L”.

  20. tapkcir Says:

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

  21. anang5 Says:

    wow… nice …
    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. :)

  22. wiretotheear Says:

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

  23. phototristan Says:

    Sure, use the …
    Sure, use the contat area on my website.

  24. workpress Says:

    Photographer, I …
    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!

  25. phototristan Says:

    Thanks!

    I’m a …
    Thanks!

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

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.

Posted by admin and filed under how to blog | 25 Comments »

|