Re: Using Replication in mySQL version 5

2008-11-19 Thread Roman Eberle
Date: Mon, 17 Nov 2008 10:16:16 + From: Tompkins Neil [EMAIL PROTECTED] Subject: Using Replication in mySQL version 5 We are looking to upgrade our version of mySQL to the latest version of mySQL 5. One of the main features we are going to think about using is replication for our website

Basic information: MySQL Table crash?

2008-10-31 Thread Roman Eberle
can one take to avoid a table crash? Are there any symptoms that show up when a table crash is about to happen? (like: out of swap memory, disk full, too much system load, ...?) Any comments/hints/links appreciated, thanks in advance, regards, Roman -- MySQL General Mailing List For list

crystal reports andd mysql

2006-10-31 Thread Roberto William Aranda-W Roman
hello everybody anybody had to deal with this? i have a windows form created on VB.net to get a report on embbeded crystal reports develop program im trying to customize the fields to show by using the CR form via Sql Sintax option for the fields but the formula editor seems does not

excel and Mysql?!

2006-10-18 Thread Roberto William Aranda-W Roman
hello . anybody knows how to export from excel to mysql in order to create or fill a database table?? tanks for your help and patience cheers

data time wrong format between mysql 5.01 and visual.net

2006-08-29 Thread Roberto William Aranda-W Roman
hello i'm developing a program on visual.net 2003 where i need to extract data from a date time format column working with mysql.net component for extract via mysqlcommands and dataadapters im fillin datagrills but the column displayed only presents the date but not the time im still

Re: innodb_buffer_pool_size / *_buffer_size relation

2004-01-08 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2004-01-08 13:26:26 +0200: Lhettj: Roman Neuhauser [EMAIL PROTECTED] # [EMAIL PROTECTED] / 2004-01-06 10:57:52 +0200: From: Roman Neuhauser [EMAIL PROTECTED] My first question is: what is the interaction between MySQL's *_buffer_size and InnoDB's

innodb_buffer_pool_size / *_buffer_size relation

2004-01-05 Thread Roman Neuhauser
I've been trying to tune a MySQL installation a bit, and have a few questions regarding relations/interactions between InnoDB and MySQL when it comes to the various buffers... I wanted this mail to be more specific, but given the lack of info in the manual, I basically don't have much cannon

Re: High load on not used server

2004-01-05 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2004-01-05 13:49:17 +0200: I'm running MySQL 4.0.17 on FreeBSD machine. i have one process which rarely uses Mysql DB, and few postfix processes which uses db for authorizaton. In `top` i see that mysql process usually eats 40-50% +/-20. `mytop` show ~5 sleeping processes

Re: innodb: storage requirements

2003-09-26 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-09-25 08:58:09 +0300: From: Roman Neuhauser [EMAIL PROTECTED] Also, is there a way to *measure* the fragmentation of a table? If there is, how should the info be interpreted? Sorry, no. But adding such a feature would be easy: just look at page numbers, page

Re: multiple foreign key references on one column

