Problems with backup and special characters

Restoring a backup of a very large database, I've received an error message by the server (4.13) about an sql syntax error. I've done the backup with mysql administrator and I've used the same procedure for months without problems. I've discovered that problem is into a blob field that store

Re: Disasterous database corruption

On Wednesday 10 August 2005 10:23 am, Daniel Kasak wrote: Fajar Priyanto wrote: Well, it's not 5.0.x, it's 4.0.25-standard. I'm not sure how the error appears in the first place. What I notice when I open the database using phpMyadmin is that that particular troubled table status is in use.

Cleanup of connections

Hi, I've noticed that connections are sometimes left open in MySQL when i use the Show Processlist command. Does MySQL do any form of housekeeping to close old connections or is it just down to the developers to make sure they issue close connection statements? Thanks.

Getting the data dictionary in MySQL 4.1.13

Hi, Initially I used MySQL 5.0.4 for all my development. At that time I used the following SQL query to load the whole data dictionary into my local memory to reduce load on DB as I am using the prepared statements API, that requires column types as one of the inputs. select

Re: Replication, charset / collations Problem

Hello. `key` varchar(255) character set utf8 collate utf8_bin NOT NULL All your character_set_xxx variables have a 'latin1' value, while the `key` column has utf8. In my opinion, this is the root of the problem. Marco P$hler [EMAIL PROTECTED] wrote: Please, send the output of

Re: Problems with backup and special characters

