Dear all,
can anybody tell me how to install mysql replication
step by step :-).
thanks in advance.
Best regards,
Madrus
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.c
I'm trying to write a cron job to back up my databases. The manual says:
> Do a full backup of your databases:
>
> shell> mysqldump --tab=/path/to/some/dir --opt --full
>
> You can also simply copy all table files (`*.frm', `*.MYD' and`*.MYI'
> files), as long as the server isn't updating anythin
Hi,
Can anyone help me out! Does MySQL run efficently in a multi
CPU environment. I am using FreeBSD 4.1 at the moment but I am
looking to upgrade to 4.3 because as most ppl know 4.1 had that
bug that meant Mysqld would use 100% of the CPU. So my
questions are does MySQL support Multip
Hi,
how a field ( names of products ) of database should be defined so that you
could not enter identical entries at the field?
Or does one need to do the validation before inserting info?
Jari Mäkelä
-
Before posting, pleas
Using the source on the command line, I am getting "access denied" (to
the file, I am guessing).
The user has all privledges granted. I have tried
"mysql -h hostname -u user database < source_file"
and I received the same "access denied" message.
What am I doing wrong?
Edward (newbie)
NetZe
At 1:31 PM +1000 6/12/01, Noel Clarkson wrote:
>I don't know about MySQL 3.22.32 but in 3.23.27 if you create a table with
>a primary key of two fields, one of which is an auto increment field then
>you will get the behaviour you are looking for (ie the auto inc will start
>at 1 for each different
>From: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: failure notice
>Date: 11 Jun 2001 04:51:01 -
>
>Hi. This is the qmail-send program at web.mysql.com.
>I'm afraid I wasn't able to deliver your message to the following
>addresses.
>This is a permanent error; I've given up. Sorry it
Never mind, I got that part :-) Thanks anyway!!
How do I make an error display, but still continue the script anyway? The
subroutine does not exit, but the subroutine that calls it doesn't continue
after the error message, it just quits.
=Dawn H
-Original Message-
From: Dawn H [mailto:[
What do the mysql error logs say?
- Original Message -
From: "Gerry Tool" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, June 12, 2001 11:33
Subject: Re: Installation problem
> No, the daemon isn't running.
>
> Gerry
>
> Rolf Hopkins wr
No, the daemon isn't running.
Gerry
Rolf Hopkins wrote:
> Has it already started? Check with ps -ef | grep mysqld
>
> - Original Message -
> From: "Gerry Tool" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, June 12, 2001 10:38
> Subject: Installation problem
>
>
>> I
I don't know about MySQL 3.22.32 but in 3.23.27 if you create a table with
a primary key of two fields, one of which is an auto increment field then
you will get the behaviour you are looking for (ie the auto inc will start
at 1 for each different value in the other field). I don't have 3.22.x
Got the code below, an excerpt anyway. I need to be able to insert each of
the rooms without knowing ahead of time which rooms are going to be chosen.
Line 10, they choose their rooms. Line 41, they list their room size. How do
I pull the info out that's input in Line 41 and insert it into the dat
Hello,
I had a problem with my server: it was shut down by a sudden
energy cut, after that I ran a 'myisamchk -o' for recover the tables but
the autonumerics fields insert -1 and nothing else.
What should I do to resolve that problem (I have 5 tables with
autonumeric in
Has it already started? Check with ps -ef | grep mysqld
- Original Message -
From: "Gerry Tool" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 12, 2001 10:38
Subject: Installation problem
> I have just installed mysql on a RH7.1 system from
> mysql-3.23.38-pc-linux-gnu
I have just installed mysql on a RH7.1 system from
mysql-3.23.38-pc-linux-gnu-i686.tar.gz using the procedure in the manual.
-
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
shell> ln -s mysql-VERSI
Hello everyone,
I should start by saying that though an experienced vb/asp/ado windows
developer I have little experience with solaris or mysql.
The task i am facing is to connect and read some data from a W2K box
by connecticting to a Solaris box running MySQL.
What do I do??? Please, provide
You should be able to change your mysql.sock in your my.cnf or php.ini file
and it will work. I'm thinking that it's a sock error you are getting.
--Joe
On Mon, Jun 11, 2001 at 09:43:56PM -0500, Whit Blauvelt wrote:
> Trying to upgrade from 3.23.27 to 3.23.38 via rpm. The problem is then
> Apac
try download full windows odbc setup (not download only .dll). Then,
follow with Setup.exe.
Sommai Fongnamthip
At 07:39 11/6/2001 -0700, Bob Andrews wrote:
>I recently downloaded the ODBC client software for windows, ran setup, then
>went into the 'ODBC Data Source Administrator' from the cont
Trying to upgrade from 3.23.27 to 3.23.38 via rpm. The problem is then
Apache/PHP cannot connect to the database (using the mysql routines internal
to PHP), so I'm left having to --force --nodeps a downgrade to keep the
system up. Now, PHP can be compiled to use the current MySQL libraries, but
th
Rich,
You can try TO_DAYS() first before finding the diff. of the two dates. Perhaps this
would give you a better solution.
Hasan
- Original Message -
From: "Rich Duzenbury" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 12, 2001 5:22 AM
Subject: Elapsed time
> Ver
> I have a customer file, keyed by an auto-increment customer
> number. Customers can have orders. The order file is keyed by an
> auto-increment order sequence number, which works fine, but is not
> convenient. Rather, I would like the order sequence number to start at 1
> for each customer, a
Will the update statement work under the mysql prompt?
- Original Message -
From: "Vladimir Kravtsov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 12, 2001 8:39
Subject: Table won't update
The table sitesats won't update and shows no errors! (even though there are
two
SELECT max(fieldname) FROM table;
> Hi!
>
> Does anybody knows how can I check whether the max value in some
> database's
> field has
> been reached?
> For example, I have MEDIUMINT column and I want to reset its value once it
> reaches its maximum, that is 8388607. How can I check which is the m
There are settings that could probably fix the problem then but I would need
to RTFM.
- Original Message -
From: "Aldo Spano" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, June 12, 2001 0:03
Subject: Re: MYSQL error
> Ok! thanks.
> I t
Okay, password was not recognized because I had the tunnel working with the
f.q. server name rather than localhost (whereas the mysql client on the
slave will _only_ work with the tunnel if it is by the fq server name, since
localhost just goes to the local machine regardless of socket).
But reve
Can someone please help with this database problem.
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Iceberg Media" <[EMAIL PROTECTED]>
Sent: Monday, June 11, 2001 8:56 PM
Subject: Re: Please Help
> Your message cannot be posted because it appears to be either spam or
> simply off t
Ver 8.0, Distrib 3.22.32
I have a customer file, keyed by an auto-increment customer
number. Customers can have orders. The order file is keyed by an
auto-increment order sequence number, which works fine, but is not
convenient. Rather, I would like the order sequence number to start at 1
Ver 8.0, Distrib 3.22.32.
I have two fields in a table that are TIMESTAMP fields. I'd like to show
the amount of elapsed time between the two timestamps in a human readable
format. For example, I'd like to print 'Elapsed time: 1 year 4 months 27
days 9 hours 13 minutes 42 seconds. ' Or perh
Is that a Red Hat gcc? There was a famous version they put out with 7.0
that's broken for a lot of things - but I don't recall the gcc version
number.
I've compiled MySQL just fine with gcc version 2.95.2 on Debian (aside from
MySQL needing some help finding zlib). If you go to gnu.org and downlo
Hi José
Could you give us some more information ?
Something like "gcc -I/usr."
Generally you didn't point the compiler which library to use or where is it
or simply did it in wrong order.
I think so but I'm not 100% sure of it because I'm a novice too ;-)
Regards
Karol Majewski
query / sql
On Monday 11 June 2001 08:30, Haapanen, Tom wrote:
> Our normally reliable back-end server for our web site has now gone
> completely crazy ... it's falling over every few seconds. Automatic
> restarts are nice, but it really makes the web site unusable.
>
> mysqld got signal 11;
> The manual se
Here are some ideas for an improved debugging methodology.
First, take the query that you think should be working, substitute in
hard-coded values, and test it through the mysql command-line
client interface.
So, for example, run the "update sitesats set..." query and use
hard-coded values for $
Sinisa Milivojevic wrote:
>
> Van writes:
> > Greetings:
> >
> > With the following code, I have 3 problems:
> > 1../client -psecret works, but, ./client --password=secret does not;
> > 2.After calling load_defaults, the argument vector is getting parsed,
> > but, it's not making it
> echo("You must review the site"); } else {
> if (!isset($anegative)) {
> echo("You must review the site"); } else {
> connectdb();
> mysql_select_db(xtopsites);
^^ quotes
> $sql = "insert into sitesats set areview='$areview', apositive='$apositive',
>anegative='$anegat
On Mon, Jun 11, 2001 at 01:49:48PM -0400, Jude C. Divierte wrote:
> Hello:
>
> I was wondering if there is a simple way to put a ceiling on the
> maximun amount of memory that can be allocated to the mysqld
> process?
The various memory related options in the my.cnf file give you a fair
amount o
On Mon, Jun 11, 2001 at 06:55:34PM +0200, Thomas Seifert wrote:
>
> just another question. I have a lot of tables in one mysql-database
> (around 3200 for now) because I am running Phorum with a lot of
> boards. (yes I am working on it to split it in different databases
> but it can take a whil
Hi all,
Installing mysql on solaris 6 sun4u sparc SUNW,Ultra-5_10
release:
-- mysql-3.23.38.tar.gz
via
./configure --prefix=/dir --with-low-memory
make
make install
I get to:
yacc -d sql_yacc.yy && mv y.tab.c sql_yacc.cc
"sql_yacc.yy", line 71: fatal: invalid escape, or illegal reserved wo
You might have issues with the 'environment' you're setup with...
What 'shell' are you using (especially when you performed the installation)
??
Isn't "/export" an 'NFS mounted' area ? (will this cause issues with the
installation ?)
Can you 'resolve' (lookup) your system name yourself ? (i.e
So I had some expensive fun, eh?
John 'TPG' Smith wrote:
> Very nice of you to take your very expensive time to write me an idiotic
> message.
>
> TPG
>
> - Original Message -
> From: jay downs <[EMAIL PROTECTED]>
> To: John 'TPG' Smith <[EMAIL PROTECTED]>
> Sent: Monday, June 11, 2001 6
The table sitesats won't update and shows no errors! (even though there are two
instances of echo(mysql_error()))
Any ideas?
Hello all,
I use the bash shell and the vi editing mode (set -o vi) in my .inputrc.
On one of my boxes, I managed to get the command line tool (mysql) to honour
that setting. However, I have forgotten how I did that. Does anyone know how
to do that?
I am running 3.23.33 master/ 1 slave config on Caldera eDesktop 2.4
system. I had not examined the error logs on the slave for sometime but
was looking them over because the slave thread crashed on a bad query
(not related to my question). I found the error message 'Received a
Signal 16 on rep
on 6/11/01 15:13, [EMAIL PROTECTED] at [EMAIL PROTECTED]
wrote:
> I am running MySql 3.23.38, Slackware Linux 7.1 (custom Kernel 2.4.4), PhP
> 4.0.5, and Apache 1.3.19.
>
> I have found what I believe is a bug with this release of MySql. When I try
> to delete an entry from a table (DELETE FROM
Hi all,
a bugfixed MySQL version 3.23.39 was announced on Freshmeat on June,
7th, but there is no announcement on the list and nothing on the site.
Was it a premature announcement?
Michael
-
Before posting, please check:
ht
Hi,
I'm developing an application with mysqlclient library, my code is right but i get an
error:
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function 'my_uncompress':
my_compress.o(.text+0x9a): undefined reference to 'uncompress'
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
I am currently trying to compile mysql on solaris 2.7
, running on an ultra1 with 512 megs of memory. I have
uninstalled the bin package off sunfreeware.com for
gcc and replaced it with 2.95.3 compiled on my box. I
also have the libstdc++ library with G++ installed as
well.
When i try to run ./con
Hi:
There is a perl module for MySQL you can download from cpan. It provides
the interface to MySQL database you can use to connect, execute SQL
statements from perl programs.
Seung-woo Nam
John Tsangaris wrote:
>
> >From the docs, it doesn't look like too much has been done in the area of stor
I didn't get a confirmation mail or anything so here goes ...
I'm trying to compile a simple C program to access a db and dump out the
info (for testing purposes). Here is what I get when I try to compile it:
ebulon:/var/www/www.miester.org/cgi-bin# gcc -g -o miesterc miesterc.c
-I/usr/local/my
I downloaded the file mysql-3.23.38-sun-solaris2.7-sparc.tar.gz last
Friday. I followed the installation instructions, except that mysql is
installed in /export/mysql since I don't control /usr/local.
The file mysqlbug doesn't exist anywhere in my distribution. The
scripts subdirectory only has
That would be an apache question. If you look in the Apache Docs for
instructions on how to do use directories (www.host.com/~user) I think that
might point you in the right direction. In short, getting Apache to read the
user's homedir out of a MySQL database would require modifying Apache i
Careful here, a left join is not necessarily the same as a join. In
particular a left join will return rows for the left table even if there are
no matching rows in the right table. Under many conditions the two are
identical but definitely not always. That being said, maybe one could use
temp
I am running MySql 3.23.38, Slackware Linux 7.1 (custom Kernel 2.4.4), PhP
4.0.5, and Apache 1.3.19.
I have found what I believe is a bug with this release of MySql. When I try
to delete an entry from a table (DELETE FROM articles WHERE article_id =
'3') the database only deletes the article_id w
On Sun, Jun 10, 2001 at 01:15:38PM +0300, Sinisa Milivojevic wrote:
> > Hello,
> >
> > I'm a database administrator for a hosting provider, and we have currently 2 SMP
>MySQL-database servers. The one that is causing me problems, has at least 900
>databases running on it. That's an dual PIII-55
hallo
i use VB6 - ADO 2.6 with the newest MyODBC with options 16834
even when make a select on a date or time type columne i get the windows-format
24.12.2001 , but the format is realy -MM-DD. So i get a lot of trouble..
what i have to do, that i get the right date/time-format(-MM-D
Well, getting stunnel clean now presents additional info in the *.err file
on the slave:
010611 13:35:41 Error reading packet from server: Access denied for user:
'ftp@localhost' (Using password: YES) (0)
This being repeated every minute implies it's from the replication
connection, which is s
Hello Dimitar
I'm not a great linux programmer but I had few days ago similar problem.
My advice is to try this:
gcc -o test.cgi test.c cgihtml.a
-I/usr/local/mysql/include -L/usr/local/mysql/lib -lz -lmysqlclient -lz
The only change here is twice use of "-lz". In my case that was _very_
import
Hi
I and my friends we are going to write new JDBC driver for MySQL. Where can we get
description of communication protocol between client and server?
Tomek
We have linux/solaris mounted on the same data storage
unit and I would like to install the mysql server once
with the ability to evoke it from linux or solaris.
Is this possible?
---
--==- Sonia Van TasselSoftware Engineer
Hello:
I was wondering if there is a simple way to put a ceiling on the maximun amount of
memory that can be allocated to the mysqld process?
Please advise.
Thanks,
jcd
Hello,
I use 3.22.32 on WinNT. Left Join works perfectly (I have one stmt that has
10 left joins).
JohnC
> -Original Message-
> From: Holger Böhnke [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 11, 2001 7:44 AM
> To: mysql
> Subject: LEFT JOIN in MySQL Version 3.22.32
>
>
> Hi,
>
> u
Yes
That was the trouble.
Thanks
I just upgraded the entire thing while I was at it,
perl 5.6, DBI, mod_perl, embperl
Thank you very much. I thought I did get the latest version. Maybe I go a
pre-release version.
Ruben
On 2001.06.11 11:06:01 -0400 Dave FitzPatrick wrote:
Ruben,
I ran
Is mysqlgui capable of connecting to the mysqld daemon via a unix
socket, or must it use the network. Mysqlgui appears to ignore
the 'socket' option in the my.cnf file. Am I out of luck, or did
I possibly make a mistake in the compile?
thanks,
bl
--
//== Brett G. Lemoine -=- <[EMAIL PROTECT
On Mon, 11 Jun 2001 17:15:09 +0200, "Simon Abolnar"
<[EMAIL PROTECTED]> wrote:
What kind of data type is the column in questions?? VAR, CHAR,...etc.??
>>Hello!
>>
>>When I add record in database everything works OK. When I modify data in database
>using
>>RS.Update
>>function everything work
hi,
what did you assign the col type and what is the length...
- Original Message -
From: "Simon Abolnar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 11, 2001 8:15 PM
Subject: Field length problem!
Hello!
When I add record in database everything works OK. When I mod
At 07:39 11/06/2001 -0700, Bob Andrews wrote:
Hi,
Assuming that:
1- You have the ODBC Data Source Administrator, means that your
machine has already the ODBC core installed.
2- You ran the MyODBC setup for Win9x and something wrong happened.
If the item 2 is true, verify if the myodbc.dll e
Hi
I and my friends we are going to write new JDBC driver for MySQL. Where can we get
description of communication protocol between client and MySQL server?
Tomek
this:
select tbl1.field1, tbl2.field2 from tbl1, tbl2 where tbl1.id = tbl2.id
is the same thing as:
select tbl1.field1, tbl2.field2 from tbl1 left join tbl2 on tbl1.id = tbl2.id
- TIM
> Hi,
>
> unfortunately my provider still runs My SQL version 3.22.32 on his server.
> Apparently the LEFT
> > > > Doing that, I'm now seeing: "ERROR 2013: Lost connection to MySQL
> > > > server during query" after entering the password.
> Right. That was a client error. The server is the only thing which
> cares about the master.info file.
Okay, this is solved - stunnel works better when compiled w
Hi folks,
just another question.
I have a lot of tables in one mysql-database (around 3200 for now) because
I am running Phorum with a lot of boards.
(yes I am working on it to split it in different databases but it can take
a while).
So my question is ... does that mass of tables in one datab
At 12:23 PM +0530 6/11/01, Rohit Peyyeti wrote:
>Hello All:
>
>I am trying to access second mysql server which is running on port
>3308 through java. Even when I specify port number in my connection,
>it still connecting to the database running on port 3307.
>
>When i try to access 2nd mysql serve
>From the docs, it doesn't look like too much has been done in the area of stored
>procedures.
Are there any resources which would teach me or point me in the right direction to
writing procedures for mysql? The manual mentions that it has facility for c++
procedures, but if you want to learn
Hi,
I downloaded the mysql-3.23.38 source rpm.
When I try to build it I get the error message:
checking for gcc... egcs
checking whether the C compiler (egcs -O3 ) works... no
configure: error: installation or configuration problem: C compiler cannot
create executables.
error: Bad exit status
Hello,
I have been using JDBC with MySQL for the past couple of days without any user id or
password. After reading the directions in the privileges section I decided to change
the password for root. I used the following example from the online manual:
shell> mysql -u root mysql
mysql> UPDAT
Hi all,
My ISP provides me with MySql version 3.23.36 on Red Hat Linux 5.2 box,
gcc version is 2.7.2.1, libc version 5.
When I try to compile my C application I get lots of errors. What is
wrong ?
Since this is not my own server, what should I ask my ISP to do in order
to correct this? I mean, if
Ok! thanks.
I tried and with the prompt it seems to work. Effectively i have this error
often, but sometime it works correctly.
Maybe the packet it's too big?
A.
Scrive Rolf Hopkins <[EMAIL PROTECTED]>:
> You don't have to join the mailing list to send mail to the list. Send
> it
> to the list
Hello,
I always have my problem with the 31 tables in a join limitation.
In crash-me database comparaison page, I saw that mysqld 3.23.39 could
manage up to 63 tables in a join. I didn't see in history log that
the limite has been updated from 31 (in 3.23.36 version we use) to
where can i found description of BDB messages writed in log and also what
must be done in the case
or maybe somebody can help and tell me what went wrong:
bdb: Log sequence error: page LSN 1:2043982; previous LSN 1 2074929010608
21:12:22
bdb: Log sequence error: page LSN 1:2043982; previous LSN
On Mon, 11 Jun 2001, h3rb wrote:
> Ok. I have read the manual =) But one thing I am not clear on. Is if I can
> create a user who can create their own database's..modify them..and drop them
> if need be. But they wouldn't have access to any database on the server. I
> am asking because I hos
Hello!
When I add record in database everything works OK. When I modify data in database using
RS.Update
function everything works OK again when I use the same or less length field that it
was before. (lets say "123" to "456" or "45" o "4")
The problem is when I use greater field length (my sql
Ruben,
I ran into the same thing on a Compaq Tru64 box last week. Version
1.1835 of the Msql-Mysql-modules is WAY out of date. For some reason
it is still listed in the CPAN database if you try to install
Bundle::Mysql or Bundle::Msql.
Try again by:
cpan> install J/JW/JWIED/Msql-Mysql-modu
I had converted an Access Database into MySQL format and it used
autoincrement fields. I will try without the autoincrement and see what
happens.
Thanks
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 11, 2001 1:54 AM
To: Granville A. Gayle Jnr.
Cc:
On Friday 08 June 2001 22:16, Rohit Peyyeti wrote:
> > Hello All:
>
> I have two mysqld runnning in ports: 3307 & 3308 respectively. I started
> the second one by using 'mysqld_multi start 2'. whereas mysqld running on
> port 3307 is the default mysqld started at the boot time.
>
> when i issue c
> > > > Doing that, I'm now seeing: "ERROR 2013: Lost connection to MySQL
> > > > server during query" after entering the password.
> >
> > The problem above shouldn't be master.info related.
Sheesh, yeah, it's:
"stunnel[7765]: Connection from xxx.xx.xxx.xx:1635 REFUSED by libwrap"
which is th
Hi,
unfortunately my provider still runs My SQL version 3.22.32 on his server.
Apparently the LEFT JOIN statement does not work on this version.
Anybody knows a workaround?
Holger
-
Before posting, please check:
http://www
Hello,
I donwloaded the mysql 3.23.38 binary for AIX 4.3.3 and installed an IBM rs6000
workstation. When I started mysql server with safe_mysqld, I got following error
message:
>
Start MySQL server deamon
exec(): 0509-036 Cannot load program /usr/local/mysql/bin/my_print_defaults
I recently downloaded the ODBC client software for windows, ran setup, then
went into the 'ODBC Data Source Administrator' from the control panel per
the readme. I tried to add a new datasource, but MySQL was not in the list
so apparently the setup program didn't work as expected.
Any suggestion
Our normally reliable back-end server for our web site has now gone
completely crazy ... it's falling over every few seconds. Automatic
restarts are nice, but it really makes the web site unusable.
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack t
Could anybody e-mail me a copy of "libmysqlclient.so" for Solaris 7 -or- let me
know where I can get one?
Many Thanks,
=Adrian=
Information in this message is confidential and may also be legally privileged.
It is intended solely for the person to whom it is addressed. If you are not the
i
hi.
check out a book or online tutorial on database normalization. even a mildly
normalized database will provide a way to uniquely reference a row.
otherwise, you can use:
delete from table1 where c1 = 10 and c2 = 'MySQL' limit 1;
that will delete one row only, and if the rows are truly identic
At 15:04 11/06/2001 +0300, Heikki Tuuri wrote:
Hi,
Only to complete the Heikki's instructions, also you need to
edit on /my.cnf the variables:
[mysqld]
basedir=F:/mysql
datadir=F:/mysql/data
The above is necessary when MySQL was installed on different location
than the default c:\mysql.
Regar
Ok. I have read the manual =) But one thing I am not clear on. Is if I can
create a user who can create their own database's..modify them..and drop them
if need be. But they wouldn't have access to any database on the server. I
am asking because I host 4 different sites and 3 of them want
I have a slackware box with Apache Perl 5.6, DBI and mod_perl. I can't get
the MYSQL DBI module to install. It's dieing on this line.
I'm very perplexed.
Ruben
umask -a
Linux vidor 2.2.13 #127 Thu Oct 21 13:13:20 CDT 1999 i686 unknown
make[1]: Entering directory `/root/.cpan/build/Msql-Mys
Saleel,
mysqld.exe was accidentally compiled with __NT__ defined.
You should use mysqld-max.exe.
The next version .39 will ask from the OS if it is Win 95, ...,
and this problem will not appear any more. I am sorry for the
inconvenience.
Regards,
Heikki Tuuri
Innobase Oy
>Hello,
>I was wonder
I seem to have a connectivity problem that I'm having trouble diagnosing.
I have an internal network (192.168.0.*) with mysql running fine on machine
"A". The outside world can get to A fine, and ordinarily so can machine
Bhowever randomly and more often, I cannot log into A from B using
m
Hi Sommai.
On Mon, Jun 11, 2001 at 04:52:01PM +0700, Sommai Fongnamthip wrote:
> Dear,
> I am preparing my web page to display search result. How could I use SQL
> command to handle display specific row per page and next button at the
> bottom page (like most search engine display result
Van writes:
> Greetings:
>
> With the following code, I have 3 problems:
> 1../client -psecret works, but, ./client --password=secret does not;
> 2.After calling load_defaults, the argument vector is getting parsed,
> but, it's not making it into the switch processing. The values
I have some sort of problem too...
Look at this:
mysql> explain select * from game3 order by memberid;
+---+--+---+--+-+--+--+-
---+
| table | type | possible_keys | key | key_len | ref | rows | Extra
|
+---+--+---+-
Hi!
Does anybody knows how can I check whether the max value in some database's
field has
been reached?
For example, I have MEDIUMINT column and I want to reset its value once it
reaches its maximum, that is 8388607. How can I check which is the maximum
(min) value I can insert into field?
Bye!
Just out of interest
If you are selecting * then you are using all the records
What if you use are 'where'..?
Simon
-Original Message-
From: Lukas Knecht [mailto:[EMAIL PROTECTED]]
Sent: 11 June 2001 10:49
To: [EMAIL PROTECTED]
Subject: Again: ORDER BY key_part1,key_part2 does
In PHP, I used something like this:
query("select * from table limit $x,25");
while ($row=$db->fetch_array($result))
{
echo $row[column];
}
$next = ($x+25);
echo "Next\n";
?>
So that's the idea...
Leon Mergen
[EMAIL PROTECTED]
President of Operations
BlazeBox, Inc.
T: +31 31 735 03 03
F: +3
1 - 100 of 120 matches
Mail list logo
