INSTALL.sqlite.txt

Same filename in other branches
  1. 7.x INSTALL.sqlite.txt
  2. 9 core/INSTALL.sqlite.txt
  3. 10 core/INSTALL.sqlite.txt
  4. 11.x core/INSTALL.sqlite.txt
SQLITE REQUIREMENTS
-------------------

PHP's PDO SQLite driver must be enabled. If you do not have pdo_sqlite
available, depending on your system there are different ways to install it.

Windows
-------
Read more about it on http://www.php.net/manual/en/pdo.installation.php

Linux
-----

  sudo apt-get install php-sqlite3

SQLITE DATABASE CREATION
------------------------

The Drupal installer will create the SQLite database for you. The only
requirement is that the installer must have write permissions to the directory
where the database file resides. This directory (not just the database file) also
has to remain writable by the web server going forward for SQLite to continue to
be able to operate.

On the "Database configuration" form in the "Database file" field, you must
supply the exact path to where you wish your database file to reside. It is
strongly suggested that you choose a path that is outside of the webroot, yet
ensure that the directory is writable by the web server.

If you must place your database file in your webroot, you could try using the
following in your "Database file" field:

  sites/default/files/.ht.sqlite

Note: The .ht in the name will tell Apache to prevent the database from being
downloaded. Please check that the file is, indeed, protected by your webserver.
If not, please consult the documentation of your webserver on how to protect a
file from downloading.

File

core/INSTALL.sqlite.txt

View source
  1. SQLITE REQUIREMENTS
  2. -------------------
  3. PHP's PDO SQLite driver must be enabled. If you do not have pdo_sqlite
  4. available, depending on your system there are different ways to install it.
  5. Windows
  6. -------
  7. Read more about it on http://www.php.net/manual/en/pdo.installation.php
  8. Linux
  9. -----
  10. sudo apt-get install php-sqlite3
  11. SQLITE DATABASE CREATION
  12. ------------------------
  13. The Drupal installer will create the SQLite database for you. The only
  14. requirement is that the installer must have write permissions to the directory
  15. where the database file resides. This directory (not just the database file) also
  16. has to remain writable by the web server going forward for SQLite to continue to
  17. be able to operate.
  18. On the "Database configuration" form in the "Database file" field, you must
  19. supply the exact path to where you wish your database file to reside. It is
  20. strongly suggested that you choose a path that is outside of the webroot, yet
  21. ensure that the directory is writable by the web server.
  22. If you must place your database file in your webroot, you could try using the
  23. following in your "Database file" field:
  24. sites/default/files/.ht.sqlite
  25. Note: The .ht in the name will tell Apache to prevent the database from being
  26. downloaded. Please check that the file is, indeed, protected by your webserver.
  27. If not, please consult the documentation of your webserver on how to protect a
  28. file from downloading.

Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.