$msg .= "/*Connection Information for the database\n";
$msg .= "\$def_coy - the default company that is pre-selected on login\n\n";
$msg .= "'host' - the computer ip address or name where the database is. The default is 'localhost' assuming that the web server is also the sql server.\n\n";
+ $msg .= "'port' - the computer port where the database is. The default is '3306'. Set empty for default.\n\n";
$msg .= "'dbuser' - the user name under which the company database should be accessed.\n";
$msg .= " NB it is not secure to use root as the dbuser with no password - a user with appropriate privileges must be set up.\n\n";
$msg .= "'dbpassword' - the password required for the dbuser to authorise the above database user.\n\n";
$msg .= "'dbname' - the name of the database as defined in the RDMS being used. Typically RDMS allow many databases to be maintained under the same server.\n";
+ $msg .= "'collation' - the character set used for the database.\n";
$msg .= "'tbpref' - prefix on table names, or '' if not used. Always use non-empty prefixes if multiply company use the same database.\n";
$msg .= "*/\n\n\n";
}
// update per company files
- $cnt = max(1, count($db_connections));
+ $cnt = max(1, count_array($db_connections));
for($i = 0; $i < $cnt; $i++)
{
$newexts = $extensions;
"drop function if exists" => 'drop_queries',
"drop trigger if exists" => 'drop_queries',
"select" => 'data_queries',
- "delete" => 'data_queries',
+ "delete" => 'data_queries',
+ "drop view if exists" => 'drop_queries',
+ "create view as" => 'data_queries' //we should be able to create views after all tables have been created
);
$protected = array(
ini_set("max_execution_time", max("180", ini_get("max_execution_time")));
db_query("SET foreign_key_checks=0");
+ db_query("SET sql_mode=''");
if (isset($connection['collation']))
db_set_collation($db, $connection['collation']);
return db_export($conn, $path . clean_file_name($filename), $ext, $comm);
}
-//
// Generates a dump of $db database
//
function db_export($conn, $filename, $zip='no', $comment='')
$max_size = 1048576 * 2; // 2 MB
// changes max size if value can be retrieved
if (ini_get("memory_limit"))
- $max_size = 900000 * ini_get("memory_limit");
-
+ $max_size = 1048576 * (int)ini_get("memory_limit");
// set backupfile name
if ($zip == "gzip")
$backupfile = $filename . ".gz";
{
foreach ($all_tables as $row)
{
- $tablename = $row['Name'];
- $auto_incr[$tablename] = $row['Auto_increment'];
-
- $out.="\n\n";
- // export tables
- $out.="### Structure of table `".$tablename."` ###\n\n";
-
- $out.="DROP TABLE IF EXISTS `".$tablename."`;\n\n";
- $out.=$table_sql[$tablename];
-
- $out.=" ;";
- $out.="\n\n";
-
- // export data
- if (!$error)
- {
- $out.="### Data of table `".$tablename."` ###\n";
-
- // check if field types are NULL or NOT NULL
- $res3 = db_query("SHOW COLUMNS FROM `" . $tablename . "`");
-
- $field_null = array();
- for ($j = 0; $j < db_num_rows($res3); $j++)
- {
- $row3 = db_fetch($res3);
- $field_null[] = $row3[2]=='YES' && $row3[4]===null;
- }
-
- $res2 = db_query("SELECT * FROM `" . $tablename . "`");
- $maxinsert = 0;
- $insert = '';
- for ($j = 0; $j < db_num_rows($res2); $j++)
+ if (!empty($row['Engine'])) { //don't export views like tables
+ $tablename = $row['Name'];
+ $auto_incr[$tablename] = $row['Auto_increment'];
+
+ $out.="\n\n";
+ // export tables
+ $out.="### Structure of table `".$tablename."` ###\n\n";
+
+ $out.="DROP TABLE IF EXISTS `".$tablename."`;\n\n";
+ $out.=$table_sql[$tablename];
+
+ $out.=" ;";
+ $out.="\n\n";
+
+ // export data
+ if (!$error)
{
- $row2 = db_fetch_row($res2);
- $values = '(';
- for ($k = 0; $k < $nf = db_num_fields($res2); $k++)
+ $out.="### Data of table `".$tablename."` ###\n";
+
+ // check if field types are NULL or NOT NULL
+ $res3 = db_query("SHOW COLUMNS FROM `" . $tablename . "`");
+
+ $field_null = array();
+ for ($j = 0; $j < db_num_rows($res3); $j++)
{
- $values .= db_escape($row2[$k], $field_null[$k]);
- if ($k < ($nf - 1))
- $values .= ', ';
+ $row3 = db_fetch($res3);
+ $field_null[] = $row3[2]=='YES' && $row3[4]===null;
}
- $values .= ')';
- $len = strlen($values);
- if ($maxinsert < $len+1)
+
+ $res2 = db_query("SELECT * FROM `" . $tablename . "`");
+ $maxinsert = 0;
+ $insert = '';
+ for ($j = 0; $j < db_num_rows($res2); $j++)
{
- $maxinsert = EXPORT_MAX_INSERT;
- if ($insert)
+ $row2 = db_fetch_row($res2);
+ $values = '(';
+ for ($k = 0; $k < $nf = db_num_fields($res2); $k++)
{
- $out .= $insert .';'; // flush insert query
- $insert = '';
+ $values .= db_escape($row2[$k], $field_null[$k]);
+ if ($k < ($nf - 1))
+ $values .= ', ';
+ }
+ $values .= ')';
+ $len = strlen($values);
+ if ($maxinsert < $len+1)
+ {
+ $maxinsert = EXPORT_MAX_INSERT;
+ if ($insert)
+ {
+ $out .= $insert .';'; // flush insert query
+ $insert = '';
+ }
+ }
+
+ if ($insert == '')
+ {
+ $insert = "\nINSERT INTO `" . $tablename . "` VALUES\n";
+ $maxinsert -= strlen($insert);
+ } else {
+ $insert .= ",\n";
+ }
+
+ $maxinsert -= $len;
+ $insert .= $values;
+
+ // if saving is successful, then empty $out, else set error flag
+ if (strlen($out) > $max_size && $zip != "zip")
+ {
+ if (save_to_file($backupfile, $zip, $out))
+ $out = "";
+ else
+ $error = true;
}
}
-
- if ($insert == '')
- {
- $insert = "\nINSERT INTO `" . $tablename . "` VALUES\n";
- $maxinsert -= strlen($insert);
- } else {
- $insert .= ",\n";
- }
-
- $maxinsert -= $len;
- $insert .= $values;
-
- // if saving is successful, then empty $out, else set error flag
- if (strlen($out) > $max_size && $zip != "zip")
- {
- if (save_to_file($backupfile, $zip, $out))
- $out = "";
- else
- $error = true;
- }
+ if ($insert)
+ $out .= $insert. ';';
+ // an error occurred! Try to delete file and return error status
+ }
+ elseif ($error)
+ {
+ @unlink($backupfile);
+ return false;
+ }
+
+ // if saving is successful, then empty $out, else set error flag
+ if (strlen($out) > $max_size && $zip != "zip")
+ {
+ if (save_to_file($backupfile, $zip, $out))
+ $out= "";
+ else
+ $error = true;
+ }
+ } //end if Engine set (not a view)
+ }
+ //process views last so all tables have been created before views are created
+ foreach ($all_tables as $row)
+ {
+ if (empty($row['Engine'])) {
+ $viewname = $row['Name'];
+ $out .= "\n\nDROP VIEW IF EXISTS `".$viewname."`;\n";
+ //db_get_view_schema() is in /includes/db/connect_db_mysqli.inc because it is mysql specific
+ if (NULL !== ($schema = db_get_view_schema($viewname)))
+ {
+ $out .= "CREATE VIEW `".$viewname."` AS ".$schema.";\n\n";
+ if (!save_to_file($backupfile, $zip, $out)) $error = true;
+ else $out = "";
+ }
+ else $error = true;
+
+ if ($error) {
+ @unlink($backupfile);
+ return false;
}
- if ($insert)
- $out .= $insert. ';';
- // an error occurred! Try to delete file and return error status
- }
- elseif ($error)
- {
- @unlink($backupfile);
- return false;
- }
-
- // if saving is successful, then empty $out, else set error flag
- if (strlen($out) > $max_size && $zip != "zip")
- {
- if (save_to_file($backupfile, $zip, $out))
- $out= "";
- else
- $error = true;
}
}
projects / fa-stable.git / blobdiff