errors

Hi All, I am very new to using mysql. I have encountered lots of problems when I first installed mysql on my freebsd box. I am running an Intrusion Detection System on my freebsd box and it needs to have mysql and DBI modules installed in order for its web based reporting system to work. I am see

RE: 3-letter stop words in FULLTEXT

On Fri, 4 Jan 2002, Chris Lott wrote: > How is full-text working for you otherwise? Is it excruciatingly slow to > generate indexes and optimize tables as some have said? Oh god, yes. Running 3.23.46 on Linux with a 1Ghz PIII and 4 GB of RAM it _still_ takes a heck of a long time to do optimize

For posterity, I had to jump through a few small hoops to install 4.0.1-MAX Binary

The directions do not work exactly right. INSTALL-BINARY for one example... The my.cnf examples do not work exactly right. ( Especially since there is some innodb crap in the data directory already to begin with, notably my-small.cnf says look in ../var, and the size of the innodb table

Re: Newbie Question - Long Queries

Hi Bill, Try putting first all the county equality tests together and then the other tests in the where clause. select * from jobs where (county = 'county1',' or county = 'county2'... or description like '%county1%' or or description like '%county2' ... or title like '%county1%' or title lik

Re: ENUM -- integers or strings?

PHP will handle your var types for you just fine. If you want to bet sure, so an intval() before you compare. On Fri, 4 Jan 2002 16:18:24 -0500, Erik Price used a few recycled electrons to form: | There's no data in the database yet, so I haven't tested this code. I | don't want to use the mys

RE: copy table

* Bogdan Stancescu > No, I mean the type of the fields. When you create a table you > have to define the field types -- char, varchar, stuff like > that. Does your code take care of that? It seems like it does: mysql> use test Database changed mysql> create table test4 (a char(8),b int(9)); Quer

Re: copy table

No, I mean the type of the fields. When you create a table you have to define the field types -- char, varchar, stuff like that. Does your code take care of that? Thanks for the links! Bogdan Roger Baklund wrote: > * Bogdan Stancescu > > I'm curious about this issue too - does the third line i

RE: copy table

* Bogdan Stancescu > I'm curious about this issue too - does the third line in your > code take care of the table structure as well?! > > I'm also wondering how one could duplicate a whole database (for > backup purposes in my case). > Roger Baklund wrote: > > create database new_db; > > use new_

Re: copy table

I'm curious about this issue too - does the third line in your code take care of the table structure as well?! I'm also wondering how one could duplicate a whole database (for backup purposes in my case). Bogdan Roger Baklund wrote: > * saraswathy saras > > how to copy table from one database

RE: copy table

* saraswathy saras > how to copy table from one database to another database,is it possible. If the table type is MyIsam, you can copy the tables on the OS level. You can also execute some commands like these: create database new_db; use new_db; create table new_table select * from old_db.old_t

copy table

hi, how to copy table from one database to another database,is it possible. Please help me. Thanks in advance _ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com -

RE: query

Hi Nathan : Thanks for the help look, I read the php.net manual and use the mysql_num_rows(); function, and I write down this script, did you think is good enough. Thank. Untitled Document " target=new_window>..:: Edit ___

Editing field length causing grief.

Hello.. I am having a problem reconfiguring a field. This menu select puts $type into a varchar(6) field. Type: $type Regula Servic Open The record and field is loaded and everything works fine until I try to change it to varchar(7). After I edit the field to 7 characters, I get an

mysql client exits with core dump segmentation fault

>Description: ## After building mysql and installing the GRANT tables I start the daemon ## and then try to run the mysql client to alter the GRANT tables to a ## useful configuration. Subcommands like connect and use seem to work ## ok, but if I try entering anything else, ev

Re: OK - Simple Timestamps problem getting the better of me!

My response below is incorrect, with regard to the NULL behavior. MySQL will insert the current time and date for a TIMESTAMP only for the first column *if* you omit the columns from the INSERT statement. If you set the column to NULL explicitly, MySQL should set any TIMESTAMP to the current dat

bug in if() when using float?

Hi, there seems to be some bugs when using floating point constants and user variables with the if() function. Is this known bugs? I have searched for it, but not found anything... is it fixed... I have tested it on 3.23.30-gamma on win2k and 3.23.39 on solaris, I don't have access to any newer i

Re: OK - Simple Timestamps problem getting the better of me!

At 23:41 + 1/4/02, David Ayliffe wrote: >I have created a test table with: > >CREATE TABLE TimeTest ( >Time1 TIMESTAMP(4), >Time2 TIMESTAMP(8), >Time3 TIMESTAMP(10), >Time4 TIMESTAMP(12), >Time5 TIMESTAMP(14)); > >This works fine! No problemo > >Now ALL I am trying to do is insert the current

RE: 3-letter stop words in FULLTEXT

> Is there some way to turn off the default 4-letter > minimum length for words in the FULLTEXT index in mysql > 3.23.41-nt ? from: http://www.mysql.com/doc/F/u/Fulltext_Fine-tuning.html > Minimal length of word to be indexed is > defined by MySQL variable ft_min_word_length. > Change it to th

Re: OK - Simple Timestamps problem getting the better of me!

You may try an "INSERT INTO TimeTest set Time5='2002-1-2'" and see if at least Time1 gets populated... In the worst case you can INSERT INTO TimeTest (now(), now(), now(), now(), now()); David Ayliffe wrote: > NO, not originally but I have now and it seems to make no difference! > Any other ide

RE: OK - Simple Timestamps problem getting the better of me!

NO, not originally but I have now and it seems to make no difference! Any other ideas? -Original Message- From: Bogdan Stancescu [mailto:[EMAIL PROTECTED]] Sent: 05 January 2002 00:12 To: David Ayliffe Cc: 'MySQL' Subject: Re: OK - Simple Timestamps problem getting the better of me! Di

Re: OK - Simple Timestamps problem getting the better of me!

Did you define the columns as NOT NULL? Bogdan David Ayliffe wrote: > I have created a test table with: > > CREATE TABLE TimeTest ( > Time1 TIMESTAMP(4), > Time2 TIMESTAMP(8), > Time3 TIMESTAMP(10), > Time4 TIMESTAMP(12), > Time5 TIMESTAMP(14)); > > This works fine! No problemo > > Now ALL I a

Re: Crazy mysql statements.. what if..

* Roger Davenport > I'm trying to do the impossible I think but what I'd like to do is join > two tables, using the "colname" results from "a" table to lookup a > column named "colname" in b... here we go. I don't think you can do that, but... > suppose we have > > table a: > id coln

OK - Simple Timestamps problem getting the better of me!

I have created a test table with: CREATE TABLE TimeTest ( Time1 TIMESTAMP(4), Time2 TIMESTAMP(8), Time3 TIMESTAMP(10), Time4 TIMESTAMP(12), Time5 TIMESTAMP(14)); This works fine! No problemo Now ALL I am trying to do is insert the current time and date into each field in the table!! That's al

query

Hi: I have the next question when i program in asp a query to a database and the query doesn´t returns info you use the while not eof, and then you can control what will appear en the html page ok. There is something or a code that do the same in php4 Thanks.

problems making mysql v3.23.47 on NetBSD

after running a simple ./configure --prefix=/usr/local/mysql and then running gmake I get this error: gmake[3]: Entering directory `/root/mysql-3.23.47/sql' c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr/local/mysql\ "" -DDATADIR="\"/usr/local/mysql/var\"" -DSHAREDIR="\"/usr/local/mysql/share /m

3.21.33b mysql_install_db

Am I crazy, or should there be some CREATE TABLE statements somewhere in the mysql_install_db script? It keeps dying on me with: Starting mysqld demon with databases from /usr/local/mysql/data ERROR 1017 at line 3: Can't find file: 'db.frm' (errno: 2) The grant tables was not installed.

Crazy mysql statements.. what if..

I'm trying to do the impossible I think but what I'd like to do is join two tables, using the "colname" results from "a" table to lookup a column named "colname" in b... here we go. suppose we have table a: id colname 0 price1 1 price2 2 pr

Re: Search tough question

How about using a fulltext index on the field then using a LIKE wild card limiting. Example: SELECT blah FROM tbl WHERE MATCH (ftindex_col) AGAINST ('Neil Young') AND col LIKE "Neil Young%"; This will find only items with Neil or Young AND ^Neil Young, Playing around with this formula will al

RE: JOIN question

You can use count(*) as only one of the selects SELECT count(*), usernames.user, usernames.pass FROM usernames where condition=TRUE -Original Message- From: Boex,Matthew W. [mailto:[EMAIL PROTECTED]] Sent: Friday, January 04, 2002 3:35 PM To: 'Rick Emery'; [EMAIL PROTECTED] Subject: RE:

RE: ms acess to mysql-More information

I received similar messages to the first two in your e-mail, and setting the host field appropriately in the mysql.user table resolved it. I didn't receive any error messages like the last two in your message. What version of myODBC, MySQL, and Access are you running? Dan Crawford Integrated

Search tough question

Hi people, I think this is a tough question, or it could be pretty easy. I have this text file which has a line that has 'someartist - some song'. I use php to open the file and read the line and I now pass this line into the mysql query. (lets use $string as the var). Here's the problem. I have

RE: JOIN question

rick, thanks for the reply. that does give me a count but i also need all the data from usernames table. i need user, ask, pass, etc., then a count like you said. this is what i am looking for ++-+-+-+ | user | ask | pass | pictures | +-

Re: Mysql, innodb, linux problems

Hello, As recommended I upgrade from 3.23.39 to 3.23.47 and now everything works very well Intensive insert with simultaneous update and several simultaneous select on the same table works perfectly on InnoDB tables Regards -- Bernard CHAMBON IN2P3 / CNRS (Centre de Calcul de LYON) email: mai

Re: ENUM -- integers or strings?

There's no data in the database yet, so I haven't tested this code. I don't want to use the mysql CLI client to input data b/c the data is spread out over a number of tables, rather, I'm writing PHP pages that provide a means to populate the database in an organized way. But until the PHP is

Re: SubSelect Workaround

> >database,sql,query,table >Can someone please tell me why this won't work. > >if (defined($res)){ > my $stmt = qq{select distinct symbol from portfolio where $res}; > my $sth = $dbh->prepare($stmt); > $sth->execute(); > > my $portsymbols = ""; > > while ($sth->fetchrow) { > $portsymb

Newbie Question - Long Queries

Greetings all, I'm new to the list, and I'm somewhat new to MySQL. I have a somewhat simple question that I hope someone can help me with. I'm designing a database for a job search. There are a little over 10,000 entries in the db. I need to query the database to accomplish a few results, one of

RE: JOIN question

How about: mysql> select count(*) from usernames INNER JOIN pictures ON usernames.user=pictures.user where state = "Delaware" order by ask limit 25; -Original Message- From: Boex,Matthew W. [mailto:[EMAIL PROTECTED]] Sent: Friday, January 04, 2002 2:09 PM To: [EMAIL PROTECTED] Subject: J

Date formating

I am push a couple of date fields to mysql via the myODBC driver, however the fields are in there original format as JUN01/01 and the like. Right now these fields are type CHAR and I cant do any calculations on them. Is there a built in function to make this a legitimate date or am I stuck munging

JOIN question

howdy, i have a table, pictures, with usernames and pictures like below. mysql> select * from pictures; +--+---+ | user | pictures | +--+---+ | 189 | after

RE: ENUM -- integers or strings?

What happened when you experimented? What were your results? -Original Message- From: Erik Price [mailto:[EMAIL PROTECTED]] Sent: Friday, January 04, 2002 2:03 PM To: [EMAIL PROTECTED] Subject: ENUM -- integers or strings? A quick question -- If I have a table with an ENUM column, and

Re: UNION

Thanks for your answer, I´ve created a TEMPORARY table and it seems to work well for my purpose, the only doubt I still have is, if the table gets automatically deleted when the user closes the connection, or should I do something within my script to avoid a stack overflow? if there are too many

ENUM -- integers or strings?

A quick question -- If I have a table with an ENUM column, and the possible values are ("0", "1", "2", "3"), does the number qualify as an integer or a string? I am working in PHP4 and intend to compare this value as such: // dbaccess.access_level is ENUM("0", "1", "2", "3") column // $user_id

RE: ms acess to mysql-More information

Are you using the myodbc drivers for mysql? --- Norman McLeod <[EMAIL PROTECTED]> wrote: > Thanks for the help so far. > > The specific error messages I get are: > > > SQLDriverConnect returned: SQL_ERROR=-1 > dbc: szSqlState = "S1000", *pfNativeError = 1130, > *pcbErrorMsg = 108, >

RE: ms acess to mysql-More information

Thanks for the help so far. The specific error messages I get are: SQLDriverConnect returned: SQL_ERROR=-1 dbc:szSqlState = "S1000", *pfNativeError = 1130, *pcbErrorMsg = 108, *ColumnNumber = -1, *RowNumber = -1

RE: Connection problems

It does appear that MYSQL has not been compiled in. Execute the "phpinfo()" function in a script to determine if MYSQL is in there. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, January 04, 2002 1:14 PM To: [EMAIL PROTECTED] Subject: Connection probl

ms access to mysql, anyone familar with this?

I need to convert ms access to mysql. Has anyone done this successfully ?? thanks = Regards, Investorclb __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -

RE: ms acess to mysql

I successfully upsized a small Access 2000 database to MySQL this weekend. It was a little tricky, and I had to do some manual altering of the table structures after I upsized, but I eventually got it to work. Are you getting any kind of error message that might shed some light on the issue?

Connection problems

Hi, I try to connect to MySQL on a server (not my own, it's a shared server) with the following PHP script: I always get the error: "Fatal error: Call to undefined function: mysql_connect() ". Normally this means that PHP is not correctly configured with MySql. My service provider confirms tha

Re: ms acess to mysql

I found an article at www.devshed.com/Server_Side/MySQL/ODBC/page1.html about access and mysql --- Duncan Hill <[EMAIL PROTECTED]> wrote: > On Fri, 4 Jan 2002, Investor wrote: > > > Has anyone converted data in MS Access to Mysql? > > > > I would think this is possible!! > > "ODBC". > >

RE: ms acess to mysql

My question too... Matter of fact, I found a ODBC driver for M$<->MySQL access, i.e., Visual C++/Visual Basic/Access, but can't get it to work. Anybody have any experience with this? I know about the "Port 3306", I know about the wildcard permissions to access MySQL from any domain, but still ca

RE: Watchdog für mysql in Perl?

I use a simple script that does the following: --- snip --- mysql -e "SELECT * from table_name limit 1" db > 2>/tmp/filename x=`cat /tmp/filename` if [ "$x" = "" ] then do_nothing=1 else ## There's an issue! echo "ERROR!" fi --- end snip --- Using the re-direct of stderr is the key. the "2>/tmp/

Re: ms acess to mysql

On Fri, 4 Jan 2002, Investor wrote: > Has anyone converted data in MS Access to Mysql? > > I would think this is possible!! "ODBC". (sql,mysql,database) -- Sapere aude My mind not only wanders, it sometimes leaves completely. Never attribute to malice that which can be adequately explained

Re: UNION

You have to search for "create temporary" table then make severals insert into this_table as select Note that the temporary table are thread local I think so only the current connexion can see it. > HI, > > I found a very usefull function in Mysql (to combine the result of many > SELECTS

compile problem under SuSE 7.3

Hi, I loaded a fresh hardware with SuSE 7.3 and find myself unable to compile MySQL database any more. What happens? I unpack mysql-3.23.47 and do ./configure which stops at some point: checking for inline... inline checking for off_t... yes checking for st_rdev in struct stat... yes checking

Re: Changing part of field

Greg Peretti writes: > I have a database that has a emailaddress field. A large number of the > entries are from home.com, Excite's ISP. Since Excite is out of > business, Comcast is converting them all to comcast.net next month. > > Is there a simple way to change all home.coms to comcast.nets

ms acess to mysql

Hi, I am new to mysql and this list. Has anyone converted data in MS Access to Mysql? I would think this is possible!! What would you recommend to enter data into Mysql, For example if someone entering the data is not mysql proffecient. Could they enter data into a form or something, then I

Data corruption issue

I'm experiencing data corruption with the latest version of MySQL: ares% mysql -V mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686) Compiled with: ares% gcc --version 2.95.4 I'm running MySQL as: /usr/local/libexec/mysqld --datadir=/home/mysql -O key_buffer_size=160M -O record_buffer=

Re: Changing part of field

You want to change any occurrences of [EMAIL PROTECTED] to [EMAIL PROTECTED] in column emailaddress, right? Assuming your table is named 'mytable', it looks to me like you could use UPDATE mytable SET emailaddress=REPLACE(emailaddress,'@home.com','@comcast.net'); See

Re: further compile problems on Solaris 2.6

At Fri, 04 Jan 2002 15:34:33 +0200, [EMAIL PROTECTED] wrote... : > from 3.23.47 to 46, 45, and 44 - my compile is getting stuck at : > the same place for all of them. : > : > : Making all in libmysql : > : make[2]: Entering directory `/local/src/mysql-3.23.47/libmysql' : > : /bin/sh ../libtool

Re: Changing part of field

I don't think you can do it with a single command. One fairly easy way is to run a command to generate the sql that will do the update. So your first statement will be something like: select concat( 'update set emailaddress=''', emailaddress, '''where =', and with your values. Output the re

Changing part of field

I have what I hope is a simple problem, but being somewhat a novice at MySQL, it is a bit beyond me. I have a database that has a emailaddress field. A large number of the entries are from home.com, Excite's ISP. Since Excite is out of business, Comcast is converting them all to comcast.net next

UNION

HI, I found a very usefull function in Mysql (to combine the result of many SELECTS in one result set ), which is UNION SELECT UNION [ALL] SELECT [UNION SELECT ...] the problem is, that it was implemented in version 4.0 and above; anyone can tell me if there is a way to re-phrase

3-letter stop words in FULLTEXT

Is there some way to turn off the default 4-letter minimum length for words in the FULLTEXT index in mysql 3.23.41-nt ? I am running a database of a fixed set of texts (about 150MB) of a religious nature and the 4-letter minimum length setting makes it impossible to search for "God" among other

RE: replication

Ok... If all you need is all the offices to have a copy the main database this should work. But if you need two way replication this is harder. Two way replication can be done in a loop but there can be problems with being out of sync! V4.1 should be able to do full two way replication. Hope thi

Re: Watchdog für mysql in Perl?

Well, you could use a shell script to run "mysqladmin status". I.e. this bash script: #! /bin/bash # mystatus.sh is really just a simple alias for a # longer command. # Usage: 'mystatus.sh PASSWORD' # replace values of $my_hostname and $my_username if needed my_hostname='localhost' my_usernam

Re: load data local infile

Yes the data is consistent firstname, lastname, address, city... The data is sent to me in eight different files every day. I want to import the data into a mysql database and set a field that is not included in the txt file. The files are sent to me already organized by region and would like to

replication

The following question. We have got several office in Europe. Now I want to use 1 database in Rotterdam (main) en several other in the other countries (spain, france, portugal, belgium and germany). Know I want to synchronize those databases of the other offices with the 'big' database (mysql)

RE: duplicating column

If you want the two tables to remain separate, for normalization purposes, you can use JOINs: SELECT * FROM tableA LEFT JOIN tableB USING(id); The above statement will retrieve all the information for each id in both tables. Yet, the tables may be managed separately. This is especially valuable

Re: MySQL and COM+

I think I read something about COM+. The statement I read said it is compatible, but I don't know about MSTDC, I would think that MSTDC would be a Microsoft propriotary interface. - Original Message - From: "Patryk Choroś" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January

Re: duplicating collumn

Michael Brunson wrote: > > On Fri, 04 Jan 2002 00:58:19 +0200, "P.Agenbag" > <[EMAIL PROTECTED]> wrote: > > | Hi > | I have two tables, one contains a persons name and an ID number. The > | other table contains the ID number and another field. Is there a way of > | moving this collumn to the fir

re:mysql on AIX RS6000

You may need an updated version of zlib: http://freeware.bull.net/download/aix43/zlib-1.1.3.2.exe -- database,sql,query,table - Before posting, please check: http://www.mysql.com/manual.php (the ma

Re: Command Line Editing Mode

Hi, This $HOME/.inputrc gets you "vi-mode" in mysql and other programs that uses readline. set editing-mode vi set show-all-if-ambiguous On # after TAB is pressed Regards Jörgen Quentin Bennett wrote: >Hi, > >Using the mysql CLI, I have discovered that > >ESC-Return Return > >will put the C

RE: SSH tunnel MySQL traffic..

Hi~ I have trouble with ssh tunneling. I run this command as you told. [wertyu@inos ~]$ ssh -L 12345:localhost:3306 localhost Secure connection to localhost refused; reverting to insecure method. Using rsh. WARNING: Connection will not be encrypted. localhost: Connection refused what's the pr

Re: Updating tables via cron

Hi! On Thu, 3 Jan 2002, Webmaster wrote: > I tried to search the archives for this but I can't find it. (Not saying > it isn't there just I could not find it.) I have a table that tracks > events on a monthly and daily basis. Currently I am resetting the > appropriate fields to 0 on

Re: Mysql, innodb, linux problems

Bernard, please upgrade to 3.23.47. There were several hang bugs in 3.23.39. Regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB >Hello, > >Hope it is a good place for

MySQL and COM+

Hi! Have anyone of you used mysql and com+? is it possible to get com+/mstdc transactions to work with mysql? TIA Patryk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.

RE: Misc Question [University of Alberta, Canada]

Dear Roman Eisner, >Hello. I'm not sure where to submit bugs, so I'll do it here. It's not >that major, but I thought I'd let you know The normal place to report bugs and problems is [EMAIL PROTECTED] >In mysql, on Linux, I have a table, say "TempTable". >So, I type >Drop table Temp >an

Re: C programming to connect mysql

The manual and the sources for the clients are a good place to start. Kaming wrote: > Hi all, > > Do anyone know that how to write a C programming to connect to mysql?? > Many thanks. > > Kaming. > > > > > > - > Before po

Re: Mysql ++, Inserts

Joshua Angolano writes: > Can, you send insert statements through standard SQL, instead of using > special structures? Here is an example: > > > String loc; > loc="home"; > Query query = con.query(); > query << "insert into loacation (user_location) values('"< query.execute(); > > > Assuming

mysqldump Solaris 2.8 tables option

Hello, i am using mysqldump (v 8.17 mysql version 3.23.43) on Solaris 2.8 I am trying to get a backup of only ONE table of my database, using the following commands ./mysqldump -u root -p -n --add-drop-table --databases LBS --tables LOG_DATA ./mysqldump -u root -p -n --add-drop-table LBS LOG_DAT

Mysql, innodb, linux problems

Hello, Hope it is a good place for the following question I use Mysql (3.23.39) and InnoDB tables on Linux (2.2.17-14smp) and I got deadlock (In suppose it is a deadlock) when I do intensive work. intensive work = one insert + one update + 2 selects (simultaneously, with 4 diff

Re: Re[2]: Mysql reconnect hang

Peter Zaitsev writes: > Hello Sinisa, > > Wednesday, January 02, 2002, 6:21:59 PM, you wrote: > > > No. This happens then mysql is completely restarted. > I Understand this should not happen but somehow it does. > > > -- > Best regards, > Petermailto:[EMAIL PROTE

Re: further compile problems on Solaris 2.6

fil krohnengold writes: > > I have no pride - I'll use a binary if I can find a recent one > for 2.6 - I just can't seem to find any. I've tried backing up > from 3.23.47 to 46, 45, and 44 - my compile is getting stuck at > the same place for all of them. > > : Making all in libmysql > : make

RE: 3.23.47 compile problems with sun's forte compiler

Quentin Bennett writes: > Hi, > > >From the cc(1) man page for Forte Developer 6.2 > > These predefinitions are valid in all modes: >__sun >__unix >__SUNPRO_C=0x530 >__`uname -s`_`uname -r` >

RE: Command Line Editing Mode

Quentin Bennett <[EMAIL PROTECTED]> wrote: > Using the mysql CLI, I have discovered that > > ESC-Return Return > > will put the CLI editor in to 'vi' mode, and allow me to use my 'normal' ksh > editing keys, available in ksh after "set -o vi". Cool... Thanks... I didn't know that. Now I can

Re: Updating tables via cron

David, Was this question addressed? > I tried to search the archives for this but I can't find it. (Not saying > it isn't there just I could not find it.) I have a table that tracks > events on a monthly and daily basis. Currently I am resetting the > appropriate fields to 0 on a daily and mon

Re: Replication between MSSQL and mySQL

The idea was to have an exact replica which is always up to date. They will be networked, but is this really the only solution? I had pictured something like a trigger in the MSSQL that could push-replicate to the mySQL. The mySQL would then only update the changed data in the MSSQL. Med venlig

RE: assigning root password

After an install, you should be able to connect to Mysql as root without a password. Example: mysql - u root. Then SET PASSWORD FOR root@"%" = PASSWORD('biscuit'); That will set the root password for any host to biscuit. To set the password for root@localhost SET PASSWORD FOR root@localhost = PASS

Mysql ++, Inserts

Can, you send insert statements through standard SQL, instead of using special structures? Here is an example: String loc; loc="home"; Query query = con.query(); query << "insert into loacation (user_location) values('"

mysql replication

Goodmorning, I have two machines running mysql (win nt) They are running now, in the slave data dir, i see that the slave is connected to the master: Slave: connected to master [EMAIL PROTECTED], replication started in log 'FIRST' at postition 305 But when I insert data into the master, the sl

Watchdog für mysql in Perl?

Hi! Short question: i want to have a perl watchdog telling me when executed if my sql-server is running and if anything is allright with it. So if i get any errormessage i can restart the server by remote. Has someone done this allready? Any hint? Thanks again and best regards Sascha Kettner

assigning root password

Hello, I have installed mysql source distribution. Now I tried assigning the root password for mysql. I tried with “ mysqladmin –u root password ‘password’ “ and I also tried “ mysql -u root mysql” so that I can insert the password for the root user. Both of these are giving same error. “c

Re: problem with mysql connection

naveed abdul writes: > Can't connect to local Mysql server through socket > '/var/run/mysql/mysql.sock' Along with that you get an error code which you should look up (using perror). Without knowing what the error is it's sort of hard to tell you what to do about it, but the most common proble

RE: MyODBC leaking handles...

Venu, I really look forward to the update. Thanks for following up! Regards, ___ Jens A. Collin Envox Technical System Developer Envox Group Söder Mälarstrand 43 118 25 Stockholm Sweden Office: +46 (0)8 56 256 000 Fax : +46 (0)8 56 256 050 [EMAIL PROTECTED]