2003-09-26 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-09-25 14:59:33 +0100: CREATE TABLE `pheno` ( `id` smallint(5) unsigned NOT NULL auto_increment, `relevant` enum('y','n') default NULL, `phenotype` varchar(50) NOT NULL default '', PRIMARY KEY (`id`,`phenotype`), KEY `id` (`id`), CONSTRAINT `0_125`

Re: FOREIGN KEY Weirdness in mySQL 4.1 with VARCHAR

2003-09-26 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-09-26 15:12:03 -0700: --- Harald Fuchs [EMAIL PROTECTED] wrote: Ed Smith [EMAIL PROTECTED] writes: Greetings. When I execute the SQL script below in mySQL 4.1, I get ERROR 1216: Cannot add or update a child row: a foreign key constraint fails It

Re: Sub-selects

2003-09-24 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-09-24 02:32:10 -0600: According to documentation, in MySQL version 4.0, it is possible to use sub-selects According to what documentation? -- If you cc me or remove the list(s) completely I'll most likely ignore your message.see

Re: innodb: storage requirements

2003-09-24 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-09-23 21:56:55 +0300: From: Roman Neuhauser [EMAIL PROTECTED] A simple question regarding storage allocated / reported by MySQL/InnoDB. If BIGINT takes 8 bytes, and a table has exactly four BIGINT columns, why is the reported avg. row length 148 bytes? the table

Re: innodb: storage requirements

2003-09-24 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-09-24 17:41:29 +0300: the row count in SHOW TABLE STATUS is only an estimate based on 8 dives into the index tree. ok. You had a typical symptom of a fragmented table: space usage much bigger than you would expect. that doesn't answer my questions :)

innodb: storage requirements

2003-09-23 Thread Roman Neuhauser
A simple question regarding storage allocated / reported by MySQL/InnoDB. If BIGINT takes 8 bytes, and a table has exactly four BIGINT columns, why is the reported avg. row length 148 bytes? mysql show table status from pmsystem2 like 'editor_competence_product'\G *** 1.

crash after 15 minutes

2003-09-02 Thread Roman Hochuli
get useful logs for the developers? any help is appreciated. -- Kind regards, Roman Hochuli CCNP, CQS Cable GPS-Technik AG Zürcherstrasse 139 8952 Schlieren Switzerland Tel +41-1-7329977 Fax +41-1-7311840 X-NCC-RegID: ch.gps While talking a little bit annoyed about taxes: ...at least it does

Re: Replacing data in 1 table from another

2003-06-29 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-17 11:44:46 -0400: At 05:14 PM 6/16/2003, Roman Neuhauser wrote: # [EMAIL PROTECTED] / 2003-06-16 15:15:31 -0400: I can use: SELECT sum(if(voidreason0,0,amt)) as sales FROM sdtik where acctno=1234 and datein=20020615 to gather customers' sales totals

Re: joins

2003-06-29 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-29 08:14:28 +0100: The table customer_basket contains the products_id which is no good for my routine. What I need to check is the categories_id but there is no reference in the customers_basket. Presumably I need to do a join on the table that holds the

Re: Lookup used Version of MySql MySql Foreign Keys and Referencial Integrity

2003-06-29 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-28 16:56:13 +0200: I use mySQL on HP/UX 11.i - unfortunateley I am unable to lookup the used version. What is the command to do that? (according to mysql.info it is Version 3.23.42. ) SELECT VERSION(); -- If you cc me or remove the list(s) completely I'll

Re: two-field primary key update issue

2003-06-29 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-29 13:09:03 -0500: CREATE TABLE extraFieldOptions ( fieldID tinyint(3) unsigned NOT NULL default '0', fieldOption varchar(16) NOT NULL default '', fieldValue varchar(16) NOT NULL default '', PRIMARY KEY (fieldID,fieldOption) ) TYPE=MyISAM; mysql

Re: two-field primary key update issue

2003-06-29 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-29 23:24:58 -0500: # [EMAIL PROTECTED] / 2003-06-29 13:09:03 -0500: CREATE TABLE extraFieldOptions ( fieldID tinyint(3) unsigned NOT NULL default '0', fieldOption varchar(16) NOT NULL default '', fieldValue varchar(16) NOT NULL default '',

Re: Can't compile on NetBSD

2003-06-28 Thread Roman Neuhauser
please don't top-post. # [EMAIL PROTECTED] / 2003-06-27 14:01:58 -0400: On Fri, 27 Jun 2003, Roman Neuhauser wrote: # [EMAIL PROTECTED] / 2003-06-20 11:07:09 -0400: I am trying to compile MySQL 3.23.57 on NetBSD 1.6.1. I downloadded pthreads-1_60_beta6-mysql.tar.gz from your site

Re: Drop Foreign Key

2003-06-27 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-27 09:45:06 +0200: how can i delete an foreign key between two tables? Is there a drop foreign key - command available? yes, read: http://www.innodb.com/ibman.html#InnoDB_foreign_keys -- If you cc me or remove the list(s) completely I'll most likely

Re: Can't compile on NetBSD

2003-06-27 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-20 11:07:09 -0400: Hello, I am trying to compile MySQL 3.23.57 on NetBSD 1.6.1. I downloadded pthreads-1_60_beta6-mysql.tar.gz from your site and extracted it to mysql-3.23.57/ I ran ./configure --with-mit-threads in mysql-3.23.57 and everything went fine.

Re: mysqlhotcopy / bin-log manipulation

2003-06-27 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-27 14:44:55 +0200: I have a question regarding mysqlhotcopy's use. I'd like to use the --flushlog option in order to have a nice backup synchronized log for my replication slave in case of recover need (without stopping the master). But the lock used by

Re: datetime column dummy question

2003-06-25 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-25 12:05:49 +0800: //Wrong sql statement alter table p_asset add mydate datetime default now(); alter table p_asset add mydate datetime default time(); alter table p_asset add mydate datetime default now; alter table p_asset add mydate

Re: default value does not set using LOAD DATA INFILE ...

2003-06-25 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-25 15:18:09 +1000: From: Roman Neuhauser [EMAIL PROTECTED] please don't piggyback on other people's threads. you can start your own for free. Although it was the first time for me to send the post on this list, I was sure that I did not follow other

Re: datetime column dummy question

2003-06-25 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-25 06:18:04 +0100: Sometime recently MaFai said: A table contains a column named mydate. //Wrong sql statement alter table p_asset add mydate datetime default now(); alter table p_asset add mydate datetime default time(); alter

Re: datetime column dummy question

2003-06-25 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-25 07:10:46 +0100: Sometime recently Roman Neuhauser said: # [EMAIL PROTECTED] / 2003-06-25 06:18:04 +0100: alter table p_asset add mydate datetime default 'now()'; - you need the '' around now(); apparently http://www.mysql.com/doc/en

Re: Initializing primary key values for existing table

2003-06-25 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-25 02:11:05 -0400: I needed to add a new, autoincrementing, primary key column to a table and have been struggling to figure out how to assign an initial, unique value to each row. I finally accomplished my task, but feel sure there's an easier way. Here

Re: Query Execution Time in mysql

2003-06-25 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-24 20:32:48 -0700: insert into table1 select * from table2; Table2 has some 10,000 records while table1 has around 11,00,000 records. The time reqd. to execute the above query is round about 80- 90 secs. The table1 has 7 columns out of which 5 are composite

Re: KEYS error 1216

2003-06-25 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-25 14:03:17 +0100: Im altering a number of table from MyISAM to innoDb and adding foreign keys. The alteration of the table type works. Adding the row as an index works. Adding the foreign key fails, generating the error: alter table project add FOREIGN KEY

Re: user@% vs user@localhost question

2003-06-25 Thread Roman Neuhauser
your MUA doesn't properly represent quotation marks, breaking them in other MUAs. # [EMAIL PROTECTED] / 2003-06-25 04:51:49 -0700: This follows on a previous mail from me: When using GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY ?password? I could not get the password

Re: Access denied for user: '@localhost' to database 'mysql'

2003-06-24 Thread Roman Neuhauser
don't piggyback on other people's threads. you can start your own for free. # [EMAIL PROTECTED] / 2003-06-19 13:23:04 -0700: I ran a command which was part of the installation process for some php accounting software. update user set host='%' where host='localhost' and user='root';

Re: Foreign Key Concept

2003-06-24 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-24 16:48:24 +0800: After I create this table,and add foreign key tno to this table. If I delete tno in p_program_type table,it would alarm that some data still in p_schedule. How can I define the p_schedule or p_program_type table to make sure that while delete

Re: Transaction support

2003-06-24 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-24 15:15:33 +0530: Does MYSQL support transaction concept, which includes issues like commiting data , rollbacking etc??? Did you know MySQL has documentation? -- If you cc me or remove the list(s) completely I'll most likely ignore your message.

Re: Transaction support

2003-06-24 Thread Roman Neuhauser
:02 -0700: Roman Neuhauser wrote: # [EMAIL PROTECTED] / 2003-06-24 15:15:33 +0530: Does MYSQL support transaction concept, which includes issues like commiting data , rollbacking etc??? Did you know MySQL has documentation? Yes mysql supports transactions ... they only work

Re: Can you get the results of an UPDATE command?

2003-06-24 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-24 01:02:17 -0600: But, I need to know which rows were modified, not simply how many. So far this is the best that I have come up with LOCK TABLES MyTable WRITE SELECT * FROM MyTable WHERE SomeRecord = OldValue UPDATE MyTable SET SomeRecord = NewValue WHERE

Re: Can't find file: './mysql/host.frm' (errno: 13)

2003-06-24 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-23 16:16:50 -0400: I installed MySQL (mysql-standard-4.0.13-apple-darwin6.4-powerpc) ... but now I get this error in the log file and I am unable to still start the MySQL Server. 030623 15:59:05 Fatal error: Can't open privilege tables: Can't find file:

Re: update to 4.0 mySQL question

2003-06-24 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-23 11:11:28 -0400: I have updated mySQL to the 4.0.13-standard and had no problems UNTIL I attempted to run mysql_fix_privileges. This is the error I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) /tmp is:

