/**

popular collection of scripts for all

*/
/** Search */

Database Tools

 }

Backup DB

Hits: 19
*****
0.0

backupDB()

Hits: 18
*****
0.0

BackupZip

Hits: 18
*****
0.0
Backup DB is a very easy to
backupDB() is a PHP script
BackupZip creates a .gz
This class can be used to
use MySQL database
that backs up MySQL tables
zipped backup of a MySQL
search for data in MySQL
Backup/Restore utility
and databases to a gzip'd
database on demand. You can
database table text
written in PHP and Perl. The
file for easy daily backup.
either backup all tables
fields. It executes one
interface is written in PHP
Can back up a single
within the database or chose
or more SQL SELECT queries
to keep things streamlined
database and/or table, or
to just backup specific
to search for given keywords
and the backup/restore
all tables. Structure-only,
tables. Used with cron
in different text fields of
processes are written in
complete-inserts optional.
and an automated ftp
the same MySQL database
Perl to avoid PHP's
Can be called interactively
download, you can completely
table. The class returns
limitations in the areas of
or run as a cron job. Works
automate database backups!
an array with the values of
safe_mode file ownership and
well with doSQL() (also
If you don't have access to
primary keys of the table
system commands (v1.10 adds
available on this site).
cron, setup a reminder or
records returned by the
the option of using PHP
Faster and more robust than
scheduler to run this script
queries. Duplicate record
files for the backup/restore
phpMyAdmin's backup function.
daily or weekly via your web
entries are eliminated.
process). Backups are
 
browser and download the
 
compressed to limit storage
 
zipped files via FTP when
 
space, organized by database
 
convenient. If you don't
 
(for ease of restoring), and
 
have access to cron or would
 
saved with the date appended
 
prefer to output the backup
 
to the filename (to allow
 
file directly to your web
 
multiple backups). You can
 
browser, see the Backup
 
backup or restore one or
 
scriptlet.
 
more (or all) tables in the
 
 
 
selected database at once.
 
 
 


Date: Apr, 22 2005


Date: Feb, 18 2006


Date: Jul, 13 2006


Date: Jul, 20 2006
This script was born out of
Staggered import of large and
This is a function to convert
Cacheton - An utility to
necessity for me. I was
huge MySQL Dumps (like
a user's query in boolean
cache pages that frequently
creating quite a few reports
phpMyAdmin 2.x dumps and
syntax ("hotels AND
query a db which is not
that are to be extracted
even GZip compressed dumps).
mexico NOT cockroaches) into
updated so frequently.
from MySQL database. Format
Do you want to restore the
a SQL query over the
Script can reduce server
them into a table like
huge backup of your mySQL
appropriate database fields.
load up to 50%. Your
structure, with or without
database (or a part of it)
 
database will thank you.
headers. And be able to view
into the new or the same
 
Easy installation, just
as HTML, download as HTML,
mySQL database? You can't
 
create a cache dir and
or download as EXCEL.
access the server shell and
 
include the script.
All settings to generate a
you can't import the dump
 
Configurable cache life, use
report can be controlled by
using phpMyAdmin due to hard
 
page compression if you will.
adjusting the variables
memory/runtime limit of the
 
 
found in config.inc.php
web server. BigDump will do
 
 
This script helped me
it even through the web
 
 
somewhat in having some
servers with hard runtime
 
 
spare time to go for a good
limit and those in safe mode
 
 
round of fishing. I hope
in a couple of short
 
 
that it will aid you as it
sessions.
 
 
aided me. There would
 
 
 
not be any technical
 
 
 
assistance on this script.
 
 
 
However you can pop a
 
 
 
question or so to me at my
 
 
 
email ( ben AT benruth DOT
 
 
 
com ). It is good to say
 
 
 
hi! This script requires
 
 
 
some knowledge of SQL.
 
 
 
Features-At-A-Glance -
 
 
 
Configurable script -
 
 
 
Simple table for -
 
 
 
Download as EXCEL -
 
 
 
Download as HTML -
 
 
 
Viewing as HTML -
 
 
 
Extraction from MySQL
 
 
 
database
 
 
 


Date: May, 25 2005


Date: Apr, 17 2006


Date: May, 30 2005


Date: May, 15 2005
{ Copyright } ©2006 NuclearScripts.com