Vesta Control Panel - Forum

I just completed migrating about 50 sites over and started setting up subdomains. After creating the final database, I log into phpmyadmin and nothing is there. on the left it shows "No databases".

I have probably set up about 40 databases before this, they were all visible but now everything is not visible. My sites are still functional, I just can't databases through phpmyadmin.

Logging in as root on phpmyadmin does not show any databases either.

If I reboot the server the databases show up again until view a database. After everything is not visible until a fresh reboot.

I solved my problem. I opened mysql and ran SHOW TABLES;

It had "Error 1018 (HY000): Can't read dir of '.' (Errno: 24) - so I hit my limit for open files.

I ran "sudo lsof -u mysql" to confirm and I had 1060 files. I increased my limit by adding "open-files-limit = 2048 " in my.cnf

After restarting mysql service I can now see all of my database / tables.