Greetings Edgar,
> I would just like to know if the following is normal:
>
> I created a file TRANSACTION_LOG.sql to create an InnoDB table with
MULTIPLE
> KEYs with one AUTO COLUMN.
>
> The file consists of the following SQL commands:
>
> drop table TRANSACTION_LOG;
> create table TRANSACTION_LO
It's in the doco:
http://www.mysql.com/doc/C/H/CHAR.html
Values in VARCHAR columns are variable-length strings. You can declare a
VARCHAR column to be any length between 1 and 255, just as for CHAR columns.
However, in contrast to CHAR, VARCHAR values are stored using only as many
characters as
Hello,
I m in a great problem..
I am not able to conenct to mySQL server..
the problem is like..
when I m in root or mysql USER login.. then I can
login to mySQL server.. its fine..
but other than 'root' and 'mysql', i can not connect
to the database server..
thats why I am not able to run any
Hello,
Appareantly it's impossible to insert a string, consisting entirely out of
spaces, in a textual field (I've tried varchar(19) and char(2) types, they
both don't work). MySQL doesn't complain about it, but it trims the strings
down to the empty string. If I try a select searching for the
Hello,
I m ina great problem..
I am not able to conenct to mySQL server..
the problem is like.. when I m in root or mysql USER
login.. then I can login to mySQL server.. its fine..
but other than 'root' and 'mysql', i can not connect
to the database server..
thats why I am not able to run any w
Hello,
We are currently in the process of converting our MyISAM tables to InnoDB to
make our tables
transaction safe. Unfortunately, I am getting the following error on one
of the tables...
mysql> alter table SUBSCRIBERS type = InnoDB;
ERROR 1114: The table '#sql-fcc_1' is full
mysql>
What v
Greetings!!!
I would just like to know if the following is normal:
I created a file TRANSACTION_LOG.sql to create an InnoDB table with MULTIPLE
KEYs with one AUTO COLUMN.
The file consists of the following SQL commands:
drop table TRANSACTION_LOG;
create table TRANSACTION_LOG (SESSION_ID int(1
I am trying to install mysql for use with iis4 and when I click
on the setup.exe file an error message pops up but closes
right away so I can't see the problem. has anyone had this
frustrating experiance. If so please help.
Thank Mike
--
>an error "can't connect to MYSQL server through socket
>/tmp/mysql.sock"
This is a FAQ.
Searching through the archive will get you somewhere around a zillion hits.
Get through the filter: mysql, sql, query
Bye,
B.
-
Bef
hi ,i got this error 3 -4 times ,then i reinstalled
mysql & the it used to work properly.
Once i come baack to office the next day & run the page
again,it gives the same error again.
the error is
__
an error "can't connect to MYSQL server thr
is there a Raid Mode in MySQL.. I found a RAID_TYPE switch but dont know
much about it.
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Rizwan Majeed" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, March 12, 2002 11:51 PM
Subject: Re: RAID
> On Tue, Mar
At 21:08 12/03/02 -0800, Amit Lonkar wrote:
Hi!
>Hi All!!
>I have two machines on network System1 and System2.
>Mysql is installed on System1. On System2 I have a
>batch file which has the following command:-
You need to have a permanent System1 mapped drive on System2, for
example F:.
Then in yo
Weeehll, thet's whut ah git fer shootin' off at th' mouth.
Anybody that really knows care to correct the confusion I've caused?
(See comments below:)
Jim Philips wrote:
> On Mon, 2002-03-11 at 23:39, Joel Rees wrote:
> > Sort of off topic, but here goes:
> >
> > Jim Philips wrote:
> >
> > > I a
hi,
Can anybody tell me how can I write script for MySQL backup and
recovery.( i am newbie as per script is cencern)
I am using Innodb table type and using all the default parameters
specified in the my.cnf file (my-large.cnf)
Looking for kind response..
Thanks and regards,
Chetan Lavti
Hi All!!
I have two machines on network System1 and System2.
Mysql is installed on System1. On System2 I have a
batch file which has the following command:-
mysql --user=amit --password=amit --host=system1
--port =3306 --database=netaps --execute="LOAD DATA
INFILE 'C:\\Amit\\JobBatch.csv' INTO T
Hello,
I am trying to set permissions for a new user.
The only thing this user is allowed to do is to monitor traffic reports.
Normally, just SELECT would be enough.
But, to show him this report, program does MERGE of several tables.
In this database I have 10 static tables, all other tables a
At 22:39 -0500 3/12/02, Jianping Zhu wrote:
>I have two questions about jdbc
>1. which files should i down from www.mysql.com(mm.mysql.jdbc-1.2c.tar.gz
>or mm.mysql-2.0.4-bin.jar?)?
Neither. Go to http://mmmysql.sourceforge.net and get the current version,
which is up to 2.0.11 or so.
>2. Where
I have two questions about jdbc
1. which files should i down from www.mysql.com(mm.mysql.jdbc-1.2c.tar.gz
or mm.mysql-2.0.4-bin.jar?)?
2. Where should i put the driver and do i need to set some env variables?
Thanks
-
Bef
At 22:30 12/03/02 +, Mick wrote:
Hi!
Microsoft(R) Windows 95
(C)Copyright Microsoft Corp 1981-1996.
C:\>c:\mysql\bin\mysqld-opt --standalone --console
C:\MYSQL\BIN\MYSQLD~1.EXE: ready for connections
Microsoft(R) Windows 95
(C)Copyright Microsoft Corp 1981-1996.
C:\>c:\mysql\bin\mysql
Welc
Hi,
does any1 know what is the earliest version of Mysql
for Solaris, with support for InnoDB?
If I am not mistaken, the version that we have is
3.23.32.
Can MySql Max be added or some patch be added?
This is not on a personal machine. It's on a server
in my department (computer's science) and
Hi, Dave,
Glad to be of help. I hope you don't mind if I CC this rambling response to
the list. Concerning
> The documentation is not that useful (in terms of telling me just what
> languages are supported) but going by the directories it seems all bar
> Chinese are supported.
I haven't actuall
Hi,
I have this following error when back up table :
mysql> lock tables mytable read;
Query OK, 0 rows affected (0.02 sec)
mysql> select * into outfile
'/home/myhome/dump/mytable.txt' from mytable;
ERROR 1: Can't create/write to file
'/home/myhome/dump/mytable.txt' (Errcode: 13)
what does errc
I have this following code and mysql server running.
//Connect to MySql Server
try {
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
}
catch(Exception e){
System.out.println("Can not get class Name");
}
try {
c = DriverManager.getConnectio
Hi everybody!
I am a new for MYSQL.
I want to install MYSQL on AIX 4.3.2 (UNIX).
And I got the following error message.
Could someone can help me?
Shell> set MYSQL = '/adm/ac/listserv/Calendar/mysql'
Shell> echo $MYSQL
/adm/ac/listserv/Calendar/mysql
Shell> scripts/mysql_insta
I re-installed MySql from RH Linux 7.2 cd and now I am getting the following
[root@coolnis-ar mysql]# Starting mysqld daemon with databases from
/var/lib/mysql
020312 18:29:52 mysqld ended
[1]+ Donebin/safe_mysqld --user=mysql --err-log=my.err
[root@coolnis-ar mysql]#
[ro
I want to use your binaries (i used to build them in my own machine, but
i have followed this list and you're always saying to use yours).
Just a question: is there a way of using your binaries and have Table
type=RAID support ?
--
dsoares
(sql)
You have a strange problem so i've searched the MySQL manual:
http://www.mysql.com/doc/S/t/Starting_server.html
-
If you get the following error, it means that some other program (or
another mysqld server) is already using the TCP/IP port or socket mysqld
is tryi
I am using Visual C++ 6.0 in Windows 2000. I am able to compile
successfully. The following code(s) does not give output as documentation
specified.
Problem1 :
For documentation, please look at
http://www.mysql.com/documentation/mysql++/7_Specialized.html (7.7
sql_create)
For example documenta
On Tue, 12 Mar 2002, Sasha Pachev wrote:
> On Tuesday 12 March 2002 10:54 am, [EMAIL PROTECTED] wrote:
> > I created a ~5GB table full of large (TINY|BIG)TEXT fields in it. This is a
> fresh build and there has been no activity except for the following:
> > 1) Record inserts from flat file pars
- The default socket parameter is correct
- mysqld is not running earlier
- I changed the required ownership
#ls -ld /var/lib/mysql/
drwxr-xr-x4 mysqlmysql4096 Mar 12 17:46 /var/lib/mysql/
#
I am still getting the same
#more my.err
020312 15:56:40 mysqld started
020312 15:56:40
Here is an excerpt from http://www.innodb.com/ibman.html#InnoDB_distros,
section 4.2:
"Starting from version 3.23.43b InnoDB features foreign key constraints.
InnoDB is the first MySQL table type which allows you to define foreign key
constraints..."
Now, I assumed the version number abo
Hi,
I'm trying to run MySQL ver 3.23.49 on Win98 with Apache, PHP & Perl. Apache
reports that PHP & Perl are running OK. When I try to start MySQL, or let it
start on boot, or try to use the "WinMySqladmin" program, I get a Windows
error from MYSQLD-OPT.exe, with the usual Win98 "close" and "deta
> [root@coolnis-ar mysql]# more my.err
> 020312 15:56:40 mysqld started
> 020312 15:56:40 Can't start server : Bind on unix socket: Permission denied
> 020312 15:56:40 Do you already have another mysqld server running on
> socket: /var/lib/mysql/mysql.sock ?
> 020312 15:56:40 Aborting
>
> 02
This is what's going on
[root@coolnis-ar mysql]# Starting mysqld daemon with databases from
/var/lib/mysql
020312 15:57:31 mysqld ended
[1]+ Done./bin/safe_mysqld --user=mysql
--err-log=my.err
[root@coolnis-ar mysql]# more my.err
020312 15:56:40 mysqld started
020312 1
On Tuesday 12 March 2002 10:54 am, [EMAIL PROTECTED] wrote:
> I created a ~5GB table full of large (TINY|BIG)TEXT fields in it. This is a
fresh build and there has been no activity except for the following:
> 1) Record inserts from flat file parsing.
> 2) OPTIMIZE TABLE wich died in batch & cause
I am using Visual C++ 6.0. Samples look like MySql++ adds double-quotes
whenever required.
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, March 12, 2002 12:23 PM
Subject: Re: MySQL++ samples are not working
Check /var/lib/mysql/.err and permissions in that directory.
Does the mysql user have the permission to write on that directory ?
You you don't have the log error (it's very strange if you don't...), i
think safe_mysqld has the option --err-log= (but, by default,
it should be there).
I'm not shur
New to MySQL.
Have got RH Linux 7.2 on Intel-based processor
Installed MySql from a mysql-max-3.23.49a-pc-linux-gnu-i686.tar.gz
Followed the documentation instructions given in Chapter 2 online at
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Installing_binary
I get th
New to MySQL.
Have got RH Linux 7.2 on Intel-based processor
Installed MySql from a mysql-max-3.23.49a-pc-linux-gnu-i686.tar.gz
Followed the documentation instructions given in Chapter 2 online at
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Installing_binary
I get th
Dear Sir,
This is my first time trying to use mysql. The version
that I downloaded is mysql-3.23.49-win.zip. After
unzipped the file and execute the "Setup.exe". I
installed the mysql in f: driver. After the
installation, I am not able to locate the
"my-example.cnf" file that mentioned during the
Hi everyone,
If you have increased your MAXDSIZ variable in FreeBSD to above
2048 the mysqld will crash on FreeBSD 4.5. Please set it to 2047 or
lower:
options MAXDSIZ="(2047*1024*1024)"
to quote a very intelligent source (Thanks Sinisa!)
>It happens with MySQL as it is the only one
Hi there,
I wonder if anyone can offer me some advice...
I have developed a portal using PHP, which allows users to uploads files
into their own personal storage locations. These files are stored in a
MySQL database. The system also allows the users to select these files
and submit them for anal
Radhakrishna Mohan Tadepalli writes:
> Thanks for your reply. I do not have any problem in compilation. My problems
> are with double quote characters, single quote characters and insufficient
> help. Is there any way I can supress exceptions?
>
> Here is one of the problems I am facing when try
On Tue, Mar 12, 2002 at 10:42:37AM -, Simon Green wrote:
> PS sorry I know it not the most interesting on questions
And it has been discussed a lot frequently, in one form or another.
The bottom line is that it'll be ready when it's ready. For more
details, please check the archives.
On Tue, Mar 12, 2002 at 11:37:20AM -0800, Henry Hank wrote:
>
> Hello All,
>
> I've recently installed mySQL on a RH7.2 box without any problems
> - it runs great. I've been testing some long running queries (full
> table scans, etc) under different scenarios, and get wildy differing
> result
Thanks for your reply. I do not have any problem in compilation. My problems
are with double quote characters, single quote characters and insufficient
help. Is there any way I can supress exceptions?
Here is one of the problems I am facing when try to run a sample.
The sample compiles with 0 e
>Description:
mysql-4.0.1-alpha fails to build on IBM AIX 4.3 because of
gcc'isms in the source code. A fix for that problem is
supplied below.
However, configure says:
checking for alloca.h... no
checking for working alloca.h... (
Hello All,
I've recently installed mySQL on a RH7.2 box without any problems - it runs
great. I've been testing some long running queries (full table scans, etc)
under different scenarios, and get wildy differing results. Between each test
case, I was flushing all tables and re-starting the
On Tue, Mar 12, 2002 at 04:04:48PM +0500, Rizwan Majeed wrote:
>
> Can somebody give me an intro into using MySQL over RAID array or
> direct me to a good resource on the net. I also want to know what
> type of tables support RAID. Is it only MyISAM tables?
If you're talking about a RAID disk co
I have some code I used to convert Foxpro to XML. I've put it up for
anonymous ftp at ftp://lexpar.com/pub/foxpro_conversion.zip.
There's an executable, which requires only the Foxpro runtime dll's (which
are redistributable). It does put out memo fields correctly.
I've included the source--all
From: "Wout Neirynck" <[EMAIL PROTECTED]>
> Appareantly it's impossible to insert a string, consisting entirely out of
> spaces, in a textual field (I've tried varchar(19) and char(2) types, they
> both don't work). MySQL doesn't complain about it, but it trims the
> strings down to the empty st
From: "shaj " <[EMAIL PROTECTED]>
> Can any one tell me what is the text limitation for mySQL??
The limitation for the TEXT datatype?
>From http://www.mysql.com/doc/B/L/BLOB.html:
"The maximum size of a BLOB or TEXT object is determined by its type, but
the largest value you can actually trans
MySQL can do the whole job. The client doesn't need to do the
encryption. Just use the password() function in your select and
updates.
--Aaron
Java examples:
String insertStatementStr = "INSERT into users VALUES
(?,?,?,?,PASSWORD(?),?,?, ?, ?)";
ResultSet myResultSet = stmt.executeQuery("SELE
[EMAIL PROTECTED] writes:
> >Description:
> I am not subscribe to this list so please cc me in your reply.
>
> I created a ~5GB table full of large (TINY|BIG)TEXT fields in it. This is a fresh
>build and there has been no activity except for the following:
> 1) Record inserts from flat file pa
From: "Peter Gibbons-BU" <[EMAIL PROTECTED]>
> Hi,
> i'd like to create a password field like in the user table in the mysql
> database. The data would need to be encrypted.
>
> Can mysql do the whole job. I would need it ideally to automatically
> decrypt it for me when I do a select..
>
> any
This is probably indexed wrong, so I thought I would put it
out to the list to see if it is.. or if I 'm just going to have to
live with it.
Anyway, I have two tables I'm joining together, and MySQL is not
using the index on the column in the second table I'm joining on.
Here is the explain and
Can any one tell me what is the text limitation for mySQL??
--
Shaj Miah
Cheif Information Officer
t. 718.599.7775
e. [EMAIL PROTECTED]
www.Diversityforhire.Com
The Space And Place For Work & Culture
--
-
Before posting, please
Hi!
> "Ken" == Ken Menzel <[EMAIL PROTECTED]> writes:
Ken> Hi Monty and Sasha,
Ken> Just a quick not to say that's such a great idea that Monty even
Ken> thought of it before! Monty and I discussed this last September, I
Ken> hope we could get something like this in 4.1
Ken> Just a
>Description:
I am not subscribe to this list so please cc me in your reply.
I created a ~5GB table full of large (TINY|BIG)TEXT fields in it. This is a fresh
build and there has been no activity except for the following:
1) Record inserts from flat file parsing.
2) OPTIMIZE TABLE wich died in
Peter,
I have no idea what your front end is, and this is what will do the
actual encryption, all mysql does is holds the data. So whatever your
front end programming language is, it will have to do the encryption.
Below is the link for php encryption
http://www.php.net/manual/en/function.md5
Thi Cao writes:
> All,
>
> I tried to run a script using MySQL++, but the procedure threw an exception
> stating that there's something wrong with the syntax. I did the following:
>
> Connection conn;
> Query query(&conn);
> Result result;
>
> conn.connect("dbase","host","user","passwd");
> qu
Does anyone have a script to check on the replication status of the slave to make
sure it isn't falling too far behind?
Thanks, Dave Turner
sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Beings as I haven't gotten an answer to this, is there a better place to
find information on this?
- Original Message -
From: "David M. Peak" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Friday, March 08, 2002 1:03 PM
Subject: Re: Changing Default for Not Null to NOTHIN
Some use of the Host table in db mysql mite do what you need?
Simon
-Original Message-
From: Jason Joines [mailto:[EMAIL PROTECTED]]
Sent: 12 March 2002 17:25
To: MySQL Users
Subject: User / Group Permissions
Does MySQL support creation of groups so you can grant specific
permissi
Hi,
i'd like to create a password field like in the user table in the mysql
database. The data would need to be encrypted.
Can mysql do the whole job. I would need it ideally to automatically
decrypt it for me when I do a select..
any suggestions - code example would be really helpful..
peter
Does MySQL support creation of groups so you can grant specific
permissions to a group of users instead of having to do this to each
individual user?
Jason Joines
-
SELECT a, b, c, SUM(d) FROM a GROUP BY a,b
this will not work however because c isn't contained either in the group by
or a function.
Try either:
SELECT a, b, c, SUM(d) FROM a GROUP BY a,b,c
or
SELECT a, b, max(c), SUM(d) FROM a GROUP BY a,b
depending on your needs
-Original Message-
i am having a problem with mysql-3.23.49. just the client seems to be
having issues. it segfaults and core dumps, on this one machine. if i move
it to another machine, it works fine. so im pretty sure its not a bug. anyway
here is what i have found:
mysql-3.23.49
gcc 2.95.3
gnu make 3.79.1
gnu ld
"InnoDB Hot Backup-0.33 beta is now available for Windows NT/2000/XP and
Linux."
Any plans for Solaris by the May 2002 release date?
> From: "Heikki Tuuri" <[EMAIL PROTECTED]>
>
> The beta testing of InnoDB Hot Backup (a non-free add-on tool) started on
> Monday. If you want to take part in the
that's just a typo in the email message, however the script itself is
correct
-Original Message-
From: Thi Cao
Sent: Tuesday, March 12, 2002 11:00 AM
To: Thi Cao; MySQL
Subject: RE: Running a script using MySQL++
sorry, careless typing, but that's just a typo
-Original Message
Hi folks,
I need a select groupped by more than one field like:
SELECT a, b, c, SUM(d) FROM a GROUP BY CONCAT(a,b)
- but it doesn't work (MySQL 3.22). Is it poissible somehow?
cu,
fns
-[ mailto:[EMAIL PROTECTED] http://www.megaram.hu/~fns icq:878397 ]-
-[ Zavart erzek az eroben.
sorry, careless typing, but that's just a typo
-Original Message-
From: Thi Cao [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 10:48 AM
To: MySQL
Subject: Running a script using MySQL++
All,
I tried to run a script using MySQL++, but the procedure threw an exception
stating t
Hi,
you can see the monitor's output in the logfile. In my case (mandrake linux), it is in
/var/lib/mysql and I do:
tail -f /var/lib/mysql/SERVERNAME.err
> Also, where do I designate autocommit = 0;
Use "SET AUTOCOMMIT = 0" as a SQL query. Just issue it where you do your SELECT,
UPDATE etc.
* Thi Cao
> dropt database if exists sample;
^
Don't know if this is the reason for your problem, but it should be 'drop'.
--
Roger
query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
All,
I tried to run a script using MySQL++, but the procedure threw an exception
stating that there's something wrong with the syntax. I did the following:
Connection conn;
Query query(&conn);
Result result;
conn.connect("dbase","host","user","passwd");
query << "source batch.sql"; //most lik
Hello,
Appareantly it's impossible to insert a string, consisting entirely out of
spaces, in a textual field (I've tried varchar(19) and char(2) types, they
both don't work). MySQL doesn't complain about it, but it trims the
strings down to the empty string. If I try a select searching for t
BUNTER,
Tuesday, March 12, 2002, 5:45:00 PM, you wrote:
BM> I tried the blank password by hitting enter instead of entering
BM> text with no luck - same rejection. I shall try updating the
BM> table. I thought that passwords could only be changed with
BM> mysqladmin. The password will be unencryp
Javier,
Tuesday, March 12, 2002, 3:04:21 PM, you wrote:
J> I have a table like that
J> table1:
J> field1
J> field2
J> .
J> .
J> .
J> where :
J> field1,field2
J> is the primary key.
J> When I make this query:
J> SELECT * FROM table1 USE INDEX(PRIMARY)
J> I get a different
>Description:
A build of mysql-4.0.1-alpha on DEC Alpha OSF/1 4.0 failed
like this:
gcc -O3 -DDBUG_OFF -o ft_dump ft_dump.o libmyisam.a \
../mysys/libmysys.a ../dbug/libdbug.a \
../strings/libmystrings.a -lpthread -lmach -lexc -lz -lm \
--- Reçu de RVIDOI.BUNTERMA 04 72 96 57 7712/03/02 16.45
I tried the blank password by hitting enter instead of entering
text with no luck - same rejection. I shall try updating the
table. I thought that passwords could only be changed with
mysqladmin. The password will be unencrypted i
You could just log on and use update on the user table...
Or try entering a blank password?
Simon
-Original Message-
From: BUNTER MATTHEW [mailto:[EMAIL PROTECTED]]
Sent: 12 March 2002 15:32
To: [EMAIL PROTECTED]
Subject: MySQL 3.23.41 on RH7.2
--- Reçu de RVIDOI.BUNTERMA 04 72 9
>Description:
mysql command line client seems to favor local sockets for
connections, even when -P or --port are used.
I wish to have mysql connections tunneled through ssh. This is
complicated by the fact that I'm running mysqld on the remote host
and the local host.
--- Reçu de RVIDOI.BUNTERMA 04 72 96 57 7712/03/02 16.32
All,
Installed MySQL as part of my setup. Server is running, I can
connect as root with no password.
I attempt :
mysqladmin -u root -p password 'newpassword'
I get :
Enter password : blahblahblah
root@localhost rejected
I l
This is odd. I was able to access my mysql server from another machine
on the LAN just fine last week. I updated the rpms from the official
mysql site and am now running version 3.23.49a of the server. Access is
fine from the localhost, but I get an ERROR 1130 from a host on the LAN.
That host lo
How about trying to avoid using ODBC? Check out:
http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=22472&lngWId=1
or
http://www.icarz.com/mysql/
Craig
At 10:53 AM 3/12/2002 +0100, you wrote:
>Hi there,
>
>I have a problem with MySQL and the connection to it.
>
>What I want is
Hi,
Denny wrote:
>
> Hi,
>
> Is there any examples on developing a java interface with mysql?
Do you want to develope a JDBC API with MySQL?
If no and you want to develope a Java Program using JDBC API with
JDBC Driver for MySQL, please see this web site.
http://java.sun.com/docs/book
Äþº£½¢,
Tuesday, March 12, 2002, 7:47:34 AM, you wrote:
Ä> The mysql server can't work.Anyone know what will I do?
1. What OS do you use?
2. How did you install MySQL? (binary or source distribution)
3. How did you start MySQL server?
4. What type of error did you receive? (check 'mysql.err' or
Jerrad,
Tuesday, March 12, 2002, 12:52:00 AM, you wrote:
JP> Why doesn't mysql have a --err-log option?
JP> Are at the *very* least send it's output to STDERR instead of STDOUT?
mysqld writes all errors to the 'mysql.err' file (in Windows) or to
the stderr, that is redirected by safe_mysqld to t
Philip,
-Original Message-
From: Philip Molter <[EMAIL PROTECTED]>
To: Heikki Tuuri <[EMAIL PROTECTED]>
Cc: Bob McLaughlin <[EMAIL PROTECTED]>; MySQL Mailing List
<[EMAIL PROTECTED]>
Date: Tuesday, March 12, 2002 4:21 PM
Subject: Re: Foreign keys in mysqldump?
>On Tue, Mar 12, 2002 at 1
On Tue, Mar 12, 2002 at 11:50:12AM +0200, Heikki Tuuri wrote:
: Bob,
:
: I have now improved foreign key support so that version 3.23.50 does
:
: 1. show the FOREIGN KEY definitions when you call SHOW CREATE TABLE; this
: should also show them in mysqldumps;
: 2. preserve FOREIGN KEY definitions
Bob,
thank you!
I believe 3.23.50 will be out in two weeks. It is a stable version. The
changes in foreign keys were actually rather small. I hope they do not
degrade .50 to the beta category.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysq
Harald Fuchs writes:
> [This is for MySQL 4.0.1 alpha on Linux 2.2.18-SMP, if it should matter]
>
> Either I misunderstand the manual, or I found a small bug. Consider
> the following command sequence:
>
> mysql -e 'CREATE DATABASE t1'
> mysql t1 -e 'CREATE TABLE t1 (id INT)'
> mysql -e 'G
Heikki,
You are the man!
I am glad you are addressing these issues in 3.23.50. They will make
foreign key support in MySQL much more robust (in my opinion, anyway..)
Is the .50 release available yet? If not, do you have a timeline for when it
will be, and when it would be recommended to use in
I'm with you on that. Many times we preach against "reinventing the wheel",
but sometimes doing that can help you learn an awful lot about "the wheel".
I also find that some of my best learning comes from taking on a hard
project and just trying to make my own solution to it. Anyway...
You migh
Thanks Kim and Georg,
but I want to do this myself! Ok it may be hard, but i'm confident
I have taught myself an awful lot by having a 'difficult' project on the go
so, bearing that in mind, can I re-ask my question!
thanks again
incidently I am making a SITE search, not a web search engin
On Mon, 2002-03-11 at 23:39, Joel Rees wrote:
> Sort of off topic, but here goes:
>
> Jim Philips wrote:
>
> > I am trying to understand how to store both Latin and Cyrillc characters
> > in a database. I built in support for koi-8 and win1251, but I don't
> > seem to be getting real support for
Hi all,
I'm having a small problem with a biggish query.
The query:
$Itemlistquery= "select [a whole load of fields from 3 tables] ending with
";
$Itemlistquery.= "transactions.Pdownload ";
$Itemlistquery.= "from bib_extract,scanrates,transactions where ";
$Itemlistquery.= "(transactions.Course
Radhakrishna Mohan Tadepalli writes:
> Does anybody tried MySQL++ samples? I guess they are not working. Any help
> is appreciated -Radha
>
Hi!
They should all be working.
Supported compilers :
* GNU 2.95.* and 3.*
* Compaq 6.3
* VC++ 6.0 (custom*.cc examples do not work)
* BC++ 5.*
--
Rega
Hi all,
I have a table like that
table1:
field1
field2
.
.
.
where :
field1,field2
is the primary key.
When I make this query:
SELECT * FROM table1 USE INDEX(PRIMARY)
I get a different result, if I make this:
SELECT * FROM table1 ORDER BY field1,field2
Why? Is not th
George,
What I would do is include an auto_increment column in the table and order
the select queries
by that column. I don't know of a way of doing what you want with existing
data.
John Lodge
-Original Message-
From: George Marnellos [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12,
1 - 100 of 115 matches
Mail list logo
