>Description:
MySQL crashed at final step, when executing script mysql_install_db, with msg:
mysqld got signal 11;
Here is all last output line at finish installation:
/usr/bin/ginstall -c .libs/mysqlmanager /usr/local/bin/mysqlmanager
make[2]: Nothing to be done for `install-data
NEWEST**
I am now getting this error while trying to Replicate to a second MySQL
server.
021125 0:41:01 Slave: Failed reading log event, reconnecting to retry, log
'bsd1-bin.001' position 73
021125 0:41:01 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replicatio
Greetings,
Im trying to keep the mysql installation to a minimal since space
is limited on a Compact Flash card. The following binaries in the 'bin'
directory total 16megs. Mysql is used very limited, only inserts and reads
from php are done to the database, and replication will be used as
I am getting this error while trying to Replicate to a second MySQL server.
021124 23:40:25 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position
4
021124 23:40:25 Error reading packet from server: Binary log is not open
(server_errno=2000)
I have
Dear sir,
I want to create a website in my native language.
I would like MySQL support for my native character set, which is Bengali. I
think MySQL does not support this language. How can I add support for it in
MySQL ?
Thanks in advance for any reply.
Shyamal
-
On 11/24/02 4:30 PM, "Bruno Batarelo" <[EMAIL PROTECTED]> wrote:
> The question is what does Access do in order to perform subqueries on MySQL
> via MyODBC driver since it is obvious that they work? What can I do, but I
> do not want to use access database as a layer between my application and
> m
hey Alex,
1 swap "from stats" and "AS cstatus" - the "AS" is to put a column name/give
you an associate array element name for the "if(captain = 1,'C','')"
2 recommend replacing the '' within the if() with captain - that way
something will be returned regardless of the if() comparison
3 recommen
Greetings!
I am aware that MySQL does not support subqueries. I have a 3 gb large
database of bibliographic records. Database is designed by a model that is
accepted by almost every library system, but there is one problem. When
searching that database, nested queries are needed and there's a diff
hey,
I got that query to work but i dont know how to display it on an HTML page,
I'm using this and its not displaying anything:
$captainquery = mysql_query("select if(captain = 1,'C','') from stats AS
cstatus WHERE captain > 0 and number = '19' group by number");
while($captain2=mysql_fetch_arra
Is it possible to tell MySQL 4.0.5 what special characters it can index? For
instance, I would like it to index "-" and "+" characters so that hyphenated words
like "full-text" and words like "C++" are indexed and can be searched. I've been
trying to find a way to do this, but haven't found a
select if(captain = 1, 'C', '')
from stats
where captain > 0
and number = $number
group by number
This returns 'C' whenever the captain field is 1 and '' (empty string)
otherwise.
--jeff
- Original Message -
From: "Alex Behrens" <[EMAIL PROTECTED]>
To: "DL Neil" <[EMAIL PROTECTED]>; "MYS
Hey,
I'm not sure how to implement this into my query, i looked it on the
mysql.com documentation and it's confusing.
I tried this query:
select captain from stats where captain > 0 if (captain(1,'C') and number
= '$number' group by number;
but i dont think its right cuz its returning a value.
Hey Alex
> select captain from stats where captain > 0 and number = '23' group by
> number;
>
> this returns a 1 for any player with the number that matches being a
> captain, however it display a 1 is it possible to make that 1 displayed as
a
> C on my page?
MySQL allows an IF() within the SELE
Hey All,
I'm working on a site that displays all the players on my hockey team and I
want to the page to indicate the captains automatically. Right now im using
the following query to display all the captains, however, captains are
indicated by a 1, is it possible to display a "C" when a 1 is foun
On Sun, Nov 24, 2002 at 10:39:43PM +0200, Sweethome.co.il Webmaster wrote:
> Dear list,
>
> Does any of you guys operate a mysql server in virtual hosting environment?
> I need some advice on tuning and restriction based on system resources.
One thing you need to nail down is what the abstraction
Dear list,
Does any of you guys operate a mysql server in virtual hosting environment?
I need some advice on tuning and restriction based on system resources.
My system is running RH7.2 , on an Intel based server, 2x1Ghz CPU's and 1
giga of RAM.
I have 2 hd's in raid 1 mode (hardware). I currenl
Notice: Bravo Technical Resources does not allow EXE files into its email
system, they are deleted automatically. Please refrain from sending them in
the future. If there is a legitimate need to send an executable email,
please contact [EMAIL PROTECTED] Thank you.
Antigen for Exchange found fear.s
Matthew Scarrow wrote:
I have an applet and I'm trying to use Connector/ J 3 to connect to my
database.
I have uploaded the applet to my web server.
I have uploaded the mysql-connector-java-3.0.2-beta-bin.jar file to
the same
dir as the applet
I have made a reference to the mysql.jar file in th
Ares Liu wrote:
> As both of them type IV JDBC, which one is the better?
>
If you're talking about the Apache Group's Turbine, it's not a JDBC
driver, it's a servlet framework that sits on top of JDBC.
-Mark
--
For technical support contracts, visit https://order.mysql.com/?ref=mmma
Hi
I would like to know whether MySQL with the Berkeley DB tables supports
two phase commit?
Thanks
Gil
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Dear Soenke,
> i wanna setup replication, everything works so far, but the slave
> can'tconenct to the master, access denied. but if i connect with the
'mysql'
> program from slave machine to master machine, it works!
Before you go crazy, check if the slave (user) has sufficient privileges.
Let's
hello,
i wanna setup replication, everything works so far, but the slave
can'tconenct to the master, access denied. but if i connect with the 'mysql'
program from slave machine to master machine, it works!
going crazy .. both mysqld's are 3.23.53 !
what is going wrong here ahh?
regards, soenke.
Thanks. That explains it.
Pae
> The first column of type timestamp will always be initialized with the
> current timestamp. See the fourth and fifth paragraphs of the following
> link.
>
> http://www.mysql.com/doc/en/DATETIME.html
>
> > Isn't it suppose to be 'NULL'? Thanks
>
> --
> Linux: Beca
hay guyz
im havin a weired problem
i ve this search query
$srch_qry = " select ctnt_inf.* from ctnt_inf ".
" where (match (firstName ) against (\"".$srch."\") ".
" or match (lastName ) against (\"".$srch."\") ".
" or match (summary ) against (\"".$srch."\") ".
" or match (body) against
The first column of type timestamp will always be initialized with the
current timestamp. See the fourth and fifth paragraphs of the following
link.
http://www.mysql.com/doc/en/DATETIME.html
> Isn't it suppose to be 'NULL'? Thanks
--
Linux: Because rebooting is for adding hardware.
Fingerprint
I have created a test table for different data types as follows:
CREATE TABLE AllDataTypes (
id INTEGER,
col_bit BIT,
col_boolean BOOL,
col_tinyint TINYINT,
col_smallint SMALLINT,
col_int INT,
col_integer INTEGER,
col_bigint BIGINT,
col_float FLOAT,
col_double DOUBLE,
col_char
26 matches
Mail list logo
