mig_nuage_paillettes

   1
   2
   3 https://nicolaslang.fr/articles/migrer-la-bdd-nextcloud-de-mysql-vers-postgres
   4
   5 gzip -d ARCHIVE_dump_bdd.gz
   6
   7 préparation MYSQL
   8 DROP DATABASE pailleccambouis;
   9 CREATE DATABASE pailleccambouis;
  10 GRANT ALL PRIVILEGES ON *.* TO 'nextcloud' WITH GRANT OPTION;
  11 source /home/roms/ARCHIVE_dump_bdd;
  12
  13
  14 drop table oc_bbb_restrictions;
  15 drop table oc_bbb_room_shares;
  16 drop table oc_bbb_rooms;
  17 drop table oc_mail_accounts;
  18 drop table oc_mail_aliases;
  19 drop table oc_mail_attachments;
  20 drop table oc_mail_classifiers;
  21 drop table oc_mail_coll_addresses;
  22 drop table oc_mail_mailboxes;
  23 drop table oc_mail_messages;
  24 drop table oc_mail_recipients;
  25
  26 mysql -u nextcloud -p pailleccambouis
  27
  28 modif config.php avec localhost + dbuser nextcloud + dbpass Ckoideja
  29
  30 sudo -u www-data ./console-7.4 db:convert-mysql-charset
  31 sudo -u www-data ./console-7.4 db:add-missing-columns
  32 sudo -u www-data ./console-7.4 db:add-missing-indices
  33 sudo -u www-data ./console-7.4 db:convert-filecache-bigint
  34 sudo -u www-data ./console-7.4 maintenance:mimetype:update-db
  35 sudo -u www-data ./console-7.4 maintenance:mimetype:update-js
  36
  37 préparation PGSQL
  38 vim /etc/postgresql/11/main/pg_hba.conf
  39 local   all             nextcloud                               peer
  40 CREATE USER nextcloud;
  41 ALTER USER nextcloud WITH PASSWORD 'Ckoideja';
  42
  43 DROP DATABASE nextcloud;
  44 CREATE DATABASE nextcloud;
  45
  46 ALTER DATABASE nextcloud OWNER TO nextcloud;
  47 GRANT ALL PRIVILEGES ON DATABASE nextcloud TO nextcloud;
  48
  49
  50 adduser nextcloud -disabled-login --disabled-password --home /opt/nuage --no-create-home --shell /bin/false --system
  51 adduser nextcloud postgres
  52
  53 adduser nextcloud www-data
  54 sudo -u www-data ./console-7.4 db:convert-type --all-apps pgsql nextcloud localhost nextcloud
  55 certaines tables ne sont pas convertis donc perdus. Dire OK.
  56
  57
  58
  59 unlink nextcloud
  60 sudo -u www-data ln -s /opt/source/nextcloud22/nextcloud/ nextcloud
  61 sudo -u www-data ./console-7.4 upgrade
  62 service php7.4-fpm reload
  63
  64
  65 sudo -u www-data ./console-7.4 db:add-missing-columns
  66 sudo -u www-data ./console-7.4 db:add-missing-indices
  67 sudo -u www-data ./console-7.4 db:add-missing-primary-keys
  68
  69
  70 migration:
  71
  72     autoriser site_pec_nuage a se connecter dans /etc/passwd
  73     lancer un rsync depuis la vm vers ligatures dans un /tmp (ou tester un fichier dans le /data)
  74     comparer les fichiers de conf
  75     sudo -u php_pec_nuage ./console upgrade
  76     test de la v26
  77     update en v27
  78