Php Database Backup Snippets


05 July, 2012   

Backup MySQL Database to SQL File with mysqldump

Exam code to backup MySQL Database to SQL File

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.

09 October, 2011   

This code shows how to backup a table to a CSV file.

09 February, 2011   

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

24 September, 2012   

Connects to a database, and runs a query

An example code to restore MSSQL database from backup

05 December, 2013   

AppleScript Source Code for Evernote Notebooks Backup

30 December, 2010   

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

Script to query db growth history using backup history this is accurate as long as there's no compression involved.

13 April, 2011   

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.

07 April, 2013   

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

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.

21 May, 2012   

PHP example for connecting to MySQL

MySQL code to Find PHP code in database Drupal 6.x

The mysql_fetch_assoc "converts" a row from a table into an associative array. The mysql_insert_array "converts" an associative array into a row in a table.

17 July, 2013   

This one creates a back of the current workbook.

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.

26 December, 2012   

This cron will do the same on Windows as session management works on Linux

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