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