sarahana schrieb am Freitag, 3. August 2001, 03:07:31:
> If mysql is shown when runnnig phpinfo() - does it mean that its installed,
> and if yes, why this error?
this only shows that php is compiled with mysql support.
> thanks, what needs to ben done?
I assume you work under win.
You need t
I was watching the log for errors, but none occurred. I absolutely lost
at what this could be. I just did a mysql_install_db (and deleted the
old) thinking maybe a permission might be messed up. We'll see if that
helps.
Chris Hilbert
-Original Message-
From: Werner Stuerenburg [mailto
>Description:
binary test failed on Mac OS X Server 1.2 using mysql 3.23.40. Problem
appears with both binary distribution and built from source according to manual
instructions.
>How-To-Repeat:
make test
>Fix:
not known.
>Submitter-Id:
>Originator:David Cake
>Organiz
I downloaded, compiled, and installed the latest MySQL release from the
source code at www.mysql.com last night. I was running through the tests
documented in the INSTALL-SOURCE file, and I've found that mysqladmin -u
root shutdown does not work. I've done a ps and I can still see the
mysqld r
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Adam Douglas writes:
>> I'm running MySQL v3.22.32. Here's my problem I run the following
>> select query and both CompanyRep and PostalCodeInfo tables are not
>> using my Indexing. Why? How can I get these two tables
Yeong CN schrieb am Freitag, 3. August 2001, 06:43:11:
> How can I add an excel file with *.xls extension
> directly into MySQL database..is it possible to do or
> I need to convert it into *.csv format or *.txt format
> first?
You can put anything into MySQL provided you choose the right
colum
Dear Alex,
> to add a new user with full privileges on only 'abcdb'. How
I assume "abcdb" is a database, not a table. Try this:
GRANT ALL ON abcdb.* TO "newuser"@"localhost" IDENTIFIED BY "pw"
Regards,
--- Stonix <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm new in mysql admin. I have question
Hello Friends
I think my mysql database carsh but I hope there are some utility to
recovered the data crash.
Can any one help me in this.
Rupak Joshi
-
Before posting, please check:
http://www.mysql.com/manual.php (
hi, mysql£¡
I'm interesting in your GUI style, so I download a copy of
your source code, but, IMHO, I'm so surprised that the style
of the code is so bad, it's so unreadable.
And another question is that, After it is connected to a host(Solaris) which
settled in local network, but it is very ver
Date |Thu, 2 Aug 2001 15:18:51 -0400
>From |"Stonix" <[EMAIL PROTECTED]>
Hello!
S> Hi,
S> I installed mysql, and found root can login without a password.
S> So I checked mysql manual and setup a password for root. However,
S> according to the manual, I need to type another commond:
S> "flush pr
Mark Tully writes:
> Hi Sinisa,
>
> The server functions fine, I can run queries on it and I've lot it linked
> into a bulletin board through php and apache and that works like a dream.
> But it still won't die!
>
> mysqladmin -uroot -psql shutdown
>
> Returns without any complaint but the task
Just do a SELECT query to MySQL before you do an INSERT then compare the
two. Compare whatever you don't want to be a duplicate. In most cases you'll
have a central point at which you should be able to check but it all depends
on your setup/situation. Understand? I could go into a more in depth de
On 2001 Aug 03, Miguel Angel Solórzano <[EMAIL PROTECTED]> wrote:
> I was be able to repeat your bug report. Thanks and it
> will be fixed.
This has been fixed in the current code. Here is a
patch:
*** sql/ha_berkeley.cc.orig Fri Aug 3 09:46:50 2001
--- sql/ha_berkeley.cc Fri Aug 3 09
Is it possible to create mulitple database directories ... with one of them
on a CD-ROM?
One of the databases our app uses is an 'archive', and once a record is
written to it, that record is never altered or updated. Each night, a daemon
runs through the archive, 'indexes' it and writes out a pai
I am getting an error message
Can't connect to local MySQL server through socket '' (111)
trying to connect via mySQLgui on my Linux box running RH6.2
I do have a
/tmp/mysql.sock
with proper authorizations
and have no problem connecting to the serverwithout the client.
Thanks for your clues
Char
It looks like you dont have the correct privileges on your mysql server to
connect from a specified host.
Look at the Grant function in mysql manual for more info
Sherwin Ang
Web Programmer
Yesmynet Internet
- Original Message -
From: Mike <[EMAIL PROTECTED]>
To: MySQLList <[EMAIL PROT
Dear Tong,
if you have access to the machine in question as root, try:
mysqldump --all-databases > export_it_all_file.sql
You may have to enter MySQL superuser name and password, so it goes like
this:
mysqldump --all-databases -u superuser -p > export_it_all_file.sql
(enter pw at promp
If mysql is shown when runnnig phpinfo() - does it mean that its installed,
and if yes, why this error?
thanks, what needs to ben done?
> What does this error mean?
> I ran a simple connect query just to check if mysql is there, and now I
know
> it is cause i ran phpinfo():
>
> Warning: Can't
Ken,
Thanks for taking the time in the midst of all your priorities to help
me look into this problem. I was able to get the proper pid for the
mysqld process, but running truss -p (number here) resulted in no
return. Running truss /usr/local/libexec/mysqld resulted in the
display I sent in my
Adam Douglas schrieb am Donnerstag, 2. August 2001, 19:14:15:
> I have a group of 3 queries that's used to find our representative for
> Unitary, Applied and Wholesale based on a Zip Code. This all is executed
> through PHP to MySQL. The three queries work fine and get the results I
> want. The
True, but his question was about Windows NT Server.
-Original Message-
From: Sommai Fongnamthip [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 02, 2001 2:16 AM
To: Gerald R. Jensen; Garth Hansen; [EMAIL PROTECTED]
Subject:Re: Version question...
3.23.40 is stable on Linu
Hi,
I'm trying to compile MySQL 3.23.40 on Solaris 7 (Intel platform) machine.
I extracted and configured the source but when I tried to run "make" there
was the follwoing error:
In file included from mysql.cc:28:
../include/global.h:646: warning: abstract declarator used as declaration
*** Erro
Mark R. Cervarich schrieb am Freitag, 3. August 2001, 03:33:44:
> On 2 Aug 2001 [EMAIL PROTECTED] wrote:
>> Your message cannot be posted because it appears to be either spam or
>> simply off topic to our filter. To bypass the filter you must include
>> one of the following words in your messa
HI,
I've tried to unsuscribe myself from this list but I am still getting lots
of mails!
Can you help me please?
Cheers,
CHris.
--
email: [EMAIL PROTECTED]
mobile: 07944 042924
icq: 24960908
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 02 August 200
Gerald R. Jensen schrieb am Freitag, 3. August 2001, 02:51:36:
> Is it possible to create mulitple database directories ... with one of them
> on a CD-ROM?
As far as I know, you can spread your data physically to
different locations and different media. You will find
information on this quest
Hello
How is possible to know if the DBD (for Perl Interface) is already installed
in Mysql ?
Is there a way to install it , after MySQL is installed ?
Regards
Claudemir F. Martins
-
Before posting, please check:
http://
Hi !
Can you send me the ODBC trace ?
Thanks in advance
venu
> -Original Message-
> From: Adam Douglas [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 02, 2001 10:52 AM
> To: '[EMAIL PROTECTED]'
> Subject: Access to MySQL Column Type Error
>
>
> I'm trying to do an append query in A
Hi,
I installed mysql, and found root can login without a password.
So I checked mysql manual and setup a password for root. However,
according to the manual, I need to type another commond:
"flush privileges;" I don't undersdant why should I do this.
Any one can give me a hint?
Alex
---
Thanks Gerald,
I finally figured that out, from what I understand, when locking and the given
table is set to 'WRITE' this includes 'READ' too. so I only needed to use the
table once :)
Cheers,
>>On Fri, 03 Aug 2001 14:31:00 -0500, Gerald Clark <[EMAIL PROTECTED]>
> wrote:
>>
>>> Hi All,
>>
I saw this command listed on
http://www.mysql.com/doc/R/e/Replication_SQL.html
LOAD TABLE tblname FROM MASTER
However, the same command is not listed on:
http://www.mysql.com/doc/L/O/
Is the command very new, because it doesn't seem to work:
mysql> load table sessions from master;
ERR
just out of curiousity, was there a particular advantage to you using
varchar as opposed to date for the column type? because if so it would be
a lot easier to manipulate that date.. you could calculate differences in
dates, get portions of the date, and all sorts of other nice things if it
were
We've upgraded from 3.22.27 to 3.23.39 to utilise replication but have found
that this version is significantly slower that our old version (we haven't
switched replication on yet either). Has anyone else noticed this or have
any suggestions to improve performance.
We upgraded MySQLdb from MySQL
Hi people with far more knowledge than myself,
I have recently started making use of MySQL on a virtual server provided by
my ISP. I can telnet into the server using SSH Telnet, log in to my
database, create tables and populate those tables. When I try to alter the
field definitions of a table
on 8/3/01 9:20 AM, Kyle Hayes at [EMAIL PROTECTED] wrote:
> I went though the online docs for dbjdns and didn't really see anything that
> looked like it would talk to MySQL. DBJ likes to use his CDB code for a lot
> of his projects. Is there a FAQ or page I missed?
my bad. the reason djbdns p
I hate to ask this on the list, but I have tried everything to unsubscribe
and nothing works. Any suggestions?
Thanks.
-Original Message-
From: TIGNAC BRUNO <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Friday, August 03, 2001 11:00 AM
Subject: [MySQL] Database siz
Chris Hilbert schrieb am Donnerstag, 2. August 2001, 12:54:55:
> Its seems like the only way to watch the process list would be to do
> something like mysqladmin -uroot -i 1 processlist. Since I can't show
> processlist when it won't connect to it (I tried to do it while it was
> dead). Still
Hi,
I import a CSV file into MySQL using LOAD DATA INFILE. That's no problem. The problem
is the textfile contains German umlauts. When I query the table with MySQL-program on
the console (SQL monitor) it even works fine.
But when I output in PHP it only shows the correct characters if I send h
>Description:
I get the message
bin/mysqld: Fatal error: Can't find messagefile
'/usr/local/mysql/share/mysql/english/errmsg.sys'
when I try to start mysqld. Note that my mysql is *not* under /usr/local,
which might have something to do with it. (The problem is that I do
on 8/3/01 10:30 AM, Ravi Raman at [EMAIL PROTECTED] wrote:
> what's up with that 30 second pause?
> does this look like a network problem to you guys? if it was, why would it
> not affect the 'limit 1' query as well?
> is there some sort of resource that mysql needs to process the 53000 rows
How would I select all the tables _names_ in a particular database? Is it possible?
i.e. Select table_names from tables;
Thanks.
Blessings,
Mike
Revelation 1:8 I am the Alpha and Omega, the Beginning and the Ending, says the Lord,
who is and who was and who is to come, the Almighty.
-- The
TKC> Hi
TKC> I just took over a mysql database with no documenation. Is there any
TKC> tools or anyway I could generate a database/table creation script from
TKC> the current database? This is because I need to recreate the database
TKC> on another machine and currently I have no way of doing s
Sorry, I am not sure to understand with 'interfere with any other
instance'. I have more table and application in 1 database (in 1 server)
which have a lot of database operation in everyday (insert, delete). and I
could backup or restore any table in this database whenever I want. If you
me
Hello,
On Fri, Aug 03, 2001 at 10:48:55AM +0500, Grigory Bakunov wrote:
> No. You need to remove -p from this command line.
> So "/usr/bin/mysqladmin -u root password 'new-password'" works like a dream -);
>
So, this must be corrected on the install script ($bindir/mysql_install_db):
-
e
Rupak schrieb am Dienstag, 10. Juli 2001, 10:27:47:
> I think my mysql database carsh but I hope there are some utility to
> recovered the data crash.
read on myisamchk or recovery in the manual.
--
Herzlich
Werner Stuerenburg
_
Date |Thu, 2 Aug 2001 06:08:24 -0700 (PDT)
>From |makarand yevatekar <[EMAIL PROTECTED]>
Hello!
MY> I am makarand From Vinayak Computer When i run the the
MY> mysql it gives me errot
MY> ERROR 2002 : Canat't connect to the local Mysql server
MY> through scocket ' /var/lib/mysql/mysql.sock' (111)
hi and thanks for the responses.
grigory: obviously local connections will be faster...but a query time
difference of 2 seconds locally compared to 5 minutes for a machine on the
same network (that can scp/ftp a 1 meg file in a few seconds) is a little
strange.
and at the risk of going offtopic, i
Fournier Jocelyn [Presence-PC] writes:
> Hi,
>
> I caught a bug in MySQL-4.0, but I don't know how to reproduce it ;)
>
> Here is the description :
>
> mysqld got signal 11;
> This could be because you hit a bug. It is also possible that this binary
> or one of the libraries it was linked agais
Errno: 1046
Error: No Database Selected
I get this on only one of my sites, on the first query during a
connection only, and actually it is an impossible error.
All sites are driven by db_mysql.inc from PHPLIB. Therefore,
everything is totally automatic, no chance to omit the database
name durin
Date |Fri, 03 Aug 2001 11:52:00 +0700
>From |Sommai Fongnamthip <[EMAIL PROTECTED]>
Hello!
SF> Why do not use table and user permission separately in 1 database?
Cause problem specification says "I would not want
this database to interfere with any other instance of MySQL that may be
running on
Hi there,
At 17:09 Uhr +0300 3.8.2001, Sinisa Milivojevic wrote:
>Michael Collins writes:
>>
>>
>> Sorry I cannot answer to the technical needs of installing this
>> application. I think the answer on whether end-users would install
>> the requisite components in order to run this application
On 2 Aug 2001 [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> database,sql,query,table
>
> If you just reply to this message
Date |Fri, 3 Aug 2001 12:07:15 +0800
>From |"TestMonster" <[EMAIL PROTECTED]>
Hello!
T> Hi
T> I've followed exactly every step lin the README.
T> 1. cp ./support-files/mysql.server to /etc/rc.d/
T> 2. create link /etc/rc0.d/S01mysql to /etc/rc.d/mysql.server
T> 3. create link /etc/rc3.d/S9
I hope i'm asking in the right place, as i've asked around alot and
haven't gotten an answer.
Would it be inefficient to use the command "SELECT * FROM users_info WHERE
name LIKE "%phil%" and company like "%" and address like "%";"
Note the single % by itself. Would this slow down the s
Mario Witte wrote:
>
> Tonight one of our database servers died, though it din't have any
> special load at that time. The following output could be found in
> /var/log/warn:
>
> Aug 3 04:58:57 db2 kernel: Unable to handle kernel paging request at
> virtual address 6dad7220
> Aug 3 04:58:57 db
hi.
find ar...add it to your path..something like:
PATH=$PATH:/usr/sbin
export PATH
type make again.
hth.
-ravi
-Original Message-
From: Alex Cook [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 03, 2001 2:19 PM
To: '[EMAIL PROTECTED]'
Subject: Error during make process on mySQL 3.23.
Apparentlly there's a 4 GB limit to a MyISAM file when the table it contains
has VARCHAR, TEXT, or BLOB columns. In order to get around this limitation I
was looking to switching to InnoDB table types. As this looks like a
relatively new subsystem I'm wondering if it is stable enough for pro
These are the softwares on the sever I'm using:
Apache/1.3.12 Cobalt (Unix) mod_ssl/2.6.4 OpenSSL/0.9.5a PHP/4.0.1pl2
mod_auth_pam/1.0a FrontPage/4.0.4.3 mod_perl/1.24
Which of these should I be mysql installing:
a.. HP-UX 10.20 [hp-hpux10.20-hppa1.1]
b.. IBM AIX (PowerPC) [ibm-aix4.3.3.0-rs600
Dear Faiz,
try PhpMyAdmin. You can find it here: www.phpmyadmin.com.
This is a browser based graphical interface - so it will work
everywhere (Win, Linux, Intranet, local machine, web, ...). Well, you
need to have PHP and a webserver installed on the machine where
PhpMyAdmin runs. You can find a
ok, I'm running a Solaris 8 SPARC box, and I configure with:
./configure --enable-thread-safe-client --enable-shared --prefix=/usr2/mysql
--enable-user=acook
I then run make, use GNU make, and get:
ar cru libreadline.a readline.o funmap.o keymaps.o vi_mode.o parens.o
rltty.o co
mplete.o bind.o
on 8/2/01 9:55 AM, Chris Malloch at [EMAIL PROTECTED] wrote:
> Hi people with far more knowledge than myself,
>
> I have recently started making use of MySQL on a virtual server provided by
> my ISP. I can telnet into the server using SSH Telnet, log in to my
> database, create tables and popul
Dear Glyndower,
> "All remote db connections are blocked so
This says it! You are not allowed to connect to the database server
from anywhere else but from localhost.
Try:
GRANT ALL ON *.* TO me_as_odbc_user@% IDENTIFIED BY "my_password"
This will grant access to me_as_odbc_user from everywher
> -Original Message-
> From: kieran buckley [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 03, 2001 10:29 AM
> To: [EMAIL PROTECTED]
> Subject: RE: jdbc - tcp/unixsockets
>
>
> Venu...lifesaver!!
> thanks very much,
> kieran
You, welcome..
venu
>
> >> Original Mes
Dear Tony,
try this for a first strike:
GRANT ALL ON *.* TO ""@"%"
This will grant access to everything for everyone connecting from
everywhere. No user name and password are required.
If you manipulate the mysql.host and mysql.user tables directly with
update or insert statements, you will
Curtis Spencer writes:
> Is this possible with 2.0 version (type 4 I think) MM driver found on
> www.gjt.org? Also how do the file reading privileges for this work because
> I tried doing it and it gave me an authorization error even though my mysql
> user has FILE on it's privileges. Also, t
Hi there,
I'm running into problems with functions "floor/ceiling" when I use
Visual Basic to talk to mySQL through myODBC.
My code looks like this:
sSQL = "select floor(3.2)"
Set rs = MySQL_conn.Execute(sSQL)
I got rs.eof = true after execution of the query. However the following
codes works f
Thanks for all the replies - it shows me to look a little harder next time before I
send a question to the mailing list. Thanks, but ...
I did as it told but it still return an empty set. Here are the results:
mysql> show tables;
Empty set (0.01 sec)
mysql> select database();
++
The only place I've seen a tool like this is in urSQL (a MySQL GUI Client
for Windows 95/98/NT 4.0). I'm just using the unregistered version and this
feature seems to work fine. You can grab the program from the following
location, http://www.urbanresearch.com/software/utils/urbsql/index.html.
>
Ashadul Khan writes:
> Dear Sir,
>
> I'm new to mysql. So please forgive me if I may sound so stupid.
>
> I did install mysql database. I also downloded you
> Sun Solaris 2.7 Sparc static binary of MySQLGUI 1.6
>
> After I unziped what should I do? How can this to work?
>
> My database is ru
Well I did the trace and it's about 2.81MBs. What exactly do you need out of
it? I didn't notice much help from it but then again I'm not very knowledge
in that area. Considering the size do you still want me to directly e-mail
it to you?
One other thing I forgot to mention was the data in the Fa
A newbie question: how to drop a user from mysql?
Alex
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[
> Adam Douglas schrieb am Donnerstag, 2. August 2001, 19:14:15:
>
> > I have a group of 3 queries that's used to find our
> representative for
> > Unitary, Applied and Wholesale based on a Zip Code. This
> all is executed
> > through PHP to MySQL. The three queries work fine and get
> the resu
Spam friendly offshore website hosting only $300 per month.
Advertise your website risk free!
More hits and business than you can imagine.
100mb space
MYSQL
SSL
CGI
PHP
FTP Access
Unlimited Band Width
Front Page Extensions
NO PORN OR CASINO.NO PORN OR CASINO
Resellers welcome.
Also bulk f
Sorry, it never fails. As soon as I send a mail, I find the answer. My last question
was about how to find the names of the tables in aparticular database(just a dump of
the names). Well I found out the answer is the following
mysql> show TABLES;
I did as it told but it still return an empty se
joe schrieb am Freitag, 3. August 2001, 07:46:09:
> Would it be inefficient to use the command "SELECT * FROM users_info WHERE
> name LIKE "%phil%" and company like "%" and address like "%";"
What use have
> and company like "%" and address like "%"
Omit it and you will be just as fine. If y
how can i execute a silent installation of mysql for windows?
Thanks a lot for your time.
David Tomás Fargas
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi Michael,
Sounds like the mysqld may have been stuck in a tight loop then.
Any ideas Sinisa?
Try the truss once more if it happens again. I can't think of
anything that would cause this.
Let me know what happens, also try the truss when the server is
running normally just to see the output a
This query is driving me nuts!
I have two tables, affiliates, and advertisers. The advertisers table has an
affiliate_id field, which matches the affiliates tables' primary key. I'm
trying to write a query that will return all affiliate id's, contact names,
and the # of rows in the advertisers ta
In the last episode (Aug 02), [EMAIL PROTECTED] said:
> I'm new to the list so please forgive me if this problem has already
> been solved.
>
> I've been using MySQL for development for sometime. Up until now I've
> been using MyISAM tables. I've decided to switch to InnoDB because
> some table f
M> How would I select all the tables _names_ in a particular database? Is it possible?
M> i.e. Select table_names from tables;
SHOW TABLES FROM database_name;
or
SHOW TABLES;
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)
I've had this happen (" Can't connect to local MySQL server") at the
command line when I forgot to specify a host, so mysql assumes localhost.
Check your host argument.
On Thu, 2 Aug 2001, sarahana wrote:
> If mysql is shown when runnnig phpinfo() - does it mean that its installed,
> and if yes
Marc Liyanage writes:
>
> Hi there,
>
>
> Yup, but that is for the "old" Classic Mac OS, right?
>
> I looked around and did not find a port that runs directly
> on the Aqua UI, which is what would be needed to run this software.
>
>
>
>
>
>
> --
> ___
I have a database I enter data into from a web based php form.
I wonder if there is a way to have mysql check the database for
a duplicate entry before it gets written into the database? And
inform me of such so I will not have duplicate entries?
--
Regards,
Chip
Vish Kolla writes:
> Hi,
>
> We are trying to install mysql on AIX 4.3.3 and have encountered
> the following errors. MySQL is dependent upon libz.a(shr.o). Where
> can we find this library ? Did anyone encounter this problem before ?
> If so what is a viable solution ?
>
> Please respond to me
Hi
I just took over a mysql database with no documenation. Is there any
tools or anyway I could generate a database/table creation script from
the current database? This is because I need to recreate the database
on another machine and currently I have no way of doing so.
thanks
tk
Bruce Stewart writes:
> Hi Monty and all,
>
> I believe that you are planning to introduce foreign key support in a future
> version of MySQL (I think version 4.0).
>
> Could you consider offering an option to the definition of a foreign key
> which specifies the error message to return if the F
Ken,
Thanks for looking into the problem. For now, it seems as if the
issue has resolved itself.
Kindest Regards,
Michael
Institute for Social Ecology
1118 Maple Hill Rd.
Plainfield, Vermont, 05667
USA
Tel./Fax. 1 (802) 454-8493
http://www.social-ecology.org/
-Original Message-
Fr
Hi All,
Was hoping some one maybe able to explain this error when attempting to LOCK
MySQL tables for READ and WRITE:
Error Encountered:
Unable to LOCK tables.
Error: Not unique table/alias: 'members'
The correct database has been connected to, and the members table is a valid
table. It's exe
How can I add an excel file with *.xls extension
directly into MySQL database..is it possible to do or
I need to convert it into *.csv format or *.txt format
first?
Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
--
At 1:07 PM -0700 8/2/01, Mark -None- wrote:
>I downloaded, compiled, and installed the latest MySQL release from
>the source code at www.mysql.com last night. I was running through
>the tests documented in the INSTALL-SOURCE file, and I've found that
>mysqladmin -u root shutdown does not work.
Hello.
MySQL doesn't support sub-queries (yet). See the following page for
more information and also for hints how to work without sub-queries:
http://www.mysql.com/doc/M/i/Missing_Sub-selects.html
I never used full text search before, so I might miss something, but a
starting point for your qu
Date |Thu, 2 Aug 2001 12:56:23 -0700
>From |Bryan Ross <[EMAIL PROTECTED]>
Hello!
BR> Hi.
BR> What I want to do is this: Use mysql as a dedicated database for a desktop
BR> application, meaning that basically there's only one client allowed to
BR> connect to it, and that client is the applica
Marc Liyanage writes:
> >I'm looking into it right now after reading your cc'd mails
> >to the list. I'm not on the list BTW, you need to cc me...
> >
> >
> >
> >>>But as there is FLTK library for OS X and as there are GNU tools
> >>>available, it is quite doable.
> >
> >Can someone point me to th
Well you have a couple options, you could export the Excel file to a
delimited text file and then import into MySQL. You could also just use the
Excel file and import directly into MySQL with the use of MyODBC and MS
Access. That's all I can think of right now. Either way would work fine I
believe
Date |Thu, 2 Aug 2001 20:20:51 -0700
>From |[EMAIL PROTECTED]
Hello!
>>Description:
E> I cannot set the root password, or any password after installing from RPM. I have
installed the following RPM packages:
E> MySQL-3.23.40-1.i386.rpm
E> MySQL-client-3.23.40-1.i386.rpm
E> MySQL-shared-3.23.40-
Tong Kiat, Chiah schrieb am Freitag, 3. August 2001, 12:44:45:
> I just took over a mysql database with no documenation. Is there any
> tools or anyway I could generate a database/table creation script from
> the current database? This is because I need to recreate the database
> on another m
--- Reçu de CMB.TIGNABR 0298426574 03-08-01 17.21
Hello,
I plan to use MySQL/InnoDB to store about 13 GB of data, into 40 tables. One
of the tables is over 5 GB, and a second over 1,5 GB. Do you think I can use
MySQL/InnoDB ?
Thank you.
Bruno Tignac
03-08-01 17.
On Thursday 02 August 2001 17:27, mike cullerton wrote:
> on 8/2/01 3:31 PM, Ricardo Kleemann at [EMAIL PROTECTED] wrote:
> > Hi,
> >
> > Anyone know if there's a module or plug-in or something that allows BIND
> > to work with a mysql database?
>
> from http://www.isc.org/products/BIND/bind9.html
HelpHi.
I'm using the timestamp format (AAMMDDHHMMSS) on my session.
how can I know the minutes between two dates.
I'm doing:
=20
$date =3D $row_secao['date'];
$date_now=3Ddate("ymdHis"); =20
$x=3D$date_atual-$date;
if ($x > 1000) {
echo "Session exp
At 12:49 AM +0200 8/2/01, Marc Liyanage wrote:
>>Can someone point me to this particular FTLK for OS X?
>>
>>This seems to require that one is running X11 on
>>Mac OS X, right? How many end-users would be willing
>>to install XFree86 just for this application? What do
>>you folks think?
Sorry I
It seems that the replication system takes the value of now() or curtime()
to be the time that the query was run on the slave, not the time the master
logged the query.
Is there a way to get around this (other than changing all the queries)?
Thanks,
Ord Millar
www.cityvu.com
--
1 - 100 of 115 matches
Mail list logo
