#mysql50#database after MariaDB conversion

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
teethdood
Posts: 267
Joined: Sun Jul 29, 2007 12:39 am
Location: Visalia, CA
Contact:

#mysql50#database after MariaDB conversion

Post by teethdood » Fri Jul 01, 2022 5:37 pm

after MariaDB conversion from MySQL, if your database shows up as #mysql50#database instead of database, then the directory data structure needs to be altered. As always, make a backup.

mysql -u root -p
MariaDB> ALTER DATABASE `#mysql50#database` UPGRADE DATA DIRECTORY NAME;

Note: use ` character above the ~ to the left of 1, not the single quote '

Hope it helps
Philip H. Doan, DDS
http://www.kaweahdental.com/

Post Reply