The database version number.
public db_version ( ) : false | string | ||
return | false | string | false on failure, version number on success |
/** * connectDatabase() * * Initializes a connection to the mysql database. * REQUIRES: databaseSettings portion of state to be set. * * @return boolean True on success; else false. Success testing is very loose. */ function connectDatabase() { $this->_before(__FUNCTION__); global $wpdb; $wpdb = new wpdb($this->_state['databaseSettings']['username'], $this->_state['databaseSettings']['password'], $this->_state['databaseSettings']['database'], $this->_state['databaseSettings']['server']); // See if we have a specified character set and collation to use from the source site. $charset = null; $collate = null; if (isset($this->_state['dat']['db_charset'])) { $charset = $this->_state['dat']['db_charset']; } if (isset($this->_state['dat']['db_collate'])) { $collate = $this->_state['dat']['db_collate']; } if (null !== $charset || null !== $collate) { pb_backupbuddy::status('details', 'Setting charset to `' . $charset . '` and collate to `' . $collate . '` based on source site.'); $wpdb->set_charset($wpdb->dbh, $charset, $collate); } else { pb_backupbuddy::status('details', 'Charset nor collate are in DAT file. Using defaults for database connection.'); pb_backupbuddy::status('details', 'Charset in wpdb: ' . $wpdb->charset); } // Warn if mysql versions are incompatible; eg importing a mysql < 5.1 version into a server running 5.1+. global $wpdb; if (isset($this->_state['dat']['db_version'])) { $incomingVersion = $this->_state['dat']['db_version']; } $thisVersion = $wpdb->db_version(); pb_backupbuddy::status('details', 'Incoming mysql version: `' . $incomingVersion . '`. This server\'s mysql version: `' . $thisVersion . '`.'); if (version_compare($incomingVersion, '5.1.0', '<') && version_compare($thisVersion, '5.1.0', '>=')) { pb_backupbuddy::status('warning', 'Error #7001: This server\'s mysql version, `' . $thisVersion . '` may have SQL query incompatibilities with the backup mysql version `' . $incomingVersion . '`. This may result in #9010 errors due to syntax of TYPE= changing to ENGINE=. If none occur you may ignore this error.'); } return true; }
function get_system_data() { global $wp_version; $php = phpversion(); $maxMemLimit = ini_get('memory_limit'); $extensions = implode(', ', get_loaded_extensions()); $disabledFunctions = ini_get('disable_functions'); $maxExTime = ini_get('max_execution_time'); $upMaxExTime = 0; $newMaxExTime = intval($maxExTime) + 60; @set_time_limit($newMaxExTime); if (ini_get('max_execution_time') == $newMaxExTime) { $upMaxExTime = 1; $maxExTime = ini_get('max_execution_time'); } $mysql = ''; if (!class_exists('wpdb')) { require_once ABSPATH . '/' . WPINC . '/wp-db.php'; } $mysqli = new wpdb(DB_USER, DB_PASSWORD, DB_NAME, DB_HOST); $errors = $mysqli->last_error; if (empty($errors)) { $mysql = $mysqli->db_version(); } $upMemLimit = 0; $newMemLimit = intval($maxMemLimit) + 60; ini_set('memory_limit', $newMemLimit . 'M'); if (ini_get('memory_limit') == $newMemLimit) { $upMemLimit = 1; $maxMemLimit = ini_get('memory_limit'); } $extensions_s = array('curl', 'json', 'mysqli', 'sockets', 'zip', 'ftp'); $disabledFunctions_s = array('set_time_limit', 'curl_init', 'fsockopen', 'ftp_connect'); $ext = comparison_function($extensions, $extensions_s); $function = comparison_function($disabledFunctions, $disabledFunctions_s, true); return array('wp_version' => $wp_version, 'wp_lang' => get_option('WPLANG'), 'php_verion' => $php, 'maxExecutionTime' => $maxExTime, 'extensions' => $extensions, 'disabledFunctions' => $disabledFunctions, 'mysqlVersion' => $mysql, 'upMaxExecutionTime' => $upMaxExTime, 'newMaxExecutionTime' => $newMaxExTime, 'upMemoryLimit' => $upMemLimit, 'newMemoryLimit' => $newMemLimit, 'maxMemoryLimit' => $maxMemLimit, 'ex' => $ext, 'func' => $function); }