Re: why me??!

2003-06-23 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-21 12:35:04 -0700: I'm trying to load a couple tons of data into a shopping cart system and for some reason it keeps kicking back with an error. I'm too dumb to figure out why. Can anyone tell me what's wrong with this code and why it doesn't work? I can

mysql 4.0.13 and show databases topic

2003-06-19 Thread Roman
Hello, I have installed mysql 4.0.13 but suddenly all users can see names of all databases on the server in phpmyadmin (show databases command afaik) Is there something to avoid it ??? Sincerely, Roman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: MySQL Error Log problem.

2003-06-18 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-18 12:24:06 -0400: [psg:/usr/local/mysql] psgarcha% sudo ./bin/mysqld_safe [5] 703 [psg:/usr/local/mysql] psgarcha% Starting mysqld daemon with databases from /usr/local/mysql/data 030618 11:50:09 mysqld ended [5]Done sudo

Re: extensive unicode support: no LIKE with unicode? - slightly absurd solution

2003-06-17 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-17 10:59:13 +0200: On Mon, Jun 16, 2003 at 11:56:59PM +0200, Roman Neuhauser wrote: # [EMAIL PROTECTED] / 2003-06-16 15:27:21 +0200: mysql select * from unitest WHERE t LIKE 'A%'; ERROR 1210: Wrong arguments to like SELECT * FROM unitest

