From 4b9c62980599228f070b401c7673dce8085b0c61 Mon Sep 17 00:00:00 2001 From: Derek Jones Date: Fri, 1 Jul 2011 17:40:48 -0500 Subject: backed out 648b42a75739, which was a NON-trivial whitespace commit. It broke the Typography class's string replacements, for instance --- user_guide/database/utilities.html | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) (limited to 'user_guide/database/utilities.html') diff --git a/user_guide/database/utilities.html b/user_guide/database/utilities.html index ec45f2688..c488180a8 100644 --- a/user_guide/database/utilities.html +++ b/user_guide/database/utilities.html @@ -105,7 +105,7 @@ foreach ($dbs as $db)

$this->dbutil->database_exists();

Sometimes it's helpful to know whether a particular database exists. -Returns a boolean TRUE/FALSE. Usage example:

+Returns a boolean TRUE/FALSE. Usage example:

if ($this->dbutil->database_exists('database_name'))
@@ -114,7 +114,7 @@ if ($this->dbutil->database_exists('database_name'))
} -

Note: Replace database_name with the name of the table you are looking for. This function is case sensitive.

+

Note: Replace database_name with the name of the table you are looking for. This function is case sensitive.

@@ -184,7 +184,7 @@ echo $this->dbutil->csv_from_result($query);

The second and third parameters allows you to -set the delimiter and newline character. By default tabs are used as the delimiter and "\n" is used as a new line. Example:

+set the delimiter and newline character. By default tabs are used as the delimiter and "\n" is used as a new line. Example:

$delimiter = ",";
@@ -193,14 +193,14 @@ $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.

$this->dbutil->xml_from_result($db_result)

Permits you to generate an XML file from a query result. The first parameter expects a query result object, the second -may contain an optional array of config parameters. Example:

+may contain an optional array of config parameters. Example:

$this->load->dbutil();
@@ -217,18 +217,18 @@ $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.

$this->dbutil->backup()

-

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

+

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

Usage Example

@@ -278,7 +278,7 @@ $this->dbutil->backup($prefs); Options Description -tablesempty arrayNoneAn array of tables you want backed up. If left blank all tables will be exported. +tablesempty arrayNoneAn array of tables you want backed up. If left blank all tables will be exported. ignoreempty arrayNoneAn array of tables you want the backup routine to ignore. -- cgit v1.2.3-24-g4f1b