Re: ibbackup and mysql slaves

Jason, - Original Message - From: "Jason Davis" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Saturday, December 18, 2004 1:23 AM Subject: ibbackup and mysql slaves Hello, I have a mysql master and slave server. I use ibbackup to backup the master nightly. I have the lates

joins on temporary tables, and grant statement limitations

MySQL Manual A.7.3 TEMPORARY TABLE "You cannot refer to a TEMPORARY table more than once in the same query." Anything in the works to fix this pretty major limitation? Also, any chance of being able to specify wildcards in table names in GRANT statements any time soon? E.g. GRANT ALL ON test.'t

queries and mail function

Hi, This is my first post so I hope I've done it right. I am having trouble querying an email address from MySQL and then placing that field into the PHP mail function. It doesn't work. Here's my code: $query_string = "SELECT Email FROM instructors WHERE HSA_NO = '$insthsaid'"; $result = mysql_q

ibbackup and mysql slaves

Hello, I have a mysql master and slave server. I use ibbackup to backup the master nightly. I have the latest version of ibbackup and mysql version 4.0.21. Every time I run ibbackup the slave stops replicating. I have to run the following commands twice... SET GLOBAL SQL_SLAVE_SKIP_COUNTER =1;

Index file ratio

Is there a correlation between myisam table file size and related .myi file size ? If I need to introduce additional index for some field in 40-50Gb table, would there be any concerns about my.ini settings like key_buffer_size etc. Is it possible to place index file to memory to speed up things

Re: Quick Question: Year() function result?

Rhino wrote: Does anyone know what Column Type the result of the Year() function is? In other words, if I execute: select Year(Hiredate) as mycolname from mytable; is the result a smallint? a char()? a varchar()? Unfortunately, the manual doesn't say and I can't think of a quick way to figure it ou

Re: Quick Question: Year() function result?

At 03:24 PM 12/17/2004, you wrote: Does anyone know what Column Type the result of the Year() function is? In other words, if I execute: select Year(Hiredate) as mycolname from mytable; is the result a smallint? a char()? a varchar()? Unfortunately, the manual doesn't say and I can't think of a qui

undefined symbol