Re: Triggers

2003-06-17 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-17 21:28:12 +0300: From: Kerry Colligan [EMAIL PROTECTED] I see that 5.x will support triggers. Does anyone have any advice for implementation of triggers on the DB? I will need to be able to utilize them from web applications AND from command-line type

Re: a MOVE command?

2003-06-16 Thread Roman Neuhauser
lines as long as 380 characters are hard to read. hit enter every now and then, please. # [EMAIL PROTECTED] / 2003-06-15 17:47:39 -0700: I created the following function to move a record from one table to another. The only difference in the table structures are the auto-incremented id

Re: several key values in one field?

2003-06-16 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-16 14:47:19 -0500: Content-Type: text/plain; charset=ks_c_5601-1987 ?... posting in english would yield more replies. -- If you cc me or remove the list(s)

Re: several key values in one field?

2003-06-16 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-16 15:23:21 -0500: I thought it was written in EnglishIt wasn't? It was written in English, but your MUA labeled it as being encoded with ks_c_5601-1987. Is that a Korean charset? Non-broken MUA will obey the header, and display it as though it was

Re: How to have AUTO_INCREMENT ignoring 0?

2003-06-16 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-16 21:09:14 +0200: In AUTO_INCREMENT fields, inserting a 0 into the field requests a new sequence number. Is it possible to turn off this behaviour? I doubt that. (without messing with the code, of course) I doubt that some more. Using NULL to get

Re: Replacing data in 1 table from another

2003-06-16 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-16 15:15:31 -0400: I have two tables... Table 1 newdata contains a lot of statistical data on our customers, including last 12months sales amt. table 2 sdtik contains all ticket information for all customers. Both tables have acctno as primary key. I can use:

