Mac OS XS 10.2
when you install the OS you have the oppt'y to put in a machine name
(not the AppleTalk, Sharing name).
i almost always put in a name. that name (mbase), it is also my
default web host; that name also shows up at my terminal prompt
(instead of the usual localhost).
if i look
Hi,
Can anybody tell me is it possible in the my sql to set the function as
default value, for example can i set the now() function for the date column
field.
Thanks in advance.
Regards
Daya Krishan Dubey
Core Solucomm Ltd
423 B, Hamilton court
DLF phase IV
Gurgaon, India
Ph# 91-124-6392896/7
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
tel. 0121-242-1473
---
-Original Message-
From: Paul Romanic
From: [EMAIL PROTECTED]
Date: Tue, 24 Sep 2002 13:41:23 +0800 (WST)
I've got a problem with HEAP tables (undoubtedly the way
that I'm using them).
I'm running MySQL v.3.23.51 under Debian Linux with a
2.4.17 kernel.
If anyone can help clear some of the fog, I'd
Hi,
I have now been able to solve this problem.
I used MySQL 3.23, but when I installed MySQL 4.0.3 it worked fine.
Great
Tobias
Tobias Eriksson
ComOpt AB
Michael Löfmans gata 6
254 38 Helsingborg, Sweden
Direct: +46 42 389918
Phone: +46 42 389900
e-mail: [EMAIL PROTECTED]
Hi
How do I
DeNewbie,
Sunday, September 29, 2002, 12:46:29 AM, you wrote:
D I am a newbie and I have just recently installed MySQL. I am somewhat confused as
to why the tests that I am running from my command prompt are not showing any results
yet I believe that my MySQL
D server is running;
D
David,
Monday, September 30, 2002, 4:44:19 AM, you wrote:
DG I am attempting to use mysql 3.23.52 on win2000pro. I have installed
DG it and I believe everything went okay for that. At least I did get any
DG errors.
DG When I open services, mysql is set for automatic but it is
Daya,
Friday, September 28, 2001, 10:36:30 AM, you wrote:
DKD Can anybody tell me is it possible in the my sql to set the function as
DKD default value, for example can i set the now() function for the date column
DKD field.
No, you can't:
http://www.mysql.com/doc/en/CREATE_TABLE.html
--
mailto,
Friday, September 27, 2002, 8:52:25 PM, you wrote:
majdd i am a mysql newbie (my first time i install it)
majdd i give up, i can't solve the problem without help.
majdd all the time i try to start the mysqld, it ends up instantly with a shutdown
majdd of mysqld, i cant run the prog: i
Jiri,
Sunday, September 29, 2002, 11:18:51 PM, you wrote:
JM I'm solving problem how to set up quota on MySQL db. I've look for that
JM in mailing lists and docummentation but with no success.
JM Can someone help me with this problem?
You can do it using disk quotas.
--
For technical
Alexander,
Saturday, September 28, 2002, 12:47:19 PM, you wrote:
AS Is it feasible to use replication to keep the database which powers my
AS website up-to-date? The database itself is on the hosting companies server
AS and contacted via dialup so the connection isn't there all of the time.
AS
ÀÌö¿ì(õ¸®¾È),
Saturday, September 28, 2002, 9:42:24 AM, you wrote:
ÀÃ I'm new to MySQL.
ÀÃ Anyway...
ÀÃ My O/S is FreeBSD 4.6.
ÀÃ In /etc/hosts there are only two line.
ÀÃ 127.0.0.1localhostlocalhost.paldal.com
ÀÃ 192.168.0.88unix.paldal.comunix
ÀÃ And in
I've just installed MySQL on a MacOS X 10.2 system. Everything is OK but I
can't find how I can login as a master to create users and give privileges ?
Thanks.
--
S.PINEL
-
Before posting, please check:
On Mon, 30 Sep 2002, Victoria Reznichenko wrote:
Jiri,
Sunday, September 29, 2002, 11:18:51 PM, you wrote:
JM I'm solving problem how to set up quota on MySQL db. I've look for that
JM in mailing lists and docummentation but with no success.
JM Can someone help me with this problem?
You
Hi,
I am trying to set up a mail server using Postfix, Web-cyradm and mysql
on SusE 8. I have followed all the steps in Luc de Louw's documentation
so far and MySQL server is running. When I try to use the scripts that
came with Web-Cyradm to create the databases and tables I get the
folowing
Odhiambo,
Saturday, September 28, 2002, 9:05:00 AM, you wrote:
OW I have some problems with my database and not being quite profficient in SQL,
OW I did myisamcheck and posted the data on the site below:
OW http://ns2.wananchi.com/~wash/RT2/myisamcheck.txt
OW I am wondering if someone can take
Stéphane,
Monday, September 30, 2002, 2:34:17 PM, you wrote:
SP I've just installed MySQL on a MacOS X 10.2 system. Everything is OK but I
SP can't find how I can login as a master to create users and give privileges ?
It's not so difficult. You should connect to the MySQL server as
root:
Lawrence,
Monday, September 30, 2002, 2:47:44 PM, you wrote:
LS I am trying to set up a mail server using Postfix, Web-cyradm and mysql
LS on SusE 8. I have followed all the steps in Luc de Louw's documentation
LS so far and MySQL server is running. When I try to use the scripts that
LS came
Joel Rees wrote:
If I compile MySQL using --with-charset=sjis , how will it handle the
Latin, Chinese, and Korean characters?
Multiple databases on multiple servers?
Try this one on for size:
CREATE TABLE Customers ( Name VARCHAR(100) );
Now ... if your customers have names in
Victoria Reznichenko wrote:
Cyril,
Friday, September 27, 2002, 4:19:25 PM, you wrote:
CZ if I build mysql with
CZ ./configure --with-charset=koi8_ru
CZ then check (make; make check; make test) failed!
Because MySQL by default uses latin1 character set and you have compiled only
with
David,
Saturday, September 28, 2002, 2:37:00 AM, you wrote:
DY Hi all. I'm trying to load a file into mysql using load data infile and
DY got a ton of warnings. Is there any way to see what the warnings are?
MySQL doesn't store warnings anywhere.
--
For technical support contracts, goto
Before I go and write one, does anyone know of any tools to create MySQL tables from
FMP databases?
All that I've seen are commercial products that synch the two, but the MySQL tables
have to already exist. (I have hundreds of columns that I'd rather not key in
manually!)
--
: Jan Steinman
That would be a great way to keep your website up to date.
The slave can handle loss of connection (though some data may not make sense if part
of it is missing), and resume where it has left of previously.
Or you could also manually start and stop the slave process when you know there is a
Cyril,
Monday, September 30, 2002, 3:35:40 PM, you wrote:
Cyril,
Friday, September 27, 2002, 4:19:25 PM, you wrote:
CZ if I build mysql with
CZ ./configure --with-charset=koi8_ru
CZ then check (make; make check; make test) failed!
Because MySQL by default uses latin1 character set and
-Original Message-
From: Paul Darius [mailto:[EMAIL PROTECTED]]
Subject: Database Replication
'lock database with read lock' command already done before the above
replication started and followed by 'unlock all' when finished.
Question, how to sync an unsync table or the
Maybe try one line...
I got this tons of warnings this morning making an import from Excel.
But it was apparently successful...but all decimal value where store
truncated like 128.00 , the reason is I'm in France and Excel exports
decimal with coma 128,34 but MySQL expects 128.34 so I just
You know that process would be much easier if you used the GRANT syntax
http://www.mysql.com/doc/search.php?q=GRANTfrom=%2Fdoc%2Fen%2Findex.html
-Original Message-
From: Insanely Great [mailto:[EMAIL PROTECTED]]
Subject: Setting Permission For Column Level Only
Greetings...
I
Iikka,
Monday, September 30, 2002, 2:40:32 PM, you wrote:
Jiri,
Sunday, September 29, 2002, 11:18:51 PM, you wrote:
JM I'm solving problem how to set up quota on MySQL db. I've look for that
JM in mailing lists and docummentation but with no success.
JM Can someone help me with this
Did you make the changes to master.onfo to point to the new master?
Did mysql own master.info when you were through?
Eric Frazier wrote:
Hi,
I changed my hostname(The DNS change was taken care of elseware) in
FreeBSD 4.6 in the rc.conf file, rebooted. Mysql had no problems
starting, but
Hi,
I didn't have a new mysql master, just the slave name was changed. Yes on
the second question too.
Thanks,
Eric
At 09:09 AM 9/30/02 -0500, gerald_clark wrote:
Did you make the changes to master.onfo to point to the new master?
Did mysql own master.info when you were through?
Eric
Victoria Reznichenko wrote:
Cyril,
Monday, September 30, 2002, 3:35:40 PM, you wrote:
Cyril,
Friday, September 27, 2002, 4:19:25 PM, you wrote:
CZ if I build mysql with
CZ ./configure --with-charset=koi8_ru
CZ then check (make; make check; make test) failed!
Because MySQL by default uses
on 9/30/02 9:47 AM, Victoria Reznichenko at [EMAIL PROTECTED]
wrote:
It's not a so good decision and not suitable if database contains
InnoDB tables, but you can't limit database size only with MySQL.
Is this a planned feature anywhere on the MySQL roadmap for 4.x? A database
size quota?
Mmm.. filter goodness. Trying again with the required words: sql query
... along the lines of using the database as a pointer to the real file in
a
normal filesystem that others have suggested.. may I add the idea of using
a
'hashed' directory structure such that you don't end up with an
CP,
Monday, September 30, 2002, 3:48:31 AM, you wrote:
C The Master's server id is 1 while the slave's server id was set to 5. There
C is no problem for the slave to establish connection to the master. However,
C the slave complains that error reading packet from server, the reason is
C
Because you did not set autocommit on?
Noor Dawod wrote:
Hi all,
I found out today that MySQL is adding a 'ROLLBACK' command to each
session connecting to it, without explicitly ordering this.
This is new since we never had this behavior before. Why is this
happening, and how can I revert to
+-+
| Grants for [EMAIL PROTECTED]
| |
You need to grant privileges on the master to the new slave machine.
Eric Frazier wrote:
Hi,
I didn't have a new mysql master, just the slave name was changed. Yes on
the second question too.
Thanks,
Eric
At 09:09 AM 9/30/02 -0500, gerald_clark wrote:
Did you make the changes to
Does MySQL 3.23.39(version) support IFNULL(NULL,0) || NULLIF(0,NULL)
Thanks,
Gramos
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
http://www.mysql.com/doc/en/Control_flow_functions.html
top of the page
-Original Message-
From: Gramos Brestovci [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 11:47 AM
To: [EMAIL PROTECTED]
Subject: IFNULL || NULLIF
Does MySQL 3.23.39(version) support
On Sun, 29 Sep 2002, Insanely Great wrote:
Date: Sun, 29 Sep 2002 22:43:43 +0530
From: Insanely Great [EMAIL PROTECTED]
To: Ibrahim Al-Tawil [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: Urgent!!
Greetings...
I believe that ASP works well with MySQL thru ODBC. As of learning other
William R. Mussatto wrote:
On Sun, 29 Sep 2002, Insanely Great wrote:
Date: Sun, 29 Sep 2002 22:43:43 +0530
From: Insanely Great [EMAIL PROTECTED]
To: Ibrahim Al-Tawil [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: Urgent!!
Greetings...
I believe that ASP works well with MySQL thru
[.snip.]
? How do you intend to run .ASP on linux?
[.snip.]
Its called Sun ONE from SUN.
http://www.chilisoft.com/
Dan
-Original Message-
From: William R. Mussatto [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 10:29 AM
To: Insanely Great
Cc: Ibrahim Al-Tawil;
There is a package called Chilisoft that will let you take your ASP pages
and change them to PHP, I am not sure how well it works. I had a client that
want to run ASP on linux and told I didn't think you could but PHP works and
to me is better. But the price of Chilisoft was a little hight. I
On 9/30/2002 12:14 AM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Mac OS XS 10.2
when you install the OS you have the oppt'y to put in a machine name
(not the AppleTalk, Sharing name).
i almost always put in a name. that name (mbase), it is also my
default web host; that name also
Chuck Payne wrote:
There is a package called Chilisoft that will let you take your ASP pages
and change them to PHP, I am not sure how well it works. I had a client that
want to run ASP on linux and told I didn't think you could but PHP works and
to me is better. But the price of Chilisoft was
IMPORTANT INFORMATION!
This is an automated message.
The message you sent (attached below) requires confirmation
before it can be delivered. To confirm that you sent the
message below, just hit the Reply button and send this
message back (you don't need to edit anything). Once this is
done,
Chuck,
ChiliSoft ASP is actually a Linux port of ASP 3 (I think). On the whole
we've found it to run OK but there are a few features that are not included
in the more recent Microsoft releases. While it makes it easy for IIS users
to port their sites to a Linux server I personally wouldn't
Its called Sun ONE from SUN.
http://www.chilisoft.com/
Don't most people who use ASP want to use Visual Basic? So the
problem isn't really lack of ASP on Linux but lack of VB. Somehow I
doubt that Microsoft (at least in its current incarnation) is going
to come out with VB for Linux.
Hi,
I've just tried to download the Win32 binaries of the MySQLGUI tool.
I recieved about 50kB. When I tried to unpack the archive,
WinCommander told me, that the zip archive is corrupted.
Hope it helps, thanx guys for wonderfull MySQL.
Pavel
Hi,
I have a grand total of two very important but possibly humiliatingly daft
questions, that I hope some kind soul will patiently solve:
1. Can I run a mySQL server on a Linux computer, and query it through myODBC
running on a Windows computer?
2. The licensing info seems only relevant to
On Mon, 30 Sep 2002, Drulli B wrote:
Date: Mon, 30 Sep 2002 18:13:51 -
From: Drulli B [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Mixing Linux and Windows and paying for it
Hi,
I have a grand total of two very important but possibly humiliatingly daft
questions, that I hope
Ryan Fox wrote:
I think you mean asp2php. I don't know any reason that someone would
want to convert from php to asp. :)
Thanks for that; I'm sure the clarification would be obvious to anyone
reading the thread; my mind must have been fried from so much MFC
programming today ...
On Monday, September 30, 2002, at 04:34 24h, Stéphane Pinel wrote:
I've just installed MySQL on a MacOS X 10.2 system. Everything is OK
but I
can't find how I can login as a master to create users and give
privileges ?
Thanks.
With the server running you first need to give root a
I am a MySQL newbie and i am somewhat confused. Firstly did I make a mistake running
mysql_install_db and afterwards running the commands;
/usr/bin/mysqladmin -u root password 'new-password'
mysqladmin -u pazin1 sqlpass
and;
/usr/bin/mysqladmin -u root -h cords-orj86jfje password
I never actually looked into it. There are so many work arounds I need
to do in FileMaker that I just redesign the tables in MySQL.
If there isn't a FileMaker converter, I'm sure there is a DBF converter.
You can just save you FileMaker databases as DBF and then convert them.
On Monday,
JMichael
William R. Mussatto [EMAIL PROTECTED]
09/30/2002 02:23 PM
To: Drulli B [EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
Subject:Re: Mixing Linux and Windows and paying for it
On Mon, 30 Sep 2002, Drulli B wrote:
Date: Mon, 30 Sep 2002 18:13:51
I welcome the pedantics!
Multiple databases on multiple servers?
That is what I thought...which I assume means multiple machines (not an
option). And I'm glad you pointed it out that it still wouldn't solve
the problem.
Go re-read the section of the manual on string literals. Ask
yourself
Question are you want to take your data from Filemaker to Excel? Because
what I had to do was re-create the tables in MySQL then out putting the data
to cvs table. Making sure the data was divide by a command, then I use
mysqladmin or you can use phpMyAdmin import it into you MySQL.
If that what
CREATE TABLE Customers ( Name VARCHAR(100) );
Now ... if your customers have names in Japanese, Russian and German,
how do you compile MySQL so it can store them all in
Customers? You use
Unicode with a binary field and do post-processing work (like
ORDER BY)
yourself.
I have
Which DB type will provide the best performance? We're currently using
MyISAM, but I'm curious if switching to InnoDB will provide any performance
improvements.
Regards,
Brian Safford
EDS Messaging
Note: The following was added to get this posting through the spam
filters: sql query
Your webform application must call the appropriate mysql escape string
function for the language
in which it is written.
Dawn Friedland wrote:
CREATE TABLE Customers ( Name VARCHAR(100) );
Now ... if your customers have names in Japanese, Russian and German,
how do you compile MySQL so it
Hello all,
I am currently creating a table per hour for some data I have. Each table has
502 fields (yeah, I knownothing I can do about it, this is a very
special situation) and about 100,000 records.
A few hours worth of data creates a 2GB table, and I don't really want
to increase the
hi!
The application is a password-username-location-type store. The types are web,mysql,
and entries for different computers to I can see all usernames/passwords on certain
computers
I would like to make myIsam tables into innodb to provide foreign keys, but I have a
'missing link'
I
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 6:21 PM
To: Tewfic Kidess
Subject: Re: RE: date column
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you
William R. Mussatto [EMAIL PROTECTED]
On Mon, 30 Sep 2002, Drulli B wrote:
1. Can I run a mySQL server on a Linux computer, and query it through
myODBC
running on a Windows computer?
Why not query it directly on its std port? What language are you using?
Perl (including ISAPI version .plx)
I found a solution!!! ***Replace all backlashes with two backslashes.***
(The hex value of the backslash is 0x5c, see Joel Rees' previous emails
for an explanation on how multibyte Japanese characters contain the hex
value 0x5c and that MySQL uses that value as an escape character.)
VBscript
Brian Safford wrote:
Which DB type will provide the best performance? We're currently using
MyISAM, but I'm curious if switching to InnoDB will provide any performance
improvements.
Regards,
Brian Safford
EDS Messaging
Note: The following was added to get this posting through the spam
Greetings. I try to save 7MB large binary string to mysql blob field in the
latest mysql server. I use innodb tables. Error I receive from myodbc driver
says: Memory allocation error. Here is my.ini extract:
set-variable=max_allowed_packet=30M
set-variable=wait_timeout=10
set-variable =
On Mon, Sep 30, 2002 at 03:45:20PM -0400, Brian Safford wrote:
Which DB type will provide the best performance? We're currently
using MyISAM, but I'm curious if switching to InnoDB will provide
any performance improvements.
It depends.
There are cases when MyISAM is the clear winner and
Hi everyone,
I am just starting to work with MySql on MAC OS X.When i
installed mysql i got the following message :
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is
done with: /usr/local/bin/mysqladmin -u root -p password 'new-password'
/usr/local/bin/mysqladmin -u
Thanks to all who responded.
It seems that my problem was two fold.
1) I needed the my.cnf file in the root on C:/ for one.
2) I had install it the first time to my D drive. When I couldn't get it to
work I uninstalled and reinstalled it to the C: drive. For some reason, the
services command to
On Monday, September 30, 2002, at 03:03 24h, Palash Mohanlal Kasodhan
wrote:
Hi everyone,
I am just starting to work with MySql on MAC OS X.When i
installed mysql i got the following message :
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is
done with:
Is MySQL running?
Use Process Viewer to see if there is an entry for mysqld.
If not, I would ask if you issued the install_db command and then
started mysql.
Ted
On Monday, September 30, 2002, at 06:03 PM, Palash Mohanlal Kasodhan
wrote:
Hi everyone,
I am just starting to
What does your VB code look like?
Mike Hillyer
-Original Message-
From: Bruno Batarelo [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 3:42 PM
To: [EMAIL PROTECTED]
Subject: MySQL BLOB Visual Basic
Greetings. I try to save 7MB large binary string to mysql blob field in
On Monday 30 September 2002 10:13, Drulli B wrote:
Hi,
I have a grand total of two very important but possibly humiliatingly daft
questions, that I hope some kind soul will patiently solve:
1. Can I run a mySQL server on a Linux computer, and query it through
myODBC running on a Windows
On Monday, September 30, 2002, at 03:53 24h, Slava Imeshev wrote:
Hello All,
Could anyone help me with this issue? Is it
possible to create/drop database using mySQL
JDBC driver?
Yes.
--
Clayburn W. Juniel, III -- Effective Software Solutions
Phone: (602) 326-7707Mobile:
Multiple databases on multiple servers?
That is what I thought...which I assume means multiple machines (not an
option).
For future reference, MySQL can actually run multiple servers with
different configurations on a single machine in Linux. (*BSD and Mac OS
X, too, I think.) They are
I found a solution!!!
Hooray!
***Replace all backlashes with two backslashes.***
You probably want to consider whether you want to replace all quotes
with backslash-quote, as well. Backslashes in the English text would
only show up for something like file paths on MS OSses, but your
customer
the answer to your question is yes.
however, what you're considering is a complex
technical exercise while it's being set up. after
you get it going, it'll work like a charm, but your
technical people will need to know what they are
doing.
corereader is a ms. windows app and one of its
I have two tables
CREATE TABLE pid_segment (
id INT NOT NULL UNIQUE PRIMARY KEY,
msg TEXT)
TYPE=INNODB
CREATE TABLE hl7incom(
id INT NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY REFERENCES pid_segment
(id).
msg TEXT,
time TIMESTAMP NOT NULL)
TYPE=INNODB
There are few data stored in both tables.
On Mon, 2002-09-30 at 23:44, Gebhardt, Karsten wrote:
I have two tables
CREATE TABLE pid_segment (
id INT NOT NULL UNIQUE PRIMARY KEY,
msg TEXT)
TYPE=INNODB
CREATE TABLE hl7incom(
id INT NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY REFERENCES pid_segment
(id).
msg TEXT,
time TIMESTAMP
No way, I've already tried this.
I have two tables
CREATE TABLE pid_segment (
id INT NOT NULL UNIQUE PRIMARY KEY,
msg TEXT)
TYPE=INNODB
CREATE TABLE hl7incom(
id INT NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY REFERENCES pid_segment
(id).
msg TEXT,
time TIMESTAMP NOT NULL)
Just a suggestion:
SELECT hl7incom.id
FROM hl7incom, pid_segment
WHERE hl7incom.msg LIKE '%PID%'
AND not(pid_segment.id = hl7incom.id)
GROUP BY hl7incom.id;
Otherwise my only other suggestion would involve using the 'NOT IN'
logic, but I think that might be too convoluted for your needs.
Same result, also if I do not define unique index.
Just a suggestion:
SELECT hl7incom.id
FROM hl7incom, pid_segment
WHERE hl7incom.msg LIKE '%PID%'
AND not(pid_segment.id = hl7incom.id)
GROUP BY hl7incom.id;
Otherwise my only other suggestion would involve using the 'NOT IN'
logic, but I
Greetings..
Even the MySQLGui does not work for me. It is not getting downloaded. What
should I do ?
Insane
SQLyog ( http://www.webyog.com/sqlyog )
The Definative GUI for MySQL
- Original Message -
From: Pavel Hlouek [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 30,
85 matches
Mail list logo