hi, i want to use an udf function that lives in a library A that is dynamically linked against another library B. when running `create function...' i get error 1126, an undefined symbol in lib A that lives in lib B. when checking A with ldd, all seems ok (lib B is shown and no unresolved symbols ar

Quick Question: Year() function result?

Does anyone know what Column Type the result of the Year() function is? In other words, if I execute: select Year(Hiredate) as mycolname from mytable; is the result a smallint? a char()? a varchar()? Unfortunately, the manual doesn't say and I can't think of a quick way to figure it out R

Re: appropriate column type to store day and time in YYYYMMDDhhmmss format

Jason Joines wrote: I'm using MySQL 4.1.7 and need to create a column to store date and time. Also, I need to be able to update the column with something like: update machines set update3_status='y', update3_time=SOMETHING; I don't want update3_time to be automatically changed any time

Load Data Infile in Stored procedure

I can't seem to make the Load Data statement work inside of a stored procedure. ie LOAD DATA LOCAL INFILE "file.txt" INTO my_table this works fine in PHP, but when I use it in a procedure, and pass in the file name as a parameter, it won't compile. LOAD DATA LOCAL INFILE fileParameter INTO my_

Re: appropriate column type to store day and time in YYYYMMDDhhmmss format

You have 4 options for storing datetime values: You can use an UNSIGNED INTEGER column to store the # of seconds since EPOCH You can use a CHAR or VARCHAR column to store any arbitrary string (including a string that looks like a formatted date) You can use a DATETIME field You can use a TIMESTA

Newbie problem

I am new to MySQL and have an odd problem of which I am hoping someone can assist. I am attempting to insert data into my db using C++ and the C-API. The database connects fine, and I can get a select statement to return data, but the insert will not work from the program. I then had the pro

Re: libmysqlclient name library wrong

On Fri, 17 Dec 2004 16:19:25 -0200 (BRST) [EMAIL PROTECTED] wrote: > >Description: > > Mysql 4.1.8 installs libmysqlclient as libmysqlclient.14.0.0 > instead of libmysqlclient.so.14.0.0 which is the correct for > Linux. I wish you were about 1/2 hour faster, I just finish

libmysqlclient name library wrong

>Description: Mysql 4.1.8 installs libmysqlclient as libmysqlclient.14.0.0 instead of libmysqlclient.so.14.0.0 which is the correct for Linux. >How-To-Repeat: make install >Fix: Correct the installation process >Submitter-Id: >Originator:daniel >Orga

appropriate column type to store day and time in YYYYMMDDhhmmss format

I'm using MySQL 4.1.7 and need to create a column to store date and time. Also, I need to be able to update the column with something like: update machines set update3_status='y', update3_time=SOMETHING; I don't want update3_time to be automatically changed any time another column changes. W

Upgrading to MySQL 5 (for testing)

I have an installation of 4.1 and 5 running on the same test server... I want to start using 5 for testing but still want to use the same test data I had before... Is it possible to simply point MySQL 5 to the old 4 data dir? -- MySQL General Mailing List For list archives: http://lists.mysql.co

Re: What is the "default database"?

Hello. Oops, yes, perhaps I was thinking about some[body] else while answering %-) Sure, the last USEd database is the default one and that's a simplier way to understand the concept of a default database. Thank you. And it's friday! :-) [EMAIL PROTECTED] wrote: > > I guess that tra

Re: No connect to mysql

Hi, I have solved .. I have writed in 'Index' file: cp1251 83 still thanks, thanks gelbs !!. :-)) Salvatore. - Original Message - From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 16, 2004 6:39 PM Subject: Re: No connect to mysql > Hello. > >

Re: Restore help! been going 2 weeks

Can you post your my.ini or my.cnf sense your restore actually worked Mine is not swapping, in fact, mysql is only using 610,824 K of ram, there is still over 1 gig of ram free Our next server will have 16 gig of ram and quad xeons, I'm going to completely disable the swap files -- MySQL Genera

Re: MySQL non-portable with Oracle, MS-SQL, Sybase SQL statements due to ISO non-conformant backslash

Tried the build 5.0.2-alpha-nt: select 'te\''st' returns "te''t" and select 'te\'''st' causes a fast server crash: -ken (the function symbols are missing so a stacktrace is a bit hard) Application exception occurred: App: (pid=1188) When: 12/17/2004 @ 09:07:05.253 Exception

Re: php and mysql

Have you tried posting this to the PHP general mailing list? Respectfully, Ligaya Turmelle --- Life is a game... so have fun. --- www.PHPCommunity.org Open Source, Open Community Visit for more information or to join the movement Fernando F. Retagi wrote: Hi All! I have installed mysql 4.0.20 (wen

Re: Flush_time question and related item

Gleb - Original Message - > Hello. > > > >Does that imply that if we set this flush_time value to zero (ie no > >periodic flush to disk), then some of the data will not be committed to > >disk, and if we had a subsequent power failure, then any data since the > >last flush would be lost

Re: What is the "default database"?

Gleb Paharenko wrote: Hello. I searched a while but could not find an explanation. So the question remains: what is the "default database"? See: http://dev.mysql.com/doc/mysql/en/mysql_select_db.html While it does explain default database, that page documents a function in the Mysql C API. Tha

RE: Restore help! been going 2 weeks

please check the my.cnf parameters with recommended values given in my_huge.cnf file in support files. to my knowledge For 2 GB RAM values you set are very high. I think system is going for heavy swapping that might be the reason it is going very slowly. Anil -Original Message- From:

Re: MySQL non-portable with Oracle, MS-SQL, Sybase SQL statements due to ISO non-conformant backslash

Thanks!!! Yes, I found the bug on it, but it looks like its not working yet Is the bug simply no updated to show the fix perhaps? ken Sergei Golubchik wrote: Hi! On Dec 17, Sergei Golubchik wrote: On Dec 16, Ken Johanson wrote: Hi all, Does anyone know fo a way to run the server in more of a

Re: What is the "default database"?

I guess that translates (for those users not using the C API) to mean whatever database was last "USE"ed ? So if I say "USE Mydatabase", is "Mydatabase" now the default database or does the concept of default database only apply to those users using the C API? Shawn Green Database Administrato

Re: What is the "default database"?

It's the one you're using at that moment. That is, it's the one you don't have to explicitly mention to access its tables. If you connect with mysql [options] db1 or issue a USE db1 command, then db1 is the default database. This is in the manual

Re: How to enable BDB support?

Hello. Your MySQL distribution doesn't have support for BDB. > What do I need to do to enable BDB support on the system that > currently does not have it? See: http://dev.mysql.com/doc/mysql/en/BDB_install.html sol beach <[EMAIL PROTECTED]> wrote: > I have two systems running mysql

Re: Flush_time question and related item

Hello. >Does that imply that if we set this flush_time value to zero (ie no >periodic flush to disk), then some of the data will not be committed to >disk, and if we had a subsequent power failure, then any data since the >last flush would be lost? We have innodb_flush_log_at_trx_commit set

Re: What is the "default database"?

Hello. > I searched a while but could not find an explanation. > So the question remains: > what is the "default database"? See: http://dev.mysql.com/doc/mysql/en/mysql_select_db.html "Dr. Frank Ullrich" <[EMAIL PROTECTED]> wrote: > Hi, > > I came across this term several times

Re: Weird problem upgrading from MySQL 4.0.21 to MySQL 4.1.7/InnoDB mysql db (D'oh)

No InnoDB here, just some old ISAM tables. Sorry about my stupidity on this one, I have only myself to blame... I have a bunch of old-school ISAM tables that need to be converted to MyISAM, is there any way to do this en-masse? (I.E. not having to go through each DB in the DBMS and ALTER TABLE t

Re: Restore help! been going 2 weeks

Are you sure innodb is better for tables larger than 4 gig? | 12 | xotech | localhost:3115 | finlog | Query | 238224 | copy to tmp table | alter table bragg_stat engine=innodb pack_keys=0 | | 14 | xotech | localhost:3356 | NULL | Query | 0 | NULL |

Re: Limit drive usage per thread

mos wrote: At 12:05 PM 12/13/2004, you wrote: Is there any way to limit drive usage per thread? I have a problem where an update thread will use 100 % of the drive, and simple index searches that should be instant will wait and wait and wait before responding. I dont want one user to kill everyb

Re: No connect to mysql

"Gleb Paharenko" wrote: > What output does the following command produce? > myisamchk -dvv host.MYI the result is: myisamchk: File '/usr/share/mysql/charsets/italian.conf' not found (Errcode: 2) myisamchk: Character set '#'83' is not a compiled character set and is not specified in the '/usr/s

Re: Weird load issues

Daniel, - Original Message - From: "Daniel Andersen" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, December 17, 2004 2:04 AM Subject: Weird load issues Hey, A couple days ago my SQL server started hogging the entire CPU for no reason that I can find. I'm running

Re: Relative efficiency (in terms of disk io) between REPLACE and

John, Harrison, - Original Message - From: "John McCaskey" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, December 17, 2004 3:33 AM Subject: Re: Relative efficiency (in terms of disk io) between REPLACE and Ahhh, thats very good to know. Thank you. On Wed, 2004-12

What is the "default database"?

Hi, I came across this term several times while reading about character set and collation handling, e.g. in the last paragraph of the online manual section 10.3.2 (http://dev.mysql.com/doc/mysql/en/Charset-database.html): " The character set and collation for the default database are available a

Re: MySQL non-portable with Oracle, MS-SQL, Sybase SQL statements due to ISO non-conformant backslash

Hi! On Dec 17, Sergei Golubchik wrote: > On Dec 16, Ken Johanson wrote: > > Hi all, > > > > Does anyone know fo a way to run the server in more of a string-quoting > > standards compliant mode, so that a generic SQL string quoting function > > only has to escape single quotes, instead of also '

Re: MySQL non-portable with Oracle, MS-SQL, Sybase SQL statements due to ISO non-conformant backslash

Hi! On Dec 16, Ken Johanson wrote: > Hi all, > > Does anyone know fo a way to run the server in more of a string-quoting > standards compliant mode, so that a generic SQL string quoting function > only has to escape single quotes, instead of also '"', '\', and '\0'? > > I've tried the ANSI_QUO