Back Mysql Database Snippets


Below shown how to Back Up and Restore a MySQL Database

29 December, 2012   

How to Back Up and Restore a MySQL Database

18 June, 2013   

Define few variables with your MySQL database connection settings and connect to MySQL database using mysql_connect() and mysql_select_db() functions.

19 May, 2012   

Example code to load CSV back into mySQL

09 May, 2011   

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.

14 May, 2011   

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.

07 April, 2014   

Adding a linked server to MSSQL account - particularly a MYSQL server

05 July, 2012   

Backup MySQL Database to SQL File with mysqldump

12 January, 2011   

Browsers already have "back" buttons, so you'd better have a darn good reason for needing to put one on your page! This is totally obtrusive, but you could fix that by only appending this button through JavaScript.

14 May, 2011   

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

Exam code to backup MySQL Database to SQL File

22 September, 2012   

Allows you to take a user to the previous page they were on using a button

30 August, 2011   

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

21 May, 2012   

PHP example for connecting to MySQL

13 October, 2013   

To create 'examples' database on your MySQL server you should run the following script

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

23 November, 2013   

You can search and replace fields by below query in MySQL Database

The below snippet will create a MySQL user and grant them all permissions on the given database.

09 May, 2011   

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