Loads and saves a compressed dump of an array
In order for this to work, you will need to copy mysqldump.exe and mysql.exe from the MySQL bin Program Files folder into the same directory as your executing PHP script. If you know the direct path to these for your server, you can use those instead.
Class to back up entire databases and email them out, or individual tables
Class to back up entire databases and email them out, or individual tables.
Example for Dumping a database to HTML tables
Connects to a database, and runs a query
Calculates the total size of a MySQL database in KB/MB or GB...
Define few variables with your MySQL database connection settings and connect to MySQL database using mysql_connect() and mysql_select_db() functions.
Backup MySQL Database to SQL File with mysqldump
Exam code to backup MySQL Database to SQL File
Oracle 10G has enhanced the flashback feature further and has turned it into a much more powerful feature by introducing a number of additional function. Some of the more common ones are discussed here. - Flashback Table - Flashback Drop - Flashback Database
To create 'examples' database on your MySQL server you should run the following script
Below shown how to Back Up and Restore a MySQL Database
How to Back Up and Restore a MySQL Database
The below snippet will create a MySQL user and grant them all permissions on the given database.
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 MySQL...
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.
DBCA is what you need to create a test database in only 5 mins.
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.
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.