[bmac88]

To "rename" the database I had to export it:
$ mysqldump -u root -p -v a78 > ~/a78.sql
then create the aa78 database:
$ mysqladmin -u root -p create aa78
then import the exported a78 to the new aa78 database:
$ mysql -u root -p aa78 < ~/a78.sql

THEN I open HeidiSQL and "drop" the original a78 database.
Then I run Kodi and it creates the a90 and a48 databases.
To get the pastebin script to run without errors, I had to remove all b c d and e databases first.
Result: /* Affected rows: 8 Found rows: 0 Warnings: 0 Duration for 284 queries: 3.897 sec. */

When I run the two queries in post #118 I get:
/* SQL Error (1050): Table 'seasonview' already exists */
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 0 of 1 query: 0.000 sec. */
and...
/* SQL Error (1050): Table 'tvshowcounts' already exists */
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 0 of 1 query: 0.000 sec. */
...respectively.

Until I get clarification I am going to attempt importing my library backups anyways. Also, I'm really not understanding in HeidiSQL how you can run the query on a specific database. It seems to just run the query globally. i.e. you can't run the query just for a90 or run the query just for b90. At least, I don't understand how to do it?? you say:

If you have done this open b90(...c90...d90) do the same job again.

EDIT: I figured it out! After waiting for my library to import and seeing that my 2nd and third profile TV shows weren't accessible, it became more clear. You don't have to (or they don't appear to do anything) run the post 118 scripts on a90, just b90, c90, d90 and e90.
If anyone else is having any trouble, I feel stupid that I didn't figure this out sooner, but you just click on the b90 database icon so it's highlighted in the HeidiSQL tree in the left. then run the first query and then the second query. Highlight c90 and run both queries and so on...