Backup fails on mysql tables after renaming user account

[JeffreydeV]

Hello, a few days ago I have renamed some of my directadmin user accounts using change_username.sh.

Everything went well except for a few tables in mysql. Those that used a different engine (InnoDB instead of the standard MyISAM) are not showing anymore (in phpmyadmin, aswell in it's own database and the information scheme). At first this wasn't really a problem since these tables where only there for testing.
However now my backups fail.

I get the following message:

Error while backing up database sql02_000000002
mysqldump error output: mysqldump: Got error: 1146: Table 'sql02_000000002.dataPageBlock' doesn't exist when using LOCK TABLES

Does anyone know how I can show these tables again so I can remove them?
Or how I just remove them in the first place?

 

[scsi]

You might need to run a repair database

 

[JeffreydeV]

Thank you for your suggestion

I tried the following:

mysqlcheck -u[user] -p[password] --check --auto-repair --all-databases

While checking the databases it shows:

sql02_000000002.dataPageBlock
Error    : Table 'sql02_000000002.dataPageBlock' doesn't exist
error    : Corrupt

And at the end of the file:

Repairing tables
sql02_000000002.dataPageBlock
Error    : Table 'sql02_000000002.dataPageBlock' doesn't exist
error    : Corrupt

I have a feeling that even though the database name now has changed to sql02_000000002 that its internal name(?) is still the old database name.
However I have no idea how I could check this.

-- edit --
Also when I login using da_admin to mysql and try to drop the specific table it gives me the following message:

Unknown table 'dataPageBlock'

-- solution --

What I did to make it work again:

DROP TABLE dataPageBlock;

You will get an error:

Unknown table 'dataPageBlock'

Then recreate the table (if you skip the first step you will get an error here):

CREATE TABLE IF NOT EXISTS `dataPageBlock` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Then I ran the mysql repair tool:

mysqlcheck -u[user] -p[password] --check --auto-repair --all-databases

And dropped the table again:

DROP TABLE dataPageBlock;

Now without getting the error.