I am a novice using MySql.
I would like to know if and what kind of problem may generate to using de
"test" database of MySql engine (creating tables and data into "test"
database", for example).
Thank You
Valerio Di Marino
VUDIEMME Software
www.vdmsoft.com
Monty,
Took your advice and downloaded
mysql-3.23.42-pc-linux-gnu-i686.tar.gz
Placed it in /usr/local
Renamed /usr/local/mysql to /usr/local/mysql-old
unpacked with
tar -zxvf mysql-3.23.42-pc-linux-gnu-i686.tar.gz
which made /usr/local/mysql-3.23.42-pc-linux-gnu-i686
I checked out the dir (
R Talbot wrote:
> Boyd Lynn Gerber wrote:
>
> > What version of Caldera are you running? I may be able to help next week.
> >
> > tt,
> >
> > --
> > Boyd Gerber <[EMAIL PROTECTED]>
> > ZENEZ 3748 Valley Forge Road, Magna Utah 84044
> > Office 801-250-0795 FAX 801-250-7975
>
> Hi...
> I am a
R Talbot wrote:
> Michael Widenius wrote:
>
> > Hi!
> >
> > > "R" == R Talbot <[EMAIL PROTECTED]> writes:
> >
> > R> Sasha Pachev wrote:
> > >> On Thursday 20 September 2001 20:37, R Talbot wrote:
> > >> > My problem is probably my lib-2.1.2.so and GNU Make v. 3.78.1
> > >> > being too old...
database,sql,query,table
What version of Caldera are you running? I may be able to help next week.
tt,
--
Boyd Gerber <[EMAIL PROTECTED]>
ZENEZ 3748 Valley Forge Road, Magna Utah 84044
Office 801-250-0795 FAX 801-250-7975
--
Hi!
> "R" == R Talbot <[EMAIL PROTECTED]> writes:
R> Sasha Pachev wrote:
>> On Thursday 20 September 2001 20:37, R Talbot wrote:
>> > My problem is probably my lib-2.1.2.so and GNU Make v. 3.78.1
>> > being too old but how muc trouble is it to upgrade.the LIB
>> > V. 3.23.40 is run
Sasha Pachev wrote:
> On Thursday 20 September 2001 20:37, R Talbot
wrote:
> > My problem is probably my lib-2.1.2.so and
GNU Make v. 3.78.1
> > being too old but how muc trouble is it
to upgrade.the LIB
> > V. 3.23.40 is running but with 12 failed
tests including bigint is
> > this an
Hi.
I was wondering if there was a way to find out when the last time the
database was modified? (like a last modified function for a webpage?).
Thanks for the help.
Regards,
Camilo Rostoker
--
+=+
Camilo Rostoker
[EMAIL PROTECTED]
http://
We are encountering two issues when using MySQL with large tables (by large,
we're talking > 1 million rows). Our application is written in Java and we
are using the mm.mysql JDBC driver. We run our applications using both
Oracle and MySQL. Below are issues that we have experienced.
1. The mm.
At 4:27 PM -0400 9/21/01, Jason Frisvold wrote:
>Currently I'm checking to see if a value exists in the database before
>deciding whether to update it or insert it. Would this be quicker to do if
>I merely used REPLACE? Is that the purpose of the REPLACE command? If it
>exists, just update it,
I'be been using phpMyAdmin and like it very much. Are there advantages to
using mysqlgui? Am interested in hearing from people who have tried both.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
I'm having a difficult time synchronizing my Master and Slave Servers.
I've been doing this using MySQL Binary Logs, where the Master rotates the
logs at 1 hour times, and the slave downloads it and imports it.
What happens why I try to pipe the binlog into mysql is that it reports and
error that
Hi,
I need some help in installing MySQL.I did the following things
1) Downloaded the mysql version 3.23.36-pc-linux-gnu-i686.tar.gz
2) tar -zxvf mysql-version
3) ln -s /usr/local/mysql-version mysql
4) adduser mysql
5) passwd mysql
6) chown -R mysql mysql-vesion mysql
7) chgrp -R root my
If I want to filter out records when SELECTing from a database, how do I do
it with an
and/or type of statement. Like this:
SELECT * FROM websites WHERE keywords LIKE '%akeyword%' AND/OR description
LIKE '%description%'
I want it to show most relevant (AND) then 2nd to most (OR). Please help.
Sasha Pachev wrote:
> On Thursday 20 September 2001 20:37, R Talbot wrote:
> > My problem is probably my lib-2.1.2.so and GNU Make v. 3.78.1
> > being too old but how muc trouble is it to upgrade.the LIB
> > V. 3.23.40 is running but with 12 failed tests including bigint is
> > this an i
Currently I'm checking to see if a value exists in the database before
deciding whether to update it or insert it. Would this be quicker to do if
I merely used REPLACE? Is that the purpose of the REPLACE command? If it
exists, just update it, and if it doesn't exist, insert it?
Thanks,
--
> -Original Message-
> From: Matthew Walker [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 21, 2001 9:48 PM
> To: 'Matthew Simpson'
> Cc: [EMAIL PROTECTED]
> Subject: RE: Dumb Question...
>
>
> How would I go about turning them off? Yes, I know. Another RTFM
> question, but some of
> Okay, I know this is an RTFM question, but I tried, and I couldn't find
> it in the online manual.
Try loading the manual, then do your browsers equivalent of
find in page, and search for "-bin" 3 or 4 searches on
next occurence, and you're there
>
> I was looking at the /var/lib/mysql directo
How would I go about turning them off? Yes, I know. Another RTFM
question, but some of these things are a little hard to find in the
online manual.
-Original Message-
From: Matthew Simpson [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 1:47 PM
To: Matthew Walker
Cc: [EMAIL P
Don't feel badly, I wondered the same thing!
In a nutshell, they are logs, and you can delete them. You can also turn
them off (I did).
- Original Message -
From: "Matthew Walker" <[EMAIL PROTECTED]>
To: "MySQL Mailling List" <[EMAIL PROTECTED]>
Sent: Friday, September 21, 2001 2:36 PM
That would explain it... I appreciate the prompt replies :)
Thanks!
sql
---
Jason H. Frisvold
Senior ATM Engineer
Engineering Dept.
Penteledata
CCNA Certified - CSCO10151622
[EMAIL PROTECTED]
---
"Only two things are infinite, the universe and hum
Also,
a simple fix for you sendmail guru's
HFrom: $>check_from
Scheck_from
[EMAIL PROTECTED] $#error $@ 5.5.5 $: "Broken MTA, Message
ignored"
Cheers.
Colin Faber wrote:
>
> As near as I can figure there are a few people out there that have yet
> to setup their MTA's correctly, so they th
Okay, I know this is an RTFM question, but I tried, and I couldn't find
it in the online manual.
I was looking at the /var/lib/mysql directory today, where all my
databases are, and I noticed a bunch of -bin files. What /are/
those, and are they something I need to be concerned about?
--
Matthew
As near as I can figure there are a few people out there that have yet
to setup their MTA's correctly, so they think they're receiving messages
for any addresses in the headers of the email.
Jason Frisvold wrote:
>
> Can anyone explain why I'm getting a "Mail account is disabled" message from
Jason Frisvold writes:
> Can anyone explain why I'm getting a "Mail account is disabled" message from
> [EMAIL PROTECTED] regarding anything I post to the mysql list?
Yep, that server uses some sort of broken software which
mistakes the sender for the receiver or does something
similarly braind
Can anyone explain why I'm getting a "Mail account is disabled" message from
[EMAIL PROTECTED] regarding anything I post to the mysql list?
The body of the message says :
The mail account ([EMAIL PROTECTED]) is currently disabled, and is not
receiving mail at this time.
Thanks,
--
Hi all..
Can anybody tell me how or where doc of tutor complete about WinMySqladmin and
MySqlManager?I have only activated WinMySqladmin and MySqlManager but nothing more
because i only had little information about these things. I used WinMySqladmin Versi
1.2 which distribution by Miguel A. Sol
Try this :
/usr/bin/mysqladmin -u root -p password '22'
The first instance of 'password' is a command.. It doesn't mean you need to
replace it with the password..
---
Jason H. Frisvold
Senior ATM Engineer
Engineering Dept.
Penteledata
CCNA Certified - CSCO10151622
[E
Just installed mssql and in the end of the installation I receive the
message taht now is the time to change root password for the db using
mysqladmin using the following synthax:
/usr/bin/mysqladmin -u root -p password 'new password'
So issued the following command:
/usr/bin/mysqladmin -u root -p
Rich,
I do recall that there was a mail program that was written in Perl that
utilized mySQL as the backend for storing the message. It was reviewed in
Linux Journal. I still have the CD on my desk but haven't had a chance to
install yet so I cannot give you a personal review, but the write ups i
Setup :
MySQL 3.23.42
Perl 5.6.0
DBI 10.32
I’m trying to do a few different queries where the table name needs to be
dynamic. I’ve tried the following :
$dbquery = $dbhandler->prepare_cached(“SELECT id, target FROM ? where
somedata=?”);
$dbquery->execute($tablename,$somedata);
But I keep gett
I'm a little fuzzy on this, but I seem to recall that a .forward file can
call a program (perl script?) of your choosing for each mail message. Or,
perhaps procmail can do this task?
Regards,
Rich
At 01:05 PM 9/21/01, Christopher Bergeron wrote:
>Does anyone know of any applications that inse
Hi!
I had a similar problem using gcc-3.0 on HP-UX-11.0.
...
configure:4198: gcc -E -D__STDC_EXT__ conftest.c >/dev/null 2>conftest.out
: warning: "__STDC_EXT__" redefined
: warning: this is the location of the previous definition
configure: failed program was:
#line 4193 "configure"
int main ()
From: jweage
To: [EMAIL PROTECTED]
Subject: compile fails under HP-UX 11.00 missing
CBREAK
>Description:
I've configured mysql with ./configure
--prefix=/usr/arch/mysql
--disable shared. Typing make produces the following
error:
rltty.c: In function `prepare_terminal_settings':
rltty.c:2
Does anyone know of any applications that insert email into mysql databases?
I can use either Windows or Linux as the client; however, I want mysql
server on the linux box (for stability). I don't like having all of my
email in MSOutlook's proprietary format because in 5 years when I need to
look
Keith Woodworth writes:
> I dont have a my.cnf but now need to relocate the database on the system,
> where does mysql get the environtment var's it uses to start by default?
It doesn't get them from env vars AFAIK, but you can change them at
compile time. Also, there are command-line parameter
Need to change locations of where mysql is storing all its database info.
When the system starts it initiates safe_mysqld and starts with the base
dir of /usr/var/local
I dont have a my.cnf but now need to relocate the database on the system,
where does mysql get the environtment var's it uses
> Can anyone out there provide GUI-Based table creation tools for mySQL?
> (something like Access)
>
Here is an ERD based tool with full support for MySQL. Versions for various platforms
including Linux and Windows
http://www.thekompany.com/products/dataarchitect/index.php3?dhtml_ok=1
Peter
Glad to hear this. I was already going that way with my site because I
didn't want to have to either drop and reload the database or take ther
mysql server down to run the cleanup utility. W/o blobs/text you can use
fixed length fields which means the database doesn't become fragmented.
On F
Dear friends,
I have downloaded following packages from mysql.com
MySQL-3.23.41-1.i386.rpm
when i tried to double click on it, it showed me
following error :
Application "gnomrpm-auth" (process 2624) has crashed
due to fatal error(Segmentation fault)
when i tried to install it from promp
Howabout
select record.* from record left join user on
user.account=record.account where user.username='george';
Since there is no table name "account"
>select record.* from record left join account on
>account.username=record.account where account.username='george'
>
> >SELECT account FROM use
Dear friends,
>My name is Jimi. I am working on a project that
> involves to store my data through c++ in mysql.
>
> when i tried to run my program that just tries to
> connect to mysql server, following error arrived :
>
> /usr/lib/mysql/libmysqlclient.so : undefined
> reference
> to '[EMA
Hi Kishore!
> I have mysql installed on a Linux server, I am trying to connect to the
> server using mysql client for windows, I get the following error
> "Host '192.121.2.115' is not allowed to connect to this MySQL server",
> any idea what permissions I need to change to be able to connect?
ht
JSaur,
>Hello Igbar,
>
>thank you for your script.
>Bud I need to change just word "with". Woman with hammer was just example.
>There is text about 1000 words in one fied, and I need to change just a
>short string.
>I show you another example.
>
>CREATE TABLE my_table(c1 int NOT NULL PRIMARY KEY,
Hi
I have a large genome database running on MySQL (Ver. 3.23) . I
would like to mirror it on a IBM DB2 (Ver 7.2) Server. Could someone
tell me if this could be done?
Regards,
Radhakrishnan Sundaresan.
Radhakrishnan Sundaresan
Graduate Research Assistant
Cluster I/O Labs, Ohio State Uni
Hi,
I have mysql installed on a Linux server, I am trying to connect to the
server using mysql client for windows, I get the following error
"Host '192.121.2.115' is not allowed to connect to this MySQL server",
any idea what permissions I need to change to be able to connect?
Thanks
-
Have a look at urSQL -- http://www.urbanresearch.com/ursql
On Fri, 21 Sep 2001, Calvin Chin wrote:
> Can anyone out there provide GUI-Based table creation tools for mySQL?
> (something like Access)
>
> Thank you.
>
> Regards,
> Calvin Chin
> [EMAIL PROTECTED]
> Ipmuda Berhad - Building materi
Can anyone please guide me in uninstalling MySQL...
P.S: i did a rpm -e but there was no mysql rpm package...
tia,
sandeep
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql
Preface #1: Hi MySQL Admin!
There's an oddity at http://www.mysql.com/doc/. Entering my.cnf returns no
hits. Entering cnf returns all relevant hits.
Preface #2: Hi All!
Folks, this is the *best* online documentation I have ever ever seen. You
can save youself lotsa time waiting for replies here
Hi,
We have MySQL 3.23.27 stalled and running on a Solaris 2.7 machine. We are
planning to move our server to AFS school system (OS version is Solaris 2.7
(Sparc)). The AFS version is 3.5 or 3.46.
Is anybody know whether MySQL 3.23.27 is compatible with AFS 3.5 3.46?
Have a nice day
Hello Tommy!
> We suspect that the problem is related to the fact that we delete ~7000
> rows and inserts the same shortly thereafter. The mysql-manual mentions
> that you should run an "optimize table" after deleting many rows from a
> table, but doesn't list it as an requirement.
If you're hav
Hello
I was wondering if it is possible (in a search result) to first get those
results where the search string matches exactly (whole word) and then those
who include the search string.
Example :
Searchstring : car
Exact match : car
then
Including the serachstring : incarnation
Lorang Jac
Hello,
I need to create a user ('x', for instance) that only has permission to
access (Select, insert, update, delete) only 2 tables in a database
('test').
Assuming that 'x' does not exist, I execute the folowing statments ('a' and
'b' are the tables whose access I want to grant to 'x'), conne
We've had problems for a few months with corruption of a MyISAM table,
when deleting many rows. The same setup/code didn't have problems under
3.22.x but started when we switched to 3.23.x - we're now running 3.23.40.
The table is used by a mod_perl application serving webpages running on
the
Hi, I'm the author of the JDBC driver. I'm not sure what the problem is, but
I am going to try and talk you out of storing multi-megabytes as blobs.
Here's whyIn most cases it is more overhead than it is worth. If you're
going to be serving the data from these blobs from some other type of ser
You must also be sure the mysql user has read, write, and execute
permissions in the nfs mounted directories.
Patrick Drouin wrote:
> Hello everyone,
>
> I have been running mysql for a little while now and my filesystem seems to
> get a little tight. I decided to setup a file server that woul
You coppied it as root, and mysql does not own it.
chown -R mysql /var/lib/mysql
Nandakumar wrote:
> Hi all,
> I am working on Redhatversion 6.2. I used Mysql version 3.22.xx
> before . I took the back up of all datas. I formatted my machine 2 weeks
> back. I installed mysql version 3.23
Hi!
On Sep 21, Jordan Elver wrote:
> Hi,
> Thanks for the advice. Looked on mysql.com for advice on REGEXP. Seems
> promising but I can't seem to find the right regexp (I hate them :-()
>
> I might just have to screen the words before I search like james suggested,
> does anyone know where I c
You _might_ also be able to do something like:
SELECT *
FROM news
WHERE newstype='1' AND global='1'
ORDER BY concat(if(depart='center', 'A', 'B'), SortNumber) ASC
I don't have quite enough info here, but I'm going to assume that you
want the records with depart='center' sorted f
On Thursday 20 September 2001 20:37, R Talbot wrote:
> My problem is probably my lib-2.1.2.so and GNU Make v. 3.78.1
> being too old but how muc trouble is it to upgrade.the LIB
> V. 3.23.40 is running but with 12 failed tests including bigint is
> this an install I want to develop with..
l> Hello,
l> I'm trying to do a mysql select statement like this:
l> SELECT * FROM news WHERE newstype = '1' AND global = '1' OR depart =
l> 'center' ORDER BY SortNumber ASC
l> But I would like the ORDER BY to list all records where depart = 'center'
l> first and then all the rest of the depart
Hello,
I'm trying to do a mysql select statement like this:
SELECT * FROM news WHERE newstype = '1' AND global = '1' OR depart =
'center' ORDER BY SortNumber ASC
But I would like the ORDER BY to list all records where depart = 'center'
first and then all the rest of the depart records in
alphab
Hi,
Thanks for the advice. Looked on mysql.com for advice on REGEXP. Seems
promising but I can't seem to find the right regexp (I hate them :-()
I might just have to screen the words before I search like james suggested,
does anyone know where I can get a list of commonly usd words! ;-)
Cheers
Hello everyone,
I have been running mysql for a little while now and my filesystem seems to
get a little tight. I decided to setup a file server that would provide one
of its disk to act as the mysql data drive.
Anyhow, the operation seemed to be quite simple:
1. Mount the new partition usin
Hi all,
I am working on Redhatversion 6.2. I used Mysql version 3.22.xx
before . I took the back up of all datas. I formatted my machine 2 weeks
back. I installed mysql version 3.23.33 using rpm file. Now i copied the
backedup datas to /var /lib/mysql directory.I can start the mysql daemon
select record.* from record left join account on
account.username=record.account where account.username='george'
>SELECT account FROM user where username = 'george';
>then using the result from this query,
>i pass it onto the next:
>
>SELECT * FROM record WHERE account = 'result from above';
>
>
Hi,
I have the following queries:
SELECT account FROM user where username = 'george';
then using the result from this query,
i pass it onto the next:
SELECT * FROM record WHERE account = 'result from above';
I am new to 'JOIN' and dont know the correct join syntax.
THANKS,
jaime
--
Hi,
I am facing some problem using MYSQL..When I am listing the records I am
getting the following error..
Microsoft Cursor Engine error '80004005'
The data provider or other service returned an E_FAIL status.
/keyknowledgev1.2/content/admin/productlist.asp, line 87
Line 87 Highlighted below
T
Dear sir,
Please help and drop me a email.([EMAIL PROTECTED])
I have Apache 1.3.17, MySQL 3.23.30 install on a Sparc Solaris 8 and Apache
1.3.20, MySQL 3.23.40 installed on a Interl RedHat Linux 7.1, I got
mod_auth_mysql-2.20 and following below instruction to compile and failed on
both platf
Hello
I was wondering if it is possible (in a search result) to first get those
results where the search string matches exactly (whole word) and then those
who include the search string.
Example :
Searchstring : car
Exact match : car
then
Including the serachstring : incarnation
Lorang Jac
Calvin Chin writes:
> Can anyone out there provide GUI-Based table creation tools for mySQL?
> (something like Access)
http://www.mysql.com/downloads/index.html
I use phpMyAdmin which is a neat web tool that works with most
browsers (requires frames and tables). You might be more
interested i
Can anyone out there provide GUI-Based table creation tools for mySQL?
(something like Access)
Thank you.
Regards,
Calvin Chin
[EMAIL PROTECTED]
Ipmuda Berhad - Building materials for tomorrow's world !
-
Before posting, ple
72 matches
Mail list logo