Hello. What do you think about switching to mysqldump with --hex-blob option? [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Restoring a backup of a very large database, I've received an error message by the server (4.13) about an sql syntax error. I've done the backup with mysql

Re: Getting the data dictionary in MySQL 4.1.13

Hello. The common way is to use different 'SHOW' statements, for example 'SHOW CREATE TABLE'. Sometimes mysqldump with --no-data helps a lot. Sujay Koduri [EMAIL PROTECTED] wrote: Hi, Initially I used MySQL 5.0.4 for all my development. At that time I used the following SQL

Re: Cleanup of connections

Hello. What state do MySQL threads of your old connections have? Ben Smith [EMAIL PROTECTED] wrote: [-- text/plain, encoding 7bit, charset: US-ASCII, 23 lines --] Hi, I've noticed that connections are sometimes left open in MySQL when i use the Show Processlist command. Does

RE: Cleanup of connections

-Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: 10 August 2005 09:07 To: mysql@lists.mysql.com Subject: Re: Cleanup of connections Hi, They appear to be in SLEEP state Hello. What state do MySQL threads of your old connections have? Ben Smith [EMAIL

HELP! sql command question for mysql

Hello there, first of all, my english isn't good, hope you understand what I mean. I have a table name p like that: mysql select * from p; +---+---++ | id| price | vendor | +---+---++ | OG012 |40 | a | | OG012 |20 | b | | OG012 |20 | c

RE: JOIN QUERY - UPDATE ... help?!

Brendan Gogarty wrote: We are running mysql 3.23.58 and I want to do a query with joins from two tables and then insert the results into the column of a third. [snip] Shawn Green wrote: Start from here: http://dev.mysql.com/doc/mysql/en/update.html Updates *are* allowed to use JOINED

RE: how to find out the name of the server

Is this information exposed anywhere or am I going to have to write something In particular I want the connection ID And Is the application at the source exposed And Can you trap the login event as a trigger yet? Kn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

Re: Cleanup of connections

Hello. Normally mysqld successfully closes connection if client has correctly disconnected. If you want to debug this issue, please, provide information about your operating system and MySQL version. If your developers connect to MySQL through TCP/IP, check with netstat the state of

Re: Upgrade from 4.018 to 4.1.13 ?

Hello. See: http://dev.mysql.com/doc/mysql/en/upgrade.html m i l e s [EMAIL PROTECTED] wrote: Hi, I have a silly questionDUH Im running OS X Server, I installed 4.018 and I want to run 4.1.13, how do I upgrade the server, without losing anything ? Do I just

Re: Table and Data access only through procedures

Hello. MySQL 5.0.10 offers modifying tables from stored procedures, however I've met some problems. I've tried to create a procedure like your DELETE_USER, but DROP USER seems to accept only literal strings, not variables, while direct modifying of GRANT tables and calling FLUSH privileges

Re: Help table's locked/missing?

Hello. Do you have a shell account? What engines do you use for your tables? In your previous post you said you had tried to repair database (did you want to say table?) while it was in use. What way had you chosen for repairing? If myisamchk - that wasn't good idea on running server. If

RE: Cleanup of connections

I've found out a little more. There is a PHP script that is run from a cron job which goes off and gets data from a 3rd party. Generally this completes just fine but there is another job, a cron job, that Kills this script/connection if it takes more than 2 minutes. I was just wondering if this

SELECT vs SET for creating variables

I am using version 4.0.12-nt on a Windows 2000 machine. I have noticed some difference in the way SET and SELECT create variables. The following statements do not work the way I would expect. SELECT @neededStep := 10; SELECT @startOfCenter := 7; SELECT @returnData := IF(@neededStep =

RE: Table and Data access only through procedures

Gleb, I had already submitted that bug, around a week ago, you can see my version here: http://bugs.mysql.com/bug.php?id=12307 Apparently it's been fixed in 5.0.11.. Now documenting. You may want to update your bug to point to mine and close it off ;) The procedure in the bug causes some

Case issue in Information_schema

Hello, I was just checking INFORMATION_SCHEMA in 5.0.10. All the tables, columns and values are given in CAPS lock. The case is not important in Windows but it is in Linux. Do I assume that even in Linux it will be in CAPS and the case is not going to change in near future? Karam

MYSQLDUMP and Triggers, Functions and SP

Hello, mysqldump bundled with 5.0.10 does not seem to support the above features. Any plans when they will be supported? Karam __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL

mysql 5.0.10 compilation error

Hello, I am trying to compile 5.0.10. While compiling i am getting the following error: e:\mysql5010abetasrc\extra\yassl\src\yassl_imp.cpp(393) : fatal error C1001: INTERNAL COMPILER ERROR (compiler file 'msc1.cpp', line 2701) Please choose the Technical Support command on the

Re: mysql 5.0.10 compilation error

I am trying to compile 5.0.10. While compiling i am getting the following error: e:\mysql5010abetasrc\extra\yassl\src\yassl_imp.cpp(393) : fatal error C1001: INTERNAL COMPILER ERROR (compiler file 'msc1.cpp', line 2701) Please choose the Technical Support command on the

Re: MYSQLDUMP and Triggers, Functions and SP

mysqldump bundled with 5.0.10 does not seem to support the above features. http://dev.mysql.com/doc/mysql/en/mysqldump.html lists triggers in 5.0.11. I see no mention there of functions or stored procedures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

my.cnf not found

hi, I tried installing MySQL4.1.13 and in the process I installed the following packages * MySQL-client-4.1.13-0.i386.rpm * MySQL-server-4.1.13-0.i386.rpm * MySQL-shared-standard-4.1.13-0.rhel3.i386.rpm I am able to make connections to mysql and able to do

Re: mysql 5.0.10 compilation error

I plan to modify mysqldump and mysql import utility to support SP, Triggers etc and plan to send a patch to the MySQL development tree. Thus downloading the binary does not seem to be option :) --- Martijn Tonies [EMAIL PROTECTED] wrote: I am trying to compile 5.0.10. While compiling i am

RE: [SPAM?]: Case issue in Information_schema

Thx. That answered my question. karam --- Mark Leith [EMAIL PROTECTED] wrote: Hi Karam, I'm not sure what you mean by All the tables, columns and values are given in CAPS lock... Certainly, all of the INFORMATION_SCHEMA tables and their columns are defined in upper case. This

Re: UTF8 support in MySQL 4.0

So how can I do that? I've already tried SET CHARACTER SET and it didn't work since someone said its not available in MySQL 4.0. You can store UTF-8 in any database in the world. UTF-8 is compatible with any application capable of dealing with null-terminated strings of 8-bit characters.

Re: my.cnf not found

Sujay Koduri wrote: hi, I tried installing MySQL4.1.13 and in the process I installed the following packages * MySQL-client-4.1.13-0.i386.rpm * MySQL-server-4.1.13-0.i386.rpm * MySQL-shared-standard-4.1.13-0.rhel3.i386.rpm I am able to make connections to mysql and able

Re: SELECT vs SET for creating variables

Bill Dodson wrote: I am using version 4.0.12-nt on a Windows 2000 machine. I have 4.1.11. I have noticed some difference in the way SET and SELECT create variables. The following statements do not work the way I would expect. SELECT @neededStep := 10; SELECT @startOfCenter := 7; SELECT

Re: SELECT vs SET for creating variables

Bill, SELECT @neededStep := 10; SELECT @startOfCenter := 7; SELECT @returnData := IF(@neededStep = @startOfCenter, CONCAT(@neededStep, ' = ', @startOfCenter), CONCAT(@neededStep, ' ', @startOfCenter) ); In the above example @returnData ends up being '10 = 7', but when

Index in the desc order

I am not able to create index with the DESC flag on it. - javabuddy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: my.cnf not found

Thanks a lot stassen :) sujay -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 10, 2005 9:50 PM To: Sujay Koduri Cc: MySQL mailing list Subject: Re: my.cnf not found Sujay Koduri wrote: hi, I tried installing MySQL4.1.13 and in the

Re: Index in the desc order

Gana wrote: I am not able to create index with the DESC flag on it. - javabuddy. Hassan Schroeder answered this exact question just yesterday http://lists.mysql.com/mysql/187582. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Create Index with DESC not working on v5

asdas wrote: It could be a known issue, but thought it's a well known well used feature so, asking you all. I am trying to create an index with the following command - create index an_idx on atable (acol desc, bcol, ccol) Then when I do a - show index from atable It shows for all

Create Index with DESC not working on v5

Thanks a lot Michael, it sure helps. People are conversing... without posting their email or filling up their mail box. ~~1123696760414~~ roomity.com http://roomity.com/launch.jsp No sign up to

MSSQL to MySQL mapping

We have a web based application running on IIS 5.0 using MS SQL Server 2000 as the DBMS; we use ODBC to connect to the DB. We migrated our DB to MySQL and used the MySQL ODBC driver. It appears that some of the SQL statements that are accepted by SQL Server 2000 are not accepted by MySQL. Is

MSSQL to MySQL

We have a web application that uses SQL statements and interacts via an ODBC interface to MS SQL Server. When we changed the DBMS to MySQL some of the SQL statements are not accepted by MySQL. Is there a mapping between MSSQL to MySQL statements? Thank you John C.

Re: Cleanup of connections

Hello. MySQL usually waits some time for data from client even if connection is broken, because MySQL could no nothing about it. The time depends of the socket implementation of your OS (for example for TCP, connection can be marked as established even if the other side is down for several

help with slow query

this query runs slow because AVG and COUNT on maps_rating table i think. can anything be done to improve? query: SELECT maps.*, AVG(maps_rating.rating) AS rating, COUNT(maps_rating.id) AS votes, user.username FROM maps LEFT JOIN maps_rating ON (maps.id = maps_rating.map) LEFT JOIN user ON

OR in Query String

Hi List, I have the following query where I am trying to locate a single students record. I only know that the students record has an id of 3690 and an employer_id of 3 possibles. So I thought that OR would work great. The problem is that it returns all students with employer_id's of 3, 78,

Re: OR in Query String

Justin Palmer wrote: Hi List, I have the following query where I am trying to locate a single students record. I only know that the students record has an id of 3690 and an employer_id of 3 possibles. So I thought that OR would work great. The problem is that it returns all students with

Re: OR in Query String

Justin Palmer wrote: Hi List, I have the following query where I am trying to locate a single students record. I only know that the students record has an id of 3690 and an employer_id of 3 possibles. So I thought that OR would work great. The problem is that it returns all students with

MySQL C API Version incompatibility

hi, I was connecting to MySQL 5.0.4 through the C API and it was workign fine. But when I downgraded to MYSQL 4.1.13, the same code is giving the following error. mysql_stmt_bind_result() failed Using unsupported buffer type: 0 (parameter: 1) I tried uninstalling all the existing mysql

Re: Upgrade from 4.018 to 4.1.13 ?

Are you running the stock Apple MySQL install?? I went through this a few times. If so figure out where the default Apple install places the data dir. The MySQL pkg installers will install everything in: /usr/local/mysql/data/ where: /usr/local/mysql/ is really a symbolic link to each

long text insert failure

Dear Guys, Can please anyone advice me how to successfully insert long text data into my innodb table rawlog with table stucture as follows: mysql desc rawlog; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra |

Re: MSSQL to MySQL mapping

John c wrote: We have a web based application running on IIS 5.0 using MS SQL Server 2000 as the DBMS; we use ODBC to connect to the DB. We migrated our DB to MySQL and used the MySQL ODBC driver. It appears that some of the SQL statements that are accepted by SQL Server 2000 are not

Cannot start mysqld

I installed mysql from the following rpm packages: mysql-4.1.10a-2.RHEL4.1 mysql-server-4.1.10a-2.RHEL4.1 I tried running 'mysqld start' and the server said startup failed. Here is the mysq.log: 050810 20:26:48 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: