MySQL Bugs: #65589: Not able see the databases which has created by alfresco share

Bug #65589	Not able see the databases which has created by alfresco share
Submitted:	12 Jun 2012 6:46	Modified:	25 Oct 2012 0:11
Reporter:	Amarnath Lingshetty	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S5 (Performance)
Version:	5.5.16	OS:	Linux
Assigned to:		CPU Architecture:	Any

Description:
Every time i execute mysqldump command i get this error message:
mysqldump:got error 1049 "unknown database when selecting the databases"
even thought the database exist.

mysql\bin>mysqldump -u root -p dbname > dump.sql
mysqldump:got error 1049 "unknown database dbname when selecting the databases"

i tied with all possible syntax butresult is same...
The content of dump file:

-- MySQL dump 10.13  Distrib 5.5.16, for Win32 (x86)
--
-- Host: localhost    Database: dbname
-- ------------------------------------------------------
-- Server version	5.0.83-community

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES UTF8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Not dumping tablespaces as no INFORMATION_SCHEMA.FILES table on this server
--

How to repeat:
create the databse with appropriate login credentials...
and try to dackup the database which you created...
using mysqldump command..
mysql\bin>mysqldump -u root -p dbname > dump.sql

 

Suggested fix:
please go though this error message....

screenshot

Attachment: files.zip (application/x-zip-compressed, text), 54.43 KiB.

Please, upload the entire error log of your server (should be <hostname>.err file in the datadir). I suspect you had upgraded from some older version and something was missed during upgrade.

logfile,scrrenshot,dump file

Attachment: updated.zip (application/x-zip-compressed, text), 106.87 KiB.

I do not see any messages related to problematic t6ables in mysql database, so my assumption about problematic upgrade was wrong.

I wonder, though, why you restart your server all the time soon after startup:

120607 16:36:50 [Note] D:\AlfrescoApp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16'  socket: ''  port: 3307  MySQL Community Server (GPL)
120607 16:42:26 [Note] D:\AlfrescoApp\mysql\bin\mysqld.exe: Normal shutdown

120607 16:42:26 [Note] Event Scheduler: Purging the queue. 0 events
120607 16:42:26  InnoDB: Starting shutdown...
120607 16:42:27  InnoDB: Shutdown completed; log sequence number 216536634
120607 16:42:27 [Note] D:\AlfrescoApp\mysql\bin\mysqld.exe: Shutdown complete

As for the database that you can not dump, please, connect with mysql command line client and send the output of:

show databases;

Then, please, specify the exact database name you are trying to dump (from this list).

Sorry, I see SHOW DATABASES results on your screenshot. So, looks like the problematic database is called "dbname". Let's double check it this way:

select concat('>', concat(schema_name, '<')) name, length(schema_name) size 
from information_schema.schemata 
where schema_name like 'db%'\G

its not with dbanme,i cant even dump any of the databases which are listed there....

the output of above query...
name:>dbname<
size:6
1 row in set(0.13sec)

output of query

Attachment: out.7z (application/octet-stream, text), 28.73 KiB.

Please, send the output of:

mysqldump --version

Also, please, consider upgrade to recent version, 5.5.25.

The output of above query is :
mysqldump  Ver 10.13 Distrib 5.5.16, for Win32 (x86)

your mysql client using one version of server and your mysqldump another.
you probably have a wrong host in [mysql] or [mysqldump] or [client] sections of my.ini.

try running mysql and mysqldump with --no-defaults as the first argument
and explicitly specify the host and port on the command line.

Thanx for information...

Envirnoment:Linux
Not able to see the databases which already exist...
i have installed alfresco in linux envirnoment which intrun creates the bitnami_alfresco database.. the applications runs fine
and bitnami_alfresco is updated on every interaction with user..

but in mysql i cant able to see that database itself 
port number which i am using:3305 

i tried with folloeing commands

mysql>bin>mysql -u root --port 3305 -h localhost 
mysql>show databases;
but database bitnami_alfresco is not listed

any suggestion plz

I've noted port 3307 in your log previously, now you speak about port 3305. Are you sure you check on the same instance where database was created? Please, double check.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Exact same issue here. Always the bogus error "Unknown database" when the database does exist.

Please reopen

Did anybody find a workaround?

Please reply last @Valeriy Kravchuk question. Thanks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".