Categorized | MySQL

How to manually back up your MySQL databases from PHPMyAdmin

Posted on 11 March 2010 by Abidoon


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 phpmyadmin

Tags | , , , , ,

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

  1. 1888junkteam says:

    excellent tutorials

  2. 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..?

  3. Films4You says:

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

  4. 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