Commit Graph

64 Commits

Author SHA1 Message Date
Micah Beasley
3b9cc59baa
Add MySQL Header and MariaDB note
Add MySQL Header and MariaDB note to ensure users will know there are separate steps provided for MariaDB installations.
2020-03-28 16:38:16 -05:00
Patrick Robertson
8b744351fb Include info about Barracuda innodb_file_format
innodb_file_format=Barracuda is required for utf8mb4, some hosts/servers might not use this file format. It is important to check before upgrading.

Signed-off-by: Patrick Robertson <robertson.patrick@gmail.com>
2019-07-02 10:07:49 +00:00
cyBea
195726a3de Update mysql_4byte_support.rst
To clarify needed mysql user privileges.
I am not quite sure if this also applies to <code>ALTER DATABASE nextcloud CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</code> in mysql section 3.
2019-07-02 05:39:45 +00:00
J N
ec7a5e7ef8 Update linux_database_configuration.rst
PostgreSQL instead of MySQL on how to remotley access a postgres server (previously "To access a PostgreSQL installation on a...")
2019-05-31 16:02:21 +00:00
BernieO
ec0ca3b5f7 Make people continue with MySQL instructions
Signed-off-by: Bernhard Ostertag <bernieo.github@gmx.de>

It does not seem to be obvious to continue with the MySQL steps when using MariaDB 10.2 or earlier after step 4 when no error occurred.

According forum thread: https://help.nextcloud.com/t/solved-mysql-is-used-as-database-but-does-not-support-4-byte-characters-error-message-persist-after-fix/52999/2
2019-05-13 10:09:28 +00:00
Morris Jobke
e4b1a2b14d
Merge pull request #1408 from rth-dev/patch-2
Update mysql_4byte_support.rst
2019-05-06 15:13:58 +02:00
Morris Jobke
3c12ce9bb5
Update admin_manual/configuration_database/mysql_4byte_support.rst
ok

Co-Authored-By: rth-dev <rth@dev-used.de>
2019-05-02 23:28:33 +02:00
Morris Jobke
c885b724e1
Update admin_manual/configuration_database/mysql_4byte_support.rst
thanks for the hint : )