Re: Can not run mysql_install_db

2003-06-16 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-16 12:01:57 +: I installed the mysql 4.0 pkg on Mac OS 10.2, then I followed the installation instruction. It works fine. I then tried to create database, but is saysAccess denied. I checked Show database , there is only one database in, which is 'test'.

Re: extensive unicode support: no LIKE with unicode?

2003-06-16 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-16 15:27:21 +0200: I'm trying to use 4.1.0-alpha's extensive unicode support. [...] Now I try to read the data, this time from the commandline client: mysql select * from unitest WHERE ID=72; ++---+---+ | ID | vc|

Re: Can not run mysql_install_db

2003-06-16 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-17 11:25:36 +0900: Hi Roman, just saw this by chance. sockstat -4l | grep 3306. I never heard of such a tool , also I did not find any info on the internet. I assume you dont mean sock, of course. Could you let me know where I can find the tool

Re: Which database?

2003-06-10 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-10 14:38:49 +0300: I am fairly new to databases, but my boss has assigned me to choose a database system for our company. I know of Oracle databases but they are way too expensive so it's not an option for us. I did some research and came up with two free

Re: Which database?

2003-06-10 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-10 14:11:39 +0100: (...) lack of commercial support company means you are unlikely to get the same level of support. unlikely? perhaps. but... how many OS programs do you use, how many of them have commercial support, and how do those that have

Re: Mysql language

2003-06-06 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-06 09:21:32 -0400: Heikki Tuuri wrote: InnoDB is totally C, MySQL half C++ and half C, with a few hundred lines of x86 Assembler. Oh? I thought that MySQL ran on Mac OSX as well as various Intel platforms. the parts that are written in assembler are also

Re: Specifics on using join multiple tables

2003-06-05 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-04 09:17:01 -0400: acc.name, acc.phone, acc.acctno, sales1.amt as mo1sales, sales2.amt as mo2sales, (sales1.amt - sales2.amt) as diff SORT by diff I need all data in sales1 and sales2, but only for records from acc that are in either/both sales1, sales2. I

Re: out f memory error

2003-06-05 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-04 16:37:08 +0300: I have a program that runs a loop,in every loop I execute a query. the query itself is very efficient, the result of the query is 4 rows at most but... after a while I get the following error: Out of memory! Bus error (core dumped) how can

Re: debuggine 1205 / LOCK wait timeout exceeded errors

2003-06-05 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-04 17:11:19 +0300: Roman, looks like your application fails to commit this transaction: 030604 13:52:21 INNODB MONITOR OUTPUT ... LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 407759, ACTIVE 2090 sec, OS thread id 10251 10 lock struct(s), heap

Re: debuggine 1205 / LOCK wait timeout exceeded errors

2003-06-05 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-04 17:11:19 +0300: Roman, looks like your application fails to commit this transaction: 030604 13:52:21 INNODB MONITOR OUTPUT ... LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 407759, ACTIVE 2090 sec, OS thread id 10251 10 lock struct(s), heap

debuggine 1205 / LOCK wait timeout exceeded errors

2003-06-04 Thread Roman Neuhauser
Hi there, I have a problem with LOCKs. I use InnoDB tables and transactions. [EMAIL PROTECTED] ~ 1001:0 /usr/local/libexec/mysqld --version /usr/local/libexec/mysqld Ver 4.0.13 for portbld-freebsd4.8 on i386 [EMAIL PROTECTED] ~ 1002:0 uname -sr FreeBSD 4.8-RC [EMAIL PROTECTED] ~ 1003:0 httpd

Re: C API

2003-06-04 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-03 18:45:31 +0200: Executing gcc.exe... gcc.exe U:\mep\Dev\abr.c -o U:\mep\Dev\abr.exe -IC:\Dev-Cpp\include -IC:\mysql\include -LC:\Dev-Cpp\lib C:\DOCUME~1\badier1\LOCALS~1\Temp/ccW8.o(.text+0x1d2):abr.c: undefined reference to [EMAIL PROTECTED]'

Re: Mysql / PHP image link problem.

