From f66de86a85676771d61759fb63e851fc496b0a3b Mon Sep 17 00:00:00 2001 From: admin Date: Tue, 10 Oct 2006 23:30:04 +0000 Subject: --- user_guide/database/utilities.html | 20 +++++++++++++++----- 1 file changed, 15 insertions(+), 5 deletions(-) (limited to 'user_guide/database/utilities.html') diff --git a/user_guide/database/utilities.html b/user_guide/database/utilities.html index 68cf7ffb2..1fdc4b009 100644 --- a/user_guide/database/utilities.html +++ b/user_guide/database/utilities.html @@ -138,12 +138,15 @@ foreach($dbs as $db)

$this->dbutil->optimize_table('table_name');

+

Note:  This features is only available for MySQL/MySQLi databases.

+ +

Permits you to optimize a table using the table name specified in the first parameter. Returns TRUE/FALSE based on success or failure:

if ($this->dbutil->optimize_table('table_name'))
{
-    echo 'Success!'
+    echo 'Success!';
}
@@ -153,12 +156,15 @@ if ($this->dbutil->optimize_table('table_name'))

$this->dbutil->repair_table('table_name');

+

Note:  This features is only available for MySQL/MySQLi databases.

+ +

Permits you to repair a table using the table name specified in the first parameter. Returns TRUE/FALSE based on success or failure:

if ($this->dbutil->optimize_table('table_name'))
{
-    echo 'Success!'
+    echo 'Success!';
}
@@ -168,10 +174,12 @@ if ($this->dbutil->optimize_table('table_name'))

$this->dbutil->optimize_database();

+

Note:  This features is only available for MySQL/MySQLi databases.

+

Permits you to optimize the database your DB class is currently connected to. Returns an array containing the returned status messages or FALSE on failure.

-$result = $this->dbutil->optimize_databass();
+$result = $this->dbutil->optimize_database();

if ($result !== FALSE)
{
@@ -206,7 +214,7 @@ $newline = "\r\n";
echo $this->dbutil->csv_from_result($query, $delimiter, $newline);
-

Important:  This function will NOT write the CSV file for you. It simply creates the CSV layout. +

Important:  This function will NOT write the CSV file for you. It simply creates the CSV layout. If you need to write the file use the File Helper.

@@ -231,7 +239,7 @@ $config = array (
echo $this->dbutil->xml_from_result($query, $config); -

Important:  This function will NOT write the XML file for you. It simply creates the XML layout. +

Important:  This function will NOT write the XML file for you. It simply creates the XML layout. If you need to write the file use the File Helper.

@@ -240,6 +248,8 @@ If you need to write the file use the File

Permits you to backup your full database or individual tables. The backup data can be compressed in either Zip or Gzip format.

+

Note:  This features is only available for MySQL/MySQLi databases.

+

Note: Due to the limited execution time and memory available to PHP, backing up very large databases may not be possible. If your database is very large you might need to backup directly from your SQL server via the command line, or have your server admin do it for you if you do not have root privileges.

-- cgit v1.2.3-24-g4f1b