Hi all
I am an oracle dba and will be shifting to mysql. I have the documentation(html)
downloaded with me and mysql on my PC (on linux) however I need to find out where
exactly I ll get the info related to mysql database administration? Is it as difficult
as oracle? The html downloaded is qui
:) Is this some sort of a joke?
I am grouping using event_id, which makes your query useless because it will
return just the first time row per each event_id.
Thanks anyway. I may have to use second query... :-(
Mihail
- Original Message -
From: "Bhavin Vyas" <[EMAIL PROTECTED]>
To:
Asma Aripin <[EMAIL PROTECTED]> writes:
> --
> I want to select 1 record from 200,000 rows of records. I use this SQL
> statement:
>
> SELECT password FROM TableUser WHERE username='jack00'
>
> It takes me about 20 seconds just to view the password.
>
> Is there any other way to decrea
Hi list
Did you make 'index' on your table?
make index like this:
CREATE INDEX index_name ON table_name(field_name);
i.e. CREATE INDEX username_index ON TableUser(username);
and you'll get result in 0.x seconds!
- Original Message -
From: "Asma Aripin" <[EMAIL PROTECTED]>
To: <[EMAIL
--
I want to select 1 record from 200,000 rows of records. I use this SQL
statement:
SELECT password FROM TableUser WHERE username='jack00'
It takes me about 20 seconds just to view the password.
Is there any other way to decrease the time? (In about less then 1 second)
--
T
At 08:34 PM 7/11/2002, you wrote:
> > Attn: mysql ,
> >
> > My name is Mr. Oluwafunmi G, the manager, credit
> > and foreign bills of Ecobank Plc. I am writing in
>
>Well, they're getting smart enough to vary the story line a bit now:
>
>http://www.google.com/search?hl=en&ie=ISO-8859-1&q=nigeria+m
I just downloaded the MySQL 3.23.51 rpms (currently running 3.23.47) and
noticed that they were significantly larger (14MB instead of 6MB for the
main package) and looked in the packages and noticed that the
executables in the 3.23.51 rpms are not stripped... I also noticed
that the strip progra
Hello all,
Can i make mysql to put enteries in two different machines
If there is an entry made in mysql in local machine, is there any options
so that the same entry is made in the remote machine mysql db
If there is any option pls. let me know
Thanx in advance
--
Regards,
Charitha
>Description:
I've coded a end-user login routine which connects, prepares a select query,
tests the column,
finishes, then, prepares an update query, sets a timeout variable, finishes,
and disconnects.
After the Db sequence, the routine prints(Perl5) HTML for the menu
(authority granted) or
re-p
William Miller <[EMAIL PROTECTED]> wrote:
> I am new to MySQL and I was trying to find out how to setup a record
> with a datatype as a image jpg etc...
I have recently done just that. Here is my table structure:
CREATE TABLE IF NOT EXISTS Item_binary (
entry int(11) NOT NULL,
vidx s
try 'show processlist' first to see what is actually running.
[EMAIL PROTECTED] wrote:
>
> Hello,
> I am running mysql on linux and I have too many mysqld-max processes running
> at the same time. Why is that and what can I do about it apart from killing
> the processes after every boot?
> Than
delz wrote:
> Hi All,
>
> How do I make calculations in php or mysql if the value has a comma like
> 2,000 + 32,000 = 34,000. I have a problem
> calculating if one of my values has a comma. It doesn't display the right
> output. I'll appreciate anyone who can
> help me with this.
>
> Thanks.
> Attn: mysql ,
>
> My name is Mr. Oluwafunmi G, the manager, credit
> and foreign bills of Ecobank Plc. I am writing in
Well, they're getting smart enough to vary the story line a bit now:
http://www.google.com/search?hl=en&ie=ISO-8859-1&q=nigeria+money+laundering+419
http://home.rica.net/alph
Im running windows 98, Apache 2.03, MySQL 3.23.51 and Php 4.0
I can user all mysql's functions using php to interact with the MySQL sever
but am having problems using the MySQL GUI. I can connect to the database
however when i try to use functions such as create database it comes back
with the
Yes, it is possible unless you insist on using an unimaginative, strict,
interpretation of what Info wrote.
Mechanism 1: Create a separate database server for each database. You
can create servers wherever you want.
Mechanism 2, which might not work, but might be worth a try: assuming a
si
I am trying to update my version and I am not getting. My current version is
3.23.49-nt. I am using MySql in Windows 2000.
When I try to install it happens the mistake -103:
An error occurred during the moves date process: -103
Component: servers
File group:
File:
thank you
--
How about:
SELECT
event_id, time,
count(DISTINCT time) AS Ranges
FROM
events
GROUP BY
event_id HAVING Ranges > 1
- Original Message -
From: "Mihail Manolov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 11, 2002 2:58 PM
Subject: Help - query sug
Matt,
I tried this and still no cigar. The only difference that I could see was
that the mysql.server file location was different, i.e.
/usr/local/share/mysql/mysql.server, mine exists in
/usr/share/mysql/mysql.server. I altered the script to reflect this but
still the process does not start. A
>Description:
i set up replication according to the directions in the manual. i have
repeatedly ensured that all the tables are synced up and the logs are
cleaned before restarting. it seems to work, but the slave is constantly
generating these errors:
020711 17:18:10 Error reading packet fro
On 11 Jul 2002, at 17:41, Witness wrote:
> SELECT DISTINCT affiliates.id, DISTINCT
> sales.client_id,SUM(sales.client_id)
> FROM affiliates,clients,sales
> WHERE affiliates.id = clients.affiliate_id AND sales.client_id =
> clients.id;
I don't think that's what Daren wanted. For one thing, I
Hi there,
I've just moved up from non-free os's to debian linux, and installed
a couple of database programs with the hope of getting started on some
projects I've been
thinking about. Several of these projects involve web archives. The
idea is, a url is entered with a bunch of bibliograph
They're threads. It's the way linux does threads. You only have 1
running.
[EMAIL PROTECTED] wrote:
> Hello,
> I am running mysql on linux and I have too many mysqld-max processes running
> at the same time. Why is that and what can I do about it apart from killing
> the processes after e
Greetings,
I am stuck with this problem:
I have the following table:
event_id time
1002000-10-23
1002000-10-23
1012000-10-24
1012000-10-25
I need to know all event_id's that have multiple times + time columns. Is it
possible to get that result in just one quer
Hello,
I am running mysql on linux and I have too many mysqld-max processes running
at the same time. Why is that and what can I do about it apart from killing
the processes after every boot?
Thanks in advance,
Balteo.
-
Befo
I am new to MySQL and I was trying to find out how to setup a record
with a datatype as a image jpg etc...
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.c
Hi.
I am trying to set up a mysql replication master servers in a circular
format in
different geographical locations (Los Angeles, New York, Chicago, and
Houston) but the client wants to keep working on the database and "catch up"
with the rest of the offices should there ever be a network proble
I don't think it's impossible. It might be nicer if you could use a
sub-select. But here's join.
SELECT DISTINCT affiliates.id, DISTINCT
sales.client_id,SUM(sales.client_id)
FROM affiliates,clients,sales
WHERE affiliates.id = clients.affiliate_id AND sales.client_id =
clients.id;
I have three tables, affiliates, clients, and sales.
The affiliates table stores all of the information about affiliates,
clients about clients, sales about sales. In the clients table, there is
a field for affiliate_id (affiliates refer clients), and in the sales
table there is a field for clien
Try the following:
safe_mysqld --user=mysql &
Also make sure that your data directory is readable and writeable by the
mysql user.
the socket file is generally just named mysql.sock and it would be in your
/tmp dir.
-Original Message-
From: Alex Jarvis [mailto:[EMAIL PROTECTED]]
Sent
Use adduser, or the appropriate command for your version of UNIX to
create the mysql account.
Alex Jarvis wrote:
> To summarize: I was getting a "cannot connect through
>socket..." error. It would appear that the server is not running and the
>socket doesn't exist. So I tried to start t
OOPS!
Bob Bell wrote:
>On Thu, Jul 11, 2002 at 08:32:28AM -0500, Gerald Clark
><[EMAIL PROTECTED]> wrote:
>
>>Naathan wrote:
>>
>>>I am getting the following error message like .
>>>
>>>" [TCX][MyODBC]Host is not allowed to connect this MySQL
>>>server "
>>>
>>>Kindly let me know how to connec
To summarize: I was getting a "cannot connect through
socket..." error. It would appear that the server is not running and the
socket doesn't exist. So I tried to start the server (as root) using
safe-mysqld & and mysql.server start, but in either case I recieve the
message:
chown: 'mys
On Thu, Jul 11, 2002 at 08:32:28AM -0500, Gerald Clark
<[EMAIL PROTECTED]> wrote:
> Naathan wrote:
> >I am getting the following error message like .
> >
> >" [TCX][MyODBC]Host is not allowed to connect this MySQL
> >server "
> >
> >Kindly let me know how to connect the MySQL database stored on
Hello All,
I'm having trouble with ordering. I've got data in a varchar field that
currently gets ordered like this when I use 'order by myfield asc':
aristo 1001
aristo 156
aristo 222
I'd like it to order like this:
aristo 156
aristo 222
aristo 1001
How can I do this in MySQL? Is there a w
Hi,
I have a MyISAM table which has a run_id which together with user_id forms
the
primary key for the table. run_id is not null and auto-increment. I delete
records from this table, and add new records. I want the run_id to keep
incrementing and not reuse values, but here is the actual behavior:
I have three tables, affiliates, clients, and sales.
The affiliates table stores all of the information about affiliates,
clients about clients, sales about sales. In the clients table, there is
a field for affiliate_id (affiliates refer clients), and in the sales
table there is a field for clien
[snip]
I am just wondering, how can i unsubscribe from this list. I am sure, i can
block this email address, but i would prefer to unsubscribe. anybody has the
instructions. I would really appreciate that
[/snip]
Uhlook at the message footer, where it says "To unsubscribe, e-mail
http://www.m
Here's a small script to use for automaticly starting the mysqld demaon. Cut and Past
it into a file and call it mysqld then save it in the /etc/rc.d/init.d directory. Upon
reboot you should see that you mysql server is up and running ( use ps -A as root and
look for the mysqld pid's). As for u
Just to clarify, I should always boot mysql using safe_mysqld, I thought
this was used only for setting up your initial database and setting the root
password. Most Documenation I found said to use it mysql.server as the
start up process..
Thanks for the Help!!!
DK
-Original Message-
Hi!
InnoDB is a MySQL table type which provides transactions, row level locking,
automatic crash recovery, foreign keys, and hot backup capability to MySQL.
InnoDB is included in all distributions of MySQL-4.0, not just in
MySQL-Max-4.0.
Since InnoDB in MySQL/InnoDB-4.0.1 was the same as InnoDB-
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 11, 2002 12:01 PM
To: Roma
Subject: Re: How do i unsubscribe from the mysql list
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass th
Most likely this will solve your problem. This comes right from the mysql website
documentation. It is for the C API but I'm sure the same concepts go for C++ as well.
If this doesn't work provide more info on the program you are using for coding and the
errors you are getting. Thanks.
http
Under redhat you can type setup and choose the services you want to
start during boot.
Justin Best
NOC - Infostations
On Thu, 2002-07-11 at 09:45, David Kramer wrote:
> I tried to automate the starting and stopping of the mysql service upon
> reboot. I created the two links for mysql.server to
On Thu, Jul 11, 2002 at 10:28:39AM -0700, daniel wrote:
>
> i'm just wondering why when i hit 'reply' to a message on this list,
> that it goes to the individual sender, and not the list itself.
> doesn't that defeat the purpose of a mailing list? aren't all
> responses to a post supposed to be t
In the last episode (Jul 11), daniel said:
> i'm just wondering why when i hit 'reply' to a message on this list,
> that it goes to the individual sender, and not the list itself.
> doesn't that defeat the purpose of a mailing list? aren't all
> responses to a post supposed to be threaded on the
I would use this query:
SELECT DISTINCT SUBSTRING(email,LOCATE('@', email) ) FROM AddressList ;
Cheers,
Kent
sql, query, y'hear
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://list
[snip]
PHP code:
$result = mysql_query("SELECT * FROM products WHERE sale_price IS NOT NULL
ORDER BY RAND() LIMIT 3") or die(mysql_error());
The error message is as follows:
You have an error in your SQL syntax near 'RAND() LIMIT 3' at line 1
[/snip]
Using;
$query = "select * from tblBAR WHERE
Got it on a none server machine I had typed my chown without the /P at
the end.
Also used the package from entropy. I may have used it before.
John
On Thursday, July 11, 2002, at 08:43 AM, A. John Peters wrote:
> New error msg, I think I have permissions right
>
> 020711 08:37:57 mysqld st
What causes this error when trying to replicate mysql server:
020711 10:50:50 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replication resumed in log 'jupiter-bin.001' at
position 1262
020711 10:50:50 Error reading packet from server: log event entry
exceeded max_allowed_packet - increa
You should be using 'safe_mysqld &' (v3.2) or 'mysqld_safe &' for v4.0.
Did you look at the .err file to see what the problem was?
This file should be in the same location as .pid file.
-Chait
-Original Message-
From: David Kramer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 11, 2
i'm just wondering why when i hit 'reply' to a message on this list, that it
goes to the individual sender, and not the list itself. doesn't that defeat
the purpose of a mailing list? aren't all responses to a post supposed to
be threaded on the list rather than stored in the original sender's m
> $id = mysql_query("SELECT * FROM products WHERE sale_price IS NOT NULL ORDER
> BY RAND() LIMIT 3",$link) or die(mysql_error());
PHP code:
$result = mysql_query("SELECT * FROM products WHERE sale_price IS NOT NULL
ORDER BY RAND() LIMIT 3") or die(mysql_error());
The error message is as follows:
What does your PHP code look like ? It might be a syntax problem inside PHP
-Message d'origine-
De : Jamie Tibbetts [mailto:[EMAIL PROTECTED]]
Envoye : jeudi 11 juillet 2002 18:22
A : [EMAIL PROTECTED]
Objet : ORDER BY RAND() not working
I'm running PHP 4.1.2 and MySQL 3.23.39. I ha
[snip]
I'm running PHP 4.1.2 and MySQL 3.23.39. I have a simple query that works if
I telnet into MySQL and run the query manually. If I try and use it in a PHP
page, I get the "Supplied argument is not a valid MySQL result resource"
error. However, if I take out the ORDER BY RAND() part from the
Thank-you Chuck, Ralf, Phil, Daniel, and Wouter. All your great advice worked,
and helped me device a method of attack. What I eventually did was edit the text
file itself, with vi, to add "delete from churchmail where email = '" to the
start of each line, and to add "';" to the end of each line,
first make sure there is a mysql.sock file in var/lib/mysql;
second make ps -ef | grep mysqld --if the output is xxx xxx xx grep mysqld
then the server is down for sure
third go to the binary of mysql and execute safe_mysqld & (means it forks
itself and is running in the background
four
I tried to automate the starting and stopping of the mysql service upon
reboot. I created the two links for mysql.server to the associated rc.d
directories(rc0.d and rc3.d). I rebooted my RH 7.2 box and nothing
happened. The real kicker is that I cant even manually start mysqld "mysqld
start".
Sure it is. It's just TRICKY. :)
step 1. Create database.
step 2. Move database to users' homedir
step 3. Symlink $USERHOME/databasedir/ to $MYSQLDATADIR
Alexander Barkov wrote:
> This is not possible.
>
> Info wrote:
>
>> sql,query
>>
>> How can i have each users database to be stored i
But the default table type is already MyISAM
> That is the normal behavior for ISAM type files.
> Convert them to MYISAM.
>
> Richard Fox wrote:
>
> >>Hi,
> >>
> >>I have a mysql table which has a run_id which together with user_id
forms
> >>
> >the
> >
> >>primary key for the table. run_id is no
I'm running PHP 4.1.2 and MySQL 3.23.39. I have a simple query that works if
I telnet into MySQL and run the query manually. If I try and use it in a PHP
page, I get the "Supplied argument is not a valid MySQL result resource"
error. However, if I take out the ORDER BY RAND() part from the query,
filter: sql, mysql, query *bites filter :-]*
Hi gang.
I have the following problem facing me: Currently, we are utilizing
mysql to handle our business data needs. To this end, we have lots of
customers who access their data through a web-based interface. That
accounts for probably around 2-
On Thu, 11 Jul 2002, Victoria Reznichenko wrote:
> robbat2,
> Thursday, July 11, 2002, 11:57:16 AM, you wrote:
>
> >>Description:
> r> The tokenizer is not behaving correctly with certain tokens relating to
>comments.
>
> r> Correct Behaviour:
> r> mysql> SELECT + /* foo */ 200;
It means you don't have enough privileges to access
'mysql' database. You can add these privileges using
"GRANT" command under user 'root' (or under another
superuser). Check manual, the section about privileges.
anjani.sinha wrote:
> Hi all,
>
> I am getting the error when trying to connect se
Hi!
First of all, MEDIUMBLOB type is case-sensitive.
I checked this sequence and everything worked as
expected. I think you have a mistake in your table.
What does "SHOW CREATE TABLE table" give?
Second, there is no needs to check that the value is already
presents using "SELECT" just to avo
This is not possible.
Info wrote:
> sql,query
>
> How can i have each users database to be stored in it's home dir ?
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists
Probably execution with "nice" will help.
Edwin Wang wrote:
> I want to find a way to limit how much of a system processor (cpu) the
> mysql server will use, so that I don't run the risk again of having
> googlebot or other web robots interrupt my other server operations in my
> computer.
>
> Th
a and b r not tables but views. i am using multiple views .
The sql for the views are as follows:
CREATE view cch_dubber_dublist_view_a1 as select distinct
a.playlist,a.material_id,a.destination_locator,a.destination,a.air_time,a.traffic_duration,a.comment,a.title,a.device_name,m.media_locator
MySQL,
This is a bug, isn't it?
mysql> select 798 between 75.2 and 999.1;
++
| 798 between 75.2 and 999.1 |
++
| 1 |
++
1 row in set (0.01 sec)
mysql> select 798 between 75.2 and 1e30;
+
Jan,
Thursday, July 11, 2002, 1:25:11 PM, you wrote:
JK> I am running MySQL 3.23.49 on Red Hat Linux 7.3 (installed from rpm included
JK> in RH distribution). I am using ext3 file system. In my my.cfg is
JK> "skip-locking".
JK> The system is Intel i810, Intel Celeron 433 MHz, 64 MB RAM. It is us
Wouter,
Thursday, July 11, 2002, 2:23:55 PM, you wrote:
WvV> * The mysql index and data files, can they be exchanged from a Windows
WvV> Platform to Linux? Need they be prepared in some way maybe?
In general you can just copy files and then check permissions. But
usage of mysqldump is more recom
Kevin,
Wednesday, July 10, 2002, 10:36:06 PM, you wrote:
KF> One of our servers (of many running the same software and mysql version) is
KF> frequently getting
KF> "ERROR 1030: Got error 127 from table handler"
KF> on two of its tables.
KF> mysql version is 3.23.49.
KF> We can not rec
robbat2,
Thursday, July 11, 2002, 11:57:16 AM, you wrote:
>>Description:
r> The tokenizer is not behaving correctly with certain tokens relating to
comments.
r> Correct Behaviour:
r> mysql> SELECT + /* foo */ 200;
r> ERROR 1064: You have an error in your SQL syntax near
Thomas,
Wednesday, July 10, 2002, 3:40:40 PM, you wrote:
TS> On Wed, 10 Jul 2002, Victoria Reznichenko wrote:
>> oliver,
>> Wednesday, July 10, 2002, 2:33:06 AM, you wrote:
>>
>> >>Description:
>> o> I was trying to find every row in a table which contains the umlaut
>> o> ü (ue
A.,
Thursday, July 11, 2002, 4:36:40 PM, you wrote:
AJP> I have installed mysql on OS X server. I used the pkg install.
AJP> Everything appears to have run fine except when I do safe_mysqld the
AJP> daed starts and stops. See error log below.
AJP> Any ideas?
AJP> 020701 19:46:50 mysqld sta
Hi all,
I am getting the error when trying to connect server from my client:
ERROR 1044: Access denied for user: '@NRICRIV1.ad.rivenet.com' to database
'mysql'
any answer?
thanks,
anjani
-
Before posting, please check:
h
You can go this link and get MySQL in package form it works great...
http://www.entropy.ch/software/MacOSx/mysql
Hope this helps.
Chuck Payne
Magi Design and Support
http://www.magidesign.com
-
Before posting, please check:
UmI don't think anyone (or hope noone) on this list is stupid
enough to get sucked in by a piece of spam.
--
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
On Thu, 11 Jul 2002 15:39:33 +0100
Kevin Passey <[EMAIL PROTECTED]> wrote:
> Do not give your b
Setup a user level my.cnf file and make sure the data dir isn't overriden by
the other levels of my.cnf
Just a theory, I haven't tested it !
-Original Message-
From: Info [mailto:[EMAIL PROTECTED]]
Sent: 11 July 2002 15:17
To: [EMAIL PROTECTED]
Subject: Re: creating database
sql,query
Hi everybody,
I've got a MEDIUMBLOB column in a table, where I want values to be unique. So
I made it UNIQUE.
When my program wants to enter a value, it first does a select * from table
where column =x in order to see if x already exists, if not, it does an
insert. Now the interesting point:
If
Do not give your bank details to anyone offering large amounts of money for
nothing.
What normally happens is that you give your details over - then you are
sucked dry - watch out.
Regards
Watch out mysql list
-
Before posting
A. John Peters wrote:
> New error msg, I think I have permissions right
No you don't.
Mysql must own the database directories and files.
>
>
> 020711 08:37:57 mysqld started
> 020711 8:37:57 /usr/libexec/mysqld: Can't create/write to file
> '/usr/var/e-mac
> .pid' (Errcode: 13)
> 020711
As i selling web hosting with mysql as a package, and i like to restrict on
the amount of space used. I had setup quotas on the plans. How can i create
databases to the user's account, home dir, so that the customer can check
his quota.
Or how should i go about restricting?
sql,query
-
On Thursday 11 July 2002 04:20 am, Iago Sineiro wrote:
I vote for Reiserfs personally. I've been running it for a year, its totally
stable, and reasonably fast. ext3 is OK as well, but its slower and at least
in theory does not provide an absolutely guaranteed consistent file system
100% of th
sql,query
How can i have each users database to be stored in it's home dir ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Dear MySQL user,
During 2002, MySQL AB will release two levels of official MySQL
certification: MySQL Core Certification and MySQL Professional
Certification. This e-mail describes the upcoming program as
well as some of your opportunities.
Contents
1. The MySQL Certification Progr
This opens so many possibilities ... manage MySQL tables in MS Access using
MyODBC. Guess this works for remote MySQL servers too?. Almost don't dare to
ask, but is this also possible from PostgreSQL? I'm in two situations with
alike problems, one using MySQL and the other one PostgreSQL .. I'll s
Attn: mysql ,
My name is Mr. Oluwafunmi G, the manager, credit
and foreign bills of Ecobank Plc. I am writing in
respect of a foreign customer of my bank with account
number 14-255-2004/utb/t who perished in a plane crash
[Korean Air Flight 801] with the whole passengers
aboard on August 6, 1997.
Bhavin,
I am using distinct all 15 fields and order by all 15 fields, but there is
different order on 15 fields for distinct and order by.
Thanks
At 08:24 PM 7/10/2002 -0700, Bhavin Vyas wrote:
>Via mysql, you are trying to do a distinct 'field1'. So any field1
>duplicates will be removed. Wher
I need to use the C++ API for mysql under a Linux system.
I compiled the tarball downloaded from mysql.com/Downloads but
I get several errors during compilation of C++ code.
Can anyone supply some information.
Thanks.
-
Before
New error msg, I think I have permissions right
020711 08:37:57 mysqld started
020711 8:37:57 /usr/libexec/mysqld: Can't create/write to file
'/usr/var/e-mac
.pid' (Errcode: 13)
020711 8:37:57 /usr/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno
: 13)
020711 8:37:57 /usr/libe
Dough! They started behaving like big corporations
already; certification, consulting, etc, etc.
:-)
--- "Defryn, Guy" <[EMAIL PROTECTED]> wrote:
>
>
>
> I was wondering if anybody heard about a possible
> release of books that help you prepare for the Mysql
> certification?
>
> Cheers
>
>
-
I have installed mysql on OS X server. I used the pkg install.
Everything appears to have run fine except when I do safe_mysqld the
daed starts and stops. See error log below.
Any ideas?
020701 19:46:50 mysqld started
020701 19:46:50 /Library/mySQL/libexec/mysqld: Table 'mysql.host'
doesn
Naathan wrote:
>Hello,
>
>Greetings!
>
>I am trying hard to connect to MySQL database stored on Linux machine
>through a
>VB program running on windows on another machine.
>
>My problems are ..
>
>Problem No1:
>
>My Windows machine is under a Windows NT domain.
>Linux machine is under another W
No1.
Sounds like a permission problem. Make sure that you
have that domain in the list of computer allowed to
connect to MySQL. Refer to MySQL manual to get more
information about this.
No2.
PC based application won't run on Linux unless you run
them under an PC-emulator which I don't even know i
No, those are termcap database entries.
Configure is looking for libtermcap or libterminfo int .the /lib directory.
If you are running RedHat Linux you need to install the ncurses rpm.
David Johnston wrote:
>When running ./configure I am getting the error no termcap libraries but in
>/usr/lib/te
[EMAIL PROTECTED] wrote:
>Not surprisingly, I'm still confused. Could you hold my hand?
>
>Here's what I've got --
>
>This is my table --
>
>CREATE TABLE churchmail (
> email varchar(30) NOT NULL
>);
>
>It has one field containing 40,000 email addresses.
>
>I have a text file -- remove.txt, w
Hello All,
I m using linux and gcc complier.
Myodbc driver and itz APIs working fine in my
application to manipulate the database.
I m having one problem.
First i run query Select id...from ...
then I use SQLBindCol to bind the columns after that i
use SQLFetch to fetch the rowset.
then i
On Thu, 2002-07-11 at 06:47, [EMAIL PROTECTED] wrote:
> Hello MySQL list,
>
> I have set up a master-slave replication and am reading the following in the
> .err file of the slave:
>
> Error reading packet from server (server_errno=1159)
>
> Where can I find a list of server_errno's and th
> * I was wondering, is there some application for Windows that gives a
> frontend to MySQL similar to MS Access? Or maybe connect from
> access to
> MySQL ? (guess not, right?)
You *can* use MS Access. The MySQL server can be on Windows or Linux or
anywhere you like. You'll need an ODBC driver -
I've been handed a 'data.seq' file containing a really useful database.
This is currently hosted on my future employer's site using Oracle. I wish
to look up some of the data there and pull it into my Filemaker database.
I'm using Filemaker for historical reasons and plan to move to MySQL in a
fe
1 - 100 of 117 matches
Mail list logo
