My Databases not displayed in MySQl Console

Game development with Board Game Arena Studio
Post Reply
User avatar
gameczar
Posts: 18
Joined: 27 November 2022, 20:47

My Databases not displayed in MySQl Console

Post by gameczar »

On Monday, when going to the mySQl console (https://studio.boardgamearena.com/db/index.php) , I could see my tutorial game (Reversi) database and tables. However, since yesterday, they have "disappeared". I can only see the "information_schema" now.

Any idea what caused this?
User avatar
SwHawk
Posts: 133
Joined: 23 August 2015, 16:45

Re: My Databases not displayed in MySQl Console

Post by SwHawk »

If the games were finished it's completely normal. Those databases are deleted every once in a while. There was also a database server maintenance on Tuesday. But your DBs should have been migrated onto the new server.
User avatar
Een
Posts: 3861
Joined: 16 June 2010, 19:52

Re: My Databases not displayed in MySQl Console

Post by Een »

Just like in prod, after a while without games played, tables are closed automatically and databases are garbage collected to free space.
Probably your table was realtime; my advice would be to create turn based tables if you want to keep a table open long term (there is still a limit, but it's over a month).

Edit: just noticed that another answer was posted at the same time, and I wanted to clarify that database maintenance on Tuesday was only for the main site, not the studio. There was no maintenance on the studio.
User avatar
gameczar
Posts: 18
Joined: 27 November 2022, 20:47

Re: My Databases not displayed in MySQl Console

Post by gameczar »

Thank you both. That was exactly the issue.

PS: I created a turn-based table, so that I have more time to study the database.
Post Reply

Return to “Developers”