[KevinC]

I am another long-time SQLyog customer who has switched to MariaDB. I think it would be wise to see MariaDB additional capabilities surfaced in SQLyog as they roll out, esp. as plans now call for one or more no SQL data store engines. I don't want to have to switch my MySQL client just to access these additional capabilities.

[KevinC]

'peterlaursen' wrote:

I asked if you could not simple DROP DATABASE for the databases you what to get completely rid of. This was actually meant to be a solution. Right-click the database in the Object Browser (the left pane of SQLyog) .. More Database Options .. DROP Database.

If this fails please tell the exact error (no. and description) you get. And also tell if you use MyISAM tables, InnoBD tables or both.

I don't recall whether they were Inno or MyISAM. Much more likely to be MyISAM as they were huge databases that were totally replaced twice a year with an update (no transactions).

I get error 1051 (Unknown table ' mrdef').

[KevinC]

>

'peterlaursen' wrote:

>1) It is not safe *at all* to delete database files if there are InnoDB tables.

I know, I know. Mea culpa.

>2) if tables are MyISAM it is still not recommended – but should work if all files (.MYI, .MYD and .fm files) are deleted.

>

>

>

>

>It is not SQLyog that *invents* what dabases are there. It is simply not stored locally. It it the server that tells what databases are there, Just execuce “SHOW DATABASES;” But anyway can't you simply DROP now.

! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! !

So how do I “fix” the problem?

I didn't post on this group to get browbeaten by some smart-ass “customer support” who was never taught proper manners.

! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! !

>Please understand that such unauthorized use of MySQL is not our problem and beyond our support. At least not if “SHOW DATABASES;” returns a list of databases from the server identical to what SQLyog displays (what I assume it does).

The DB was running locally on my personal workstation, in my home, which only I use. I hardly think it was unauthorized.

[Author]

Posts