How to manually back up your MySQL databases from PHPMyAdmin

Posted by: Admin  :  Category: Phpmyadmin

Linux Cpanel shared hosting: 600 GB disk space, 6 TB bandwidth, free domain, unlimited databases and ftp accounts, web hosting cheap and pro at Hostony

Linux Cpanel shared hosting: 600 GB disk space, 6 TB bandwidth, free domain, unlimited databases and ftp accounts, web hosting cheap and pro at Hostony

www.developphp.com There is nothing more precious than information on the internet. So why leave things to chance regarding your database data? You may have a database full of members, or you render out all of your pages using a Custom Content Management System, which usually stores page data in a MySQL database. In this quick video tutorial Adam shows you how to go into your PHPMyAdmin MySQL database interface and back up or save your sensative database information. There are a few ways that you could lose the data in your database, so creating backup insert files manually is an easy way for a webmaster to safeguard his or her data. First step in keeping your database secure is not allowing users to input harmful strings. Learn of strings that may harm your database and cancel them out in your form processing. But I am assuming your scripts are secure and that you would like to backup your database just in case anything may happen out of the ordinary. You can easily replace any lost data in a few minutes using this manual methid with PHPMyAdmin. Databases get created on your server either through your cpanel or if you are on GoDaddy or a host that has a custom control panel. Once made you have acces to PHPMyAdmin which is for interacting with your database from a not too technical online interface. So not only is it handy but it teaches you code to write scripts that can interact with your database at runtime. HOT TIP: I have learned a lot of PHP-MySQL syntax from using
Video Rating: 4 / 5

Linux Cpanel shared hosting: 600 GB disk space, 6 TB bandwidth, free domain, unlimited databases and ftp accounts, web hosting cheap and pro at Hostony

9 Responses to “How to manually back up your MySQL databases from PHPMyAdmin”

  1. Ziah691 Says:

    I wanted to add that anyone with cPanel hosting will have PHPAdmin in your control panel. It will be under the Databases section in cPanel. You can just click on “Export” choose the stuff you want to backup, Select ALL if you’re not sure or see a file called “Information Schema” then select that with your DB and click Export. The options that are selected by Default do not need to be changed. Godaddy does not have cPanel hosting last time I checked so cant help ya there

  2. allennyquistlas Says:

    Better idea about Russain women gettop5.info

  3. JOSEMENDEZTAMPABAY Says:

    ( part 2 ) the open cart software on my sql workbench and from there make possible changes to my database is that possible ? you think you could help me ?

  4. JOSEMENDEZTAMPABAY Says:

    very nice tutorial 5 stars , i have a q, first let me tell you am new in all of this; ok my q? i have an opencart webpage and i would like to backup that webpage to my sql in my computer ( i understand that by doing this i will be able to work on my page with out the risk of damaging it ) so this were my steps 1 . i installed my sql in my computer , 2 installed my sql workbench software in my computer , 3 intalled the opencart software in my compute 4. i would like to install

  5. smallaxe88 Says:

    I was looking for the way to import DB of size 150MB, too. Do you have any tips? When I compress, it only imports less than 10% of total.

  6. 1888junkteam Says:

    excellent tutorials

  7. jetonmaliqi Says:

    I need for insert my database in one site, please tell me what i can want? Here import is limited to about 51MB..?

  8. Films4You Says:

    Import is limited to about 20Mb files, what about 10Gb databases?

  9. xmangosaintx Says:

    o wow 1st to comment^.^ hey i was searching for how to save my scripts in MySql… i am working on a project to create my own maple private server.. but i am having trouble on saving it.. so i keep getting rollback in thr.. so can u help me? pls reply my comment..(dont reply my comment in this page..) thx flashbuilding its a nice vid.. keep it up..

Leave a Reply

*