Microsoft SQL Server is one of the databases natively supported by Moodle. ...w.microsoft.com/en-us/download/details.aspx?id=20098 Microsoft Drivers for SQL Server for PHP]

This short manual is suitable if you are trying to run Moodle using the SQL*Server (MSSQL) RDBMS. Steps detailed below must be performed '''before''' i The minimum required version of Microsoft SQL Server has been stabilised to SQL Server 2008.

# In the databases section, select the Moodle database. # Click the SQL tab, then in the "Run SQL query/queries on database moodle" field type <code>REPAIR TABLE mdl_tablena

[[Category:SQL databases]]

...ar.gz file. If it is .tar.gz or .gz you need to extract it until it is an sql file. 3. If you are running mysql, import the SQL file back into a newly created database on the MySQL server. Be careful he

[[Category:SQL databases]]

== Using the SQL Server Driver for PHP from Microsoft == This short manual is for running Moodle 2.0 (and upwards) using the Microsoft SQL Server (MSSQL) RDBMS. The steps detailed below must be performed '''before'

PostgreSQL is one of the five databases that is fully supported by Moodle. A database is a required component of an List of databases

MySQL is one of the supported databases that underpins a Moodle installation. * Note: You should back up your databases before making this change.

...SQL Commands page and grant your new user the dmbs_lock permission...<code sql> ...rectly, you can run its parts (separated by slashes) independently via the SQL Commands page.

SQLite is a serverless SQL database implementation. Moodle has experimental support for it. It is not ...QLite PDO driver to be present in PHP. It won't work with native (non-PDO) SQL driver in PHP.

...p://www.YOUR_MOODLE_SITE/admin/tool/innodb/index.php</nowiki>. (With large databases, you may experience time-out issues.) Add the following statement to <nowik ...ISAM with InnoDB. Finally, restore back in the server. (e.g. mysql < dump.SQL or equivalent). '''If using this method, be very careful to use the same fi

MySQL will be your SQL database server. <code>cd /usr/ports/databases/mysql56-server/</code>

...on Moodle uses full UTF-8 for both MySQL and MariaDB by default. Existing databases will still run with partial support, but it is recommended to move over to ...base command line (or something like phpmyadmin) you can try the following sql commands:

...ys a best practice but it only involves parts of the moodledata folder and SQL table. ...greSQL]] database - We will refer to the MySQL database. There are other SQL database flavors which will work with Moodle.

Do you have any HTML, CSS and PHP skills? Do you have any SQL database skills. If you do, then you have a good start, if you do not, then ...ecurity has forced changes to the backup processes. In just looking at the databases there are an additional 60 or more tables, so that creates a number of rest

...inefield for anyone not fully conversant with all the different flavors of SQL. However, in these pages the majority support seems to be for MySQL. This c ...in can act as an additional supervisory tool for accessing any and all SQL databases you use in you web site.

...m on the web securely. But this has more to do with getting a web-server, SQL database and scripting language up and integrated than running a Moodle ins ...ntication and enrollment mechanisms, including LDAP and arbitrary external databases. Moodle will allow teachers to integrate content in a wide range of differe

...istration. From version 2.3, user content in Forums, Wikis, Glossaries and Databases can optionally be included. In addition, items can be collected and saved o # MySQL 5.1, PostgreSQL 8.4, SQL Server 2008 (= MSSQL10): Postgres now supported in 1.9.

<pre>sql>DROP DATABASE moodle;</pre> ...lar Data Stream protocol used by Microsoft SQL Server and Sybase for their databases. Unfortunately, Microsoft servers don't usually accept TDS 5.0 connections.