hello
how can we get the size of Mysql database.
niraj
BN3 Hosted Customer Service Solution, basic service FREE.
CRM enable your web site in 5 minutes! http://www.bn3.com
-
Before posting, ple
okay, I'm having problems here, probably something
very simple I'm overlooking:
./configure --prefix=/usr/local/mysql
--prefix=/usr/local \
--localstatedir=/usr/local/mysql/data
make
make install
mkdir /usr/local/mysql/data
mkdir /usr/local/mysql/tmp
cd /usr/local/mysql/bin/
mysql_install_db
/u
I've poked around some more and realized I copied the wrong mysql.server
file into the etc/rc.d/init.d folder, so that is all fine now, but I still
can't get it to autostart. I'm using Mandrake 8.0 and set the paths up
through webmin so I can stop and start it through the webmin interface.
TIA!
Hello, I have a mysql database with a table called "cust". The primary key column
custid is of type int and has the auto_increment feature which has been working
perfectly for months. The auto_increment feature set numbers as high as 21700.But
suddenly, it started over, setting numbers lik
Cheer up - I too am having similar problems using Mandrake 8.0. I can run
php files, I have MySql running etc. Hopefully I will try a couple of the
things mention here and see what happens.
-Original Message-
From: Chakravarthy K Sannedhi [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, Se
The problem is still occurring. As I said in my earlier message, it
tends to (but is not limited to) the beginning of a binary log file.
Here is an example:
mysql> show slave status;
+--+-+-+---+---+-+---+
MySQL-3.23.41-4mdk.src.rpm* is not an attachment but simply the name of an
executable file.
I would like to know how to start this program.
Thanks in advance.
Altna Gokcen
- Original Message -
From: <[EMAIL PROTECTED]>
To: Nev and Emel Gokcen <[EMAIL PROTECTED]>
Sent: Wednesday, Septem
Hello all, been lurking for a bit and have come across something I can't
quite figure out. I did a source install of MySQL and everything went
great, could connect and look around, etc. I want it to autostart on
reboot and moved the mysql.server file into /etc/rc.d/init.d so it would
start on
Deryck Henson wrote:
>
> How do I::
>
> Add a column
ALTER TABLE myTable ADD COLUMN myColumn VARCHAR(27)
> Alter a table to fit a different character lengths (say...unlimited in a 1
> column)
ALTER TABLE myTable CHANGE COLUMN myColumn myColumn TEXT
> or
> alter column to accept an unlimit
Is there a way to continualy update a MySQL database with an Excell file?
Reason:
Just to have some fun I am building a Code Red hall of shame in PHP and
MySQL. I am anoyed from cleaning XX's and NN's all day in my Apache
logs.And they call Open software Virul...
And Instead of complaining
Dear.
I have questions About Replicatation Features.
There is next sentence as follows (In Manual '11.4 Replication Features and known
problems')
>MySQL only supports one master and many slaves. We will in 4.x add a voting algorithm
>to automatically change master if something
goes wrong with
hi
| Add a column
add an integer column:
alter table sometable add somecolumn int;
add an varchar column:
alter table sometable add somecolumn varchar(255);
see: mysql doc 7.8 Alter table syntax
| Alter a table to fit a different character lengths
|(say...unlimited in a 1 column)
simply spec
How do I::
Add a column
Alter a table to fit a different character lengths (say...unlimited in a 1
column)
or
alter column to accept an unlimited amount of characters
Make a column have a check box instead of characters(VARCHAR...) or date
(DATE)
thanx
- Deryck H
- http://www.comp-u-exchange.com
Thnx
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: "Attila Soki" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 05, 2001 8:42 PM
Subject: Re: What does this error mean??!!
> hi,
>
> try to execute this query too:
> FLUSH PRIVILEGES;
>
> b
hi,
try to execute this query too:
FLUSH PRIVILEGES;
bye,
ati
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e
Cancel this,.. after loading some test data into the tables, both queries worked
perfectly and are using the indices as expected! :)
Thanks again for all the help gang! ;)
>>Tried a couple of variation querys, but I keep getting the results when I do
>"explain"
>>
>>QUERY #1
>>explain select
At 02:58 06.09.01, you wrote:
>I get the results:
>Impossible WHERE noticed after reading const tables
>
>Not sure this has anything to do with it, but there is no data in either table
>yet,
yes, that´s exactly the reason. the query optimizer found out very early
that your select would not retu
Tried a couple of variation querys, but I keep getting the results when I do
"explain"
QUERY #1
explain select t.tagnumber,m.days,m.expdate from tags t
left join membership m on m.tagid = t.tagid
where t.orderid = '2';
QUERY #2
explain select t.tagnumber,m.days,m.expdate from tags t,membership
Does anyone have a good configure statement I could try for making
MYSQL on Solaris for Sparc? I've got it compiling on X86 but I get a
parser error I've only seen mention of once on the lists, and I
did not see how to identify the reserved word I am using?
I'll continue digging around, but if
Well, I did the grant and still cannot connect. This is so annoying. Well,
I tried putting these grants::
GRANT ALL ON *.* TO anonymous@"mydomainthatisnotshowninthisemail.com";
GRANT ALL ON *.* TO anonymous@anonymous;
GRANT ALL ON *.* TO ""@"";
So far, none have worked. any suggestions? I wa
>
>When I attempted to change the MySQL root user with the command "mysqladmin
>-u root -p password 'new-password' " I received the following error:
>"Can't connect to local MySQL server through socket
>'/var/lib/mysql/mysql.sock '(2)' check that mysqld is running and that the
>socket; '/var/lib/
The confusion probably lies in the message saying the file should exist.
There were 2 conditions
to that statement, and the first (make sure that mysqld is running)
hadn't been met.
The file is SUPPOSED to be evidence that mysqld is running, and a socket
connection is possible.
However, in yo
I have perused the archive lists (on Geocrawler) for a solution to my
problem but have been unable to find an answer, so I am putting the question
forward and hoping that some kind soul will be able to give me some advice.
Scenario: RedHat 7.1 on a celeron 900 box, installed MySQL and its
compone
I have perused the archive lists (on Geocrawler) for a solution to my
problem but have been unable to find an answer, so I am putting the question
forward and hoping that some kind soul will be able to give me some advice.
Scenario: RedHat 7.1 on a celeron 900 box, installed MySQL and its
compone
The secret is to use the tags table twice, but you've got to rename them
to avoid vagueness.
select t1.tagnumbers,mem.days,mem.expdate
from tags as t1,tags as t2,membersip as mem
where t1.orderid = t2.tagid
and t1.orderid = mem.tagid
I believe that should work.
[EMAIL PROTECTED] wrote:
>Hello
Henning Schroeder wrote:
> idea? And how am I supposed to find the slow queries?
Use EXPLAIN SELECT ...
http://www.mysql.com/doc/E/X/EXPLAIN.html
Also, if you run 'mysqladmin processlist' if you see a 'copying into temp table' that
lasts a
while (e.g run mysqladmin multiple times and see if it
Thanks,
OK, I think I see where I was going wrong! :) We'll work at it again.
Appreciate the help from the list.
On Thu, 06 Sep 2001 01:27:21 +0200, Henning Schroeder <[EMAIL PROTECTED]>
wrote:
okay,
"extract all the tagnumbers,days and expdate"
select tagnumber, days, ex
Doh! Just saw the "..orderid equals the tagid in both the.." Make that:
select tagnumber,days,expdate from tags
left join membership on membership.tagid = tags.tagid
where orderid = membership.tagid
there are a few other ways to do it. The most efficient depends on which
table has the most
There may be a better way, but right off the top of my head I'd say:
select tagnumber,days,expdate from membership
left join tags on membership.tagid = tags.tagid
where tags.tagid is not null
On Wed, Sep 05, at 06:10pm, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote:
> Hello All,
>
> I got
At 01:10 06.09.01, you wrote:
>Hello All,
>
>I got a sql query I seemed to be missing the obvious or just can't see.
>Database Table structure:
>CREATE TABLE `membership` (
> `tagid` int(8) NOT NULL default '0',
> `startdate` date NOT NULL default '-00-00',
> `expdate` date NOT NULL defa
Ditto ... Ed is right. We tried a configuation where we were storing MP3
audio files for a group of about 30 radio stations in the database, and the
server performance went to h@!! in a hand-basket.
We re-wrote the PHP front-end so the databases stores paths to binary files,
and the first thing w
Hello All,
I got a sql query I seemed to be missing the obvious or just can't see.
Database Table structure:
CREATE TABLE `membership` (
`tagid` int(8) NOT NULL default '0',
`startdate` date NOT NULL default '-00-00',
`expdate` date NOT NULL default '-00-00',
`days` smallint(4) N
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 3:50 PM
To: Duc Chau
Subject: Re: mysql db replication security across the internet
Your message cannot be posted because it appears to be either spam or
simply off topic to our f
Can anyone tell me or point me to documentation on how to securely do
database replication over the internet?
I need to replicate to machines in datacenters in diffrent states. How
feasible is this? Has anyone done it? What are the security concerns with
doing this via the net? Thanks
---
This is fixed in PhpMyAdmin 2.2.0
- Original Message -
From: "Henning Schroeder" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 06, 2001 12:23 AM
Subject: RE: limit and order by issuse
>
> >sh> Here is my query:
> >
> >sh> SELECT
> >sh>
articleId,arttitle,artsourc
>sh> Here is my query:
>
>sh> SELECT
>sh> articleId,arttitle,artsourceId,artstatus,artauthorId,arteventdate,artpre
>sh> ss,artpageno,artrankId,artabstract,
>sh> artfulltext,artisdisplay,arteditionId,arttypeid,artsubjectid ,
>sh> asubjectId,asubjectname , FLOOR((TO_DAYS(CURRENT_DATE()) -
>sh> TO_D
Hi!
> "sh" == shahzazd@shebaak com <[EMAIL PROTECTED]> writes:
sh> Thanks for quick response.
sh> Here is my query:
sh> SELECT
sh> articleId,arttitle,artsourceId,artstatus,artauthorId,arteventdate,artpre
sh> ss,artpageno,artrankId,artabstract,
sh> artfulltext,artisdisplay,arteditionId,artt
Hi,
> > Looking in the process table reveals (when the page is fast) lots of
> > sleeping processes, sometimes (when the page is slow -- 30sec to load a
> web
> > page) lots (20+) processes that are locked. Usually they are some SELECTs
> > and UPDATEswaiting for a single table that is the most
Try updating your /etc/ld.so.conf file to include the path to the
libmysqlclient.so.6 library, and re-run ldconfig.
- Jeff
Webmaster wrote:
> Hi:
>
> How I can install or copy mysqlclient.so.6 without reinstall??
>
> I'm trying to execute PHP script (Phorummail) from shell, but I receive that
That's what I thought at first as well. But my tmp_table_size is set to 64MB
and I used the --big-tables option just to be sure.
Also, show table status says the size is well below 64MB:
Name | Type | Row_format | Rows| Avg_row_length | Data_length | Max_data_length
tmp| HEAP | Dyn
Hi:
How I can install or copy mysqlclient.so.6 without reinstall??
I'm trying to execute PHP script (Phorummail) from shell, but I receive that
this lib is
missing.
[root@corotu docs]# ./phorummail
> > php: error in loading shared libraries: libmysqlclient.so.6: cannot open
shared
> > object fi
Chakravarthy K Sannedhi wrote:
> --- Steve Suehring <[EMAIL PROTECTED]> wrote:
> >
> > hmm. Are you sure that MySQL is running? Conversely, does the file
> > /var/lib/mysql/mysql.sock exist?
> >
> > Steve
>
> The mysql server is running and the mysql.sock file exists. Also I am
> able to connec
--- Steve Suehring <[EMAIL PROTECTED]> wrote:
>
> hmm. Are you sure that MySQL is running? Conversely, does the file
> /var/lib/mysql/mysql.sock exist?
>
> Steve
The mysql server is running and the mysql.sock file exists. Also I am
able to connect to the mysql database by any of the follow
Try something like putting a peice of code (asuming you are using something
like ASP/PHP)
Session_On_end()
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: "Claudio Muzzio" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 05, 2001 2:09 PM
Subje
On Wed, Sep 05, 2001 at 11:10:49PM +0200, Henning Schroeder wrote:
> Looking in the process table reveals (when the page is fast) lots of
> sleeping processes, sometimes (when the page is slow -- 30sec to load a web
> page) lots (20+) processes that are locked. Usually they are some SELECTs
> a
I can't help you with your problem, because I have almost the same thing
happening to my server every 2-3 days. It is exactly as you described
Please someone offer us suggestions??
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
- Original Message -
From: "He
Hi!
I am trying to understand and fix a severe performance problem I am having
with MySQL for some weeks now, but to no avail. So I am coming here, hoping
you understand more than I do (which is not very hard to do :-)
Im am running mysql 3.23.41 (from the mysql-server-3.23.41-1 debian
packag
[EMAIL PROTECTED] (Jason Bailey) writes:
> >If the server is creating mysql.sock in and something else is looking
> >for it in /tmp, this is the easiest way to get it to work, besides
> >checking to make sure that the permissions are such that anyone who
> >needs to can read and write to mysql.so
Greetings,
This morning we sucessfully inserted a new record on our master MySQL
machine. 4 1/2 hours later, the change showed up on the slaves. I was
under the impression that MySQl replication would occur in a more timely
fashion.
We have a single master with 4 slaves replicating only one o
[EMAIL PROTECTED] wrote:
> Hello,
>
> I keep getting this:
>
> insert into tmp select * from ascend_log_2001_08_25;
> ERROR 1114: The table 'tmp' is full
>
> tmp is a heap table
There is a size limit to temp tables. See:
http://www.mysql.com/doc/F/u/Full_table.html about increasing the allowed s
FVFM (thats: From the Very Fine Manual )
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Databa
se_Administration.html#SHOW_VARIABLES
You may have the above line split by your mail reader, just cut and
paste the two havles in or go to:
http://www.mysql.com/documentation/mysql/bych
"Adams, Bill TQO" wrote:
> SELECT SUM( test=x ) AS total, COUNT(*) AS pass FROM table WHERE text=x AND
> value BETWEEN low AND high;
>
> b.
Ugh, brain fart.
SELECT COUNT(*) AS total, SUM( value BETWEEN low AND high ) AS pass FROM table
WHERE text=x;
--Bill
-
On Wed, Sep 05, 2001 at 03:46:03PM -0400, Duncan Hill wrote:
> A college graduate, with only an Associate's Degree and a CCNE
> approaches you/your company, with a resume that indicates no experience
> whatsoever, just the schooling from an associate's degree, a CCNE and
> knowledge of layers 1 -
Hi folks, just signed up to the list so I hope this is the correct place to
send such a question:
I have recently upgraded to Red Hat Linux 7.1 from Red Hat 6.x
I had successfully run MySQL under that distribution but am having problems
with it under Red Hat 7.1
I have installed mysql-3.23.36
I've been running a master/slave MySQL database system for about four months now and
I've got nearly 360mb of binary logs. I want to archive anything over about a month
old, but I've heard that there is a procedure that you have to go through to do that.
---
On Wed, Sep 05, 2001 at 07:59:15AM +0800, Steve Doig wrote:
> Hi Folks,
>
> I'm running a batch command in win2K: cmd> mysql < batch-file > output.txt
> In the batch file, can I specify that values are separated by commas instead
> of tabs?
>
> Cheers,
> Steve
>
not using that syntax but with
Hello,
I keep getting this:
insert into tmp select * from ascend_log_2001_08_25;
ERROR 1114: The table 'tmp' is full
tmp is a heap table
I've looked through the docs and mailing list archives and can't find anything
that matches my problem. I'm using 3.23.41 so it should switch to disk if it
On Wed, Sep 05, 2001 at 08:30:53PM +0100, Chris Thorpe wrote:
> Is it possible to modify the following query:
>
> SELECT COUNT(*) AS pass WHERE test=x AND value BETWEEN low AND high;
>
> to also count the total number of records where 'test=x'
> and hence return the percentage pass mark all with
my $dbh = DBI->connect( ... );
my $sth = $dbh->prepare( "SHOW COLUMNS FROM $table" ) or die;
$sth->execute( ) or die;
my @columns;
while( my( $column_name ) = $sth->fetchrow_array( )){
push @columns, $column_name;
}
$sth->finish( );
b.
"Anthony E." wrote:
> I need to read the fields of a ta
Apologies for the off topic, but I'm collecting some information, and I
figured the lists that I'm on would provide a good feedback mechanism.
Replies to me off-list if you would please. My apologies for the very
short notice, but I just heard that I need this by ~8 AM EST Thu 6th
Sept :(
A col
SELECT SUM( test=x ) AS total, COUNT(*) AS pass FROM table WHERE text=x AND
value BETWEEN low AND high;
b.
Chris Thorpe wrote:
> Is it possible to modify the following query:
>
> SELECT COUNT(*) AS pass WHERE test=x AND value BETWEEN low AND high;
>
> to also count the total number of records
I need to read the fields of a table dynamically using
DBI.pm
The resulting cgi script should be a form that has a
checkbox for each field...the user will then create a
temporary table based on which fields are checked in
the form.
=
--
Anthony Ettinger
[EMAIL PROTECTED]
415-504-8048
http:
I think your slave version is too old.
Duc Chau wrote:
> If i put a server-id in the slave my.cnf file and start up the database with
> safe-mysqld, it starts and dies with this error in the log file.
>
> unrecognized option `--server-id=2'
>
>
> -Original Message-
> From: Gerald Clar
Is it possible to modify the following query:
SELECT COUNT(*) AS pass WHERE test=x AND value BETWEEN low AND high;
to also count the total number of records where 'test=x'
and hence return the percentage pass mark all within one statement, or am I
stuck using 2 statements 1 as above to count the
Well, this is a client error, not a server error.
What client is this?
Maybe you have another my.cnf in the data directory,
or possibly a .my.cnf file in your home directory.
BW (ST) wrote:
> I'm trying to use a socket besides the standard /tmp/mysql.sock one. I've
> tried specifying socket=/pa
Hi,
I' have installed mysql on linux 7.1 and
when a web application open a new session of mysql it remain
opened in memory, so my server goes in memory overload.
please help me.
thanks
P.S.: Sorry for my english !!!
-
Before
hmm. Are you sure that MySQL is running? Conversely, does the file
/var/lib/mysql/mysql.sock exist?
Steve
At 11:52 AM 9/5/01 -0700, Chakravarthy K Sannedhi wrote:
>Hello all,
>
>I am trying to integrate the mysql with php. As I am using the Red Hat
>7.0, I know that they come pre-installed a
Chakravarthy K Sannedhi wrote:
> $db=mysql_connect ("localhost","myname","mypassword");
> mysql_select_db ("newone",$db);
> $result = mysql_query ("select * from namelist");
[snip]
> Warning: MySQL Connection Failed: Can't connect to local MySQL server
> through socket '/var/l
Hello all,
I am trying to integrate the mysql with php. As I am using the Red Hat
7.0, I know that they come pre-installed and pre-configured. When i
created test.php with the line, the page shows that
the php is able to recognize the presense of mysql. I created a small
table 'namelist' in a da
Hi all
Is there a document available somewhere outlining
some guidelines regarding what parameters should be
set in the my.cnf files for the MySQL database and to
what values?
thanks
=
__
Do You Yahoo!?
Get email alerts & NEW webcam
I am New at this Mailing List, `cause of it first of all lemme say Hi to
everybody...
I`m facing a problem with my Web Server, it`s a Conectiva Linux, running
Apache
We had a problem with it last night, all configuration files were lost and
were forced to recover the backup. After this, trying to
Hi!
Since I heard Monty is in Sweden, which will probably delay
the release of 3.23.42 still a couple of days, I decided to
release the InnoDB-3.23.41b source at my website
http://www.innodb.com right now.
The release fixes the bad BLOB bug where any update of
the primary key of a > 8000-byte ro
Yes, I gave it 644 permissions.
- Original Message -
From: "Carsten H. Pedersen" <[EMAIL PROTECTED]>
To: "BW (ST)" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]>
Sent: Wednesday, September 05, 2001 10:58 AM
Subject: RE: 'tmp/mysql.sock' (2) error
> > I'm trying to use a socket be
> I'm trying to use a socket besides the standard /tmp/mysql.sock one. I've
> tried specifying socket=/path/to/socket in both [client] and [mysqld]
> sections of my.cnf, and I've tried to edit safe_mysqld directly with this
> path. In all cases, the mysql server appears to start (no error messag
Hello again !
Sorry I made some mistakes.
The the wrong command was - DELETE FROM user WHERE Host LIKE "%";
and got this:
mysql> select * from user;
Empty set (0.00 sec)
Can I recover the user table in such a situation ???
Thanks agin.
> It seems that with a wrong command:
>
> mysql> delet
I'm trying to use a socket besides the standard /tmp/mysql.sock one. I've
tried specifying socket=/path/to/socket in both [client] and [mysqld]
sections of my.cnf, and I've tried to edit safe_mysqld directly with this
path. In all cases, the mysql server appears to start (no error messages
are g
At 7:34 PM +0200 9/5/01, Carsten H. Pedersen wrote:
> > -Original Message-
>> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
>>
>> At 6:35 PM +0200 9/5/01, Carsten H. Pedersen wrote:
>> > > Hi,
>> >> I'm using :
>> >> - Win NT 4.0 SP6
>> >> - Apache 1.3
>> >> - PHP 4.05
>> >>
Hello!
It seems that with a wrong command:
mysql> delete from user where host='%';
I have casually deleted all data in user table :(((
It works for now but after "reload" all data in the table will be lost ...
Can I recover the user table in such a situation ???
Thank you !
--
Piter
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
>
> At 6:35 PM +0200 9/5/01, Carsten H. Pedersen wrote:
> > > Hi,
> >> I'm using :
> >> - Win NT 4.0 SP6
> >> - Apache 1.3
> >> - PHP 4.05
> >> - MySQL 3.23
> >> When I try to upload JPG files, the temporay files on
Hi Derek,
- Original Message -
From: "Derek Sivers" <[EMAIL PROTECTED]>
>
> But with LOTS of MySQL traffic (20,000 unique users a day on a 100%
> MySQL-driven website) - yes the mysqld process goes up to 99% and
freezes
> the server until I reboot.
>
Have you tried capturing informati
At 6:35 PM +0200 9/5/01, Carsten H. Pedersen wrote:
> > Hi,
>> I'm using :
>> - Win NT 4.0 SP6
>> - Apache 1.3
>> - PHP 4.05
>> - MySQL 3.23
>> When I try to upload JPG files, the temporay files on the server are OK.
>> But when I store them into a BLOB field into mySQL, some images (not a
>I'm running OpenBSD 2.8 and MySQL 3.22.32 (recent cvs port).
>After time (< 1day) the cpu load for the mysqld process goes up to 98%..
>There is a known problem in 2.8 thread library. I do not know
>when will they fix it. You can ask them , though ..
>I've seen that this has been addressed in th
> Hi,
> I'm using :
> - Win NT 4.0 SP6
> - Apache 1.3
> - PHP 4.05
> - MySQL 3.23
> When I try to upload JPG files, the temporay files on the server are OK.
> But when I store them into a BLOB field into mySQL, some images (not all)
> are truncated after some lines.
> It's like an EOF byte found .
Hi,
I'm using :
- Win NT 4.0 SP6
- Apache 1.3
- PHP 4.05
- MySQL 3.23
When I try to upload JPG files, the temporay files on the server are OK.
But when I store them into a BLOB field into mySQL, some images (not all)
are truncated after some lines.
It's like an EOF byte found ...
The SQL is:
$reqS
hi.
assuming you're using a bash-type shell and gcc is in /some/directory/gcc
>PATH=$PATH:/some/directory
>export PATH
>echo $PATH
otherwise:
>setenv PATH /some/directory:${PATH}
if more errors crop up, copy and paste the error message into google and see
if any relevant results are returned.
h
OK simple stuff
Did mysql_install_db work ok?
When you do a ps can you see any thing runing?
Are you stating it from the right place?
/use/local/mysql/bin/safe_mysql &
It will be somthing simple so if you just go over stuff it will work...
Than you will be flighing...;o)
Simon
-Original Me
Hi,
I'm using :
- Win NT 4.0 SP6
- Apache 1.3
- PHP 4.05
- MySQL 3.23
When I try to upload JPG files, the temporay files on the server are OK.
But when I store them into a BLOB field into mySQL, some images (not all)
are truncated after some lines.
It's like an EOF byte found ...
The SQL is:
$reqS
subnet writes:
> Hi,
>
> I'm running OpenBSD 2.8 and MySQL 3.22.32 (recent cvs port).
>
> After time (< 1day) the cpu load for the mysqld process goes up to
98%..
>
> Is this a known problem? any ideas?
> Thanks,
> Stu
>
>
> Hi! There is a known problem in 2.8 thread library. I do no
If i put a server-id in the slave my.cnf file and start up the database with
safe-mysqld, it starts and dies with this error in the log file.
unrecognized option `--server-id=2'
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 7:25 AM
I am new to MySQL. I've installed the package under SuSe Linux 7.1
(kernel 2.4). When I try to start the database using commands from the
manual I get the following message.
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock'. I'm pretty much lost at this point as I
hav
Dear Sirs and Madams,
EMS HiTech company is announcing the NEW software MySQL Manager --
A Powerful MySQL Administration and Development Tool.
You can download the latest version from
http://www.mysqlmanager.com/download.phtml
What is the EMS MySQL Manager?
EMS MySQL Manager provides you power
=?iso-8859-1?q?Cinzia=20Rubattino?= ([EMAIL PROTECTED]) writes:
> I have to insert a file wav into a blob field of a
> table. Is that possible?And how can I do it?
Bad, bad, BAD IDEA!
Read: http://www.bitbybit.dk/mysqlfaq/faq.html#storing_images
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/3
During my attempt to configure the 3.23.41 source, I encountered the error:
"configure: error: no acceptable cc found in $PATH". As I'm using gcc on
this box, where/how do I identify gcc for configure to use properly?
Thanks,
Brian
--
This may not be the best workaround, but I changed the 'localhost' to my
actual server url, and then it worked.
Someone else mentioned this as a means of fixing privileges:
http://sourceforge.net/forum/forum.php?thread_id=123272&forum_id=50480
cheers,
Brett
-Original Message-
From: Sil
Ed,
Once again, thanks for the email response. I'm going to try all the suggestions I've
received.
A colleague has suggested as I'm new to Linux to select the 'Install Everything'
option in red hat 7.1. He suggests that it's probably easier (for me) to get everything
installed and work backwa
On Wed, Sep 05, 2001 at 04:44:01PM +0300, Sinisa Milivojevic wrote:
> De-install gcc 2.7.2.1 and install 2.95.2 or gcc 3.
Stay with gcc 2.95.X until 3 is fixed!
> --
> Regards,
>__ ___ ___ __
> / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
> / /|_/ /
Hi everyone,
I just installed MySQL on my linux box. But when I tried to connect to my
own box with jdbc (jdbc:mysql://localhost/red), it gave me "SQLException:
server configuration denies access to data source". I have already added
root in the mysql.user and mysql.db, why is this happening
Hi !!!
)-Original Message-
)From: Ghislain Gadbois [mailto:[EMAIL PROTECTED]]
)Sent: Wednesday, September 05, 2001 7:37 AM
)To: MySQL List (E-mail)
)Subject: Date functions returning Strings
)
)
)Hi,
)
)I'm using MM JDBC driver version 2.0.4 to access a MySQL database
)3.23.40 on Sola
)-Original Message-
)From: Roland Thompson [mailto:[EMAIL PROTECTED]]
)Sent: Wednesday, September 05, 2001 3:38 AM
)To: [EMAIL PROTECTED]
)Subject: Can't connect to source
)
)
)Hi,
)
)Ive just started playing about with MySQL. I created a database called
)haworth, no problem there, then
Hello Roland,
Basically users are defined with their 'hostname'. So if i dial in
from my isp it might be [EMAIL PROTECTED] so I have to define rights to
that user.
Along with the manual bit below .. you might want to get Paul DuBois's
great book on Mysql.
This bit is from the manual .. 7.35
1 - 100 of 142 matches
Mail list logo
