Title: WP_Site_Health::prepare_sql_data
Published: May 7, 2019
Last modified: April 28, 2025

---

# WP_Site_Health::prepare_sql_data()

## In this article

 * [Description](https://developer.wordpress.org/reference/classes/wp_site_health/prepare_sql_data/?output_format=md#description)
 * [Source](https://developer.wordpress.org/reference/classes/wp_site_health/prepare_sql_data/?output_format=md#source)
 * [Related](https://developer.wordpress.org/reference/classes/wp_site_health/prepare_sql_data/?output_format=md#related)
 * [Changelog](https://developer.wordpress.org/reference/classes/wp_site_health/prepare_sql_data/?output_format=md#changelog)

[ Back to top](https://developer.wordpress.org/reference/classes/wp_site_health/prepare_sql_data/?output_format=md#wp--skip-link--target)

This function’s access is marked private. This means it is not intended for use 
by plugin or theme developers, only by core. It is listed here for completeness.

Runs the SQL version checks.

## 󠀁[Description](https://developer.wordpress.org/reference/classes/wp_site_health/prepare_sql_data/?output_format=md#description)󠁿

These values are used in later tests, but the part of preparing them is more easily
managed early in the class for ease of access and discovery.

## 󠀁[Source](https://developer.wordpress.org/reference/classes/wp_site_health/prepare_sql_data/?output_format=md#source)󠁿

    ```php
    private function prepare_sql_data() {
    	global $wpdb;

    	$mysql_server_type = $wpdb->db_server_info();

    	$this->mysql_server_version = $wpdb->get_var( 'SELECT VERSION()' );

    	if ( stristr( $mysql_server_type, 'mariadb' ) ) {
    		$this->is_mariadb                = true;
    		$this->mysql_recommended_version = $this->mariadb_recommended_version;
    	}

    	$this->is_acceptable_mysql_version  = version_compare( $this->mysql_required_version, $this->mysql_server_version, '<=' );
    	$this->is_recommended_mysql_version = version_compare( $this->mysql_recommended_version, $this->mysql_server_version, '<=' );
    }
    ```

[View all references](https://developer.wordpress.org/reference/files/wp-admin/includes/class-wp-site-health.php/)
[View on Trac](https://core.trac.wordpress.org/browser/tags/6.9.4/src/wp-admin/includes/class-wp-site-health.php#L207)
[View on GitHub](https://github.com/WordPress/wordpress-develop/blob/6.9.4/src/wp-admin/includes/class-wp-site-health.php#L207-L221)

## 󠀁[Related](https://developer.wordpress.org/reference/classes/wp_site_health/prepare_sql_data/?output_format=md#related)󠁿

| Uses | Description | 
| [wpdb::db_server_info()](https://developer.wordpress.org/reference/classes/wpdb/db_server_info/)`wp-includes/class-wpdb.php` |

Returns the raw version string of the database server.

  | 
| [wpdb::get_var()](https://developer.wordpress.org/reference/classes/wpdb/get_var/)`wp-includes/class-wpdb.php` |

Retrieves one value from the database.

  |

| Used by | Description | 
| [WP_Site_Health::get_test_sql_server()](https://developer.wordpress.org/reference/classes/wp_site_health/get_test_sql_server/)`wp-admin/includes/class-wp-site-health.php` |

Tests if the SQL server is up to date.

  |

## 󠀁[Changelog](https://developer.wordpress.org/reference/classes/wp_site_health/prepare_sql_data/?output_format=md#changelog)󠁿

| Version | Description | 
| [5.2.0](https://developer.wordpress.org/reference/since/5.2.0/) | Introduced. |

## User Contributed Notes

You must [log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fdeveloper.wordpress.org%2Freference%2Fclasses%2Fwp_site_health%2Fprepare_sql_data%2F)
before being able to contribute a note or feedback.