How to manually back up your MySQL databases from PHPMyAdmin - [English]
http://www.developphp.com/PHP_tuts
There is nothing more precious than information on the internet. So why leave things to chance regarding your...
http://www.developphp.com/PHP_tuts
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
5m:23s
6298
How to Empty or Truncate Your MySQL Database Table Tutorial - english
Source Page - http://www.developphp.com/PHP_tuts/mysql_truncate_empty_table.php
Learn how to empty or truncate MySQL database tables through...
Source Page - http://www.developphp.com/PHP_tuts/mysql_truncate_empty_table.php
Learn how to empty or truncate MySQL database tables through script, or manually using the PHPMyAdmin. Sets indexes back to zero as well. I am using Dreamweaver CS4 in the video for coding out the PHP file.
5m:5s
6162
Part 5 How to Build PHP and MySQL CMS Website Software - English
Source Files - http://www.developphp.com/view.php?tid=322
Series Playlist - http://www.youtube.com/view_play_list?p=11D6E5B9CA126A57
In part...
Source Files - http://www.developphp.com/view.php?tid=322
Series Playlist - http://www.youtube.com/view_play_list?p=11D6E5B9CA126A57
In part 5 we create the administrator directory and set a link to the CMS administrator back end from the bottom of the home page. The back end admin directory will have its own index page to be the central home of the control panel.
Learn how to build custom content management systems using PHP and MySQL. Cool dynamic basic sites that anyone can edit
8m:21s
6188
Part 9 How to Build PHP and MySQL CMS Website Software - English
Playlist for series - http://www.youtube.com/view_play_list?p=11D6E5B9CA126A57
Source Files - http://www.developphp.com/view.php?tid=322...
Playlist for series - http://www.youtube.com/view_play_list?p=11D6E5B9CA126A57
Source Files - http://www.developphp.com/view.php?tid=322
Learn how to build custom content management systems using PHP and MySQL. Cool dynamic basic sites that anyone you appoint can edit.
7m:4s
4810