My mistake. The latest InnoDB works as expected. Sorry to clutter the list
with my own lack of attention.
Never compile the same code on 2 different boxes with different operating
systems and different configurations at the same time.
Thanks for all your work Heikki!
Cheers,
Brian
> Heikki,
>
on 8/1/01 5:30 AM, Mark Tully at [EMAIL PROTECTED] wrote:
> Subject: mySQLd won't die under Darwin (Mac OS X 10.0.4)
hey mark,
i just saw this thread. just to confirm your suspicion, all the macosx
sites i visit regularly have mentioned this. you can't shutdown mysql in the
normal manner.
Hi!
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 files (*.MYD)
are approaching the OS limit.
I get the above e
** Virus Warning Message (on intranet)
Found virus TROJ_SIRCAM.A in file MOU_2_4_01.doc.com
The uncleanable file is deleted.
*
Hi! How are you?
I send you this file in order to have your advice
See you later. Thanks
hi.
quick question...
i have a simple query that returns ~53000 rows.
when connected to the mysql server from localhost, this query takes about 2
seconds.
when connected to the mysql server from another box, this query takes about
3-4 minutes. 'show processlist' shows the query state as "Writing
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 directly as I am not on the list.
Date |Thu, 2 Aug 2001 15:21:40 -0400
>From |"Claudemir F. Martins" <[EMAIL PROTECTED]>
Hello!
CFM> Hello
CFM> How is possible to know if the DBD (for Perl Interface) is already installed
CFM> in Mysql ?
CFM> Is there a way to install it , after MySQL is installed ?
CFM> Regards
CFM> Claude
Dear Yeong,
> How can I add an excel file with *.xls extension
AFAIK you will have to save the Excel sheet as a CSV file. You need to
save every single sheet as CSV, but you can automate this with an Excel
macro.
Make sure you know the field separators (usually tab characters) and
line separato
Glyndower schrieb am Freitag, 3. August 2001, 05:37:15:
> The error message says :MySql said: qUERY WAS EMPTY. When I try to import
> this data.
looks like phpMyAdmin does not get the correct query. You have
the source code of phpMyAdmin. Look into that, insert some
debugging code and fix th
Heikki,
I've downloaded the latest InnoDB (3.23.40b) and recompiled mysql
3.23.40.
Unfortunately I'm still getting the same error.
Do I still need to increase UNIV_PAGE_SIZE and UNIV_PAGE_SIZE_SHIFT in
/path/to/mysql/innobase/include/univ.i? If so, how large can I set these
values?
(I increased
>Description:
>How-To-Repeat:
I try the following:
mysql> create table foo (primary key (aaa), unique(bbb), aaa varchar(20) not
null, bbb varchar(20)) type=bdb;
Query OK, 0 rows affected (0.76 sec)
mysql> replace into foo set aaa="alfa", bbb="beta";
Que
Hi
I've followed exactly every step lin the README.
1. cp ./support-files/mysql.server to /etc/rc.d/
2. create link /etc/rc0.d/S01mysql to /etc/rc.d/mysql.server
3. create link /etc/rc3.d/S99mysql to /etc/rc.d/mysql.server
But the mysql deamon still can't start automatically during bootup.
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
"A new, simplified database interface and a number of sample driv
> perhaps have limited usefulness. Amd there are other tools for
> getting a GUI interface to MySQL. If it can run off the command line
Please have a look at MySQL-Front: www.mysqlfront.de
Greetings,
Ansgar Becker
-
Be
I've included my text file as an attachment, but a sample of that data is
below, for those who arn't playing with attachmnets nowadays... :)
I'm using phpmyadmin and I' (still) trying to import a text file into an
existing table. I've included the feils names in the attachment for
reference, but
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
--
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
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
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
--- 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.
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
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-
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
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
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
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
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.
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/
--
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
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
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
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
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
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
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'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
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/)
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
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
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
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/
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
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
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
> 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
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 <[
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
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
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.
>
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();
++
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
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
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
> -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 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
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
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
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
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
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
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.
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
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
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
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
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
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
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
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
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
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)
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
_
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
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
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
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
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
>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
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
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
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
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
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
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
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
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
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,
>>
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
---
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
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://
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
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
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'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
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
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
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
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
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
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
1 - 100 of 115 matches
Mail list logo
