Is it it posiible to combine the C++ algorithm code, the MYSQL source code and the UDF code into a single DLL/SO?

2011-09-08 Thread Frank Chang
Good afternoon, We developed a C++ class algorithm and code together with sqlite3.c and the sqlite C/C++ UDFs. Everything is combined into a single Windows DLL/UNIX-LINUX SO Now we would like to change from SQLite to MySQL to take advantage of MySQL's ability to do parallel writes on separate

Re: Is it it posiible to combine the C++ algorithm code, the MYSQL source code and the UDF code into a single DLL/SO?

2011-09-08 Thread Frank Chang
, 2011 at 12:46 PM, Frank Chang frankchan...@gmail.com wrote: Good afternoon, We developed a C++ class algorithm and code together with sqlite3.c and the sqlite C/C++ UDFs. Everything is combined into a single Windows DLL/UNIX-LINUX SO Now we would like to change from SQLite to MySQL to take

Problems posting to the list lists.mysql.com

2010-02-15 Thread Frank Becker
is used for spam purposes nor I offered products. Please, how can I use the list so that I can response to posts? I read the list via gmane.org Best regards Frank Becker -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Looking for a developer, Adelaide, Australia

2009-05-30 Thread Frank J Bruzzaniti
I'm looking to engage a developer with php / mysql experience in Adelaide, Australia for full time employment or contract basis. Please email me if you are interested. Regards, Frank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Database Import from Oracle

2009-03-24 Thread frank fischer
be interessting to, how I will have to import the data. Does this work once, or will I have to divide the data in several parts for import? Best Greetings, Frank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub

Question about Master-Master replication: Is this possible?

2009-01-13 Thread Frank Becker
regards Frank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Question about Master-Master replication: Is this possible?

2009-01-13 Thread Frank Becker
of desaster. You asked for arrows. Here are they: Master3 (virtual) -- Master1 -- Master2 (virtual) ^ | v Master4 (virtual) Thank you for your help. Frank Becker -- MySQL General Mailing List For list archives

Single query possible?

2008-11-12 Thread Frank Rust
' not; etc. If there would be no possibility to do that, how could I redesign my tables? Best regards, Frank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Changing the location of my.ini and the order option files are read

2008-10-06 Thread Frank Black
Varuna Seneviratna schrieb: I added a line to the [mysqld) group As --defaults-file=C:\WINDOWS\my.ini and then I restarted the service.Everything was fine.Then I took out the my.ini file in the MySQL instalation directory the result was an error message AS Could Not start the MySQL Service on

MySQL crash on Debian Etch system

2007-11-22 Thread Frank Niedermann
why MySQL crashed? Regards, Frank -- View this message in context: http://www.nabble.com/MySQL-crash-on-Debian-Etch-system-tf4857583.html#a13900443 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Problem with repeated replication corruption - Could not parse relay log event entry

2007-10-08 Thread Frank Bottone
down the production database to resync the two and get replication going again. We mainly use the replica for backup purposes in order to avoid downtime during the backup and in the event of a hardware issue with the master. Thanks, Frank -- The sender of this email subscribes to Perimeter

Re: Problem with repeated replication corruption - Could not parse relay log event entry

2007-10-08 Thread Frank Bottone
effort than it was worth, so the systems might be slightly out of sync. Perhaps I can just ignore the checksum differences for that particular table... I'll let you know the results. Thanks, Frank Baron Schwartz wrote: Frank, Frank Bottone wrote: I've been having trouble with my master

Re: SELECT /*!40001 SQL_NO_CACHE */ * FROM `ROUTEDATA` message

2006-11-16 Thread Dr. Frank Ullrich
you can set up more slaves to spread the workload even more From what you told about the completion time of your dump it seems you should re-design your whole MySQL setup. Regards, Frank. -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str

Row count discrepancy when converting from MyISAM to InnoDB

2006-07-25 Thread Frank
will be posting output from my latest conversion attempt in some time. --Frank

Re: Row count discrepancy when converting from MyISAM to InnoDB

2006-07-25 Thread Frank
Thank you to everyone who replied. It turned out I had index corruption and after running an OPTIMIZE TABLE I was able to convert all the records to InnoDB. Thanks, Frank

connecting to the embedded server

2006-07-19 Thread Frank
to the embedded server? Regards, Frank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: connecting to the embedded server

