mysql> insert into table1 select distinct field1 , MIN(field2) from table2
where field2 >="2001-12-01 00:00:00" group by field2 ;
ERROR 1114: The table 'SQLb73d_0' is full
mysql>
please help to fix this error
-
Before posti
Rick,
The error suggests that libmysqlclient is not in /usr/local/lib/mysql.
the -L must refer to the directory containing libmysqlclient.a for the
compile to succeed.
John Lodge
-Original Message-
From: Rick Runowski [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 18, 2002 11:18 PM
T
Hi,
On Tue, 2002-02-19 at 16:25, S Aravind wrote:
> My company has developed a project using Java and
> Oracle. The client for whom the project has been
> developed wants mySQL. As a member of the team, I've
> been asked to find out the basic differences between
> Oracle SQL queries and your mySQ
mysql> insert into table1 select distinct field1 , MIN(field2) from table2
where field2 >="2001-12-01 00:00:00" group by field2 ;
ERROR 1114: The table 'SQLb73d_0' is full
mysql>
please help to fix this error
Name : Mohamed Abd El-Samei Mohamed
Title : System Administrator
Comp. : Soficom Co
For reasons of the end-arounds you note it really has to be in the
server. As mentioned views are a possibility, but could end up being
just as messy as a middle tier. It sounds like what you want is
integrated (with the OS) security (as in MS SQL); I don't know if this
is on the plate, but I'm su
By chance, is it at all possible to exceed the 4.2GB file size barrier on
Solaris 8 with MySQL 3.23.47? I've got one built with both GCC and another
one with the Solaris Workshop 6 compiler.. Neither can exceed that magical
number for some reason.. Both were built with large-files enabled.. In fa
you can find a list of what MySQL does not yet support in the table near
the bottom of this page:
http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.h
tml#Comparisons
Note that the latest stable/release version of MySQL is 3.x. Oracle is
going to support a lot more of the SQL
Triggers are evil incarnate, and notoriously har to debug. Skip triggers
entirely and use a stored procedure to do everything you need the
trigger to do (again, when SP's are available :\ )
greg
> -Original Message-
> From: Carsten Gehling [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, Feb
Hi!
My company has developed a project using Java and
Oracle. The client for whom the project has been
developed wants mySQL. As a member of the team, I've
been asked to find out the basic differences between
Oracle SQL queries and your mySQL queries. I tried my
level best on all search engines,
Hai,
MySQL server gets shutdown after 8hrs if not accessed.
I added a variable in the my.cnf file which increases this default setting.
set-variable=wait_timeout=86400 --for 24 hrs
Even then the server is getting disconnected after 8hrs of non usage.
What might be the problem do I need to ad
hi,
I'm wondering if anyone knows if it's possible to do a double-outer join in
mysql. by that I mean outer-joining on two tables instead of one (both from
the same original table). in other words, whereas a normal outer join might
go something like this:
select b.date, u.name from billing b
Hai,
MySQL server gets shutdown after 8hrs of non usage.
I added a variable in the my.cnf file which increases this default setting.
set-variable=wait_timeout=86400 --for 24 hrs
Even though the server is getting disconnected after 8hrs of non usage.
What might be the problem do i need add any anot
Hi all,
How can i acheive 'Triggers' in MySQL. or equivalent to 'Triggers'.
Regards,
sreedhar
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arc
From: "sreedhar" <[EMAIL PROTECTED]>
Sent: Saturday, February 16, 2002 6:03 AM
> How can i acheive 'Triggers' in MySQL. or equivalent to 'Triggers'.
By sitting tight and waiting, just like the rest of us :-)
http://www.mysql.com/doc/N/u/Nutshell_4.1_development_release.html
- Carsten
Hi all,
How can i acheive 'Triggers' in MySQL. or equivalent to 'Triggers'.
Regards,
sreedhar
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arc
On Mon, 2002-02-18 at 21:40, [EMAIL PROTECTED] wrote:
> I'm wondering about row level privilages - being able to restrict what
> people see and can update etc on a row level as well as a column/table
> level.
> So, anyone got any ideas about how you'd best go about this? Will
> triggers/ stor
Hi all,
I'm wondering about row level privilages - being able to restrict what
people see and can update etc on a row level as well as a column/table
level.
I know that I can implement it in my program (which is what I'm currently
doing) but unless it's in the backend db then every program tha
Hello,
I am very interested in mySQL but I haven't been able to download it:
--> The download wndow said 11.9 Mbytes received, but the file is on;ly 3.8
MByte. It happened from 4 download sites.
--> Any idea/suggestion about this ?
THANKS !,
Hernan
_
Anyone know what causes "overhead" on a MySQL table?
I wrote a JSP application using MySQL that uses updates and Inserts and have
found that a lot of "overhead" exists.
Of course if the table is optimized - the overhead is cleared.
Anyone had similar issues?
Thanks
Mark
-
In Faxing from MySQL, <[EMAIL PROTECTED]> wrote:
>
>Hi there. Anybody know how I can fax using MySQL? I might have an
>application for this.
Pretty simple problem for the APIs, you would probably spend longer on
a web search for a software package then writing it. Of course, one
can spice it u
Hi, all MySQL team
Here is another question.
I want to get individual MySQL instance's variable(like datadir, tmpdir etc)
using C API. Is there any function can do this?
I know that use mysqladmin and use query "show variables"
can do this.
Thanks and regards
Robert Li
Computer Associates
R
Hi,
> -Original Message-
> From: Massimo Colurcio [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 18, 2002 6:19 PM
> To: [EMAIL PROTECTED]
> Subject: GetDefaultConnect
>
>
> Hi, I'm having some problems using MySQL ODBC Driver release
> 3.51. When I try to call GetDefaultConnect()
At 13:13 +1100 2/19/02, Li, Robert wrote:
>Hi, all
>As we know, we can backup all dbs in one instance
>using "mysqldump --alldatabases > all_db.sql",
>so can we restore all of these dbs from "all_db.sql" in one time?
>Mysql client program "mysql" can only restore one database
>per time---mysql s
Hi, I'm having some problems using MySQL ODBC Driver release 3.51. When I try to call
GetDefaultConnect() from an
opened CRecordset object (Viual C++ 5.0, MFC), I see a 'weird' behaviour of the
driver; the return string is:
ODBC;WeissDBMySQL ODBC 3.51
Driver;DESC=;DATABASE=WeissDB;SERVER=lova
Hi, I'm having some problems using MySQL ODBC Driver release 3.51. When I try to call
GetDefaultConnect() from an
opened CRecordset object (Viual C++ 5.0, MFC), I see a 'weird' behaviour of the
driver; the return string is:
ODBC;WeissDBMySQL ODBC 3.51
Driver;DESC=;DATABASE=WeissDB;SERVER=lova
Hi, all
As we know, we can backup all dbs in one instance
using "mysqldump --alldatabases > all_db.sql",
so can we restore all of these dbs from "all_db.sql" in one time?
Mysql client program "mysql" can only restore one database
per time---mysql sample_db < sample_db.sql.
Thanks in advance.
Hello everyone,
First let me apologize if this is a taboo topic. I have been unsubbed
from this list for a while, so I may be out of sync with convention. If
I should take this question elsewhere, please show me the door.
I'm interested in learning more about XML as a format for transporting
Hi.
On Tue, Feb 19, 2002 at 04:15:36AM +0300, [EMAIL PROTECTED] wrote:
>
> I am a total MySQL newbie using MySQL 3.22.32.
[...]
> create table temp1
> -> select field_x
> -> from MyData;
>
> But, I get a syntax error (ERROR 1064) on line 2.
>
> Would somebody please point me at the ri
Hi,
I am a total MySQL newbie using MySQL 3.22.32.
I am trying to simultaneously create
a table and insert some data into it as follows:
create table temp1
-> select field_x
-> from MyData;
But, I get a syntax error (ERROR 1064) on line 2.
Would somebody please point me at the right
>Description:
MysQL 3.23.48 works fine, but after upgrade to 3.23.49:
Fatal error: Can't change to run as user 'mysql' ; Please check that the user
exists!
>How-To-Repeat:
Upgade from 3.23.48 to 3.23.49
>Fix:
Downgrade to 3.23.48
>Release: mysql-3.23.48
> -Original Message-
> From: BD [mailto:[EMAIL PROTECTED]]
> Sent: 18 February 2002 21:31
> To: [EMAIL PROTECTED]
> Subject: Security concerns on webserver with PHP & InnoDB
>
>
> I'm creating a web application with MySQL, PHP, InnoDB and I need to know
> whether I should split the one l
Dear Sir/Madam,
I install mysql on my computer but it did not work. after installing the
rpms, I use gnorpm to verify the installtion, and it's OK. but I couldn't
start my server, after I ran "mysql_install_db" and "safe_mysqld &"
commands. I list the relevant information and I use the "mysqlbug"
[EMAIL PROTECTED] wrote:
> Good, Free Mac GUI to mySQL?
The only free GUI client for mySQL for the Mac that I know of would be
CocoaSQL: http://homepage.mac.com/mxcantor/ which is only for Mac OS X.
I have not used it so I can not tell if it is any good or not but it is
open source.
There are m
All,
I am having difficulty compiling a piece of software. If I try compiling
with the following:
gcc dnd.cpp -o dnd3 -L /usr/local/lib/mysql -lmysqlclient
as suggested in "Core MySQL by Leon Atkinson" on page 436, I get the
error:
/usr/bin/ld: cannot find -lmysqlclient
collect2: ld returne
the libmysqld api is part of the 4.x development branch at the moment,
I suggest checking that out.
If you're interested in the development branch I suggest hopping on to
the internals list.
Rodney Broom wrote:
>
> From: Colin Faber <[EMAIL PROTECTED]>
>
> > With the up and coming libmysqld l
From: Colin Faber <[EMAIL PROTECTED]>
> With the up and coming libmysqld library this should be possible;
"libmysqld"? Sounds interesting, do you have an URL?
> Though I don't really see any advantages to this given the front end
> interface we have now (DBD::mysql) works like a charm.
As a
With the up and coming libmysqld library this should be possible;
assuming you want to sit down and take the time to write a module to
interface it.
Though I don't really see any advantages to this given the front end
interface we have now (DBD::mysql) works like a charm.
Regarding procedures, T
you may wish to post this to the DBI mailing list: [EMAIL PROTECTED]
>>On Mon, 18 Feb 2002 15:43:59 -0700, "Rodney Broom" <[EMAIL PROTECTED]> wrote:
>>Has anybody ever talked seriously about a Perl API for MySQL? I'd like to be able to
>access all phases of the MySQL deamon with Perl in muc
I am reading the documentation about the binary log, in particular
binlog-do-db=database_name
binlog-ignore-db=database_name
(a) Can these be specified in the my.cnf file?
(b) Can multiple databases be specified, either as a list or via multiple entries in
the
configuration?
We're running my
Has anybody ever talked seriously about a Perl API for MySQL? I'd like to be able to
access all phases of the MySQL deamon with Perl in much the same way we access Apache
via mod_perl. Things like:
- Query rewrite
- Data manipulation, pre-storage
- Data manipulation, post-query
- Prodedures
>Description:
If I follow the instuction in chapter 2.2.7 and chown/chgrep the
symbolic link we just made to unpacked source then mysql will not start
However if I use the same procedure on the source tree mysql-VERSION
it starts without problems.
I'm using
At 04:09 PM 2/18/02, Chris Boget wrote:
> > I couldn't find anything like this in my MySQL book or in the on line help.
>
>Could this be what you are looking for?
>
>http://www.mysql.com/doc/E/X/EXPLAIN.html
>
>Not sure exactly what you need to know...
>
>Chris
Sorry if I wasn't clear.
I've read
We are trying to install MySQL on a Windows 2000 Server, getting 'error
1058' when he tries to start the service.
The MySQL version is 3.23.47-nt. The MySQL drive is F:, and c:\my.cnf is:
[mysqld]
port=3306
big-tables
skip-locking
set-variable = key_buffer=
> I couldn't find anything like this in my MySQL book or in the on line help.
Could this be what you are looking for?
http://www.mysql.com/doc/E/X/EXPLAIN.html
Not sure exactly what you need to know...
Chris
-
Before posting
I'm working on a routine and was optimizing queries for it when I ran
across something I have never seen EXPLAIN return before.
Can somebody tell me what it means when EXPLAIN returns:
"Select tables optimized away"
If it helps, here is the simple query I was testing.
EXPLAIN SELECT COUNT(updat
http://www.linuxmonsters.com
sorry about that
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 18, 2002 3:41 PM
To: 'Brian P. Austin'
Cc: mysql
Subject: RE: RPMS for Development Branch
and the URL is???
it's not www.codemonsters.net; I just checked
and the URL is???
it's not www.codemonsters.net; I just checked
-Original Message-
From: Brian P. Austin [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 18, 2002 3:20 PM
To: [EMAIL PROTECTED]
Cc: mysql
Subject: RPMS for Development Branch
Hello all,
I have finished setting up a web
I'm creating a web application with MySQL, PHP, InnoDB and I need to know
whether I should split the one large table into 3 different tables with
different user privileges defined on each table.
As it stands now, the user logs in by entering a username & pw and this is
checked against a member
Hello all,
I have finished setting up a web page that contains RPMS for the Development
Branch of MySQL-4.0.
These RPMS are compiled every night at 11:00 p.m. CST and are posted to the
site at 12:00 a.m. CST.
They are built on a standard RedHat 6.2 install. You must use RPM version 4
to instal
Hi.
On Sun, Feb 17, 2002 at 09:10:24AM -0700, [EMAIL PROTECTED] wrote:
> Since my first posting of this came out all screwed up,
>
> I currently have a PHP script performing the following query:
> mysql_query("SELECT * FROM Stuff WHERE Release LIKE \"%$var2%\"",$var1)
>
> It works great except
Hello all.
I downloaded the mysql v4.0.1 source and openssl 0.9.6c source.
I built openssl OK
I built mysql as follows:
./configure --with-vio --with-openssl
make
make install
The build went well all the way.
The mysql server seem to start ok. When I try to connect with mysql
client after a fe
>Description:
--without-bench does not seems to work, at least not for me, a minor thing
but...
>How-To-Repeat:
I use this to compile mysql:
./configure --prefix=/usr
--with-mysqld-user=mysql \
--with-unix-socket-path=/var/run/mysql/mysql.sock \
Hi.
On Sat, Feb 16, 2002 at 01:46:34PM -, [EMAIL PROTECTED] wrote:
> Hi,
>
[...]
> All is fine except for one query which contains a sub select so therefore
> will not work.
[...]
How to handle missing sub-selects is explained here:
http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
>
Have a Redhat 7.2 system. Trying to install MySQL 4.0.1 version of the
server and client rpms via the KDE package manager. Am getting a dependency
failure but it does not indicate which package, library etc. that I am
missing. Any one have a suggestion?
_
>Description:
I've installed mysql on my trustix system. Trustix 1.5
comes with mysql 3.23.47. I installed it after the system
was installed using the rpms.
rpm -hivv mysql-3.23.47-1tr.i586.rpm
At the end of the installation I get this:
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER
Hi.
On Sat, Feb 16, 2002 at 09:52:18AM -0800, [EMAIL PROTECTED] wrote:
> Thank you for your response.
> Sorry, about the incompleteness. I'll try to fill in some of the blanks.
Okay, let's see.
> Benjamin Pflugmann wrote:
[...]
> Yes, this is correct shifts is a is exactly like a did show
On Monday 18 February 2002 13:05, Dan Nelson wrote:
> In the last episode (Feb 18), Marcelo Iturbe said:
> > Hello,
> > Currently I have an aplication which stores the information in an MsSQL
> > database in a straight forward manner, "insert into blah blah"
> >
> > However, I retrieve the informa
On Mon, Feb 18, 2002 at 01:52:41PM -0600, Melvin wrote:
> Hi:
> I'm trying to create an image database of about 130,000 records. Right
> now I have only the filenames in a CHAR Field (the records are of fixed
> size). I read those images a lot. Is it better to leave it this way or to
> move
> I am using a Gigabyte GA7DXR board with an onboard raid controller Ultra
> 100 from Promise. Now I would like to connect some old 15 GB disks to
> this controller. 2 or 4 disks are possible. On the raid I would like to
> have a mysql database with around 5 GB. The system should operate under
> l
RDBMS Is not a Fax machine
use middleware to do this.
Rich Fortnum wrote:
>
> Hi there. Anybody know how I can fax using MySQL? I might have an
> application for this.
>
> I would suspect third party software to reach in, generate reports, then fax
> out.
>
> Cheers.
>
> @@@ Rich Fortnum
Hi:
I'm trying to create an image database of about 130,000 records. Right
now I have only the filenames in a CHAR Field (the records are of fixed
size). I read those images a lot. Is it better to leave it this way or to
move all the image data to a blob fields?
I already tried to use
Hi there. Anybody know how I can fax using MySQL? I might have an
application for this.
I would suspect third party software to reach in, generate reports, then fax
out.
Cheers.
@@@ Rich Fortnum / Viaduct Productions / Toronto (EST)
@@@ Web Design / Databases / Internet Video / Wireless Dat
GRANT
. TO @'' IDENTIFIED BY ' ;
. = *.* will give access to everything, .* will
give access to all in that database, of course if you specify
then it will appear in the db table of the mysql database. If you specify
it will show in tables_priv.
Note: On occasion I took notice that if I set
Mikel King chortled:
> Hi Rich,
>
> Just so I understand you correctly;
>
> 1. Are you trying to use the replication features of MySql for
> this communication?
>
> Or
>
> 2. Are you talking on the client side application, like PHP,
> Java, Perl...?
>
> How about encrypting
On Mon, 18 Feb 2002, Rick Emery wrote:
> CREATE TABLE newtable SELECT * FROM oldtable LIMIT 0;
Will that create indexes in newtable that were in oldtable? Also, you'd
have to do that for each table.
Depending on exactly what you want to do, another option would be to use
mysqldump -d old_
CREATE TABLE newtable SELECT * FROM oldtable LIMIT 0;
-Original Message-
From: Todd Ellner [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 18, 2002 12:58 PM
To: [EMAIL PROTECTED]
Subject: sql: Copying the structure of DBs
I need to create multiple databases from time to time. This is
I need to create multiple databases from time to time. This isn't a problem.
The thing that seems tricky is creating databases with the same table names
and structures, but none of the data, of old ones. I thought chapter 4 of
the documentation covered this, but it doesn't quite seem to. Any
sugge
Hello,
I am using a Gigabyte GA7DXR board with an onboard raid controller Ultra
100 from Promise. Now I would like to connect some old 15 GB disks to
this controller. 2 or 4 disks are possible. On the raid I would like to
have a mysql database with around 5 GB. The system should operate under
lin
mysqlhotcopy uses the DBI to connect to the mysql database, Perl's API for
accessing the database.
>>On Mon, 18 Feb 2002 18:44:24 +0100, [EMAIL PROTECTED] wrote:
>>I'm trying to run mysqlhotcopy for the first time. I get an error that looks
>>like this
>>
>>$ ./mysqlhotcopy X /opt/my
Robert La Ferla wrote:
> /usr/include/bits/mathinline.h: In function `float log1pf (float)':
> /usr/include/bits/mathinline.h:540: Internal error: Segmentation fault.
> Please submit a full bug report.
> See http://bugzilla.redhat.com/bugzilla/> for instructions.
So? Do what that says: go to ht
In the last episode (Feb 18), Marcelo Iturbe said:
> Hello,
> Currently I have an aplication which stores the information in an MsSQL
> database in a straight forward manner, "insert into blah blah"
>
> However, I retrieve the information in XML format using the FOR XML EXPLICIT
> statements that
Hi,
I'm having some trouble with MySQL and Vb. I'm doing an app with a Do
While and I open / close a Recordset in this Do While. I think that
it's the problem... When I start the Program, after 30 seconds in the
Do While, I get this error : "Can't connect to MySQL Server ON
192.168.1.34". Doe
Hello,
I'm trying to run mysqlhotcopy for the first time. I get an error that looks
like this
$ ./mysqlhotcopy X /opt/mysql-3.23.32-sun-solaris2.7-sparc/backup
Can't locate DBI.pm in @INC (@INC contains:
/usr/local/lib/perl5/5.00503/sun4-solaris /usr/local/lib/perl5/5.00503
/usr/local/li
Hi!
First, please don't email things directly to me or to the announce
list. The best way to get help for a problem, is to write an email
only to [EMAIL PROTECTED]; In the future, please also change the
subject line to something that is appropriate and don't respond to an
email that has nothin
(for filter: query,sql,mysql,table)
I've done this a few times, I mostly do category systems and there
is no reason to list all the categories at one time, so I usually
have a "parent id" to work with in order to get all the sub
categoreis from the DB. However, I have done one where I did want
so
"Ireneusz Piasecki" <[EMAIL PROTECTED]> writes:
> Hi.
> I want upgrade mysql from 3.23.48 to 3.23.49 but i see that.
>
> first. shared
> ># /usr/lib/mc/extfs/rpm run /home/httpd/MySQL-shared-3.23.49-1.i386.rpm
> UPGRADE
> Upgrading "/home/httpd/MySQL-shared-3.23.49-1.i386.rpm"
> error: failed de
Hi,
A simple way is to make a recursive search by starting from the root,
and collecting all ID's from each layer. You need only one query per
layer, not one per node.
It looks like this :
-> start from the desired "directory" :
SELECT * FROM table WHERE id_parent IN (8)
-> say it returns chil
Hi all,
I'm currently trying to construct a query in Access that references to a
temporary table I'm creating and populating on the fly.
All is going well until I try to create the query. Although I'm opening the
connection to the table etc Access is claiming not to recognise the table,
any idea
I should have mentioned that I did a 'find / -name my.cnf' and there is
only one such file--/etc/my.cnf
Perhaps I should try creating a local version of my.cnf, but I really
want to know why it's getting the wrong .sock file in the first place.
Brad
Gerald Clark wrote:
> check for a .my.cnf
Hello,
Currently I have an aplication which stores the information in an MsSQL
database in a straight forward manner, "insert into blah blah"
However, I retrieve the information in XML format using the FOR XML EXPLICIT
statements that come with MsSQL 2000.
The select stament looks something like
On Mon, Feb 18, 2002 at 11:59:29AM -0500, Trond Eivind Glomsrød wrote:
> "S. William Schulz" <[EMAIL PROTECTED]> writes:
>
> > Hello,
> >
> > I just upgraded mysql to 3.23.49 using the rpm's. I had been running
> > 3.23.45 for many months now without a problem on a RH 7.2 box logging
> > snort
Monday, February 18, 2002, 5:51:38 PM, Henning wrote:
HS> sometimes you need to choose a good subject, but i don't know what your
HS> original subject was...
Yes maybe that actually was the reason :)
HS> what exacly you don't understand? the following message is just a
HS> special problem, no
I have run MySQL for the last 2 years using the default database tables.
Has anyone made the migration to InnoDB? Is it stable? What are the
drawbacks of using InnoDB?
David McInnis
sql
-
Before posting, please check:
htt
"S. William Schulz" <[EMAIL PROTECTED]> writes:
> Hello,
>
> I just upgraded mysql to 3.23.49 using the rpm's. I had been running
> 3.23.45 for many months now without a problem on a RH 7.2 box logging
> snort data (so it had moderate load).
Which rpms? RPMs from RH (not supported, it's just t
Hy Soren,
Søren Neigaard wrote:
> I have tried to get through with this question two ties before, and
> since I'm not getting any replies, I'm starting to think that I must be
> asking the wrong question. What am I doing wrong then?
sometimes you need to choose a good subject, but i don't know
Hi,
can someone suggest the best way to perform a query that
extract from a category table all the structure, like a filesystem?
For example, I've a table of categorie like this:
ID namedescr ID_parent
and I've assigned -1 to the root category.
I'd like to draw a directory-like structur
Hello all.
I downloaded the mysql v4.0.1 source and openssl 0.9.6c source.
I built openssl OK
I built mysql as follows:
./configure --with-vio --with-openssl
make
make install
The build went well all the way.
The mysql server seem to start ok. When I try to connect with mysql
client after a fe
Hello all.
I downloaded the mysql v4.0.1 source and openssl 0.9.6c source.
I built openssl OK
I built mysql as follows:
./configure --with-vio --with-openssl
make
make install
The build went well all the way.
The mysql server seem to start ok. When I try to connect with mysql
client after a fe
Hi,
We are having problems installing MySQL3.23.9 and below on our AIX 4.3.3-9
servers. We keep getting the shr.o error. Has anybody over come this
problem yet?
ThanX,
Greg
--
Greg D.
ISC-SEO
Systems Programmer, Linux Admin, HP-UX Admin, TSM Admin
University of Pennsylvania
~*~*
This problem appears to be similar to one I have when I create MySQL databases on my
Windows machine and then transfer them at a later date to RedHat. MySQL looks for
tables with the extensions MYD and MYI but they sometimes get converted to lowercase
and thus MySQL complains (Linux is case-sesiti
Hi.
I want upgrade mysql from 3.23.48 to 3.23.49 but i see that.
first. shared
># /usr/lib/mc/extfs/rpm run /home/httpd/MySQL-shared-3.23.49-1.i386.rpm
UPGRADE
Upgrading "/home/httpd/MySQL-shared-3.23.49-1.i386.rpm"
error: failed dependencies:
libc.so.6(GLIBC_2.2) is needed by MySQL-share
- create a file in /etc/logrotate.d, filename does not matter, take this as a
template, fill in connection parameters in mysqldump call (""):
/home/backup/sqlback/mybackup.sql {
daily
nomissingok
nocreate
compress
rotate 14
errors [EMAIL PROTECTED]
prerotate
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
It's at the bottom of every message sent to this list.
Tyler
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PR
check for a .my.cnf file in the user's home directory. It may have
conflicting entries.
Brad Emerson wrote:
>
> When I am logged in to my Linux system as root mysqladmin works
> correctly. i.e. finds mysql.sock in the correct location.
>
> When I am logged in as a normal user I get this erro
Hello,
I just upgraded mysql to 3.23.49 using the rpm's. I had been running
3.23.45 for many months now without a problem on a RH 7.2 box logging
snort data (so it had moderate load).
Now, when I try to start mysql, I get this in the log (other lines
snipped). I'm hoping someone might recogn
Hello,
I have found the solution of my sql quueris,
I want to unsubscribe from this list
can u help?
thanx
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi.
Thanks for this version. Thanks. This wersion not work on my linux RH 6.2
zoot.
Version 3.23.48 runs fine, but with wersion 2.23.49 not (this version is
bigger than previous server's version). Why ?
I make upgrade from MC on my linux box and i cannot start mysql server. What
a chek.
So for who
How did u do exactly ?
It's not documented.
Does it take a long.
Do u have to flush and lock tables before, that can be critical for 24/24
server.
what conf for logrotate ?
a+.
>I personally issue "mysqldump"s via cron and maintain the files using
"logrotate" (Redhat Linux), which >automatic
Hi Victoria,
Vic> Are you sure that your MySQL server (master) is running?
mysql> show master status;
+-+--+--+--+
| File| Position | Binlog_do_db | Binlog_ignore_db |
+-+--+--+--+
| bin.005 | 51925|
Robbie,
Monday, February 18, 2002, 4:34:34 AM, you wrote:
RN> I have been working all night on something then Outlook Express crashed my
RN> machine and now after restarting, MySQL service will not start. I am running
RN> it on Win2K Pro and have had no probs until just now. I right click on it
1 - 100 of 133 matches
Mail list logo
