Dear Sir,
I am facing problem to insert a record into mysql table from text file.
Knidly tell me how can I do that.
Actually I am new user of mysql.
I am already using Oracle8i. I want to export one oracle table to mysql table.
Is it possible or not.
Please tell me as soon as possi
Look in /usr/local/share.
--
Vibol Hou
KhmerConnection, http://khmer.cc
"Connecting Cambodian Minds, Art, and Culture"
-Original Message-
From: S A [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 6:06 PM
To: List MySQL
Subject: Can someone post up their FreeBSD .cnf file ?
My D
FreeBSD does not have as mature an implementation of threads as Linux has.
If you're looking to run a db server, use Linux or Solaris.
As for query times going up, which OS are you having that problem on?
--
Vibol Hou
KhmerConnection
http://khmer.cc
-Original Message-
From: S A [mailto:
I complied MySQL as a max binary. However when I gave all the variables for
InnoDB in the my.cnf startup file it seems that InnoDB gets initialized for
the first time only. With mysqld going fine, I try to connect using the
client and the server with it on really seems sluggish. I put in the
passw
In the last episode (May 15), S A said:
> My DBA & I can't find a .cnf file to start customizing our Free BSD
> MySQL setup.
>
> Could someone please post one up to start from ?
There really aren't any OS-specific settings in the my.cnf. All the
values really depend on what you're planning on d
In the last episode (May 15), Seth Northrop said:
> We are performing some rather extensive data collection
> (measurements) and are attempting to come up with the most sane
> storage mechanism to facilitate offline (Igor, MatLab, Custom Apps)
> and online (less complex web based solutions) analys
Dear,
I have an table which like to use recursive join but I wonder how to use
it. Please see the table struc below.
emp.id,emp name, emp salary, emp head-id
001,mr. a,1,001
002,mr. b,5000,001
003,mr. c,5000,003
004,mr. d,5000,003
Where
To begin with, there is no password, so mysqladmin -u root will get you
in. If you want to change password then use mysqladmin -u root password
new-password. After changing the password, you then need to use -p option.
- Original Message -
From: "Jon J. Morin" <[EMAIL PROTECTED]
How do I drop a Unique key from a table in my database?
I know I should Alter table, however there doesn't seems to have an option
to drop just the Unique key but not the primary key. Change and modify does
seems to do it either..
Jason Lam
-
Firstly, I'm using mysql_connect() without anyproblems.
>From what I can tell, you have not built php with mysql support. Please
consult the php manual and php list on how to fix this.
- Original Message -
From: "Jim Witt" <[EMAIL PROTECTED]>
To: "Help MySQL" <[EMAIL PROTECTED]>
Sent:
Hello,
I downloaded the MySQLGUI 1.7.5 source code from
http://www.mysql.com/Downloads/mysqlgui/mysqlgui-1.7.5.tar.gz and
unpacked it for compilation on my Linux Mandrake 7.1 system. The problem
is that it appears not to be a source distribution with no intsructions
for doing the usual ./conf
It's a little hard to figure out why without seeing the commands you used
but at a guess, I would say, when you first tried to get in, you used the -p
option but of course no password had been set at that stage.
- Original Message -
From: "Simone Lucarelli" <[EMAIL PROTECTED]>
To: "mysql
> Believe me they knew what they where doing when they
> choose not to implement this.
"I'm glad I live in rags - thank goodness I don't have to worry about
washing my clothes!!".
Enforcing foreign keys in your application can be pretty darn expensive, and
painful:
* You have to have a way of
My DBA & I can't find a .cnf file to start customizing our Free BSD MySQL setup.
Could someone please post one up to start from ?
thanks,
- Sam.
-
Do You Yahoo!?
Yahoo! Auctions $2 Million Sweepstakes - Got something to sell?
Hi everybody. I think that I have successfully installed version 3.23.37 on
my Linux box. The problem is, is that I am new to mysql and I can't get a
few things to work. I am logged in as root. I am in the mysql directory
(/usr/local/mysql). I try bin/mysqladmin --password and it
prompts me
We are performing some rather extensive data collection (measurements) and
are attempting to come up with the most sane storage mechanism to
facilitate offline (Igor, MatLab, Custom Apps) and online (less complex
web based solutions) analysis tools. The problem resides in the amount of
data coll
>On Tue, May 15, 2001 at 04:45:22PM +0200, Viktor van den Berg wrote:
> >
> > Hi,
> >
> > I am new to this list, so maybe this question is asked before.
> >
> > I like to know how to use the except statement in MYSQL. EXCEPT is
> > (almost?) the same as an exlusive or (XOR):
> >
> > selec
Dear listers,
I am looking for someone with experience in Thai support for MySQL. I have found a
person, named Pruet Boonma, in MySQL manual, but his old e-mail address does not seem
to work.
Can anyone recommend me the place to turn for help to? Please bear in mind that I do
not speak Thai at
I tried to configure MySQL like this:
./configure --prefix=/usr/local/mysql --with-charset=sjis
After a hundred lines or so of install verifications, it quits the
installation with the following:
checking whether struct tm is in sys/time.h or time.h... time.h
checking size of char... 0
configur
Honestly I am not sure how it would scale, it has worked well in my
use with several thousand very large documents (a couple million rows
in the index table). You certainly couldn't use this to develop an
internet search engine...
I had never heard of MySQL not using keys in an OR type of query,
Hi all,
I tried to load data into a table (using a txt file) by following the
example on chapter 9 (pg 9) and it did NOT work. Then I decided to include
the path of the file and it worked fine.
I got curious though. If you omit the path, where does mysql looks for it?
I placed the file into t
>
> I found FULLTEXT (MATCH/AGAINST) indexes and the SOUNDEX function. Are
> there other MySQL features that help with Fuzzy searching?
>
> Soundex seems very useful, but I'm not sure how to apply it to multi-word
> strings.
>
> I'd also be interested in pointers to general info on writing f
On 15 May 2001 13:21:12 +0300, Sinisa Milivojevic wrote:
>
> The reason why you are having problems in building from source is that
> you are most probably using gcc 2.96, which is simply broken.
I have different results. Here:
(I'm doing everything on a dual-proc Linux Red Hat 7.0 system with
hello,
is it possible to set server varibales through SQL and if so
what user-rights do i need?
thanx in advance
regards peet
I have a similar mysql enum question. What if I have the following:
enum('foo','bar','baz') default 'bar' not null.
What if I want to change the value of "bar" to "bee"? What is the best way
to implement this?
Nicole Sweeney
Software Configuration Engineer
Akamai Technologies
858-909-3654 work
8
Hi there,
I'm trying to install MySql and Mysql client
(including MySql GUI) both on Windows and Unix/Linux.
I'm having trouble reset the root password:
I ran:
./bin/mysqladmin -u root password 'mysqlroot'
./bin/mysqladmin: connect to server at 'localhost'
failed
error: 'Access denied for user: '
Try: http://eliteukserve.net/dedicatedservers/dedicated_servers.html
We specialise in managed custom server solutions. We have great experience in
providing mass virtual solutions incorporating Linux
based systems such as SuSE and RedHat with MySQL.
I would say perhaps a Dual PIII 1GHz SCSI wou
there is no command line.. you go to the mysql.com site, download
the access converter on the contributed programs page, copy the code
into an access module (macro), edit the code to tell it where to
save the result and run it.
It will produce a text file, then you can do
mysql mydatabase < myt
I also get somthing like that,
much mor productive to do somthing like
create database gnudip2(id int(10),some_colum varchar(255));
Trying to show that you add columns with the same command.
Darrell
On Tue, 15 May 2001, Ana Elisa Martinez wrote:
> When i try to create a database with the
Can you give me a sample command line please
CHRIS
In message <[EMAIL PROTECTED]>, Steve Ruby
<[EMAIL PROTECTED]> writes
>Chris Wilkinson wrote:
>>
>> I am attempting to upload an Access db to a remote mysql server - at
>> dsvr in the UK.
>>
>> I get connected (I think) but receive the follow
I have some complex multi-step queries that take over 60 seconds on Free BSD 4.2. They
seemed much faster on Linux.
Should FreeBSD 4.2 be just as fast as Linux on comparable hardware ?
When I simulate concurrent users the query times go up oddly.
1 user 66 seconds
2 users 157 seconds
3 user
create database gnudip2;
make sure you have the right permissions as well!
- Original Message -
From: "Ana Elisa Martinez" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 15, 2001 9:09 PM
Subject: Error creating database
When i try to create a database with the command
mysql> create database gnudip2;
> When i try to create a database with the command :
>
> mysql> create gnudip2;
>
> Told me an error :
>
> ERROR 1064: You have an error in your SQL syntax near 'gnudip2' at line 1
>
> Why this error ??, What is wrong ??
>
> Thanks
> Ana Elisa Martinez
>
>
>
>
--
Hi! I wonder what would be faster. Let's say I want to run two kinds of
SQL queries on the table:
SELECT id FROM mytable WHERE key1=? AND key2=? AND key3=?;
DELETE FROM mytable WHERE key1=? AND key2=? AND id=?;
What's better? This:
CREATE TABLE mytable (
key1 CHAR(20) NOT NULL,
key2 CH
With windows, you can use "type filename.sql | mysql ..."
> Maybe he's running in some windows version??
> It seems to me that your example using std-in is the easiest. I would
> suggest also writing a perl program but in this case I thing your
> example is
> right on. Then again if he's using
try:
mysql>CREATE DATABASE gnudip2;
>From: "Ana Elisa Martinez" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Subject: Error creating database
>Date: Tue, 15 May 2001 16:09:09 -0400
>
>When i try to create a database with the command :
>
>mysql> create gnudip2;
>
>Told me an error :
>
>ERROR
how 'bout read manual
create database a
- Original Message -
From: "Ana Elisa Martinez" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 15, 2001 4:09 PM
Subject: Error creating database
When i try to create a database with the command :
mysql> create gnudip2;
Told me
When i try to create a database with the command :
mysql> create gnudip2;
Told me an error :
ERROR 1064: You have an error in your SQL syntax near 'gnudip2' at line 1
Why this error ??, What is wrong ??
Thanks
Ana Elisa Martinez
Look on Ebay for Compaq 1850R 'rackmount' servers...
You can find one with 'dual' Pentium II CPU's, dual power supplies (which you can
plug into 2 different circuits or UPS's), and enough SCSI drive slots to provide the
disk space (and the different number of storage devices to 'mirror' and s
-> This was posted before, but under a title that made it sound like a "read
the manual, silly" type of question. Hopefully someone can answer this.
I would like to be able to filter users based on other criteria than just
their name/host. Will mysql complain/refuse to work if I add columns t
I have installed MySQL 3.23.32
Other apps: PHP 4.0.5, Xitami
Machine: Athlon 1 GHz, Win98, 256K RAM
Manual indicates 'mysql_connect()' is deprecated. So I try
'mysql_real_connect()' and get that nasty:
Fatal error: Call to undefined function: mysql_init() in
c:/xitami/cgi-bin/dbProc1.php on l
On Tue, May 15, 2001 at 02:06:32PM -0400, Dave Carter wrote:
> correct me if I'm mistaken, but I believe the latest version of mysql is
> 3.23.38
That's the released version, yes.
But you can pull a source copy of the MySQL 4.0 tree and compile it
yourself if you're in the mood for some fun. :-
DEFAULT 'added'; ?
Abraham Ingersoll wrote:
> Can anyone shed light on why this doesn't work, and perhaps tell me how I
> can ALTER the enum values .. or is this just not possible?
>
> mysql> ALTER TABLE nt_zone_record_log CHANGE COLUMN action action
>ENUM('added','modified','deleted')
hi.
put quotes around 'added'.
-ravi.
-Original Message-
From: Abraham Ingersoll [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 2:40 PM
To: [EMAIL PROTECTED]
Subject: alter table change enum set
Can anyone shed light on why this doesn't work, and perhaps tell me how I
can ALTE
Here is what I am trying to do:
I am creating a clockin/out utility with php and mysql. I need to do some
error checking and look at the last record of the current employee to make
sure it is a completed transaction. In other words, I want to make sure that
before I clock someone in, that they su
You need to quote the default value.
--zak
- Original Message -
From: "Abraham Ingersoll" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 15, 2001 12:39 PM
Subject: alter table change enum set
>
> Can anyone shed light on why this doesn't work, and perhaps tell me how I
No mention of this on the lists. Suggestions?
___
empire>uname -a
FreeBSD davidfavor.com 4.2-RELEASE FreeBSD 4.2-RELEASE #0a: Tue Feb 27 14:08:02 MST
2001 root@fc:/usr/src/sys/compile/VKERN i386
gcc -I. -Iinclude -I/usr/home/dfavor/rpm/BUILD/mysql-3.23.38/mit-pthreads/include
-DPTHR
I need am looking for a server for virtual hosting of websites. Ideally it would be
running Linux and be rack mounted. Right now we have a couple of websites that
require database support on another companies server and we are looking at hosting
them on-site. Currently we have a couple of ra
Maybe he's running in some windows version??
It seems to me that your example using std-in is the easiest. I would
suggest also writing a perl program but in this case I thing your example is
right on. Then again if he's using the windows version, I have no idea.
-Original Message-
From
At 03:53 PM 5/15/01 +0200, DEVOS BASTIEN wrote:
>Excuse me but what do you mean by FullText ? Is this a full-text search
>engine in MySQL ???
FULLTEXT is a kind of index in MySQL that allows for faster queries and
search-engine like "relevance" values for sorting the results.
Here's a link to s
I'm not a database god, but why would you want to store binary data in a
varchar feild when there are feilds of type binary to do store that type of
data? How can binary be upper or lower case?
-Original Message-
From: VVM Ravikumar Sarma Chengalvala [mailto:[EMAIL PROTECTED]]
Sent: Tues
Doh!
mysql> ALTER TABLE nt_zone_record_log CHANGE COLUMN action action
ENUM('added','modified','deleted','recovered') NOT NULL DEFAULT
'added';
Query OK, 25 rows affected (0.01 sec)
Records: 25 Duplicates: 0 Warnings: 0
Time to squash this bug in MysqlTool
(http://dajoba.com/pr
Can anyone shed light on why this doesn't work, and perhaps tell me how I
can ALTER the enum values .. or is this just not possible?
mysql> ALTER TABLE nt_zone_record_log CHANGE COLUMN action action
ENUM('added','modified','deleted') NOT NULL DEFAULT added;
ERROR 1064: You have an error
Hello,
From: Richard Ellerbrock <[EMAIL PROTECTED]>
> Just installed MaxSQL 3.23.38 on a test system to check out InnoDB.
> Here are my observations:
May I add my ones ...
If there are some missing entries in the my.cnf or the INNODB
handler can't be started because of permission problems a
Hello,
On Tue, 15 May 2001, Aires Lima Trindade wrote:
> How to run SQL commands from a text file" but they wasn't clear for me.
> Does anybody can share with me old experience or a real example
> about this case?
C:\mysql\bin>copy con upd.sql
USE akw;
INSERT INTO tmp (id,c1) VALUES(NUL
It wasnt my original post, however the problem with the full-text engine
built into mysql is at the current time it is very slow with many records. I
was inquiring if this other method would be any faster.
ryan
> Excuse me but what do you mean by FullText ? Is this a full-text search
> engine in
I've encountered this before. Several of my clients use mySQL and most of
them Linux, however my servers that run mySQL all are W2k. The issue
happened like you said when migrating data from w2k to linux. It was a few
versions ago in 3.22 however, but the auto-increment field didn't translate
for
At 09:42 15/05/2001 -0700, Ray Pollard wrote:
Hi,
There are several ways to do this. For example you can use
script languages like PHP (you find in our contribution pages
applications ready), also you can use SSH (maybe you need a
commercial SSH server to run on Windows) or you can use telnet
toge
Hi,
Can some one tell me the default memory the mysql
allocates when we initially create a database and how
to increase the memory subsequently.
Regards,
Ravi
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
Hi,
We can decalre a varchar field as BINARY if we need
case sensitive storage of field values.
Regards,
Ravi
--- ryc <[EMAIL PROTECTED]> wrote: > Varchar fields are
not binary, blobs are.
>
> ryan
>
> > Hi & Help!
> >
> > I would like to store some short binary data
> (encrypted). I used a
>
correct me if I'm mistaken, but I believe the latest version of mysql is
3.23.38
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, May 15, 2001 1:04 PM
To: [EMAIL PROTECTED]
Subject: MySQL 4.0 FULLTEXT SPEED
Hi Everyone,
I
I'll maybe say something stupid, but if you have your files with your SQL
commands, couldn't you use this command ? :
mysql -u your_user -pyour_password < /path/to/your/SQL/commands/file
?
> -Original Message-
> From: Aires Lima Trindade [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 15,
When I run mysqlbinlog on my binary.log file (I specified that filename),
under some situations I cannot read the file, I get Bad Magic Number error.
/etc/my.cnf
log-bin=/usr/local/mysql/data/binary.log
Results:
- On mysql 3.23.35 on Solaris 7 I have to run "flush master" from the mysql
client
Richard,
I made some measurements with fsync. If I create first the big data file
without O_SYNC and after that make a single fsync, I get a write speed
of 5 MB/s, which is 5 times more than with O_SYNC.
On the other hand, opening a log file in the O_SYNC mode makes commits
much faster than by c
Try this program. Go to http://www.artronic.hr/mysql/index.htm and get
mysqladmin. Its a windows client to manage mysql databases. You then can
put in the ip address of the computer you want to connect to that is running
a mysql database. So you would put your win2000 server ip. Then put in a
Hello All,
is there any kind of row number pseudo-column that identifies a
particular row's position in the query's result set? Something like
RowNum in oracle.
Thanks!
-- john
--
===
John Cartwright
Professional Rese
On 15 May 2001 13:21:12 +0300, Sinisa Milivojevic wrote:
>
> The reason why you are having problems in building from source is that
> you are most probably using gcc 2.96, which is simply broken.
Will you accept further patches to the spec file that will try to
autodetect the compiler and make u
When I try and update a recordset I get the following problem-
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Query based update failed. The row to update could not be found.
/Part1_Section1_Process.asp, line 82
Line 82 happens to be when I call rs.Update()
The problem only occurs w
4.12.18.1 Mac OS X Public beta
MySQL should work without any probelms on Mac OS X public beta. (Darwin);
You don't
need the pthread patches for this os!
typo: "probelms"
_
Get Your Private, Free E-mail from MSN Hotmail at h
Hi Everyone,
I've compiled the mysql 4.0 version on my computer to test the speed of
creating full text indexes.
I read that it was supposed to be 100 x faster than 3.23. However, it
seems just as slow to me. I've been building an index on my 400+MB
table for 5 days now. Does anyone have any
In message <1D9A6579106BD411BA9700A0C9A50975191A97@AFTERBURNER>, Randy
Davis <[EMAIL PROTECTED]> writes
>I was wondering if anybody would be able to help me with this. I've got a
>MySQL database set up on my Linux server. I want to be able to access it
>remotely, but all we get when we try to a
I am new to the world of mySQL and have just installed it on a Windows 2000
Advanced Server and I need to figure out how make the db accessible from a
remote PC for administration. Can anyone provide me with some direction in
that area? Bear in mind, I am a newbie.
Thanks very much,
Ray
It looks like they're running Sun Solaris version 2.6 (SunOS 5.6) on an
Intel-based system (as apposed to a SPARC based Sun server). The MySQL
site only shows binaries available for the SPARC version of Solaris, so
you'll have to download and compile the 'source' distribution...
- Origin
After installing mysql, when i try to connect the server
reply
access denied for root@localhost
How is it possible? I set the password for user root, and
all seems to be right
++ SIMONE LUCARELLI
| _ | agenzia giornalistica
||___ ___| | TUTTOCALCIO
| / /
On the mysql.com website under downloads: contributed there
is a chunk of VBA code you can put in an access database to make
it export to a SQL text file, use that, you are better off,
otherwise export from Access to text (comma separated for example)
and use LOAD DATA in mysql to load the file.
Steve
Thanks for replying. I have an Access 2000 database called webugnet and
I am attempting to Export it. I have installed MyODBC and configured a
mysql connection to the sql server on DSVR.
So, in the table window right click on the database and select "Export"
This brings up an "Export ta
Well, if you really just want it stopped, the usual unix rule is to "ps -ax |
grep mysql", read the PIDs then "kill -11 [PID]" kill the safe_mysqld script
first or it will restart the mysql daemon.
EISSEN Charlie wrote:
>
> Hello, i'm running mysqld on darwin (mac os x client)...Start is good, b
Steve,
At 09:48 AM 5/15/01 -0600, you wrote:
>Heikki Tuuri wrote:
>>
>> Steve,
>>
>> your observations suggest that it is MySQL which is holding some
>> semaphore while it is aborting a connection (which in your case
>> required a big rollback). The operating system seems to be innocent.
>>
>
Richard,
thank you for the observations. Some comments:
>Just installed MaxSQL 3.23.38 on a test system to check out InnoDB. Here
are my
>observations:
>
>1) Manual is not clear on permissions of directories - They should be
mysql.root
>owned. The error in the error log just says cannot create
Excuse me but what do you mean by FullText ? Is this a full-text search
engine in MySQL ???
> -Original Message-
> From: ryc [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 15, 2001 3:29 PM
> To: James Treworgy; Chris Nichols
> Cc: [EMAIL PROTECTED]
> Subject: Re: Re[2]: MySQL Full
Hi,
I am getting the following exception regularly. After getting this
I have to restart the DB.
Please let me know, is there any remedy for this.
Please help me out.
Thanks and Regards,
Saravanakumar.M
>12:21:23 PM java.io.IOException: Broken pipe
>12:21:23 PM at
i've downloaded a 1.7.5 Linux semi static binary distribution of My Sql Gui.
Seems to work fine except that i have a connexion error. Documentation
mention to enter a path to named pipe in options.
I'm new to linux (and unix...). I don't know what file to search for on my
Mandrake distribution.
I was wondering if anybody would be able to help me with this. I've got a
MySQL database set up on my Linux server. I want to be able to access it
remotely, but all we get when we try to access is the following message:
ODBC - call failed
[MyODBC] Access denied for user: 'user@hostname' (Using
Steve,
your observations suggest that it is MySQL which is holding some
semaphore while it is aborting a connection (which in your case
required a big rollback). The operating system seems to be innocent.
On Windows NT I have seen that disk operations will freeze the
computer almost totally. Lin
I had the same from SuSE 6.3
what I had to do was download and install:
http://www.mysql.com/Downloads/MySQL-3.23/MySQL-client-3.23.38-1.i386.rpm
and
http://www.mysql.com/Downloads/MySQL-3.23/MySQL-devel-3.23.38-1.i386.rpm
as well.
removing the originals via yast
if i remember i had a few g
On Tue, May 15, 2001 at 04:45:22PM +0200, Viktor van den Berg wrote:
>
> Hi,
>
> I am new to this list, so maybe this question is asked before.
>
> I like to know how to use the except statement in MYSQL. EXCEPT is
> (almost?) the same as an exlusive or (XOR):
>
> select userid from user1
> e
This is a known bug when running MySQL on Darwin / Mac OS X right now.
Last I heard some listy was submitting a diff or a patch to the
maintainers, but I haven't heard anything about it for a little while.
Any news, folks? Works a treat on Darwin, otherwise.
Zach
On Tuesday, May 15, 2001, a
Just installed MaxSQL 3.23.38 on a test system to check out InnoDB. Here are my
observations:
1) Manual is not clear on permissions of directories - They should be mysql.root
owned. The error in the error log just says cannot create file. This could be one of
many things! I had to use my initi
Steve,
I cannot promise any such tools in the next 6 months.
My TODO list has the two important items currently:
support for arbitrary size BLOBs and CHECK TABLE.
The right way to proceed now is to test existing tools and their speed.
Could you measure the speed of the following options in dump
I'm not for sure but when you create a user you can allow that user to only
connect from specific locations. Such as localhost or from anywhere or even
a specfied locationm 123.222.111.2. Not sure if this will help at all??
Good Luck.
-Original Message-
From: stephane parenton [mailto:[
Anyway, I'm running SuSE 7.1 and here is my error messages:-
jedi:/usr/bin # safe_mysqld
Starting mysqld daemon with databases from /var/lib/mysql
010516 06:05:54 mysqld ended
I checked my log, it said
010516 06:05:54 mysqld started
010516 6:05:54 /usr/sbin/mysqld: Can't find file: './mysql
My name is Martin Leduc from Solution Globale, Chicoutimi. We are interested by a
MySQL Solution, but we have a big problem and we dont know how to solve this one.
We use MyODBC 2.50.37 and MySQL 3.23.36 to 38 (bug fixed) and we have anytime the same
trouble. Null value with NOT NULL TEXT fie
Chris Wilkinson wrote:
>
> I am attempting to upload an Access db to a remote mysql server - at
> dsvr in the UK.
>
> I get connected (I think) but receive the following error message:
> Microsoft Access ODBC - call failed [Microsoft][ODBC Driver Manager #0]
>
> Can you point me in the right di
On Tue, May 15, 2001 at 10:24:38AM -0400, Chris Lambrou [CGL] wrote:
> Hello,
>
> This is more like a UNIX question: In our LINUX box
> startup file, we have an entry to start mysql.
> However, when the machine boots, mysql starts as root.
> How do we make it to start as mysqladm (the user
>
Hi,
I am new to this list, so maybe this question is asked before.
I like to know how to use the except statement in MYSQL. EXCEPT is
(almost?) the same as an exlusive or (XOR):
select userid from user1
except
select userid from user2
The result is a data set containing userid's that are onl
Foreign Keys are nice but they are costly items to use, best enforce the
reference in your business logic of your application. You can still join and
look up based on references but the database is not responsible for
enforcing the relationship. Believe me they knew what they where doing when
they
Andy Woo wrote:
>
> I have the same problem. Whatsssup? :-)
> /usr/bin/mysqladmin: connect to server at 'breguet' failed
> error: 'Host 'breguet.experia.com' is not allowed to connect to this
> MySQL server'
>
> what can I do to solve this ?...
I don't know i removed the things, and trie
I have the same problem. Whatsssup? :-)
-Original Message-
From: stephane parenton [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 9:23 PM
To: mysql
Subject: upgrade from SUSE7.0
hi,
I upgraded the mysql provided by suse with the 3.23.37, and I have a
problem... It's said that
I am attempting to upload an Access db to a remote mysql server - at
dsvr in the UK.
I get connected (I think) but receive the following error message:
Microsoft Access ODBC - call failed [Microsoft][ODBC Driver Manager #0]
Can you point me in the right direction for this or offer some help.
T
mysql Ver 11.15 Distrib 3.23.37, for sun-solaris2.7 (sparc)
SunOS 5.7 Generic_106541-02 sun4u sparc SUNW,Ultra-5_10
On Tue, 15 May 2001, Heikki Tuuri wrote:
> Hi!
>
> Ok, the error turned out to be out of disk space. But for some reason
> the error handling code in os0file.c did not recognize
1 - 100 of 141 matches
Mail list logo
