MySQL Database Forum

I am trying to resolve the following mysql error: File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 22) Character set '#33' is not a compiled character set and is not specified in the 'c:\mysql\share\charsets\Index' I am using mysql version 5.0 on windows xp. I have copied the share directory to the specified path, I have...

Hi there , i have a small problem ! not that much ! Im using JAVA and connecting to mysql databases Im using update comment to update First name, last name, email and password ! and when the user update his\her information, he\she cans update all information + can set a new email and this email could be availabe in my data ( i...

Expand full for viewing... I have a parent/child table. The basic setup is as follows: The parent table is called load sheet. It has fields such as Tripno, carrier, loaddate, etc. The child table contains the actual stop offs, in other words the shipper, load city, load state, etc. If a pick then shipper, otherwise a consignee. I have no...

Dear all, I have mysql 4.1.11 on my current server, i need my database restore another server.. (another server mysql version is 4.1.11 same.) And now... I just created new my database to new server following command: CREATE DATABASE dbname DEFAULT CHARACTER SET latin5 COLLATE

hi, i would like know about mysql's ipv6 support, i installed mysql 5.0.19 from a source dist and no configuration option is provided to enable ipv6. do you know some tips about? regards fusillo

I notice with PHP if a connection cannot be established to a mysql server with mysql_connect() PHP will timeout and never try the backup server. In this example: $db = mysql_connect('db1.local.net', 'username', 'password'); if (!$db) { $db = mysql_connect('db2.local.net', 'username', 'password'); } This works great and connects to the...

I haven't started using Seqouia/C-jdbc but I am probing the ability to do something like this: Controller CW has 2 controllers under it - C1 & C2. C1 is local and has a host HA with X.db's tables t1 & t2. C2 is remote and has a host HB also with X.db's tables t1 & t2. Controller CR has 2 controllers under it - C3 & C4. C3 is local and...

Hi all, I have 2 questions regarding performance: 1) I'm building a monitoring system that has to store lots of sensor data that I 'll have to query from time to time. I have pressure and temperature. Since we sample every 500 ms we will get lots of data after some time. Will my performance increase by making 2 tables; one with pressure...

Hello everyone. I created a new user with the grant command and yet, I can't login into the database I must mention that the user was created but all the privileges are set to 'N'. This is what i get trying to login with the new user I created. "ERROR 1045 (28000): Access denied for user 'nsac'@'localhost' (using password: YES)"

Hello, I have a field that have wrong typed data, for example the date in that field looks like 20-04-2006 (day month year) and i need to convert it to 2006-04-20. What is a possible way to do this ? thx

Hi I need to write a little Windows utility in C++ to retrieve data from a mysql database that belongs to a Linux backup program called Bacula. The data I am getting consists of hex values where I would have expected a character string e.g. instead of Abcd I get 41626364. Something to do with Unicode I expect but I can't find out how to...

Suppose I have a MySQL 5 table with a DateTime field in it. The table has two records where the time is blank. Running: SELECT CAST(DateTimeField AS TIME) FROM MyTable shows two records with NULL as the resultset. Running: SELECT * FROM MyTable WHERE CAST(DateTimeField AS TIME)=NULL

Hi all, I am using MySQL 5.0, and developing an internal WebApplication (Java based, running on Tomcat). Every morning, I have the following error http://sagamore.free.fr/draft/stackTrace._CSLDBtxt]. As far as I know, this is due to some kind of connection timeout that did not happen before version 5 of MySQL.

SELECT s.id, s.student_first_name, s.student_last_name, IF(s.student_ethnicity_interest_other IS NOT NULL AND s.student_ethnicity_interest_other != '', CONCAT(s.student_ethnicity_interest_other, ',', GROUP_CONCAT(e.ethnicity_name ORDER BY upper(e.ethnicity_name))), GROUP_CONCAT(e.ethnicity_name ORDER BY upper(e.ethnicity_name)) ) AS...

Hi I would like to have two mysql instances syncing with eachother over https. So I dont want to do any tunneling or have any ports but 443 open. Any ideas?

Hi all I inherited a server running MySQL 4.* from a previous developer. Now, the records on this database might be what I want, or they might just be test data. I think my only chance of finding out if this is the real thing is to find the date and time of the last insert into the database. How can I do that?

For this example I have eliminated (most of) the unreferenced columns from the table definitions. My problem is: how does one formulate a select statement or create a view in SQL (I'm using MySQL (Ver 14.7 Distrib 4.1.16)) that implements the pseudo-code that follows the table definitions? BTW, I _have_ read the manual (several times). ...

I'm trying to list my categories and how many items are in each category. I'm not much on sub queries. How can I combine these two items. I'd like to display the category and the corresponding number of items in each Cats: Select Category.CategoryID, Category.Category,

Hi, I'm able to access the MySQL database in the same pc using http://localhost:1684/mydir/myapp.aspx. For this I'm using the following few things: Server:localhost, username:root, pwd:no. But instead of localhost, if i use the ip address like this http://192.168.12.105/mydir/myapp.aspx. Now I'm just using following few things:...

Hi All I have 2 question, the first one I hope I don't start an argurment ! How secure is MySQL? I have been asked by a client to create a windows based application that will control / transfer / edit over HTTP. The data will be

Hey guys, I have a problem with mysql general log, regarding query logging. I'm running Win2K, mysql 4.1.10 with JBoss 4.0.2. When I turn on logging, the statements executed from JBoss and logged by mysql look like this: SELECT uuid from tablex AS a WHERE a.id = ?; MySQL never logs the parameters of the statements. Can somebody tell me...

How can I stop a function in PHP? When comparing data I want to stop the function on a hit. Function compare($data) { For ($n=1; $n<=10000; $n++) {

Hello, I have done tons of searching on this topic but have yet to find something relavent to the problem I am experiencing so I am hoping someone can help me. The problem I am having is that using Perl to insert some rows into a MySQL database, some entries that are being inserted include backslashes. For example, here is one error I...

When I access mysql through localhost it works. When I use my IP number is does not. What should this tell me? networking config? firewall? hosts.allow? Googling on the error message leads nowhere. for example: root@0# mysql --socket=/var/lib/mysql/mysql.sock -p -u root --host=localhost Enter password: Welcome to the MySQL monitor. ...

Hi I am having problems with the HAVING clause. I know it can use aliases but the alias I am using has a space in it, eg 'Device ID' My querry looks like (simplified, devID is a calculation) SELECT devID AS 'Device ID' FROM tblDevice HAVING 'Device ID' = '123' and it does not work