INSTALL.sqlite.txt

Same filename in other branches
  1. 7.x INSTALL.sqlite.txt
  2. 9 core/INSTALL.sqlite.txt
  3. 8.9.x core/INSTALL.sqlite.txt
  4. 10 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. Check that the file is, indeed, protected by your webserver. If not,
consult the documentation of your webserver on how to protect a file from
downloading.

File

core/INSTALL.sqlite.txt

View source 
  1. 

  2. SQLITE REQUIREMENTS

  3. -------------------

  4. 

  5. PHP's PDO SQLite driver must be enabled. If you do not have pdo_sqlite

  6. available, depending on your system there are different ways to install it.

  7. 

  8. Windows

  9. -------

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

  11. 

  12. Linux

  13. -----

  14. 

  15.   sudo apt-get install php-sqlite3

  16. 

  17. SQLITE DATABASE CREATION

  18. ------------------------

  19. 

  20. The Drupal installer will create the SQLite database for you. The only

  21. requirement is that the installer must have write permissions to the directory

  22. where the database file resides. This directory (not just the database file) also

  23. has to remain writable by the web server going forward for SQLite to continue to

  24. be able to operate.

  25. 

  26. On the "Database configuration" form in the "Database file" field, you must

  27. supply the exact path to where you wish your database file to reside. It is

  28. strongly suggested that you choose a path that is outside of the webroot, yet

  29. ensure that the directory is writable by the web server.

  30. 

  31. If you must place your database file in your webroot, you could try using the

  32. following in your "Database file" field:

  33. 

  34.   sites/default/files/.ht.sqlite

  35. 

  36. Note: The .ht in the name will tell Apache to prevent the database from being

  37. downloaded. Check that the file is, indeed, protected by your webserver. If not,

  38. consult the documentation of your webserver on how to protect a file from

  39. downloading.

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