2003-06-04 Thread Roman Neuhauser
keep the lines at or under 72 characters, please. # [EMAIL PROTECTED] / 2003-06-03 19:20:17 +0100: To display in my web page im using: img src=?php echo $row_Recordset1['imagecolumn']; ? This displays the above images in my html page The problem i have is where the field in my

Re: debuggine 1205 / LOCK wait timeout exceeded errors

2003-06-04 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-03 22:59:47 +0300: you can use SHOW INNODB STATUS to look what active transactions you have and how many lock structs they have. Also innodb_lock_monitor helps. Hi Heikki, thanks for the reply. I have dropped the database, recreated it, stopped the

Re: database design : 3 month later

2003-04-02 Thread Roman Neuhauser
X-Mailer: Microsoft Outlook, Build 10.0.2616 your MUA wrap-mutilates quoted text. # [EMAIL PROTECTED] / 2003-04-02 02:34:01 +0200: 1. If a column is a primary key, there is no need to declare it a unique. Thank you, I was doing that for every table since I

Re: database design : 3 month later

2003-04-02 Thread 'Roman Neuhauser'
# [EMAIL PROTECTED] / 2003-04-02 17:37:26 +0200: And from this page: http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html I understand it is rather recommended NOT to use foreign keys, at least until mysql integrates it more fully. which part of that page makes you say that? --

Re: Regular Expression / Replace Help

2003-03-31 Thread Roman Neuhauser
forgot to cc the list... # [EMAIL PROTECTED] / 2003-03-18 08:06:37 -0700: On Sunday, March 16, 2003, at 03:33 AM, Roman Neuhauser wrote: # [EMAIL PROTECTED] / 2003-03-15 08:29:51 -0700: On Thursday, March 13, 2003, at 12:46 PM, Roman Neuhauser wrote: # [EMAIL PROTECTED] / 2003-03-13 11

Re: MySql, PHP, and Dates

2003-03-31 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-03-31 07:38:44 -0500: Uttam wrote: u can use highly customizabe MySQL DATE_FORMAT() function for retrieving date in desired format. Thanks for the detailed information. For manipulating date in php, u can use the MySQL UNIX_TIMESTAMP(date) function to return

Re: MySql, PHP, and Dates

2003-03-30 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-03-28 21:47:28 -0500: I'm experienced with SQL, but new to MySql and PHP, which I'm using together to create a dynamic web site. Right now, I'm having minor difficulties with date formatting. It seems that when I retrieve a date from MySQL into PHP, it shows up

Re: OS X install for Unix dummy

2003-03-30 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-03-29 21:52:18 -0500: I just downloaded and installed the mysql-max-4.0.12.pkg, ran cd /usr/local/mysql sudo ./bin/mysqld_safe (Enter your password) (Press CTRL+Z) (Press CTRL+D to exit the shell) bg as specified in the readme. When attempting to

Re: database design : 3 month later

2003-03-30 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-03-30 17:49:27 +0200: Hello, I was starting a php/mysql project in december and seeked for help on this mailing list, it has been a great help for solving problems. My application is a website where you can order meals from restaurants that are within your postcode

Re: InnoDB Foreign Keys

2003-03-25 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-03-24 23:49:59 +0100: this is what Mysql Reference Manual tells me about creating foreign keys. I understood how to use them, except for the restrict here ---\ | [CONSTRAINT symbol] FOREIGN KEY

Re: php link informix problem

2003-03-24 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-03-24 16:51:25 +0800: I have a mysql+php+apache server,It must have some program to call another informix database,I don't know how to configure my php,anyone have good resource help me?? yes. http://www.php.net/manual/, and if that fails,

Re: Regular Expression / Replace Help

2003-03-13 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-03-13 11:51:52 -0700: This is not proper syntax, but I would think it is close... select replace(contact_phone, REGEXP ^[1234567890],'') from individual; I don't use REs in MySQL, but inverse classes are written [^spec], not ^[spec]. -- If you cc me or

Re: count rows

2003-02-28 Thread Roman Sanchez
Here's a nice MySQL simple returning records query question! I want to return a staement saying 'number of records shave been found' for your selection. so presumably this is a simple row count based on the the returning recordset? Andrew Either with PHP or C you can use mysql_num_rows()

