Hi list
I'm configuring our new db server, and the choice was MySQL.
Now, I think we are going to use InnoDB tables and replication.
Since replication is done after a binary log, is querying the slave
database(s) really the same than querying the master? or, is transaction
consistency guaranteed
At 22:35 19/02/2003 +, Derick Smith wrote:
Hi,
The embedded server you find at embedded->static->release directory
with the name mysqlserver.lib
Hi!
I want to emebed libmysqld.lib into a DLL I am making for Visual Basic. I
need to make the DLL in C because it is going to perform other func
Hi,
I am writing this because of a question on the fora at
WebmasterWorld.com.
A user there is having trouble understanding the formula for estimating
the memory requirement for a heap table:
SUM_OVER_ALL_KEYS(max_length_of_key + sizeof(char*) * 2)
+ ALIGN(length_of_row+1, sizeof(char*))
The qu
So what is the actual question ?
If you don't have the software, surely you should get it and read the manual
if that is the best way you learn !
Jerry
- Original Message -
From: "Marijka Walker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 6:01 AM
Subjec
Hi.
I think I detected a bug in InnoDB with MySQL 3.23.55.
I have a table named ARTICLE_POID of type InnoDB and transaction_isolation
is READ-COMMITTED. AUTOCOMMIT is 1 (default value).
mysql> DESCRIBE ARTICLE_POID;
+++--+-+-+---+
| Field | Type | N
Hi,
On Thu, Feb 20, 2003 at 10:12:56AM +0100, Iago Sineiro wrote:
> I think I detected a bug in InnoDB with MySQL 3.23.55.
>
> I have a table named ARTICLE_POID of type InnoDB and transaction_isolation
> is READ-COMMITTED. AUTOCOMMIT is 1 (default value).
>
...
> I think this is a bug because
It is really a good question. I don't think MySQL alone will suit your need.
As far as I know, most people (including me) will use programming languages
like PHP, C, Perl, VB etc. to access MySQL database. If you are not planning
to learn a programming language, you cannot do much with MySQL.
T
Thansk for the information Fred.
Iago Sineiro.
> -Mensaje original-
> De: Fred van Engen [mailto:[EMAIL PROTECTED]]
> Enviado el: jueves, 20 de febrero de 2003 10:37
> Para: Iago Sineiro
> CC: MySql Mail List
> Asunto: Re: Possibly bug in InnoDB with mysql 3.23.55
>
>
> Hi,
>
> On Thu,
"SQL is designed for computer novice to manipulate database" So how do the
experts do it ?
Depends on what the requirement for a dB is, other developers might use it
not the original builder.
If the wysiwyg of Access was frustrating then phpMyAdmin is going to turn
the user mad.
With mysql front
Hello
Does anybody have experience with this problem ?
I need to index in fulltext also words like for example "D.O.M.",
etc. In this release mysql doesnt support it.
I need it, cause i need to search also in company names.
Does anybody have any idea how to do it ?
regards
ddd
__
Hello
Does anybody have experience with this problem ?
I need to index in fulltext also words like for example "D.O.M.",
etc. In this release mysql doesnt support it.
I need it, cause i need to search also in company names.
Does anybody have any idea how to do it ?
regards
ddd
Hi to All Mysql Gurus,
I have 2 existing workstations which has both Mysql 3.23 client and server,
then I upgrade one of them to Mysql 4.0. To check, I use mysql client of
Mysql 4.0 to access the database of Mysql 3.23 server(which was on the 2nd
workstation) and worked perfectly. I was also a
>Description:
syntax checker reject length restriction when index char column
with ending by number.
>How-To-Repeat:
alter table xmlmd5 add index md5 (md5(10));
ERROR 1064: You have an error in your SQL syntax near 'md5(10))' at line 1
column definition of md5 is md
Hi all,
Can i install mysql twice on the same comuter?
And on the same hard disk?
Thanks, Shilry
_
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
---
Hi,
I am looking for advise on producing a MySQL platform which is reliable (i.e.
fault resilient).
I am not sure how, using MySQL's technology I can have two systems each one
mirroring the other, and if the primary server fails, how the system can
automatically use the other server for all DB
Yes,
http://www.mysql.com/doc/en/Installing_many_servers.html
- Original Message -
From: "shirly cohen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 11:42 AM
Subject: question about mysql installation
>
> Hi all,
> Can i install mysql twice on the same
Hi Richard
What we do is use Master Slave set-up on MySQL.
So the Master dose all the work and the slave is like a host standby that we
do backups from.
We use Heartbeat (HA project) with all requests going to one IP.
As soon as MySQL fails on box one the IP address is past to the slave.
Another sy
On Wednesday 19 February 2003 17:30, Guddack Thorsten ICM MP SCM GO 21 wrote:
> I'm using 4.0.10-max-nt of mysql.
>
> I update to this version from 4.0.5. With this version I have no trouble
> with load data local infile.
>
> But now if i try to use it from the mysql-Command-line tool i get
> an e
On Thursday 20 February 2003 01:04, Jeff Kilbride wrote:
> I have one master and two slaves all running 3.23.55-max on RedHat 7.3.
> I've had replication up and running smoothly for several days. Today, I
> decided to try out LOAD DATA INFILE on the master. After successfully
> loading on the mast
On Thursday 20 February 2003 09:28, saravanan saravanan wrote:
> I am using mysql for my project.I am finding
> problems of using FOREIGN KEY and STORED procedures in
> version 4.0.please help me and send the details as
> earlier as possible
Stored Procedures are not supported in MySQL yet.
F
On Thursday 20 February 2003 13:42, shirly cohen wrote:
> Can i install mysql twice on the same comuter?
> And on the same hard disk?
Yes and Yes:
http://www.mysql.com/doc/en/Installing_many_servers.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This
On Thursday 20 February 2003 01:37, Jon Miller wrote:
> I need to move the MySQL database from it's existing server to a newer
> server. Is there anything I need to be aware of and can it be copied from
> it's present location to the new server, with changes to config file?
Use mysqldump utility
On Wednesday 19 February 2003 13:19, Juri Shimon wrote:
> Is it a bug?
>
> C:\mysql>mysql -u root
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 29 to server version: 3.23.55-max-nt
>
> mysql> create database R;
> Query OK, 1 row affected (0.06 sec)
>
> m
hi! i have different problems:
* how can i display data in the table by HORIZONTAL TABBING?
is it possible?
* if not, how can i display data in table by VERTICAL TABBING?
* if that's so, can i have the codes for it either on HORIZONTAL TABBING
or VERTICAL TABBING? pleeassse
Hello gurus,
When I try to perform a LOAD DATA INTO, I get a "Permission Denied"
problem, although I (should) have the correct privileges, for a specific
user:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON `mydb`.* TO
'myuser'@'localhost'
I am using MySQL 3.23.54.
Has anyone
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON `mydb`.* TO
'myuser'@'localhost' IDENTIFIED BY 'password'
mysql -u myuser -ppassword
Does that do it ?
Jerry
- Original Message -
From: "Andy De Petter" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 20,
I can perfectly connect to the myqsl server, with this specific user .. he
can select/insert/update/whatever, but he gets permission denied errors,
when trying to do a load data infile ;-/
The user has:
GRANT USAGE ON *.* TO 'myuser'@'localhost' IDENTIFIED BY
PASSWORD 'password'
GRANT SELECT,
The file resides in /var/tmp (I am using the full path):
LOAD DATA INFILE '/var/tmp/whatever' INTO TABLE ...
-a
On Thu, 20 Feb 2003, Ahmed S K Anis wrote:
> If the File resides in the same machine as the Database, it should
> work.
> If the file resides where the your client program resides, t
The search engine on www.mysql.com is always worth a look first ...
"For security reasons, when reading text files located on the server, the
files must either reside in the database directory or be readable by all.
Also, to use LOAD DATA INFILE on server files, you must have the FILE
privileg
Hi,
md5 is a function name, maybe that's why you need to quote the field
name. Check the MySQL manual about that.
On Thu, 2003-02-20 at 10:51, [EMAIL PROTECTED] wrote:
> >Description:
> syntax checker reject length restriction when index char column
> with ending by number.
>
> >How-To-R
I've just tried, and it seems to work This means, there is an error
in the O'Reilly book (July 1999, 1st Edition) then. ;)
Thanks a lot,
-Andy
On Thu, 20 Feb 2003, Jerry wrote:
> The search engine on www.mysql.com is always worth a look first ...
>
> "For security reasons, when read
That's going to be a bit out of date !!
I'd suggest a combination of Paul DuBois's latest offering in blue and the
www.mysql.com search engine.
Keeps me out of trouble, well mostly !
Jerry
- Original Message -
From: "Andy De Petter" <[EMAIL PROTECTED]>
To: "Jerry" <[EMAIL PROTECTED]>
Cc
On Thursday 20 February 2003 14:40, Andy De Petter wrote:
> When I try to perform a LOAD DATA INTO, I get a "Permission Denied"
> problem, although I (should) have the correct privileges, for a specific
> user:
>
>
> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON `mydb`.* TO
> 'myuse
Hi,
yes I did this .
here were some lines from my server-cfg file:
[mysqld]
port=3306
#socket=MySQL
skip-locking
set-variable= key_buffer=16M
set-variable= max_allowed_packet=1M
set-variable= table_cache=64
set-variable= sort_buffer=512K
set-variable= net_buffer_length=8K
set-
Hi,
I am using MySQL v3.23 and have a many-to-many relationship (cars <->
colors) that I have broken up into three tables as follows
cars:
ID Manufacturer
1 Volvo
2 BMW
3 Toyota
colors:
ID
Hello,
I have two questions:
1) How to write my query with SQL_CACHE and UNION ? UNION work with
SQL_CACHE ?
A)
SELECT SQL_CACHE
UNION
SELECT SQL_CACHE
or B)
SELECT SQL_CACHE
UNION
SELECT
2) How to write my
Jeff, Egor,
Guilhem Bichot just found a bug in replication of LOAD DATA LOCAL INFILE in
4.0.
The problem is the LOCAL keyword. Of a large import file, only 8 kB or 16 kB
will actually be replicated in the slave. Do you use the LOCAL keyword?
I do not know if the bug affects 3.23.
Are you using
Thanks to you both, Karam and KH. These suggestions are most helpful.
However, my ultimate goal is to find some sort of "query", via a catalog
table, that can get arbitrary meta data from within the database. This
information will be used in subsequent queries.
Thanks, to you or anyone in the m
Jeff,
MySQL does not have system tables from where you could query metadata with
ordinary SELECT queries. You have to use
SHOW CREATE TABLE tablename.
If you do not see your foreign key definitions in SHOW CREATE TABLE, then
you probably are using MyISAM tables, which do not support foreign keys
Egor,
>> But now if i try to use it from the mysql-Command-line tool i get
>> an errror 1148, This command is not allowed with this mysql version.
>> On my server the variable local_infile is set to on.
>> I change to my.cnf-File on my client to
>> [mysql]
>> local-infile=1
>> or I try to start my
I don't have a mailing list, and I don't appreciate your email.
You subscribed to the mysql mailing list, or you would not be getting it.
The instructions to unsubscribe are at the bottom of every message.
Kip McGee wrote:
will you please take me off of your mailing list if you dont im gonna
se
I have installed MySQL version Release: mysql-3.23.38 (as found in the
mysqlbug.txt). When I use mysqlimport, I get the following error code
ERROR 1148 : the used command is not allowed with this MySQL version.
I get the same message whenever I use "LOAD DATA".
WHich version should I install ?
Hi,
why does Mysql consider an 'ä' as equal to '\' ???
The query
SELECT 'ä' = '\\';
gives 1 as result!
Is this a bug ?
Greetings,
Christian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
h
Hi again
I looked in the site and in some place they write:
"you should create an option file for each server. In your startup script
that is executed at boot time you should specify for both servers
safe_mysqld --defaults-file=path-to-option-file "
What is the startup script? is it somthing tha
> why does Mysql consider an 'ä' as equal to '\' ???
> The query
> SELECT 'ä' = '\\';
> gives 1 as result!
I get zero on 3.23.52-max-nt
mysql> select 'ä' = '\\';
++
| 'ä' = '\\' |
++
| 0 |
++
1 row in set (0.00 sec)
---John Holmes...
---
MYSQL Ver 8.23 Distrib 3.23.54,
sun-solaris2.8 [binary install]
Sun E4500
Hi we have some seriously bad benchmarks for MYSQL performance on a new
cluster - The problem seems to be IO, but the box is doing nothing:
The first set of results are the benches the second results are from my new
mysql
Stefan,
Stefan Hinz wrote:
Richard,
set-variable = max_allowed_packet=16M
Yikes!!! I knew that running "default configuration" gave you SOME
values, but I didn't know they were so small. I've placed the
my-medium.cnf as "my.cnf" in /etc on the Sparc 20, and also in C:\ on
th
Hi all!
I started using MySQL about two months ago (and I already love it!) and I'm new to
this list...
I would like to know if there's some web interface for MySQL management that has been
released as open source. Preferably this should be in ASP 3.0 or ASP .NET languages,
but I'll appreciate
I got this forwarded to me.
Yes the library from 4.0 and above is now GPL. And in 3.23 it was LGPL.
As for the inability to link with OpenSSL we as the copyright holder
can allow this. And we do so.
The same license incomparability problem also appears for the Apache
and Eclipse people that we a
Christian,
> SELECT 'ä' = '\\';
> gives 1 as result!
Not on my server, and with my character set (latin1_de):
mysql> STATUS
--
mysql Ver 12.18 Distrib 4.0.10-gamma, for Win95/Win98 (i32)
Connection id: 6
Current database: menagerie
Current user: superuser@l
Hey all,
My Question:
1. I got a table which tracks errors on systems:
mysql> select id, sys_id, beginn, end, status from error_t;
+++-+-+-+
| id | sys_id | begin | end | state |
+++--
Is there an equivalent lsit as this that also deals with PHP.
A PHP and MySQL list I am sure MySQL is used in conjunction with other languages
but I am only interested in developing PHP and MySQL solutions, unless someone
convinces me otherwise.
Also think you for whom ever it was that pointed ou
> I started using MySQL about two months ago (and I already love it!) and
I'm new to this list...
>
> I would like to know if there's some web interface for MySQL management
that has been released as open source. Preferably this should be in ASP 3.0
or ASP .NET languages, but I'll appreciate to kno
hi,
i'd like to have the syntax to import in a mysql table from a tab delimited
text file, and also the same thing from an excel file.
Thanx
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=fe
I am using phpMyAdmin. But it is written in php.
Regards,
KH
> Hi all!
>
> I started using MySQL about two months ago (and I already love it!)
> and I'm new to this list...
>
> I would like to know if there's some web interface for MySQL
> management that has been released as open source. Pr
I need to insert recond to mysql use servlets,
insert into mytable values('key', 'f1');
i need to chech if key is already in mytable.
what is a good efficient way to do that?
Thanks
-
Before posting, please check:
http://
Hello,
1. Bug:
A resultset of i.e. "select * from table" has now the behaviour of a
dynamical cursor, but a ODBC question for cursor type returns "static
cursor".
2. Question:
I have opened a conection to a MySQL-Server database. How I can get a list
of all available tables inside the database via
On Thursday 20 Feb 2003 3:07 pm, Andrew wrote:
> Is there an equivalent lsit as this that also deals with PHP.
www.php.net have a look through their mailing lists. the General one is good
for tech questions.
> As a matter of interest can I have a show of hands for all those using PHP
> with MySQ
Hello,
I need to know the link for Mysql Bug Database.
I tried a lot in google...but not yet got it.
somebody send me the link plz...
Thanks a lot in advance
regards
sunil gavaskar
-
Before posting, please check:
http://w
> Is there an equivalent lsit as this that also deals with PHP.
>
> A PHP and MySQL list I am sure MySQL is used in conjunction with other
languages
> but I am only interested in developing PHP and MySQL solutions, unless
someone
> convinces me otherwise.
>
> Also think you for whom ever it was tha
- Original Message -
From: "Chris Czeyka" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 10:02 AM
Subject: How to grab the latest record in one query?
[snip]
> Either I'm stupid or it's impossible. Let's see which case is true. :)
I'm sure it's neither. :)
Hi Taurel,
You can use a perl script to do that work for you.A sample is given below
#!/usr/local/bin/perl
use DBI;
#These are the configuration variables
$host ="host on which mysql is running";
$uname = "database user";
$pword = "user password pass";
$dbase = "database name";
#Connect to the
> I need to insert recond to mysql use servlets,
>
> insert into mytable values('key', 'f1');
>
> i need to chech if key is already in mytable.
>
> what is a good efficient way to do that?
Insert the value and see if a "DUPLICATE KEY" error is returned. Act
accordingly.
---John Holmes...
--
* Jianping Zhu
> I need to insert recond to mysql use servlets,
>
> insert into mytable values('key', 'f1');
>
> i need to chech if key is already in mytable.
why?
> what is a good efficient way to do that?
The most obvious answer, do a lookup to check if the record exist:
SELECT * FROM mytable
Thanks for the comments Steve
I am using MySLQ 3.23.53 on XP. I can try the current version and see
what happens.
As an example, I can make a backup with mysqldump, flush the logs, return
to my app and add an item to the database that contains an attachment that
might be an mp3 or bmp stored
* Inandjo Taurel
> i'd like to have the syntax to import in a mysql table from a tab
> delimited text file, and also the same thing from an excel file.
See the LOAD DATA statement and the mysqlimport utility:
http://www.mysql.com/doc/en/LOAD_DATA.html >
http://www.mysql.com/doc/en/mysqlimport.htm
yes ther is a mailing list for php/mysql.. they deal with php and any other
sql servers out there as well as lots and lots of other stuff out there...
it is [EMAIL PROTECTED] but before you send mail to that address
subscribe to it by going to www.php.net and finding the right mailing list
you need
* Dieter Stelzner
[...]
> I have opened a conection to a MySQL-Server database. How I can get a list
> of all available tables inside the database via ODBC with an SQL
> statement?
Send a "SHOW TABLES" command. Full syntax:
SHOW [OPEN] TABLES [FROM db_name] [LIKE wild]
http://www.mysql.com/doc/e
Seems to be only a problem when I send the statement to mysql over php. If
I enter the statement with the command line tool everything is fine.
So this is not a mysql problem.
At 15:58 20.02.2003 +0100, Stefan Hinz wrote:
Christian,
> SELECT 'ä' = '\\';
> gives 1 as result!
Not on my server, a
(7¤ù¸Ë)¡Aµ´¹ï¶WÈ!(Á`ª÷ÃB: 1000¤¸)
Windows XP PRO SP-1 ¤¤¤å"±M·~"¥úºÐ¥¿¦¡ª©
Windows XP Service Pack 1¥]§t¤F±qWindows XP¥h¦~10¤ë30¤é¤W¥«¥H¨Óªº©Ò¦³×¥¿¡A
³o¨Ç×¥¿µ{¦¡¥]§t¤F¦b¦w¥þ©Êªº´£°ª¡A©Ê¯àªº¥[±j¤Î¿ù»~ªº×¥¿¡A
·íµM§ó¥[¤J¤F¥þ·sªºµwÅé³W®æ¤ä´©¡A¤×¨ä¬O USB 2.0ªº¤ä´©¡A
¦Ó¥þ·sªºWINDOWS XP°£¤F§ó·s¤F¨t²Î
When running script under Windows NT as "mysql -h host -u user
--password=password http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscrib
Hi,
I think that it's your GROUP BY clause that isn't correct.
Try replacing "GROUP BY sys.name" with "GROUP BY error_t.sys_id"
(ie, group using the same table where you applied the max() function)
I didn't tryed, hope it solves.
On Thu, 2003-02-20 at 15:02, Chris Czeyka wrote:
> Hey all,
>
>
It would be great to attend more advanced training on Struts. But maybe
it is hard for you to get to the city of the presentation. What if you
could from home attend 4 different published authors?
What if additionally there were labs by Best Training as voted by JDJ?
What if you could view the p
Hi,
On Thu, 2003-02-20 at 13:20, Mac wrote:
> Hi,
>
> I am using MySQL v3.23 and have a many-to-many relationship (cars <->
> colors) that I have broken up into three tables as follows
>
> cars:
> ID Manufacturer
> 1 Volvo
> 2 BMW
> 3 Toyota
Although several years later I just wanted to add my 2 pence worth.
I had similar problems to Chad.
It would appear that mysql_options does not work.
The scenario is.
I have a host to which I am trying to connect but that host is down.
(If the host is up but mysqld is not running then mysql_real_
Heikki / Egor,
I am not using the LOCAL keyword, but I am using selective replication with
the replicate-do-table directive. Could this be causing problems? Here are
the relevant options from my.cnf on the slave:
# The MySQL server
[mysqld]
port= 3306
socket = /tmp/mysql.sock
skip-lo
Since this is off topic anyway I thought I would throw this in. Instead
of Web-X use
http://www.astaskywire.com/
This would reduce the costs and allow the trainer to host the trainings
and customize the look and feel.
FWIW
Mike
> It would be great to attend more advanced training on Struts. Bu
Hi all,
I have a table that includes an auto_increment field.
This is used to build up an audit trail of the passage of a file through my
server. As a file is received from a remote system I create the first entry
for that file in the audit trail table. I build up an sql INSERT command
(I'm
updat
I found the following error with mysql server version 3.23.52.
mysql> select snb,id_servicio from Abonados_Servicios where
snb="1144293549";
9 rows in set (0.01 sec)
mysql> select snb,id_servicio from Abonados_Servicios where snb=1144293549;
9 rows in set (45.61 sec)
mysql> describe Abonados_Serv
Hi
Thanks for your bug report.
In latest 3.23 and 4.0, the slave ignores any LOAD DATA INFILE
as long as one of these options is set on the slave :
replicate_do_table
replicate_wild_do_table
replicate_ignore_table
replicate_wild_ignore_table
regardless of the values of these options, which is a
I have a host table where I save the platform model. The platform model
can be saved in various ways. For example,
Sun Enterprise 250 (2 x UltraSPARC 164MHz)
Sun Enterprise 250 (2 x UltraSPARC-II 400MHz)
Sun Enterprise 250 (2 x UltraSPARC-II 450MHz)
Sun 250
etc. I can get the count by:
select pl
Quoting Lenz Grimmer <[EMAIL PROTECTED]>:
Lenz:
# cc -V
Compaq C V6.4-014 on Compaq Tru64 UNIX V5.1A (Rev. 1885)
Compiler Driver V6.4-215 (sys) cc Driver
# cxx -V
ksh: cxx: not found
=
I couldn't find standard source so I used the gamma source. I'm g
Hi Guilhem,
Ok, good. At least this is a confirmed bug and not something on my end. :)
Hopefully, this will be considered a "critical" problem and fixed in 3.23,
since it makes all the replicate_* config commands useless. Was this
introduced recently? Can I downgrade to an older 3.23.x to get ri
On Thursday 20 February 2003 22:32, Jeff Kilbride wrote:
> Hi Guilhem,
>
> Ok, good. At least this is a confirmed bug and not something on my end. :)
Yes, you are not crazy and that's good news.
> Hopefully, this will be considered a "critical" problem and fixed in 3.23,
> since it makes all the
MySQL, SQL, Query ...
Does anyone know of a transaction history utility for MySQL? What
I am looking for is something that logs a before/after entry anytime
a change occurs in a MySQL table. I want to be able to say
definitively "these changes occurred at these times".
There are, of course, two
Hi All,
Once again we have run into a situation where our production
database is throwing an error regarding the use of table locks for
"no apparent reason".
We are running MySql on windows with InnoDb. We have a section
of code which is working fine most of the time but occasionally will
hi,
this is the problem.
# /usr/bin/rsync -vvaz --delete rsync://sunsite.dk/mysql/
/var/www/html/mysql/
opening tcp connection to sunsite.dk port 873
rsync: failed to connect to sunsite.dk: Connection refused
rsync error: error in socket IO (code 10) at clientserver.c(89)
where should I mirror
I am writing a vb.net application to do some db management on MySQL. Ive
got it pretty far but am at a point where I am stuck. I know with php
there is a list tables function. Does anyone know of a way to list the
tables of a given database outside of php?
Any help would be GREATLY appreciated.
Jeff Pearson wrote:
I am writing a vb.net application to do some db management on MySQL. Ive
got it pretty far but am at a point where I am stuck. I know with php
there is a list tables function. Does anyone know of a way to list the
tables of a given database outside of php?
Any help would be G
SHOW TABLES;
Then treat the output as a normal result set.
see the manual for more about SHOW syntax
http://www.mysql.com/doc/en/SHOW.html
-Original Message-
From: Jeff Pearson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 20, 2003 2:31 PM
To: [EMAIL PROTECTED]
Subject: List of Tabl
MySQL-List,
I have just installed MySQL on a Windows 2K machine. I followed the
directions to make it secure and now I'm getting the "Access Denied"
error. I found in the manual that I should create a hosts file to fix
this. Where do I put it? From what I see, in the C:\mysql\bin folder,
I sho
show tables; ?
or do you mean specific to vb ?
Jerry
- Original Message -
From: "Jeff Pearson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 10:31 PM
Subject: List of Tables
> I am writing a vb.net application to do some db management on MySQL. Ive
> got
hi..
i have an mysql username that is in the form of an email address and when i
use it in my php scripts for some reason i get an error:
warning: connection to host failed access denied for '[EMAIL PROTECTED]@' in
filename.php on line 4
anybody know what the extra @ is for at the end of the user
I am writing an application that will store
information in a MySQL database. I would like to
encrypt the data being stored in the database using
the AES_ENCRYPT/DECRYPT functions. My question is,
how can I securely contain the password in memory
within the application?
For example, the applicati
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 21 Feb 03 01:41:06 Taipei Daylight Time
[EMAIL PROTECTED] wrote:
It seems someone has forged a from header and it appears to be from the
vbfx.com domain (my domain). I hope that you see it is not originating from me
or my server.
can you post line 4 of the script ?
Jerry
- Original Message -
From: "Sunfire" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 11:11 PM
Subject: @ character appended at end of username problem
> hi..
>
> i have an mysql username that is in the form of an em
if i remember right you should make a hosts file in c:\windows\ dir and
thats where it sits.. at least thats where i have mine and it works fine...
in the file do this:
127.0.0.1 localhost
#or whatever your domain name and ip address is but its
#the same format and always include localhost
-
C:\WINNT\system32\drivers\etc
There should be one there by default
Jerry
- Original Message -
From: "Sunfire" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 11:32 PM
Subject: Re: Access Denied Help Needed
> if i remember right you should make a hosts file
Hello,
I hope it is okay to ask this here. I have a MySQL server running on
Slackware 8, and I would like to access it from a Windows box using Excel
(for now). I'm downloading the ODBC driver for windows, but is there
anything I need to do on the MySQL server side? I'm a bit confused about
that.
hi list,
Is there a way i can subscribe to this list as a digest user's mode,
Similar to mailman's digest feature. I was trying to get to the mailman
user's preference page but cannot find it on mysql.com. Can anyone help me
out here.
thanks,
MT
-
1 - 100 of 126 matches
Mail list logo
