Hello,
I have a file that contains some SQL statements including CREATE TABLE, INSERT,
UPDATE and specially CREATE VIEW. This file is used to apply changes into the
database.
All databases & tables use the 'DEFAULT CHARSET=latin1
COLLATE=latin1_General_CS', so when creating views, the fields t
Hi Martin,
We have modified all timeout,buffersize,pool related parameters from mysql
server side. However, still we are getting DBCP errors.
We have practice to close the database connection in finally block of java ,
in the std practice order of resultset to conn.close..
What would be other thi
Check the permissions in the datadir.
On Wed, Jun 1, 2011 at 11:50 AM, Adarsh Sharma wrote:
> Thanks, It works & a new error occurs as :
>
> 110601 16:16:16 mysqld_safe Starting mysqld daemon with databases from
> /hdd2-1/myisam_data
> /usr/sbin/mysqld: File '/hdd2-1/myisam_data/mysql-bin.index'
Thanks, It works & a new error occurs as :
110601 16:16:16 mysqld_safe Starting mysqld daemon with databases from
/hdd2-1/myisam_data
/usr/sbin/mysqld: File '/hdd2-1/myisam_data/mysql-bin.index' not found
(Errcode: 13)
110601 16:16:16 [ERROR] Aborting
110601 16:16:16 [Note] /usr/sbin/mysqld:
Hi,
You probably didn't run mysql_install_db.
Peter Boros
On Wed, 2011-06-01 at 15:52 +0530, Adarsh Sharma wrote:
> I got the error after setting my.cnf file in /etc directory.
>
> 110601 15:23:02 [Note] Plugin 'FEDERATED' is disabled.
> /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
>
>
I got the error after setting my.cnf file in /etc directory.
110601 15:23:02 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
After some research i found the cause of this error : the new my.cnf is
very old and mysql_upgrade is needed
So , Can someon
I think the default location on Centos is /etc/my.cnf
Regards
John
On 1 June 2011 10:24, Adarsh Sharma wrote:
> Dear all,
>
> I install mysql in CentOS -5.4 through 2 commands :
>
> yum install mysql-server
> yum install mysql-client
>
> And I can see directories created in /var/lib/mysql direc
You need to provide a my.cnf for your server. There are some sample files
included with the server binaries that you can start with. These won't be
tailored for your application/server so will need to be changed as per your
requirements.
Note that several of the options are static values so will r
Dear all,
I install mysql in CentOS -5.4 through 2 commands :
yum install mysql-server
yum install mysql-client
And I can see directories created in /var/lib/mysql directory.
But now i want to change it to my /hdd1-1 diretcory and alse set logging
directories.
So , I search my.cnf file as:
