How much Hit Points does casting a two action heightened 2-nd level Heal restore?

Heal

You channel positive energy to heal the living or damage the undead. If the target is a willing living creature, you restore 1d8 Hit Points.

Two Actions (somatic, verbal) The spell has a range of 30 feet. If you’re healing a living creature, increase the Hit Points restored by 8.

Heightened (+1) The amount of healing or damage increases by 1d8, and the extra healing for the 2-action version increases by 8.

I’m reading this as a two action heightened 2-nd level Heal restoring 2d8+16 Hit Points. Am I interpreting this correctly?

Can a Wild Magic Barbarian restore a 7th(+) Level Warlock’s spell slots?

In the recently released preview of the Wild Magic Barbarian that will be in Tasha’s Cauldron of Everything (preview here), I noticed the 6th level feature ‘Bolstering Magic’. This feature has two applications. One acts as a Bless-type option, the second one reads:

Roll a d3. The creature [you’re touching] regains one expended spell slot, the level of which equals the number rolled or lower (the creature’s choice). Once a creature receives this benefit, that creature can’t receive it again until after a long rest.

Suppose this effect is used on a Warlock of level 7 or above, and for the sake of argument suppose we rolled a 3 on the d3. All of their spell slots are of spell level 4. What happens?

  • Nothing, the Warlock doesn’t have the right type of spell slot to regain
  • The Warlock has (expended) spell slots of Level 4 and higher, and now has a level 3 spell slot
  • Something else happens, namely …

Made a mistake with mysql restore on the production site instead of the staging one. Can I use mysql general log to restore?

Made a mistake with mysql restore on the production site instead of the staging one. Can I use mysql general log to restore? It seems general log is all I have. I dont seem to have a binlog with MariaDB’s Aria storage engine.

What should I do now? Anyone has any experience using general log to recover the database?

Can this Lair Action restore all the lich’s 8th or lower spell slots even when there’s no combat or any of the lich’s enemies within?

One of the Lair Actions of a lich does the following:

The lich rolls a d8 and regains a spell slot of that level or lower. If it has no spent spell slots of that level or lower, nothing happens.

A lich decided to attack the party, using some of its spell slots in the process, and then retreat to its lair to recover and await the party.

If the party manage to find the lich’s lair within 8 hours (i.e. before the lich can long rest and recover its spell slots that way), would the above Lair Action have (likely1) restored all of the lich’s spent spell slots (excluding the 9th level spell slot, obviously)?

Or is there some reason this wouldn’t work, such as the Lair Actions only being "active" when there are enemies of the lich actually in the lair (i.e. during combat)?


1 I say "likely" because there’s a dice roll involved, so technically it could not roll the numbers it needs to actually recover all its spell slots, but let’s discount that possibility as I imagine an hour or so of rolling will almost definitely roll the numbers that it needs eventually.

restore mysql database from ibdata1 and frm files

I am trying to restore some database data from my tables frm files. I am running a mariadb database. The data structure works fine and i can see the tables etc. But as soon as i add the ibdata1 and logfiles i run into trouble and get the errors below. I’ve tried to follow recommendations of the other similar posts but nothing seems to work… Any ideas? BR Lukas

my my.cnf config file:

[client-server]  # # This group is read by the server # [mysqld] # Disabling symbolic-links is recommended to prevent assorted security risks innodb_log_file_size=170M innodb_force_recovery = 1 symbolic-links=0  # # include all files from the config directory # !includedir /etc/my.cnf.d 

Journalctl -xe error:

jun 09 01:29:04 ipx.eu-central-1.compute.internal sudo[15322]: pam_unix(sudo:session): session opened for user root by ec2-user(uid=0) jun 09 01:29:04 ipx.eu-central-1.compute.internal systemd[1]: Starting MariaDB 10.2 database server... -- Subject: Unit mariadb.service has begun start-up -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel --  -- Unit mariadb.service has begun starting up. jun 09 01:29:04 ipx.eu-central-1.compute.internal mysql-prepare-db-dir[15360]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done. jun 09 01:29:04 ipx.eu-central-1.compute.internal mysql-prepare-db-dir[15360]: If this is not the case, make sure the /var/lib/mysql is empty before running mysql-prepare-db-dir. jun 09 01:29:05 ipx.eu-central-1.compute.internal mysqld[15399]: 2020-06-09  1:29:05 140284526120768 [Note] /usr/libexec/mysqld (mysqld 10.2.10-MariaDB) starting as process 15399 ... jun 09 01:29:05 ipx.eu-central-1.compute.internal mysqld[15399]: 2020-06-09  1:29:05 140284526120768 [Warning] Changed limits: max_open_files: 1024  max_connections: 151  table_cache: 431 jun 09 01:29:05 ipx.eu-central-1.compute.internal systemd[1]: Started MariaDB 10.2 database server. -- Subject: Unit mariadb.service has finished start-up -- Defined-By: systemd --  -- Unit mariadb.service has finished starting up. --  -- The start-up result is done. jun 09 01:29:05 ipx.eu-central-1.compute.internal sudo[15322]: pam_unix(sudo:session): session closed for user root 

mariadb.log file:

2020-06-09  1:17:36 140094574546752 [ERROR] InnoDB: Page [page id: space=0, page number=308] log sequence number 41316604 is in the future! Current system log sequence number 1620080.     2020-06-09  1:17:36 140094574546752 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman$       2020-06-09  1:17:36 140094574546752 [ERROR] InnoDB: Operating system error number 13 in a file operation.     2020-06-09  1:17:36 140094574546752 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.     2020-06-09 01:17:36 0x7f6a4f59cf40  InnoDB: Assertion failure in file /builddir/build/BUILD/mariadb-10.2.10/storage/innobase/fil/fil0fil.cc line 752 

mongodump and restore in single command

How to perform mongo DB dump and restore in a single command, by providing source and sink DB and collection name separately?

I understand we can do mongodump and then mongorestore but if I need to this on an intermediate machine, this will mean I will need to wait for mongodump to complete before I can start mongorestore manually again. Is there a way to do it in a single command?

How to restore hit point maximum?

As a DM, I’ve been using a Mummy and one of my players really lost a lot of hit point maximum. In my head, it was clear they’d go to the nearest town and ask for heal to the priest who can cast remove curse to halt the bleeding and greater restoration to get back their hit point maximum, but they only removed the curse (by spell swapping at a level up) and went on.

So I might throw another way to get their hit point maximum on the road, but what? Besides greater restoration (and wish), what are the other ways of getting back all of part of someone’s hit point maximum, especially at level 4-5?