Co-Authored-By: rth-dev <rth@dev-used.de>
2019-05-01 13:27:58 +02:00
Joas Schilling
e3c19483a5 Add a note about the necessary mysqldump change
Signed-off-by: Joas Schilling <coding@schilljs.com>
2019-04-29 11:48:50 +00:00
rth
c086f549af
Update mysql_4byte_support.rst 2019-04-26 22:48:42 +02:00
Morris Jobke
f8fc2a0b37 Fix double dash rendering - fixes #1344
Signed-off-by: Morris Jobke <hey@morrisjobke.de>
2019-04-02 08:08:11 +00:00
Morris Jobke
162bff24bb
Merge pull request #1181 from Yvan-Masson/patch-1
Add another table not converted from sqlite to mysql
2019-02-15 11:06:41 +01:00
Morris Jobke
46b406255a
Update admin_manual/configuration_database/db_conversion.rst
Co-Authored-By: Yvan-Masson <yvan@masson-informatique.fr>
2019-02-15 10:49:17 +01:00
jzdm
eee11867c7
Hint to suppress confirmation message
More concise and removed reference to shared hosting as unclear.
2019-01-22 12:56:59 +01:00
jzdm
3da908f939
Suppress confirmation
Shared hostings without shell access make the confirmation step impossible. Therefore you can add named argument and suppress the confirmation message. Then the conversion works even from one time cronjobs.
2019-01-22 10:46:35 +01:00
Yvan-Masson
d1b56bf7b3
Add another table not converted from sqlite to mysql 2019-01-20 21:55:26 +01:00
Georgiy Sitnikov
8b2e7e8b53 Update BigInt (64bit) identifiers
'php' was missing in command and sudo can't execute it as it was.
2019-01-15 09:09:49 +00:00
plluksie
f0ceff464a
Update linux_database_configuration.rst
typo: .dom -> .com
2018-12-21 22:53:59 +01:00
Joas Schilling
cccd8533e4
Fix numbers
Signed-off-by: Joas Schilling <coding@schilljs.com>
2018-10-24 11:49:35 +02:00
Joas Schilling
defa0fb898
Improve the documentation for MySQL 4byte on MySQL 8+ and MariaDB 10.3+
Signed-off-by: Joas Schilling <coding@schilljs.com>
2018-10-24 11:27:05 +02:00
Morris Jobke
1cf765b5e9
Fix warnings of build command
Signed-off-by: Morris Jobke <hey@morrisjobke.de>
2018-07-24 09:57:33 +02:00
Morris Jobke
e8b1849b2a
Merge pull request #812 from hanserasmus/master
Fixed a few typos in the database configuration section.
2018-07-19 12:10:53 +02:00
Hans Erasmus
b54422cb17 Fixed a few typos in the database configuration section. 2018-07-19 11:13:54 +02:00
rieger::CLOUD
74b2f05617
Cosmetical changes
Minor Cosmetical and grammatical changes
2018-07-11 13:47:15 +02:00
rieger::CLOUD
2254e67e97
UTF8MB4 amendments
added create statements and config.php value.
2018-07-09 18:29:56 +02:00
rieger::CLOUD
c7901cde4d
Removed the ** 2018-07-09 15:08:40 +02:00
rieger::CLOUD
e7ad004bb7
Found a typo.
Appologize
2018-07-09 14:43:50 +02:00
rieger::CLOUD
c32114a541
MariaDB/MySQL Global settings
Added transaction_isolation and binlog_format to the database server configuration with an example of an entire /etc/mysql/my.cnf
2018-07-09 14:35:21 +02:00
Louis-Philippe Véronneau
0d98b043c3
grant minimal sql privileges instead of granting all of them (fix #648) 2018-03-16 16:17:08 -04:00
Thomas Tanghus
b1fe49d082
Fix grammar error 2018-03-06 22:51:11 +01:00
Marc Schröder
e1ffa0b96b
Update mysql_4byte_support.rst
Added php for the instructions of changing the config.php and converting the existing tables.
2018-03-05 10:07:46 +01:00
Jos Poortvliet
d7c06cedc6
Update linux_database_configuration.rst
php5 -> php7
2017-12-11 19:10:04 +01:00
Joas Schilling
743ec09a3f
Fix typo in "committed"
Signed-off-by: Joas Schilling <coding@schilljs.com>
2017-11-24 13:34:19 +01:00
peterdamian
9919a3fd3d #600 Change headers to sentence case 2017-11-20 15:15:05 -05:00
peterdamian
e07dd2c746 Header changes for the admin manual, #602 2017-11-15 17:01:03 -05:00
Joas Schilling
fa222396df
Suggest to shutdown or maintenance mode
Signed-off-by: Joas Schilling <coding@schilljs.com>
2017-10-26 10:36:09 +02:00
Joas Schilling
954ed2468b
Add doc about bigints
Signed-off-by: Joas Schilling <coding@schilljs.com>
2017-10-25 10:14:18 +02:00
Morris Jobke
937c54826e Fix type of config option
Fixes #286

Signed-off-by: Morris Jobke <hey@morrisjobke.de>
2017-08-08 14:09:13 +02:00
Marius Blüm
b74354e573 remove wrong database-guide
Signed-off-by: Marius Blüm <marius@lineone.io>
2017-07-29 18:15:00 +02:00
Alixerid
e917bcf8c4 change value of innodb_large_prefix to 1
Older versions of mysql may not accept `on` as a value and configuration may fail. `1` is sure to work. 
See issue #4846 https://github.com/nextcloud/server/issues/4846
2017-06-22 19:58:26 +02:00
Morris Jobke
028e4430e6 Move MySQL 4 byte to DB section
Signed-off-by: Morris Jobke <hey@morrisjobke.de>
2017-05-14 15:13:01 -05:00
Joas Schilling
66aa779a86
Downstream of https://github.com/owncloud/documentation/pull/2700
Signed-off-by: Joas Schilling <coding@schilljs.com>
2017-01-05 10:40:31 +01:00
Lukas Reschke
6ccd2c5678
Branding 2016-07-21 00:21:47 +02:00
Joas Schilling
f28c228322
Cleanup admin manual from enterprise apps 2016-07-13 17:59:00 +02:00
RealRancor
5641f8f4e9
Update MySQL / MariaDB database requirements. 2016-07-11 11:13:44 +02:00
Joachim Sokolowski
7b27cf8dcd Changes for Nextcloud (#34)
* Changes for Nextcloud

* Changes for Nextcloud

* Update command_line_installation.rst

-oci Enterprise removed

* removed Enterprise

* Changing to nextcloud

* enterprise removed

* Update external_storage_configuration_gui.rst

typo

* Update command_line_installation.rst

Oracle changed

* to nextcloud

* Update linux_installation.rst

* Update linux_installation.rst
2016-06-22 14:41:58 +02:00
Patric Lenhart
fc8a6de37b
replaced owncloud by nextcloud in database configuration 2016-06-21 00:30:41 +02:00
Stefan Weil
b059e6eea6 admin_manual: Fix typos found by codespell
Signed-off-by: Stefan Weil <sw@weilnetz.de>
2016-06-12 21:42:27 +02:00
RealRancor
2ba2354f59 Add more notes that Oracle is ES only. 2016-05-14 18:09:25 +02:00
Carla Schroder
3b7697ff5c make edition names consistent 2016-05-13 11:34:40 -07:00