Below shown how to Back Up and Restore a MySQL Database

How to Back Up and Restore a MySQL Database

If you have a database driven site and you want to optimize MySQL tables then this is perfect. It goes through all the tables in a MySQL database and does table optimization on each one using the MySQL Optimize Table syntax.

This is a general code to use when inserting an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. An extention of this code would be to make sure the entry you are adding to the database doesn't already exist (to save dupicate entries). Note: This code requires you to connect to the...

This is a general code to use when updating an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. Note: This code requires you to connect to the MySQL database to work. Also, all field and table names need to be set up to match.

Backup MySQL Database to SQL File with mysqldump

This is a general code to use when deleting an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. A variation of the code would be not to delete the record (as you tend to always need to restore or retrieve it sooner or later) you can add a 'status' field. If status='d' then it is...

Calculates the total size of a MySQL database in KB/MB or GB...

PHP example for connecting to MySQL

This is a general code to use when selecting an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. Note: This code requires you to connect to the MySQL database to work. Also, all field and table names need to be set up to match. This MYSQL Code using in PHP

Connecting to a MySQL database to make the data from the database available in your Web application, can be done in many different ways. Here are two often used methods.

MySQL code example to optimize all tables of database

Connects to a database, and runs a query

MySQL code example for sorting data in a GRID

This query will show you how to select only distinct (unique) entries from a database

A simple example code for user login with a login form and database query

Basic Database Connection, Random Query, Display Result

Example MySql code to append Data to Field in MySql

MySQL code to connect to db. Don't forget to change the parameters.

Class to back up entire databases and email them out, or individual tables.