Lesson 22 Backing Up Databases

ALL 22 JOOMLA LESSONS
HIGH RESOLUTION
FOR JUST $7
http://planettucker.com/JL/
FREE "HOW TO MAKE A WEBSITE"
GUIDE:
http://planettucker.com/af/ecom.php
HOME PAGE:
http://planettucker.com
FOR AFFILIATE WEBMASTERS:
http://ecommerceaffiliatewebmaster.com
HOSTING RECOMMENDATIONS:
http://acegxhosting.com/
RECOMMENDED SITE BUILDERS:
http://planettucker.com/af/quicsite.php
http://planettucker.com/af/sitebuildit.php
http://planettucker.com/af/buildaniche.php
http://planettucker.com/af/simplweb.php

If you listen to nothing else I say listen to this!!! It is soooo important to backup your database(s). This tutorial shows you how through PHPMyAdmin.

Category:

Education

Tags:

• quic site.com tutorials
• planet tucker tutorials
• database tutorials

[7means]

Hello,

I was going to move my sites from one account to another account. I have backedup all databases and now my question is do i need to export Information_schema also or no?

One more question is it advisable to move one site after another or i can just move the contents of public_html at one time only since i have lot of sites. Thank you so much for your help.

[QuicSite]

@7means, Typically no, you don't have to export the schema, HOWEVER in my opinion you can never back up too much, including things you 'shouldn't' need. Yes, if you have many added on domains on your account which equate to many folders in your public_html folder that hold the website files, you can take a copy of the public_html folder and all other subfolders (websites) will follow. You'll of course have to add on these domains to the new account and point your domains. Hope this helps.

[QuicSite]

No not at the moment. But in your phpMyAdmin instead of using export, you would use import, find the file you previously downloaded, go to the bottom and hit "GO". This will bring in the contents. Your done! Make sure the database you are importing to is empty (i.e. no tables or anything). Your platform will then need to have this new databases information specified in the configuration file (whatever it may be for the platform you are using.).

Hope this helps :)

[themonst]

exellent

[flyguyga321]

Thanks for the tutorials! You are like a web angel! I learn a lot from your videos!

[7means]

@QuicSite

Hi, Thanks for your reply. Let me try it and if i have any questions i will comment again. Thanks

[avoltha]

cool man thanks a lot

[7means]

Thanks!

[7means]

Hi,

Good tutorial. I was just wondering Do you have another video on how to restore? I didn't seeThanks

[shanna1950]

Totally Tops, Thanks