error in left join

2002-09-04 Thread Roman Menshikov
| 0 | +-+---++ See the difference in the 3rd columns??? -- Best regards, Roman mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com

mysqld-max-nt 4.0.1-alpha shutdown problem

2002-07-14 Thread Roman Vorobiev
When mysqld-max-nt.exe is started with options --console --standalone and after issuing mysqladmin -u root shutdown mysqld reports a shutdown, but does not exit. mysqld-max don't have this problem. OS Windows 2000. Roman Vorobiev. e-mail: [EMAIL PROTECTED

table description in database differs from script definition

2002-01-24 Thread Roman Zagorowski
(0.00 sec) some columns (dsg, nt, wot, k, drt, cr, wat) declared as char in script are varchar in database... whats is going on? mysql ver 3.23.41 Roman - Before posting, please check: http://www.mysql.com/manual.php

Path Variables

2002-01-10 Thread Roman Eisner
each of these variables, because I'm moving the server to a different directory. Thanks, -Roman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Connection limit per user

2001-11-27 Thread Roman
Hi All. Does anybody know how can I limit maximun connections number to mysqd for individual user, not for all users in sum, as it done by the variable max_connection ? I suppose it is nonstandard feature, and may be a patch for mysql is available ? -- regards Roman

Re: Connection limit per user

2001-11-27 Thread Roman
The maximum number of active connections for a single user (0 = no limit). so this feature is readily available depending on which version of mysql you are using. thanks, -- Andrew - Original Message - From: Roman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 27

mysql instalation

2001-11-27 Thread Landy Roman
mysql fails to start i get msg starting mysqld with database /var/lib/mysql and then it terminates please advice - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: What sites?

2001-10-18 Thread Roman Festchook
://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Roman Festchook Network Engineer ISP ORTA Polesye http://www.polesye.net

Re: Installation problsm - Can't locate DBI.pm

2001-09-13 Thread Roman Festchook
unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Roman Festchook Network Engineer ISP ORTA Polesye http://www.polesye.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Convert to MyISAM

2001-09-06 Thread Roman Festchook
://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Roman Festchook Network Engineer ISP ORTA Polesye http://www.polesye.net

Re: Setting User Privilges ? Confused !!

2001-08-29 Thread Roman Festchook
/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Roman Festchook Network Engineer ISP ORTA Polesye http://www.polesye.net

Re: submit a full bug report

2001-08-26 Thread Roman Festchook
: *** [all-recursive-am] Error 2 -- Roman Festchook Network Engineer ISP ORTA Polesye http://www.polesye.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

telnet MySQL

2001-05-14 Thread Shtykh Roman
When I try to telnet MySQL which uses port 3030 as below: telnet grdmss57 3030 I get : Trying 163.143.156.38... Connected to grdmss57.u-aizu.ac.jp. Escape character is '^]'. ( 3.23.38jN(xIDWiConnection closed by foreign host. What is the possible reason? Is it normal?

MySQL installed in a user home dir, HELP!

2001-05-13 Thread Shtykh Roman
in advance. Roman. __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com

Installing MySQL on Solaris as a user(not root)

2001-05-02 Thread Roman Shtykh
I have a problem running MySQL on Solaris. I downloaded the source and compiled it following all the instructions and made mysql directory in my home directory. When I enter mysqladmin version I get: mysqladmin Ver 6.9 Distrib 3.21.33b, for sun-solaris2.8 on sparc TCX Datakonsult AB, by Monty

[MAILER-DAEMON@263.net: Undelivered Mail Returned to Sender]FYI

2001-03-17 Thread Landy Roman
: Submitter-Id: submitter ID Originator:Rolando Roman Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.35 (Official MySQL binary) Server

please help me with charset

2001-01-10 Thread Roman Serbski
folder with Index and cp1251.conf. I checked Index - records are OK. Should I add something to /etc/my.cnf file? Looking forward to hear from you. Regards, Roman -- - Please check "http://www.mysql.com/documentation/manua