2006-07-19 Thread Frank
Jim Winstead wrote: On Thu, Jul 20, 2006 at 08:41:23AM +1200, Frank wrote: Dear all, is it a desired feature that the embedded version of the client library still tries to create a network connection when I pass a hostname into connect? Yes, the embedded version also acts as a standard

InnoDB buffer cache internals available?

2006-07-13 Thread Dr. Frank Ullrich
Hi, in order to size the innodb buffer cache optimally it would really be beneficial to see what it is composed of and how much memory each of the components (also internal structures!) consumes. Is there any chance to get this information? Regards, Frank. -- Dr. Frank Ullrich, DBA

Re: How to find matching tables that have specific field name.

2006-06-07 Thread Frank
tables in the information_schema database: http://dev.mysql.com/doc/refman/5.0/en/information-schema.html In case you are using an older version, you need to issue a show tables query, iterate over all the tables, execute a describe TABLE statement for each and parse the output. Cheers Frank

Re: mysqldump and foreign keys

2006-04-27 Thread Frank
Nico Rittner wrote: Hi Frank what I meant was: are you sure that the tables which are in your database are defined correctly, i.e. have the actions? Yes, if i try to delete or update a record which is referenced by another i get mysql error #1217 , which should be correct. might have

Re: innodb file per table

2006-04-26 Thread Dr. Frank Ullrich
(*.ibd). Regards, Frank. -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538 -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: mysqldump and foreign keys

