Apologies for posting such a basic query, but I couldn't find an
archived version of the mailing list, or a fix to my problem. Using
Linux Mandrake 8.2.
It's the problem with mysql.sock, which I've tried to make the /tmp
directory sticky, following the command on the mysql site. However, it
s
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
Dear Sir,
I am developing an application on PHP using MYSQL database.
Its alittle comples database. It uses a lot of links within database.
The problem is how i can implement "ON DELETE" and "on update"
operation with PHP & MYSQL. Are there STANDARD LIBRARIES for this operat
>Description:
Our mysql server crashes relatively often. Most of the time after a crash,
the error logs show a line like "thd->query at 0x84aef98 = show processlist" (although
some have "0x50e64580 is invalid pointer" and others "(nil) is invalid pointer").
We do have a process whic
Hi.
Please do not quote a whole long mail (206 lines) if you are only
referring to one single sentence.
On Mon 2002-06-03 at 20:30:40 -0400, [EMAIL PROTECTED] wrote:
> Philip Olson wrote:
[...]
> > e) While developing, put error_reporting(E_ALL); on top
> >of your script.
[...]
> ps (what d
try this jule..
$link_glob = "mysql_connect('$host_glob', '$un_glob', '$pw_glob')";
$temp= PASSWORD($password);
$query = "INSERT INTO user values('0', '$fname', '$lname', '$email',
'$username', '$temp');";
i think this will work..=) i hope ive done something.
- Original Message -
Philip Olson wrote:
> Are you sure this is the correct file? This is full
> of syntax errors, you should be getting parse errors.
>
> A few tips:
>
> a) Don't post to multiple lists. This is a PHP issue,
> not MySQL. Hopefully this will end the mysql list
> thread.
>
> b) Don't u
Wait a second
Is this a typo or what...
$link_glob = "mysql_connect('$host_glob', '$un_glob', '$pw_glob')";
The qoutes around mysql_connect statement makes
it to a string, nothing else but a STRING !!
So it will never get executed !!
And '$link_glob' is either "a link recource" its just c
Are you sure this is the correct file? This is full
of syntax errors, you should be getting parse errors.
A few tips:
a) Don't post to multiple lists. This is a PHP issue,
not MySQL. Hopefully this will end the mysql list
thread.
b) Don't use mysql_db_query() as it is deprecated.
At 18:09 -0400 6/3/02, Jule Slootbeek wrote:
>Hey guys,
>i'm getting this error with the following sql script using php:
>--error--
>Warning: Supplied argument is not a valid MySQL-Link resource in
>/var/www/phpquiz/register_user.php on line 12
>--error--
>
>--script--
>$link_glob = "mysql_connec
If the snippet is copied directly out of your code, are you missing a single
quote before:
$link_glob
$result = mysql_db_query('$db_glob', '$query', $link_glob');
- Original Message -
From: "Jule Slootbeek" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 03, 2002 5:09 P
[EMAIL PROTECTED] wrote:
> Hi Jule !!!
>
> This can be a socket error.
> Sometimes when installing PHP/Mysql as binary dist PHP
> does not know where mysql socket is.
>
> The default is (AFAIK) /tmp/mysql.sock
>
> Make a test:
> Try to connect with mysql console with exactly
> the same info as
[EMAIL PROTECTED] wrote:
> Hi Jule !!!
>
> This can be a socket error.
> Sometimes when installing PHP/Mysql as binary dist PHP
> does not know where mysql socket is.
>
> The default is (AFAIK) /tmp/mysql.sock
>
> Make a test:
> Try to connect with mysql console with exactly
> the same info as
Hi Jule !!!
This can be a socket error.
Sometimes when installing PHP/Mysql as binary dist PHP
does not know where mysql socket is.
The default is (AFAIK) /tmp/mysql.sock
Make a test:
Try to connect with mysql console with exactly
the same info as You use in Your PHP script.
shell#> mysql -hlo
Jule Slootbeek wrote:
> G r e g L a w r i e wrote:
>
>> It would also appear you are missing a closing ) at the end of the
>> '$query=...' line. You have two opening backets and only one closing.
>>
>> Greg
>>
>> -Original Message-
>> From: Bruce Lewis [mailto:[EMAIL PROTECTED]]
>> Sent:
Jule Slootbeek wrote:
> G r e g L a w r i e wrote:
>
>> It would also appear you are missing a closing ) at the end of the
>> '$query=...' line. You have two opening backets and only one closing.
>>
>> Greg
>>
>> -Original Message-
>> From: Bruce Lewis [mailto:[EMAIL PROTECTED]]
>> Sent:
G r e g L a w r i e wrote:
> It would also appear you are missing a closing ) at the end of the
> '$query=...' line. You have two opening backets and only one closing.
>
> Greg
>
> -Original Message-
> From: Bruce Lewis [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 4 June 2002 7:50
> To: [
It would also appear you are missing a closing ) at the end of the
'$query=...' line. You have two opening backets and only one closing.
Greg
-Original Message-
From: Bruce Lewis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 4 June 2002 7:50
To: [EMAIL PROTECTED]; mysql; php-general
Subject:
Your missing your closing "}" at the end of the else statement.
- Original Message -
From: "Jule Slootbeek" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>; "php-general"
<[EMAIL PROTECTED]>
Sent: Monday, June 03, 2002 5:09 PM
Subject: stupid error, please kick me (and send me a solu
Hey guys,
i'm getting this error with the following sql script using php:
--error--
Warning: Supplied argument is not a valid MySQL-Link resource in
/var/www/phpquiz/register_user.php on line 12
--error--
--script--
$link_glob = "mysql_connect('$host_glob', '$un_glob', '$pw_glob')";
$query = "IN
Hello:
A newbie here using Lasso5, MySQL on a Mac OSX
I would like to back up the MySQL dbs at certain intervals during
business hours. The backups should not be overwritten but kept as
archives.
Is there a commercial/shareware product which will automate this process
as well as reconstruct the db
1.You need libraries+headers from MySQL installation
2.You have to specify their locations in "configure" parameters
(--with-mysql-lib=..., --with-mysql-include=...)
As I remember one of these parameters does not recognize well on RH 7.2
(and 7.1 also I guess)
> I try to install mySQL++ 1.7
Hi,
If you have installed MySQL, the library it is on the right place.
Gelu
- Original Message -
From: "Shaorong Liu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 12:01 AM
Subject: mySQL++ 1.7.9 installation help
> Hi,
>
>I try to install mySQL++ 1.7.9 in
I can't remember my root password. I know that there is a way to set it by
starting mysql with certain parameters, but I can't remember what those
parameters are. Can you help me out? Thanks!
-
Before posting, please check:
On 3 Jun 2002, at 22:23, Benjamin Pflugmann wrote:
> You missed to mention that using LEFT JOIN changes the meaning of the
> SELECT in question and it may also be a lot slower, dependend on the
> data.
>
> I think STRAIGHT_JOIN is more appropriate to force the tables to be
> read in a certain or
Hi,
I try to install mySQL++ 1.7.9 in Linux 7.1 (gcc 2.96). I put the mySQL++
source code in /home/group2/ and type the following commands:
automake
autoconf
./configure --with-prefix='/home/group2/'
but there is an error message: checking for MySQL library directory...
configure: error: Didn'
Hello, I use a little function to solve this problem in mysql++ .
char* c_string(const string& s){
char* p = new char[s.length() + 1];
s.copy(p, string::npos);
p[s.length()] = 0;
return p;
}
char *temp = c_string(row[ "YOUR COLUMN"].c_str());
MArio H.C.T.
-
Yes, the concepts he presents are in generic SQL. I've used them in 2
different systems (menus and security) and they work fine. (NOTE: You DO
have to write your own code.) ;)
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From:
Hello.
You missed to mention that using LEFT JOIN changes the meaning of the
SELECT in question and it may also be a lot slower, dependend on the
data.
I think STRAIGHT_JOIN is more appropriate to force the tables to be
read in a certain order.
Bye,
Benjamin.
On Mon 2002-06-03 at 14:
> SQL for Smarties by the demigod Joe Celko. Chapters 28 and 29 describe this
> tree structure. READ BOTH OF THEM, even though you won't use the code in
> 28. Chap 29 holds the simplified concepts to make a tree structure work with
> single select.
> It's not easy. It's a complex concept but onc
Hi.
On Mon 2002-06-03 at 14:17:42 -0400, [EMAIL PROTECTED] wrote:
> Try changing your WHERE clause from:
> WHERE
> call_notes.ticketid = '1' &&
> call_notes.userid = users.userid &&
> call_notes.contactid = facility_contact.contactid &&
> call_notes_text.noteid = call_notes.noteid
>
> To
> WHER
Hey guys,
there are 2 files in my /tmp directory that look like mysql datafiles:
#sql208_ecc_0.MYD
#sql208_ecc_0.MYI
They're on the same box as our development mysql instance but I don't see them on any
of our other instances. Anyone have any idea what they are/if I can delete them?
They're c
Hi.
As MySQL AB normally only does a "stable release", when the
appropriate state is reached, the only valid answer is "when it's
ready". A more useful answer may be
http://www.mysql.com/doc/M/y/MySQL_4.0_In_A_Nutshell.html
Btw, (stable) transactions are already available in the 3.23.x
releases
http://www.amazon.com/exec/obidos/ASIN/1558605762/qid=1023135114/sr=8-1/ref=
sr_8_1/104-1283502-0494342
SQL for Smarties by the demigod Joe Celko. Chapters 28 and 29 describe this
tree structure. READ BOTH OF THEM, even though you won't use the code in
28. Chap 29 holds the simplified concepts
Need to go grab myodbc. Check downloads at www.mysql.com. grab the
binaries unless you are brave enough to compile. :)
Install (It comes with a setup) and then configure an ODBC source like
normal.
it works, I've done it.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.c
Is there a way to do this in one query (never mind the possibilities
for endless loops):
Say you have a table that looks like this:
fieldName dependantOn
"joe" "monster"
"bob" "joe"
"briggs"
"monster" "briggs"
"vision"
I want to do a query so that the r
Hello!
I just installed MySQL. Win 2000 Professional.
I am logged in as none.
No User Id. No Password.
I wonder how. :)
I could create tables, update records, query etc,.
Now I would like to make ODBC connections.
And eventually make JDBC connection from my \
Java co
Hi.
On Mon 2002-06-03 at 10:22:35 -0300, [EMAIL PROTECTED] wrote:
> Unfortunately, I don't have. I subscribed today.
Irrelevant. What he meant is, check the online archives (it is the
recommended thing to do before posting a question at all):
http://www.mysql.com/documentation/searchlists.html
Thank you Keith - I worked with your example and LEFT JOIN has solved the
problem.
Best Regards,
Mike
> -Original Message-
> From: Keith C. Ivey [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 03, 2002 2:26 PM
> To: [EMAIL PROTECTED]
> Cc: Stembridge, Michael
> Subject: Re: Sluggish p
http://www.mysqldeveloper.com/lists/index.pcgi?readlist=mysql
[EMAIL PROTECTED] wrote:
>
> Unfortunately, I don't have. I subscribed today.
>
> -- Mensagem Original --
>
> >you can't. Check the archives, this was discussed about 2 weeks ago.
> >
> >*
> >* Cal Evans
> >* Journeyman Programmer
>
On 3 Jun 2002, at 10:06, Mike G wrote:
> Basically, I look to see whether the currect date exists by retrieving
> the high and low for the date. If it succeeds, I calculate whether the
> new price is higher than the existing high or lower than the existing
> low. Then I update the high, low and l
You are loading all databases, but the security database (mysql) is already
there. Assuming you are starting with nothing and restoring all databases
that the server knows about, one method that works is to start the server
with --skip-grant-tables, then load the dump file, then flush privileges.
On 3 Jun 2002, at 11:49, Stembridge, Michael wrote:
> FROM
> call_notes,
> call_notes_text,
> users,
> facility_contact
> WHERE
> call_notes.ticketid = '1' &&
> call_notes.userid = users.userid &&
> call_notes.contactid = facility_contact.contactid &&
> call_notes_text.
First of all, sorry for the multiple mailings of the same message. I was
receiving bounce messages, so I thought they weren't going through.
On to the reply...
I saw that a while ago and decided to try reversing, but I still have the
same delay.
Mike
> -Original Message-
> From: B
Try changing your WHERE clause from:
WHERE
call_notes.ticketid = '1' &&
call_notes.userid = users.userid &&
call_notes.contactid = facility_contact.contactid &&
call_notes_text.noteid = call_notes.noteid
To
WHERE
call_notes.ticketid = '1' &&
call_notes.userid = users.userid &&
call_notes.contac
I have built a MySQL binary from source and have installed it with no
problem. However, when I go to make uninstall, make bombs on me. Any
recommended way for uninstalling a MySQL distro?
-
Before posting, please check:
h
Michael,
In Oracle, with which I am much more familiar, only primary keys are
indexed automatically. Foreign keys are not indexed automatically. You
have to create the indexes on the foreign key columns explicitly. My guess
is that MySQL works the same way, and that this is the source of yo
Hey everyone,
Thanks for all the help / comments re cygwin. I'll definitely be giving
some of them a try.
Terry offered a pre-compiled binary which I am busy getting at the moment
that I'll have a look at to see how nice it is. I'll also be very tempted
to compile my own versions However,
I have a database containing stock data which I want to keep up to date.
The relevant fields are the symbol, date, high, low, and last prices.
When a new price comes in for an existing date, I want to update the high if the price
is higher, the low if the price is lower, and I always want to u
-Message d'origine-
De : Alexandre Zglav [mailto:[EMAIL PROTECTED]]
Envoyé : lundi, 3. juin 2002 19:05
À : mysql (Elektronikus levelek)
Objet : InnoDB and Windows
Hello all .
Nice to meet you.
Maybe this thread has already been solved. If so im sorry for the disturb.
Here is my p
The following query takes a very long time to process. It finally returns
only the row I'm wanting, but when I run an EXPLAIN SELECT on it, it looks
like all 14687 rows are being examined for the record -- instead of mysql
honing in on the desired row immediately.
SELECT
Hi all,
I have a problem with MySQL under Windows NT/2000 where it crashes every time I issue
an ALTER TABLE command while the table is being written to under high load. I've
tried several versions of MySQL on a few different machines/OS and still the problem
remains. I'm hoping someone might
Oh, not the alpha, but the stable version, of course!
> Is there a roadmap for mysql 4.0?
> We'd like to upgrade our MySQL DB
> server to another one which can use
> some useful techniques eg. sub-selects,
> transaction handling, etc.
> I like mysql very much and I know that in
> 4.0 these tech
Hi,
Is there a roadmap for mysql 4.0?
We'd like to upgrade our MySQL DB
server to another one which can use
some useful techniques eg. sub-selects,
transaction handling, etc.
I like mysql very much and I know that in
4.0 these techs will be implemented.
But I don't know when will this new
serv
From: Peter Lloyd <[EMAIL PROTECTED]>
To: script
Subject: No response from mysql; & mysql_install_db freezes
>Description:
I am following the installation instructions in the documentation, and after invoking
the script
'mysql_install_db', I see a few announcements, then nothing happens. I wai
A database is being used to log support calls for a call center. There are
around 25,000 clients in the database. The existing call notes were imported
from flat text files.
One table (call_notes) contains the call time, ticketid, noteid, ect..
Another table (call_notes_text) only contains notei
A database is being used to log support calls for a call center. There are
around 25,000 clients in the database. The existing call notes were imported
from flat text files.
One table (call_notes) contains the call time, ticketid, noteid, ect..
Another table (call_notes_text) only contains notei
Good Day
I will attempt to give you as much information about the software as I can before I
ask the question.
OS : RedHat 7.1
MySQL : Version 3.23.49a for Linux -> binary distribution for pc-linux
I want to insert into longblob column very big large data.
but.. I have strange Error
Hi ,
Do mysql ver 2.23.X support UTF-8 .
If yes , to what extends.
I have tried UTF-8 with mysql ver 3.23.37 on windows.
It seems as that it support UTF-8 , but tools (utilities ) for mysql
does not fully support utf .
Have any body have tried that.
Regards,
shahzad sarwar
mysql> select user();
+---+
| user()|
+---+
| [EMAIL PROTECTED] |
+---+
mysql> show grants for [EMAIL PROTECTED];
ERROR 1141: There is no such grant defined for user 'root' on host
'192.168.0.17'
mysql> show grants for user();
ERROR 106
[snip]
Is there any chance to select last record in one sql
statement?
[/snip]
Try this query;
SELECT *
FROM tableName
ORDER BY id DESC
LIMIT 1
HTH!
Jay
-
Before posting, please check:
http://www.mysql.com/manual.php (t
Hello! :)
Is there any chance to select last record in one sql
statement?
Thanks.
Kosyo
__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-
One thing you could try is limiting your index length
ALTER TABLE `sometable` ADD INDEX(`somecolumn`(10))
This will only index off of the first 10 characters of your data. Depending on the
type of data you store, this may improve your
performance.
- Original Message -
From: "Mikko Noro
Hi,
I have a table with about 5 million records, and an index on that
table's VARCHAR(255) field, as well as a couple of integer indexes. The
VARCHAR-index is essential to my application as I frequently need to
search through the whole table by using the VARCHAR field.
When I do INSERTs into thi
Does anybody know of any software all ready written or what would have to
be done, to allow us to run a cyber cafe style setup. What we need the
software to do is to allow someone to come in and plug in their computer to
our network (actually a customers network). They want the following:
1.
Hi Ray,
You can see what user you is with:
select user();
Ray wrote:
>is there a show grants self or a whoami type command?
>
>i'm trying to setup security, but i'm not show who i'm login in as?
>root@% or [EMAIL PROTECTED]/255.255.255.0
>
>i am logging in just fine, but i don't really want to
Hi Chris,
I have tried to compile following version of the MySQL under cygwin.
- 3.23.47
- 3.23.50
- 4.0.1
I was able to compile (client + server ) all of mentioned version, BUT most
of the test have failed except for the version 3.23.50 that seem to me to
work in most cases but not in all.
I
At 05:28 AM 6/3/2002, you wrote:
>Hi all.
>
>I'm looking for a comparison between Interbase and MySQL.
>
>Thanks in advance.
>
>Iago.
lago
See
http://lists.mysql.com/php/search.php?ps=10&q=interbase&ps=20&m=and.
Mike
--
At 01:50 AM 6/3/2002, you wrote:
>"mysql support is not available to php on this server"
>
>This is the error I receive. MySQL is working fine, but I need to know
>how get php working with sql.
>
>Also, does anyone know the command to list all the db's? thanks.
>
>Dave
Dave,
Switch to PH
Hi all,
I would like to ask if is possible create and use this table size with MySQL.
So, I have 15 columns in 1 row and it contain 100B of data.
I have in plane insert cca 30 000 000 rows per year - 3 GB/year * 4 years = 12 GB of
data (120 000 000 rows and 1 800 000 000 ).
HW configuration is:
Hi,
I have a table with about 5 million records, and an index on that
table's VARCHAR(255) field, as well as a couple of integer indexes. The
VARCHAR-index is essential to my application as I frequently need to
search through the whole table by using the VARCHAR field.
When I do INSERTs into thi
'salright.
Short answer. The driver does not give you this message. you can time the
execution yourself and then count the rows. For the full discussion try
digging around at:
http://www.mysql.com/documentation/searchlists.html
HTH,
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http
is there a show grants self or a whoami type command?
i'm trying to setup security, but i'm not show who i'm login in as?
root@% or [EMAIL PROTECTED]/255.255.255.0
i am logging in just fine, but i don't really want to delete root@% until i
know i'm getting the right login.
\s just shows me
Curr
It sounds as if you didn't compile in mysql support with you php executable. You can
check this using the phpinfo() function. If you are using the cgi only, try something
like...
'php -q -i | grep configure'
This will show you all the configuration options you selected when
compiling/installi
Unfortunately, I don't have. I subscribed today.
-- Mensagem Original --
>you can't. Check the archives, this was discussed about 2 weeks ago.
>
>*
>* Cal Evans
>* Journeyman Programmer
>* Techno-Mage
>* http://www.calevans.com
>*
>
>
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:
This depends on whether the table will always be open
I believe you are using MyODBC connection.
Create a new table and then choose link table in access.
While linking choose to save the password.
Any changes which will occur in the mysql table will be viewable from
access.
But this will occur whe
I have a MySQL table called questions where I have (qid, catid, userid,
title, question, point, status, timestamp)
"title" and "question" are of type text with a FULLTEXT index and never
change.
I use the table for:
- Get all data
- Get results from several rows without fetching the "title" an
Have a look at urSQL from http://www.urbanresearch.com/ursql
On Mon, 3 Jun 2002, Ehmer David wrote:
> Hi
>
> Very new to MySQL and just wondering if there is an alternative
> interface to the command line. The beginners tutorial I am working
> through from WWW.Mysql.com seems to do all tasks fr
you can't. Check the archives, this was discussed about 2 weeks ago.
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 03, 2002 7:13 AM
To: [EMAIL PROTECTED]
Subject: G
Since Access is using ODBC to get to the tables I'm pretty sure this is not
possible. You could write an access form with a timer on it that requereies
the data ever x seconds to refresh it. (But this is bad...m'Kay?)
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.
hi,
i have mysql compiled with cygwin with gcc version 2.95.3
you can fetch installed version from
http://www3.ibt.com.pl/mysql.tar.gz
it is prepared to be installed in /opt in cygwin's directory structure
best regards,
terry
> -Original Message-
> From: Yegor N. Bryukhov [mailto:[EMA
Hi.
Can we use Access to link table in MySQL and force Access to refresh data
from MySQL automatically when data in MySQL table have change.
Kittiphum Worachat,M.T.
www.hatyailab.com
-
Before posting, please check:
http://
Hello,
>
> More than likely you have missed the step that the slave
> database has to be
> the exact one that the master has before the start of the
> binlog. Shutdown
> both servers, grab a copy of the master's data directory
> and tar that up,
> move that to the slave, delete the slave's curren
Arul,
Saturday, June 01, 2002, 8:34:40 AM, you wrote:
A> Is it that i can make a column auto increment only if its data type is
A> integer.
A> Can i not set auto increment value for a numeric datatype
You can set up AUTO_INCREMENT attribute for all int's and float's types.
A> -Arul
--
F
Neville,
Monday, June 03, 2002, 1:44:25 PM, you wrote:
NL> This is the error message that I get
NL>
NL> Can't connect to local MySQL server through socket
NL> '/var/lib/mysql/mysql.sock' (2)
NL>
NL> Could ayone please show
Alexander,
Monday, June 03, 2002, 9:46:40 AM, you wrote:
AB> 1. I am reading 'internals' list and I see some words about subselect in 'bk
AB> commit into 4.1 tree' messages...
AB> Seems like we can expect subselect in 4.1 branch !?? :)
Yeah, sub-selects is in our TODO for 4.1, look at:
ht
How can I get the message when I make a query like
e.g: 8 rows in set (0.01 sec)
How can I get with Delphi. I use the component Zeos dbo to access Mysql
Regards
Alexander
Curitiba/BRA
A busca mais veloz e precisa da internet. Acesse agora: http://ww
On Mon, 2002-06-03 at 04:58, Evgeny Chuykov wrote:
> What algorithm do ENCODE-DECODE functions use?
This is noname algorithm with questionable security level. Use
DES_ENCRYPT/DES_DECRYPT instead. This uses triple DES.
Tõnu
sql
---
Hello Chris,
I would recommend to try to compile MySQL itself under cygwin (or you
already tried it?). Just use GCC version they suggest (I failed to
compiled it using GCC 3.1).
BTW, if you succeed, I would really appreciate if send me
mysqlclient-library compiled under cygwin.
Leeuw van der, Tim writes:
> Hello,
>
> Thank you very much for your reply! I was hoping that this was indeed fixed
> in 4.0.2. I was using 4.0.0 when the bug occurred and upgraded today to
> 4.0.1; I will retest the query with 4.0.2 as soon as it's released.
>
> Apologies btw for not mentionin
On Sun, 2 Jun 2002 16:39:36 -0500
"Khaled Elmeleegy" <[EMAIL PROTECTED]> wrote:
> What if the MySQL server crashes during an Insert or delete or update
> statement, In what state would that leave the database, and would MySQL
> recover? If so how would it do that?
> If not what would happen, half
This is the error message that I get
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
Could ayone please show me how to sort this out
I had MySQL running before this. This has happened
all
Hi all.
I'm looking for a comparison between Interbase and MySQL.
Thanks in advance.
Iago.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arch
Inbal,
Sunday, June 02, 2002, 11:42:01 AM, you wrote:
IO> I read in the manual about building mysql not on c:\
IO> and i found that i need to change the file my.ini
IO> my questions are:
IO> 1) can i build this file by my self and not with winmysqladmin.exe?
Yes, you can create file my.ini or m
weng,
Thursday, May 30, 2002, 2:52:29 AM, you wrote:
>>>If you start MySQL server from MS DOS prompt as:
>>> C:\mysql\bin>mysqld-nt --standalone --debug
>>>
>>>mysqld shows you warning message.
wc> hi! i tried this already..
And? What result did you get? Does MySQL server run with --standa
zygiz,
Monday, June 03, 2002, 11:58:42 AM, you wrote:
z> Hello, can somebody tell me, how to execute some actions automatically at the
specified time, on MySQL server?
You can't do it with MySQL only.
z> zygiz
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
T
Eric,
Monday, June 03, 2002, 1:49:24 AM, you wrote:
EF> I didn't get that deeply into why exactly, but it seems that when I removed
EF> the mysql database from the file, that the rest went fine with
EF> mysql -u -p http://www.mysql.com/doc/m/y/mysqldump.html
EF> I got an error about the column_p
Mary,
Friday, May 31, 2002, 7:39:34 PM, you wrote:
MD> I am a newbie, to group and MySQL.
MD> I just downloaded MySQL for win 2000.
MD> The zip file, when opened and clicked on install,
MD> it created c:\mysql directory and did the install.
MD> Now what next?
MD> DOnt I have to start the ser
On Fri, 31 May 2002, Ray a PowerWeb Tech wrote:
> is there a place to get the manual that is split a bit more then the current
> manual_split.
>
> these are the 2 pages i end up reading the most
> even though its usually for just the grant, create, insert syntax (human in
> need of memory up
On Fri, 31 May 2002, andy wrote:
> I am just trying to configure my root server. The provider has preinstalled
> mysql on suse72. So I did try to get rid of this installation with yast, but
> this did not work out. After compiling php,apache and mysql, PHP is still
> trying to connect to the old
1 - 100 of 110 matches
Mail list logo
