phpmyadmin: add a table (or a view) to "favorites" (bookmarks)

In tables (or views) click on the star next to his name.


rclone and symlinks: a good news

with -l you can copy (i.g. on Mega) your symlinks (as a file with .rclonelink as extension).
When you will sync from remote, that symlink will be created in your local system as symlink.


groups in nextcloud

Nextcloud is a very interesting, open source online platform. With /e/ you have a cloud of 5 free Gb with calendar, contacts and tasks shareable between PC and smartphone.
1) First of all you should export your data (calendar, tasks, contacts) from Google; a problem arises with contacts because Google export your contacts in a vcf file without groups.
2) So you have to import your contacts from vcf google file in nextcloud and re-create groups, which this time could be saved in a vcf file with groups (as categories).
3) To see your contacts and groups you have to use DAVx5 and in account settings - > cardDAV -> group organization you have to choose as in the following image:

not [ ] groups are separated vcards
but [x] groups are per-contact categories
4) This way you will be able to see your contacts and groups in your phone app (or in whatever other app).


edit views in phpmyadmin

You can go in view -> structure and find (below) "edit view". Then you can change something, i.g. adding a nuew field, not yet present when that view was created.


test sddm screen, without logging out

this is the code (in terminal):
sddm-greeter --test-mode --theme /usr/share/sddm/themes/breeze


phpmyadmin relations in views

You can create a relation between two tables, or better between a table and a view (more flexible), so that you can use data of related table/view in the table you are using.

But if you create a view from that table (a table whose structure is "related" to another one) you have to repeat (in structure view) the relation settings.


field name containing "-" not accepted in a mysql query

You have to put the field name into quotes "`" some-text (not working) -> `some-text` (working)


Blog Archive