phpMyAdmin – phpMyAdmin is a tool written in PHP intended to handle the administration of SQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges, export data into various formats and is available in 50 languages. Development is backed up by the phpMyAdmin team.
MySQL GUI Tools – Tools from MySQL include a Migration Toolkit, MySQL Administrator, Query Browser, and Workbench, to build queries with a GUI.
PHP Mini Admin – An extremely lightweight alternative to heavy phpMyAdmin for quick and easy access MySQL databases.
KooDB – KooDB is a simple interface to MySQL that provides the features that most people need, without the complicated functions found in phpMyAdmin. It allows you to administer your databases and users from a simple, easy to use web based interface. KooDB is written in pure PHP 5 (though it will probably work with PHP4) and designed for MySQL 5.
RUIDB – RUIDB was made to enable users with little knowledge about MySQL to add/edit/delete/view rows of MySQL-Tables. It is also a nice tool for admins or website authors. RUIDB was not made and will never be able to alter the layout of tables or create tables.Comments (0) 18.07.2008. 07:24
Thousands of web applications use MySQL for their databases, and almost all of them store some sort of valuable information. You never know when a hard drive will fail, a server will die, or in the absolute worst case, when someone will find a vulnerability that allows them to delete your databases. Sometimes we just take for granted how well everything just... works. We're going to look at two simple ways to backup your databases, and how to automate them using crontabs.
http://devolio.com/blog/archives/107-Automating-MySQL-Backups-with-Cron.html
Comments (0) 18.07.2008. 07:20
update TABLENAME set [FieldName] = replace([FieldName],[ToSearchString],[ReplaceString]);
Comments (0) 16.05.2008. 08:34
MySQL is currently the most popular open source database server in existence. On top of that, it is very commonly used in conjunction with PHP scripts to create powerful and dynamic server-side applications.
mySQL has been criticized in the past for not supporting all the features of other popular and more expensive DataBase Management Systems. However, MySQL continues to improve with each release (currently version 5), and it has become widely popular with individuals and businesses of many different sizes.
http://www.tizag.com/mysqlTutorial/
Comments (0) 05.05.2008. 04:29
This mysql tutorial covers the basic stuff that you can do with MySQL. But before we go any further make sure you already have MySQL installed.
http://www.php-mysql-tutorial.com/mysql-tutorial/index.php
Comments (0) 05.05.2008. 04:28 |