2006-04-25 Thread Frank
? What do you see when you execute show create table groups? Cheers Frank mysqldump -d test child -- MySQL dump 10.9 -- -- Host: 127.0.0.1Database: test -- -- -- Server version 4.1.13 /*!40101 SET @OLD_CHARACTER_SET_CLIENT

Re: mysqldump and foreign keys

2006-04-25 Thread Frank
correctly, i.e. have the actions? The fact that show create table does not display them, implies that they might have been lost somewhere. Can you post the statement which has been used to create the groups table in the first place. Cheers Frank -- MySQL General Mailing List For list archives

Re: mysqldump and foreign keys

2006-04-24 Thread Frank
, Nico Hi Nico, are you using the InnoDB storage engine for your tables? If not, the clauses will not be included in the dump, as only InnoDB supports foreign keys. When you create a non-InnoDB table which has a foreign key specification, MySQL just ignores the specification. Cheers Frank -- MySQL

Re: Run Apache/PHP/MySQL from CD?

2006-04-20 Thread Frank
the required portability. If portability is not such a concern for you, check out dwebpro, it's quite good. Another project, I've tried but with which I was not very happy is WAMPonCD (http://www.x-author.de/en/tools/amp/x-author.html). Cheers Frank -- MySQL General Mailing List For list

Re: mysqldump question

2006-04-17 Thread Frank
. is there switch that puts it back to the old way of separate inserts for each row? Thanks Randy Hi Randy, since 4.something extended-inserts are used by default. Use mysqldump --extended-insert=false to get the old behaviour. Cheers Frank -- MySQL General Mailing List For list archives

Re: bind-address question

2006-04-16 Thread Frank
address (so it binds to two, but not all available addresses) - how can I do this in the my.cnf file? Thanks, ANdrew. Hi Andrew, judging by a quick look at the source of 5.0.18, I would say, that this is not possible. You can either bind to one or all addresses. Cheers Frank see sql

Re: writing to a database on a read-only medium

2006-04-11 Thread Frank
sheeri kritzer wrote: Frank, 1) Check out the FEDERATED storage engine, that might help. 2) You cannot specify a different location for a read database and a write database. 3) Another solution is to use multiple databases -- each database is just a directory, so you could try

Re: Determining if a trigger exists

2006-04-10 Thread Frank
in the right direction? Hi Adrian you can check whether a trigger exists by querying the information schema database: http://dev.mysql.com/doc/refman/5.0/en/triggers-table.html Hope that helps. Cheers Frank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Query help with count and join on same table I think

2006-04-10 Thread Frank
Cheers Frank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

writing to a database on a read-only medium

2006-04-07 Thread Frank
across a filesystem according to rules which you can set largely as needed), I could not find any description of how this could be done, or whether it has actually been implemented. The solution should work with either MyISAM or INNODB, or better still, be independent of the engine. Cheers, Frank

Re: newbee error (1044)

2006-03-27 Thread Frank Delatorre
zm_create.sql.in ERROR 1045 (28000): Access denied for user 'frank'@'localhost' (using password: NO) It wants to default to the OS user who is logged in and that user is NOT in the mysql database and does not need to be. I tried to insert the -u root but got a syntax error . Any ideas

Re: newbee error (1044)

2006-03-23 Thread Frank Delatorre
at [EMAIL PROTECTED] www.sify.com - your homepage on the internet for news, sports, finance, astrology, movies, entertainment, food, languages etc -- Frank DeLaTorre 408.390.0415

RE: Replication A-B-C - changes on B are not replicated to C

2006-01-03 Thread Frank Fischer
a little bit confused right now so any help is very welcome. Greetings Frank From: Glebnbsp;PaharenkoDate: December 28 2005 4:01pm Subject: Re: Replication A-B-C - changes on B are not replicated to C Hello. So now my question is: is it basically possible to do this or doesn't mysql

Replication A-B-C - changes on B are not replicated to C

2005-12-28 Thread Frank Fischer
this or doesn't mysql replication mechanism support this setup? If it is possible: Any idea where the problem could be? If it's not possible: any idea for a different setup that would allow to this? Thanks a lot for your help. Kind regards Frank

SELECT all except ... ?

2005-12-08 Thread Frank Rust
? -- Frank Rust, Technische Universität, Institut für Theoretische Informatik Tel.: +49 531 391 9525 Postfach 3329, D-38023 Braunschweig Fax.: +49 531 391 9529 Mühlenpfordtstr. 22-23, D-38106 Braunschweig -- MySQL General Mailing List

Multiple MySQL services running on the same machine

2005-11-09 Thread Frank Fischer
service names and refering to different my.cnf files? Thanks a lot for your help! - Frank

RE: Multiple MySQL services running on the same machine

2005-11-09 Thread Frank Fischer
Hi all I got it - just found another posting that briefly explains how it's done. I gave it a quick try on my workstation and i works (nevertheless i dunno what i shall do with 3 instances of mysql on my workstation lol). http://lists.mysql.com/mysql/115628 Cheers -Frank -Original Message

Saving creation date

2005-08-16 Thread Frank Busch
an error. I know, that I'm able to use creation=now() in the insert statement, but parts of the code are encrypted and I can't change them. So I need a way to handle that without modifying the statements. Got any ideas? Frank Busch

Re: How to use Like Clause in Perl? Works fine in MySQL control center!

2005-07-22 Thread Frank Bax
At 07:03 PM 7/22/05, Siegfried Heintze wrote: I'm having trouble getting the like clause to work. It seems to work fine in the MySQL Control Center 9.4.beta. I'm using MySQL 4.0.23-debug. use DBH; my $sth = DBH-prepare(SELECT 'David!' LIKE '%D%v%'); $sth-execute(); my $row; print

Re: Which Engine to use...

2005-07-21 Thread Frank Bax
At 09:39 AM 7/21/05, Scott Hamm wrote: M$ SQL executed and brought up result in 2 seconds where MySQL took 801 seconds and where Batch datalength is around 18.5 MB, QAErrors is around 464KB and QA is around 3.5MB Did you create an index? -- MySQL General Mailing List For list archives:

Re: offer a solution ?

2005-07-02 Thread Frank Bax
At 01:49 PM 7/2/05, nephish wrote: i am writing a database to track what a bunch of electric monitors are doing. the status of the monitor changes almost daily. i need access to each monitor, when it changed, and i also need to track its history. Easy enough. but if i update a row in a table,

Re: offer a solution ?

2005-07-02 Thread Frank Bax
will be _much_ easier to work with. If you want a history then you need to insert a new record for each datapoint that you get, with, as Frank suggested, a date/time column. How large your table will get will depend on the number of monitors and how often you retrieve data. Depending on how

Re: Optimizing Per-Table-Tablespaces

2005-06-22 Thread Dr. Frank Ullrich
://www.mysqluc.com/pub/w/35/sessions.html New InnoDB Features David Regards, Frank. -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538 -- MySQL General

Re: Need help

2005-06-18 Thread Frank Bax
At 09:01 AM 6/18/05, madderla sreedhar wrote: Isn't MySql supports large amounts of data to be stored in databases. What is the maximum number of records that can be handled or stored in Mysql. Is there any limit. If i want to store large amounts of data then is it necessary to migrate to

Re: Need help with a query..

2005-06-16 Thread Frank Bax
At 03:09 AM 6/16/05, Cory Robin wrote: I need to speed up a search, big time. I have an application that searches for records on a date field. If it doesn't find an exact date match, it keeps searching adjacent days until it finds a certain amount of records. The problem now is, I'm using my

Re: How to load a remote db with lots of data?

2005-06-13 Thread Frank Bax
At 10:00 AM 6/13/05, Brian Dunning wrote: I have to load my remote MySQL db's with about a gig of data - phpMyAdmin only allows me to upload a 15MB CSV file, so I have to painstakingly separate my data into 15MB chunks and upload them one at a time. It's a huge pain and takes about two entire

Re: How to load a remote db with lots of data?

2005-06-13 Thread Frank Bax
At 10:36 AM 6/13/05, Brian Dunning wrote: On Jun 13, 2005, at 7:18 AM, Berman, Mikhail wrote: How about an FTP service on your remote server? No - I actually don't have any remote access directly to the MySQL server. My ISP has separate machines for the database servers and the web servers

Re: LOAD DATA INFILE - still confused

2005-06-08 Thread Frank Bax
Wrong path, you are referring to an uri, not a path. Way off topic to starting explaining basic file system stuff here. You should be the same path you used when your uploaded the file. Something like: /home/chris/datafile.txt Frank At 10:06 PM 6/7/05, Chris wrote: Well

Re: LOAD DATA INFILE - still confused

2005-06-07 Thread Frank Bax
At 03:59 PM 6/7/05, Chris wrote: I have a simple php script which runs the following query: LOAD DATA INFILE 'datafile.txt' INTO TABLE LocationTEMPSR12 FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\r\n' which generates the error: File './mydabasename/datafile.txt' not found

Re: How to get the name of the last failed FK constraint

2005-06-02 Thread Frank Schröder
? -- Frank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to get the name of the last failed FK constraint

2005-06-01 Thread Frank Schröder
[EMAIL PROTECTED] wrote: Frank Schröder [EMAIL PROTECTED] wrote on 05/31/2005 03:18:11 AM: Hello, I have an InnoDB table running on MySQL 4.1.11 with multiple FK constraints. I'm accessing it via JDBC from Java. When an FK constraint fails with error 1216 I need to know which

How to get the name of the last failed FK constraint

2005-05-31 Thread Frank Schröder
`u_registration_ibfk_1` FOREIGN KEY (`DEVICE_ID`) REFERENCES `u_device` (`DEVICE_ID`) ... Is there a way of getting to the name of the last failed FK constraint without using SHOW INNODB STATUS? What I need is the 'u_registration_ibfk_1' from the above example. Any help is highly appreciated -- Frank

Re: problem loading dates from txt file

2005-05-31 Thread Frank Bax
At 05:23 AM 5/31/05, James M. Gonzalez wrote: Im loading rows from a txt tab separated fields file into a MySQL table. It mostly works, but the date format in one field is not the type that MySQL likes. So right now Im loading it as a char field. Yes, it is ugly and a pain to work with. I would

Re: Using MySQL to store/archive code/html etc?

2005-05-27 Thread Frank Bax
At 02:46 PM 5/27/05, zzapper wrote: Today I designed a fairly cute error404.php page, which I'd like to reuse in future. Currently I rely on remembering that I created such a page for say ACME Carpets. Now and again my memory fails to remember which site I developed a piece of

Re: Foreign keys - No action - Errors

2005-05-24 Thread Frank Schröder
My understanding is that RESTRICT and NO ACTION share the same behavior. http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html * |NO ACTION|: In |ANSI SQL-92| standard, |NO ACTION| means /no action/ in the sense that an attempt to delete or update a primary

How to get the name of the last failed FK constraint

2005-05-23 Thread Frank Schrder
-- Frank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Efficiently finding a random record

2005-05-13 Thread Frank Bax
At 12:54 PM 5/13/05, Brian Dunning wrote: I have a db of about 300,000 records and when I try to find one random record like this: select * from table order by rand() limit 1; it can take several minutes. My Sherlock Holmes instincts tell me that what I'm doing is somehow inefficient. What is the

Re: Solution to slow queries

2005-05-10 Thread Frank Bax
At 02:22 PM 5/10/05, Paul Halliday wrote: Now, as time progresses the queires are getting slower and slower. I know this is expected, I don't think so. I thought that if the number of rows returned does not change and an index is properly used, then query time should not change significantly

Re: Hardware requirements

2005-05-06 Thread Frank Bax
. This platform is not the answer to every environment; like those that require features only available in beta releases. Frank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: why NOT NULL in PRIMARY key??

2005-04-27 Thread Frank Bax
At 11:07 AM 4/27/05, Jigal van Hemert wrote: So, if we would define that the key entry 0-NULL-Whatever equals 0-NULL-Whatever (which MySQL is capable of if you look at the definition of UNIQUE indexes with BDB tables) then allowing NULLs as part of a key entry would not permit duplicate entries.

RE: why NOT NULL in PRIMARY key??

2005-04-26 Thread Frank Bax
At 08:49 AM 4/26/05, Jay Blanchard wrote: [snip] http://dev.mysql.com/doc/mysql/en/silent-column-changes.html mentions that Columns that are part of a PRIMARY KEY are made NOT NULL even if not declared that way. And http://dev.mysql.com/doc/mysql/en/create-table.html tells me that A PRIMARY KEY

Re: question about chunking sql uploads

2005-04-25 Thread Frank Bax
At 10:44 AM 4/25/05, Art.M (Wikki) wrote: I have a large .sql file to upload which is about 9 mb and I was wondering if anyone knew of a program that could break it up into chunks of 2 mb or under? So I can upload it to a shared web server. You can't upload a 9M file to webserver? But you can

Re: question about chunking sql uploads

2005-04-25 Thread Frank Bax
At 02:07 PM 4/25/05, Scott Gifford wrote: [EMAIL PROTECTED] writes: Frank Bax [EMAIL PROTECTED] wrote on 04/25/2005 11:47:12 AM: Or simply use split, default is 1000 lines, but can be changed via command line. That's a start, but the files each need to be a valid SQL statement, so that's

RE: Write to a mysql table from Excel

2005-04-22 Thread Frank Bax
At 03:12 PM 4/22/05, Jay Blanchard wrote: [snip] Thank you for your reply. Can you provide more details on how to write to a MySQL table from Excel? I am a newbie to MySQL. Thanks. [/snip] You must be new to mailing lists too... http://catb.org/~esr/faqs/smart-questions.html You can save the excel

Re: SQL to list table names

2005-04-21 Thread Frank Bax
At 11:22 AM 4/21/05, Darryl Hoar wrote: I am running Mysql 3.23. Is there an sql statment that will allow me programmatically to retrieve the names of the tables in a database ? show tables; Yes, this is an SQL statement! -- MySQL General Mailing List For list archives:

Re: Newbie trying the impossible?

2005-04-21 Thread Frank Bax
At 03:20 PM 4/21/05, Scott Hamm wrote: However when I used left join (trying to learn it) I issued this command: SELECT QA.OperatorID, QA.QAID, QA.BrandID, QA.Batch, QA.KeyDate, Batch.[Order], Batch.Errors, Batch.Comments FROM

Re: which one is faster

2005-04-15 Thread Frank Bax
At 09:22 AM 4/15/05, DebugasRu wrote: taken from the manual 3.6.2 The Row Holding the Maximum of a Certain Column which of the two queries will in general be faster: 1) SELECT article, dealer, price FROM shop WHERE price=(SELECT MAX(price) FROM shop); 2) SELECT article, dealer, price FROM

Re: Computer reboots during long table join

2005-04-15 Thread Frank Bax
At 11:21 AM 4/15/05, Ian Gibbons wrote: On 15 Apr 2005 at 9:47, mos wrote: I'm running MySQL 4.1.10 on XP and I was doing a 2 table equi join join on a date field that was indexed. There are It was taking quite a long time so I let it run overnight. There are 200 million rows in the first

Re: Cannot execute query - Can't find file: (error: 9)

2005-04-07 Thread Frank Bax
a file? If I create a table and run a select on it, then there is no access to that table for months (and MySQL is not shutdown or restarted), does MySQL still have the file open? Yes, I ran myisamchk and there are no problems with database. Frank At 02:36 PM 4/6/05, V. M. Brasseur wrote: According

Re: Cannot execute query - Can't find file: (error: 9)

2005-04-06 Thread Frank Bax
At 10:07 AM 4/5/05, Frank Bax wrote: At 04:27 PM 4/4/05, Frank Bax wrote: Cannot execute query. snip my SQL statement Can't find file: './donor/list_lst.frm' (errno: 9) - - I got the same error last week on a different table. Today I notice that there is a table in another database

Re: Cannot execute query - Can't find file: (error: 9)

2005-04-05 Thread Frank Bax
At 04:27 PM 4/4/05, Frank Bax wrote: Cannot execute query. snip my SQL statement Can't find file: './donor/list_lst.frm' (errno: 9) - - I got the same error last week on a different table. Today I notice that there is a table in another database on same system producing the same

Cannot execute query - Can't find file: (error: 9)

2005-04-04 Thread Frank Bax
, but it just locked up after entering password. Start/stop mysql and mysql cli at least started but issued errors about some tables even before I entered a command. I decided to reboot and the problem goes away (for a while). MySQL 4.0.20 - OpenBSD 3.6 Frank -- MySQL General Mailing List

Re: certain content is causing an error with INSERT - please help

2005-02-13 Thread Frank Busch
you have backslashes in you strings. You should double them, too. Frank I fixed it. But I'm not clear on why. The following code ie. taking the content and blatently putting the content through addslashes(): $descrip_field=addslashes($descrip_field); Fixed it. But the code

AW: certain content is causing an error with INSERT - please help

2005-02-13 Thread Frank Busch
things easy of trust on automatism. This always works. Put all the checks and escapes into a function and call it instead of mysql_real_escape_string... Then everything will be fine. Frank Busch ... leegold wrote: I'm ripping hair out, here's the problem...I'm trying to insert content

AW: selection problem

2005-02-08 Thread Frank Busch
species_c | +--+ 3 rows in set (0.00 sec) That's quiet near, I guess Frank Busch -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

AMD64 and thread stack size

2005-01-28 Thread Frank Denis \(Jedi/Sector One\)
. They weren't doing anything, just as if they were waiting for a dead lock. It didn't happen with MySQL 4.0 on the same hardware. Bumping up the thread stack to 256 K seems to fix the issue, both with and without NPTL. Best regards, -Frank. -- MySQL General Mailing List

2 gigs limits on MyISAM indexes?

2005-01-28 Thread Frank Denis \(Jedi/Sector One\)
and to keep the server working? Best regards, -Frank. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 2 gigs limits on MyISAM indexes?

2005-01-28 Thread Frank Denis \(Jedi/Sector One\)
On Fri, Jan 28, 2005 at 04:00:24PM +, Mat wrote: What Operating System are you running this on? Linux 2.6, 64 bits. MySQL 4.1.9. Also, is there anything in the errorlog? Nothing, but as soon as I restart the server, it enters a strange state where all slots are full with

Re: Replication Slave I/O Thread won't start on 4.1.8

2005-01-18 Thread Frank Febbraro
One thing I left out is that we are running 4.1.8-Max-log not 4.1.8-standard-log Could that have anything to do with it? Thanks for any insight, Frank On Mon, 17 Jan 2005 15:55:06 -0500, Frank Febbraro [EMAIL PROTECTED] wrote: Hey all, I have setup replication in the past on 4.0.x

Re: Replication Slave I/O Thread won't start on 4.1.8

2005-01-18 Thread Frank Febbraro
now. thanks again. Frank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Replication Slave I/O Thread won't start on 4.1.8

2005-01-17 Thread Frank Febbraro
never starts. There are no error messages in any logs, or the show slave status screen. Below are my relevant configurations. I am very sorry if I have left anything significant out. Thank you for any help, Frank MASTER CONFIG ~~ [EMAIL PROTECTED] cat /etc/my.cnf [mysqld

RE: create sequence

2005-01-13 Thread Frank Bax
You obviously do not understand auto-increment capability. You wouldn't get that value of the sequence, because you would always retrieve the same value. You would have to add a row to the 'extra' table for the auto-increment field to work as designed, then use the highest value of

Rows_sent vs Rows_examined

2005-01-12 Thread Frank Denis \(Jedi/Sector One\)
comment_base and id_commentaire (primary key) from comment_content. My obvious question is: why 3187 rows were examined since everything is indexed and there's only one matching entry of the comment_content table for every comment_base entry? Best regards, -- Frank - my stupid blog: http

replacing field contents?

2005-01-10 Thread Robin Lynn Frank
starts XXX, I want it replaced with XXX with only the new text following. TIA -- Robin Lynn Frank - Director of Operations - Paradigm-Omega, LLC Website: http://www.paradigm-omega.com/ RSS: http://paradigm-omega.blogspot.com/atom.xml Spamtraps: http://paradigm-omega.net/cgi-bin

Re: Why DATETIME takes 8 bytes?

2005-01-08 Thread Frank Bax
At 06:00 AM 1/8/05, Ehud Shapira wrote: I don't understand why DATETIME takes 8 bytes. It's just a waste, since DATE+TIME take 6 bytes. And in fact, while DATE and TIME are each rounded up to bytes on its own, a combined DATETIME should only take 5 bytes: 14 bits for year 04 bits for month 05

RE: Why DATETIME takes 8 bytes?

2005-01-08 Thread Frank Bax
At 12:15 PM 1/8/05, Tom Crimmins wrote: [snip] datetime is displayed as -MM-DD HH:MM:SS - it is *not* stored that way. It is stored as a *nix timestamp - an integer number of seconds since 1970-01-01 00:00:00. [/snip] Actually datetime is not stored as epoch time. It has a range from

Re: Trouble w/ mysqldump (images attached)

2005-01-07 Thread Dr. Frank Ullrich
)? As a further test I would suggest that you take the data table (.myd file?) from the 4.1.8 db and copy it into a __test__ 3.23 db replacing the data table there (it's myisam isn't it?). See if the avatars are ok when you read them from the 3.23 db. Regards, Frank. I'm not too sure where or what

select datetime older than X weeks

2005-01-06 Thread Frank Bax
I'm using OpenBSD 3.6 (latest version) which comes with binary packages for MySQL 4.0.20 - More recent binary packages are not yet available for this platform and installation from source is not an option. I have a table with datetime field and I would like to select all data older than X

Show Innodb Status: Output truncated

2004-12-27 Thread Dr. Frank Ullrich
long. What causes that behaviour and can you work around the problem? Regards, Frank. -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538 -- MySQL

are autoincrement values not always increasing in innodb?

2004-12-26 Thread Frank Sonntag
of the table. The inserts corresponding to ids (10, 11, 12, 13) are done inside one transaction, the insert that generates id = 5, in another (concurrent) one. Cheers Frank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: are autoincrement values not always increasing in innodb?

2004-12-26 Thread Frank Sonntag
I am aware of that. But from my experience MySQL returns the the rows in the order that you inserted them. Assuming this is the case, I was wondering if the result I have seen means that the order of autoincrement values does not correspond to the order in which inserts are done. Frank

Re: What is the default database?

2004-12-20 Thread Dr. Frank Ullrich
Michael, Gleb, thanks a lot for your hints! Now I know that default database means current database. And I did not find Section 13.3.2 in the fine manual because I searched for default database and we find the string default (current) database there :-( . Regards, Frank. Michael Stassen

Current Timestamp upon creating of a record

2004-12-18 Thread Frank Fischer
just once upon creation time without any changes later on. How could this be done? Thanks a lot for your help Frank

What is the default database?

2004-12-17 Thread Dr. Frank Ullrich
the question remains: what is the default database? Regards, Frank. -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538 -- MySQL General Mailing List

InnoDB status: why do I see MyISAM requests?

2004-12-12 Thread Frank Denis \(Jedi/Sector One\)
Just curious... While running SHOW INNODB STATUS, the list of transactions for each sessions part shows queries that are only related to MyISAM tables. Is it the expected behavior? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

mysqlcc

2004-12-10 Thread Robin Lynn Frank
I'm obviously missing something. I can use mysqlcc to change data in a row of a table and save it. But, if I try to insert a row, add data and save it, it never gets saved. What am I overlooking? -- /\ ASCII RIBBON Robin Lynn Frank \ / CAMPAIGN Director of Operations X AGAINST

Re: problems with php 4.3.9 / mysql 4.1.7

2004-12-08 Thread Frank Denis \(Jedi/Sector One\)
On Wed, Dec 08, 2004 at 11:25:55AM +0100, Bogdan TARU wrote: Everything went ok, up until the point when I tried linking PHP-4.3.9 against MySQL-4.1.7. After starting the new Apache/PHP (ldd httpd shows '/usr/local/mysql-4.1.7/lib/mysql/libmysqlclient.so.14'), I get a whole lot of

MySQL 4.1.7 Network slowdown

2004-12-07 Thread Frank Febbraro
connection problem. Can someone please provide a pointer or two to try to determine what is going on? 4.0.x was significantly faster, but I now need subqueries. Thanks in advance, Frank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: MySQL 4.1.7 Network slowdown

2004-12-07 Thread Frank Febbraro
|| +-+--+--+-+-++ Really nothing special to speak of. Thanks for helping me out, Frank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

  1   2   3   >