dont you mean:
create database gnudip2;
create table table1 (id int(10),some_colum varchar(255));
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Ana Elisa Martinez" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, May 15, 2001 10:57 PM
Subject: Re: Error creating databas
Quick simple question how do i add a user to my mysql system?
Thxs
Stephen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request th
Hi,
We're trying to set up a replication server & were wondering whether it's
possible to set up a replication server that would replicate databases from
different servers eg.
ServerA ServerB
databaseA databaseB
ServerC
databaseA
DIRLIK Christophe writes:
> i've downloaded a 1.7.5 Linux semi static binary distribution of My Sql Gui.
>
> Seems to work fine except that i have a connexion error. Documentation
> mention to enter a path to named pipe in options.
>
> I'm new to linux (and unix...). I don't know what file to se
Hi there!
I installed MyODBC and tried to import a Database from my Web Hosting
account but didn't let me. Was it me that didn't know how to do it or is it
possible that access is only allowed through local connection?
TIA
Regards
-
Florin Andrei writes:
> On 15 May 2001 13:21:12 +0300, Sinisa Milivojevic wrote:
> >
> > The reason why you are having problems in building from source is that
> > you are most probably using gcc 2.96, which is simply broken.
>
> Will you accept further patches to the spec file that will try to
Florin Andrei writes:
> On 15 May 2001 13:21:12 +0300, Sinisa Milivojevic wrote:
> I have different results. Here:
>
> (I'm doing everything on a dual-proc Linux Red Hat 7.0 system with all
> updates applied, except for the kernel which is the original one)
>
> I modified the spec file like this
Hi everybody
Anybody knows how to make a mysql farm ( like a load balancer but wiht mysql) ?
Jesús Gómez Pastor
[EMAIL PROTECTED]
Equipo de Desarrollo
Autocity.com
www.autocity.com
wap.autocity.com
We are planning to migrate from Oracle to mysql. Before we do it, i need
clarification on:
1. Does mysql supports triggers ?
2. if a client has to excess mysql then is a copy of mysql needed to be
installed on the clients machine (just as u have sql3.3 for oracle)?
Regards,
Suryakant K Shelar.
David Favor writes:
> No mention of this on the lists. Suggestions?
>
> ___
>
Hi!
Do not use MIT threads with 4.2. Use FreeBSD native threads, as
described in our manual.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*|
On Wed, May 16, 2001 at 04:13:50PM +0530, [EMAIL PROTECTED] wrote:
> We are planning to migrate from Oracle to mysql. Before we do it, i need
> clarification on:
>
> 1. Does mysql supports triggers ?
> 2. if a client has to excess mysql then is a copy of mysql needed to be
> installed on the clie
Hi all,
Two easy pieces :-):
1)Anybody has experience in using MySQL for data warehousing?
2)Anybody has tried to implement OLAP engine for data warehousing using
MySQL???
I thank You in advance!
Have a nice day ...
--
Dr. Corrado Topi
Manger of the Special Projects Unit
Elbi International
Joshua J. Kugler writes:
> -> This was posted before, but under a title that made it sound like a "read
> the manual, silly" type of question. Hopefully someone can answer this.
>
> I would like to be able to filter users based on other criteria than just
> their name/host. Will mysql complai
Use the GRANT command. Example (pick the permission you need ... be careful:
GRANT SELECT,
INSERT,
UPDATE,
DELETE,
INDEX,
ALTER,
CREATE,
DROP,
RELOAD,
SHUTDOWN,
PROCESS,
FILE,
ON {database}.*
TO {username}@localhost
IDENTIFIED BY '{password}',
WITH GRANT OPTION;
This is detailed in the MySQL Man
Jan-Erik Bullett writes:
> Hello,
>
> I downloaded the MySQLGUI 1.7.5 source code from
> http://www.mysql.com/Downloads/mysqlgui/mysqlgui-1.7.5.tar.gz and
> unpacked it for compilation on my Linux Mandrake 7.1 system. The problem
> is that it appears not to be a source distribution with no in
Can I install MySql database on PC running win95 as an OS?
Regards
Charles
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request thi
Hi,
I got the following error during compilation of MySQL-3.23.38 on my
HPUX-11 box witg gcc-2.95.2.
log0log.c: In function ´log_pad_current_log_block´:
log0log.c:330: Internal compiler error at expr.c:2829
After upgrading to gcc-2.95.3 I got the same error???
No problem compiling MySQL .37 on
I've set up a database containing 10.000 main records.
However, there are LOTs of n:m-relationship tables surrounding the main
table.
Now I want to set up an efficient search through the whole datamodel.
==> I've got lots of SELECT id, title from main LEFT JOIN subtable1 ...
LEFT JOIN WHER
Jamie,
I do not think it is the Reiser file system. Could you show what parameters
you have in my.cnf and what is the size of the file ibdata1 (when looked
with ls -l)?
Regards,
Heikki
http://www.innobase.fi
>I complied MySQL as a max binary. However when I gave all the variables for
>InnoDB i
Andreas,
sorry, it is the default MySQL behavior to create a MyISAM table if
another handler is not present.
There was a long thread of emails between MySQL developers if MySQL
should give an error message if a table cannot be created to be of
type BDB or InnoDB because the handler is not presen
Hello Heikki,
Wednesday, May 16, 2001, 4:01:26 PM, you wrote:
HT> Andreas,
HT> sorry, it is the default MySQL behavior to create a MyISAM table if
HT> another handler is not present.
HT> There was a long thread of emails between MySQL developers if MySQL
HT> should give an error message if a t
Hi,
1.
What is the default memory allocated by mysql to a
newly created database?
2.
If I make any changes to a database(either by adding a
new table or by adding or deleting a column of a
table) is there a way ,I can have a version control of
my database and retain the old tables and new tables
o
Hi,
1.
What is the default memory allocated by mysql to a
newly created database?
2.
If I make any changes to a database(either by adding a
new table or by adding or deleting a column of a
table) is there a way ,I can have a version control of
my database and retain the old tables and new tables
o
Hello,
My mySQL server runs on Windows NT. I use the default character set
Latin1. I connect to the database with myODBC from a Visual Basic
program using ADO. The problem is that the French accented characters are
not displayed correctly.
I found in the documentation a paragraph describing
how can in insert i.e. a tar-archive in a blob ?
i want to do it with perl. i read allready about the quote function but i
wount work
#!/usr/bin/perl
use DBI;
# DB-Vars
$host = "ux4";
$database = "db_webera";
$user = "webera";
$pass = "webera";
$port = 3306;
$driver = "mysql";
$dsn = "DBI:$dr
I am looking for MySQL for Apple's Mac OS X (10.0.3).
Up to now I have only found some old versions for Mac OS X Server or OS X
Beta
Any tips or hints?
Regards
Robert Goeres
-
Before posting, please check:
http://www.mysql.co
David Favor writes:
> Sinisa Milivojevic wrote:
>
> The Web hosting service I am using does not have Native Threads installed.
> When I requested they install the package, they seemed clueless about how
> to do this.
>
> What is the exact command I need to tell them to issue to install the
> Nat
>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:
At 2:36 PM +0200 5/16/01, Robert Goeres wrote:
>I am looking for MySQL for Apple's Mac OS X (10.0.3).
>Up to now I have only found some old versions for Mac OS X Server or OS X
>Beta
>Any tips or hints?
Try this ...
http://www.versiontracker.com/moreinfo.fcgi?id=10425
--
%~
Hi,
Yes, you can install MySQL in Win95 but keep in mind because of bugs in
Win95 MySQL may not perform as expected.
Win95 leaks memory each time a client connect to MySQL.
Regards,
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL
System Sun Fire 280R with dual USIII @ 750Mhz and 8G RAM. Solaris 01/01
media kit installed
Can anyone point me to the reason this is happening?
[ paul@tbd /usr/src/mysql-3.23.38 ] $ sudo
./configure --prefix=/usr/local/mysql
loading cache ./config.cache
checking host system type... sparc-sun-so
WA> how can in insert i.e. a tar-archive in a blob ?
WA> i want to do it with perl. i read allready about the quote function but i
WA> wount work
Try to use placholders. I'm under impression that quote is not
reliable. At least man DBI says:
Quote will probably not be able to deal wi
The problem is the Web hosting service I use does not have this
package installed. In other words, there is no libpthreads.* in
any of the library directories.
___
Sinisa Milivojevic wrote:
>
> David Favor writes:
> > Sinisa Milivojevic wrote:
> >
> > The Web hosting service I am using doe
"David Simmons - EliteUKServe.Net" wrote:
> what I had to do was download and install:
http://www.mysql.com/Downloads/MySQL-3.23/MySQL-client-3.23.38-1.i386.rpm
http://www.mysql.com/Downloads/MySQL-3.23/MySQL-devel-3.23.38-1.i386.rpm
>
> as well.
>
> removing the originals via yast
>
> if i rem
Andre,
try the following put on the line 330 in mysql/innobase/log/log0log.c
lsn = log_reserve_and_open(OS_FILE_LOG_BLOCK_SIZE);
Maybe gcc will compile in a different way then and not crash. Please
report to me if you succeed. I will change the source then.
Regards,
Heikki
http://www.in
Hi,
we've got a customer with a large ms sql database but want to replicate a
smaller dataset to our own mysql server. Is this possible, and does anybody
have experiences with it,
regards,
Sander
Freebsd does not have a libpthreads file.
Just compile with -pthread(s) and it'll work. Well, it does for me.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 16 May 2001 16:18
> To: Sinisa Milivojevic
> Cc: [EMAIL PROTECTED]
> Subject: Re: Help with Fr
You can compile from source on OS X. I personally built 3.23.36 on 10.0
when it came out; right now it requires a couple of edits to the source
code prior to compilation. The edit can be found here:
http://www.mysql.com/doc/M/a/Mac_OS_X_Public_Data.html
in the "Comments" section. Once you p
WA> thank you !
WA> i get it into the database but
WA> with a select i get
WA> select * from table;
WA> [..skip..]
WA> Can i read the data out and put in a file ?
WA> you understand ?
It probably just means that mysql client is confused by binary
data. It usually doesn't handle it well. It do
>>4) Ok, datafiles created overnight. Now trying alter table ...
>type=innodb
>on a
>>file with 1.2mil records. Still waiting after about 12 hours. Dumping
>files
>this
>>size is going to be problematic. Machine pegs with load of around 12! I
>suggest
>>LOTS more testing on BIG tables. Small
Hi list members!
I have a doubt regarding how can I INSERT and SELECT an IMAGE from a MYSQL
database. I'm using , in the DB, the BLOB field, so, I will be able to
receive binary data. Thnaks for any help!
Best Regards,
Felipe Moreno
-
I am searching to speed up an operation I have, which works - it just
takes minutes to finish. The current script is written in pike (a C like
scripting language). I believe that most of the overhead is the multiple
queries. Would using C++ be significantly faster? (I'd have to learn
some C before
> "DF" == David Favor <[EMAIL PROTECTED]> writes:
DF> The problem is the Web hosting service I use does not have this
DF> package installed. In other words, there is no libpthreads.* in
DF> any of the library directories.
But FreeBSD native threads do not need any libpthreads.* files. Your
Hi!
I already found an easy solution. Write to the file in 16 MB chunks
instead of 1 MB chunks. Then I got 5 MB/s on our Linux Xeon.
I do not think MyISAM uses fsync at all. I need fsync because in
recovery I must know that some database pages have been cleanly written
on disk.
These fsync thin
Hi!
At 05:04 PM 5/16/01 +0200, you wrote:
>>>4) Ok, datafiles created overnight. Now trying alter table ...
>>type=innodb
>>on a
>>>file with 1.2mil records. Still waiting after about 12 hours. Dumping
>>files
>>this
>>>size is going to be problematic. Machine pegs with load of around 12! I
>
Vivek Khera wrote:
>
> > "DF" == David Favor <[EMAIL PROTECTED]> writes:
>
> DF> The problem is the Web hosting service I use does not have this
> DF> package installed. In other words, there is no libpthreads.* in
> DF> any of the library directories.
>
> But FreeBSD native threads do not
Vivek Khera wrote:
>
> > "DF" == David Favor <[EMAIL PROTECTED]> writes:
>
> DF> The problem is the Web hosting service I use does not have this
> DF> package installed. In other words, there is no libpthreads.* in
> DF> any of the library directories.
>
> But FreeBSD native threads do not
Compiled with -D_REENTRANT -D_PTHREADS -fPIC -DPIC -Wall
Linked with -pthread
but its not mysql. For mysql I just did ./configure; make; make install
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 16 May 2001 17:11
> To: Sander Pilon
> Cc: 'Sinisa Mil
No, by multiple queries I mean that I have to querie for every title. The
query is:
Select if(Year<>'"+y+"','1','0') as quest,MM,Archive,record_num from inv where
((REPLACE(Title,'#','')='"+t+"' or REPLACE(Title,'#','')='"+s+"' or
REPLACE(Title,'#','')='"+u+"' or REPLACE(Title,'#','')='"+v+"' or
R
I have this query built from a web form. The form will add to the query
depending on what search criteria has been chosen. what happens is if they
choose the criteria in the query below, it stops comparing the other
criteria such as listed date and price range. Also the = operator does not
return
One of the tables of my database suddently became read-only; when I try
to add a line, I get:
ERROR 1036: Table 'Requests' is read only
I'm alone working on this table, and didn't lock it. Does anyone know
how I can unlock this table?
TIA
Greg
---
1) How large the data base is it? how many records?
2) Are you using index?
I has tested MySql serving with Pentium II 266 with Windows 98 2da. Ed.
operating System and with one table consisting of 762000 records. Even
before I indexed the database, speed of MySql was great. Of course, after
t
7 or so. I have indexes on most of the columns being used..
Enrique Vizcarra wrote:
> 1) How large the data base is it? how many records?
> 2) Are you using index?
>
> I has tested MySql serving with Pentium II 266 with Windows 98 2da. Ed.
> operating System and with one table consisting of
Your filter really makes having a discussion difficult. I think I'll
just go away.
> "m" == mysql <[EMAIL PROTECTED]> writes:
m> Your message cannot be posted because it appears to be either spam or
m> simply off topic to our filter. To bypass the filter you must include
m> one of the fol
Hi,
We've got a situation happening on a server, and have no idea why.
The server is a PII/600 with 1G memory, running BSDI 4.0.1 .
The Mysql is "mysql-3.22.32", and was compiled with :
gmake distclean
PATH=/usr/local/bin:/sbin:/usr/sbin:/bin:/usr/bin:/usr/contrib/bin:/
So, when MySQL goes to its own permisions table, it does a "select *", not a
"select user, host" etc.? Why is that? It seems that for flexibility it
would name the fields it was selecting so it would know the order would
always be the same.
Anyway, if I don't change the order of columns (i.e
ouch, no idea what I was thinking.
Thanks
On Wed, 16 May 2001, David Simmons - EliteUKServe.Net wrote:
> dont you mean:
>
> create database gnudip2;
>
> create table table1 (id int(10),some_colum varchar(255));
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "Ana Elisa Ma
Hello,
I am trying to install mysql(mysql-3.23.8-alpha) on Solaris2.8 with a prefix
of the installation directory.
the configure is ok but when I try to run make I get the following errors:
sh: ar: not found
*** Error code 1
make: Fatal error: Command failed for target `libreadline.a'
Current wor
Check the attrib of the file, maybe is read only.
most times, when files has been copy to CD the attrib of files is automatic
changed to read only, and when the copy is back to hard drive the read only
remains, so, acces is denied.
check too, the attributes of the table created and the user ri
hi.
add the directory where 'ar' is to your path.
PATH=$PATH:/path/to/ar; export PATH
if i remember correctly, it should be in usr/ccs/bin.
hth.
-ravi
-Original Message-
From: Dana Sharvit [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 1:06 PM
To: [EMAIL PROTECTED]
Subject: in
Dear Sir,
Thanks for your valuable answer. But I am maintaining some connection pool
and I am querying DB in regular interval. Now also this problem occurs.
Even if we assume that this problem occurs due to the reason as suggested by
you, why this error happens when there is no data ba
On Wed, May 16, 2001 at 03:01:26PM +0300, Heikki Tuuri wrote:
> Andreas,
>
> sorry, it is the default MySQL behavior to create a MyISAM table if
> another handler is not present.
>
> There was a long thread of emails between MySQL developers if MySQL
> should give an error message if a table can
Jamie,
really strange. Now I start to suspect the file system. InnoDB should create
and write a file of size 2000 MB like you specified in my.cnf.
InnoDB does the initial file write in 1 MB chunks using pwrite,
calling fsync in between.
When you restart MySQL, InnoDB checks if the data file is
I have encountered many problems during the downloading, unpacking and
installating of MySQL, some of my own making and some that I can't
determine. After two days of searching in the Documentation at mysql.com
and reading of the Archival files, I turn to you, since I cannot find an
answer to my p
>We are performing some rather extensive data collection (measurements) and
>are attempting to come up with the most sane storage mechanism to
>facilitate offline (Igor, MatLab, Custom Apps) and online (less complex
>web based solutions) analysis tools. The problem resides in the amount of
>data
>Dear,
> I have an table which like to use recursive join but I wonder
>how to use it. Please see the table struc below.
> emp.id,emp name, emp salary, emp head-id
> 001,mr. a,1,001
> 002,mr. b,5000,001
> 003,mr. c,5000,003
> 004,mr. d,5000,003
> Whe
Hi!
Note MySQL version: 3.23.33
I need to sort sql query results in a complex way. If you could please help
it would
be much appreciated. Thanks in advance!
I have 7 tables: 1 is a base table then 3 pairs of list and joiner tables
2,3; 4,5; and 6,7 where 2,4 and 6 are joiners between 1 and
CREATE TABLE Ftt (sajtid smallint(6) DEFAULT '0' NOT NULL,count int(10)
unsigned DEFAULT '0' NOT NULL,PRIMARY KEY (sajtid)) select
log.sajtid,count(*) from log,sajter where log.sajtid=sajter.id and log.mon =
5 group by log.sajtid;
the create table on its own works, the select statement works,
I am new to MySQL and am using Paul DuBois's book to MySQL guide me. (Great
Book!)
I am attempting to use PHP, My scripts always connect to the MySQL server OK,
and the Databases to, but my queries always fail with the following message:
OK 1 OK 2
Parse error: parse error in /home/httpd/html/
Shouldn't you have on line 7
print ("OK 2 ");
and not
print ("OK 2 ")
Im not a PHP person but thats what I noticed in your code. And if ;
terminates a command that can't be helping
magic words sql database
-Original Message-
From: MTF [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May
You should be using echo in place of print.
echo "OK 2";
>Robert Henkel
>Shouldn't you have on line 7
>print ("OK 2 ");
>and not
>print ("OK 2 ")
>Im not a PHP person but thats what I noticed in your code. And if ;
>terminates a command that can't be helping
>
>
>
>
>
>magic words sql database
In Addation,
Print ("OK 3") line is also missed ':'.
^^
magic words sql database
- Original Message -
From: "MTF" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 16, 2001 12:13 PM
Subject: Parse error?
> I am new to MySQL and am using Paul DuBois's book to MySQL g
MySQL WebClient 0.0.1 Features
==
Web-based access to any MySQL server on the Internet.
Easy access to database tables, allowing structural configuration and data
input/output.
Client-side form validation, minimizing unnecessary interaction with server.
Command line
Thanks for the speedy replies to my query problem, after I buy some new
glasses I'll be going back to the books.
Thanks again
Mike
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://list
Hi!
> "Steve" == Steve Ruby <[EMAIL PROTECTED]> writes:
Steve> Due to the fact that piping a table from mysqldump to an INNODB table
Steve> can be as much as 30X slower if the insert is not done with
Steve> transactions,
Steve> would it make sense to add some option to mysqldump to make eve
Hi all!
I need to know how to solve this.
I keep on having this error whenever my scripts using mysql_connect()...
Fatal error: Call to undefined function: mysql_connect() in
/www/html/phpMyAdmin/lib.inc.php on line 255
TIA!!!
Regards
Annie
Hi,
I'm trying to load a large table with 7 million records, 50 columns and
27 indexes into an innodb table. Works fine for MyISAM. Compressed size
of the data file is about 280MB (830MB uncompressed) and 1.5 GB for the
index file. Platform is RedHat Linux 6.2 with kernel 2.2.16-3 and MySQL
is 3.
This error message indicates that the version of PHP that you are using does
not have MySQL support built into it.
See http://www.php.net/manual/en/ref.mysql.php
and http://www.php.net/manual/en/installation.php
--zak
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]
Does the mysql user have write-permission in the directory where core
would be
written?
Cheers,
Kent
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the li
Put parentheses around the ..OR.. part (between WHERE and AND) - AND precedes
OR so
Also, use 'IN' instead of a series of 'OR' - this will make the query a lot
faster.
e.g. listings.Area IN ('19','24','25',...)
Vadim.
JD Daniels wrote:
>
> I have this query built from a web form. The for
On Wed, May 16, 2001 at 10:58:18PM +0200, Frank Schroeder wrote:
>
> Is there a way of turning the transactional logging off during the
> load of a table? I know that I'm out on my own then but this table
> is loaded only every once in a while.
>
> Am I running out of space on the log/or data fi
Hi!
Thanks!
Mine is the redhat distribution v7
I solved it by removing and installing php and mysql downloaded from the rh
updates.
Now it works.
Thanks again. :)
Regards
Annie
"I should always thank Him." -- Unknown
>This error message indicates that the version of PHP that you are using does
Does anyone know the correct syntax to connect to a mysql database with DBI?
I tried the syntax mentioned in the Perl DBI O'Reilly book, but I got errors.
thanks
=
#
Simon K. Chan
"Great spirits have always encountered violent opposition from medioc
I'm looking at different ways to backup a database from a solaris 2.8 box to a solaris
2.7 one. In addition to the standard system backups that our sysadmins do during the
week, I want to do a full backup of the database to a box where I have much more disk
space than the one where the product
Unfortunately I don't have an ordinary disk on that box. I'm thinking that
InnoDB is having a major problem with LVM not ReiserFS. I tried it on an
e2fs portion of the server and it still had problems.
Do you know of anyone successfully using InnoDB with just LVM?
Jamie
-Original Message---
On Wed, May 16, 2001 at 03:12:42PM -0700, Brian Warn wrote:
> I'm looking at different ways to backup a database from a solaris
> 2.8 box to a solaris 2.7 one. In addition to the standard system
> backups that our sysadmins do during the week, I want to do a full
> backup of the database to a bo
Coincidentally, I used perl DBI for the very first time last night, and this
worked for me fine:
#!/usr/bin/perl
use DBI;
my $dbh = DBI->connect('DBI:mysql:mysql','username','mypassword')
or die "couldn't connect to database: ".DBI->errstr;
$dbh->disconnect();
Regards,
Gary "SuperID"
I have a query that works fine until my date range goes one day over some kind of data
size threshold & then it mysteriously goes from 0.34 seconds to 30 seconds. My DBA
pointed out that my SQL syntax was loose & that Oracle would've flagged it as an error.
I did a GROUP BY based on an numeric
On 16 May 2001 13:40:55 +0300, Sinisa Milivojevic wrote:
> Regarding the fact that 2.96 can build working binaries, that is good
> news, but before we try it ourselves, could you please run all
> mysql-test programs plus sql-bench. See if it will pass them all.
I tried to install MySQL-bench, but
I'm trying to figure out how to get mysql to startup automatically after
rebooting the server?
I have a Redhat 7.0 box and I placed a file to call up the mysql.server auto
startup script as follows:
/etc/rc.d/init.d/mysql
which has the following code:
/bin/sh -c 'cd /usr/local/mysql ; ./bin/s
Even though I'm not one of the creators, thinking through it logically, I
would say it wouldn't work. A select * statement would retrieve the data,
so yes, you could add columns to the permission tables but you need to be
able to use the retrieved data in someway, usually programmatically.
...
Hi,
Just wondering how to get through that "Can't connect to local MySQL server
through socket '' (111)" error message with MySQL GUI for Linux (RedHat
7.0). I configured mysqlgui through ~/.my.cnf and client configuration file.
I tried the static and semi-static binary versions. If I put a "soc
Changing to C++ is not likely to give you a noticable speed difference
because your bottleneck is not the code but the queries. With proper
database design you should be able to acheive those results with one query,
and it should be fast if given the right indexes.
ryan
> I am searching to spee
Original Message -
From: "Mark Rowlands" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 3:11
Subject: create table with select syntax error problem
> CREATE TABLE Ftt (sajtid smallint(6) DEFAULT '0' NOT NULL,count int(10)
> unsigned DEFAULT '0' NOT NULL,PRIMARY
On 16 May 2001 13:40:55 +0300, Sinisa Milivojevic wrote:
>
> Regarding the fact that 2.96 can build working binaries, that is good
> news, but before we try it ourselves, could you please run all
> mysql-test programs plus sql-bench. See if it will pass them all.
Ok, finally i installed MySQL-be
When we can expect unicode version of mySQL for Win32 ?
--
Martin Jeremic - JSoft
http://jsoft.webjump.com/
mailto:[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:/
login as root. Use:
chkconfig --list mysql
to determin if it on, if it's not on issue:
chkconfig mysql on.
That will make sure that mysql starts at boot time. To start mysql
manually use:
service mysql start
Steve West wrote:
>
> I'm trying to figure out how to get mysql to startup au
Hi..
I'm from seoul,korea.
Now i'm trying to install mysql 3.23.38 through source install.
I'm using Redhat 7.1 with 128M memory,Intel Pentium III 500.
I'm trying like this..
./configure --prefix=/usr/local/mysql --with-charset=euc_kr
make
so far there is no problems.
but when i try like 'm
Hi..
I'm from seoul,korea.
Now i'm trying to install mysql 3.23.38 through source install.
I'm using Redhat 7.1 with 128M memory,Intel Pentium III 500.
I'm trying like this..
./configure --prefix=/usr/local/mysql --with-charset=euc_kr
make
so far there is no problems.
but when i try like '
Bruce,
I tried what you suggested and I get the following error message on my
redhat 7 server:
/sbin/chkconfig --list mysql
service mysql does not support chkconfig
Any ideas what I'm doing wrong?
Thanks!
SW
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sen
1 - 100 of 116 matches
Mail list logo
