> You may have a corrupt table. I would recommend printing the $query just
> before mysql_query() is ran. This will give you the query that is failing
> and the table that it is attempting to write to. May want to try a "check
> table" on this table.
SELECT post_id, post_subject, post_text FROM
Since you have used SQLyog, I will say you contact the
SQLyog people about this.
Karam
--- "Joshua J. Kugler" <[EMAIL PROTECTED]> wrote:
> You "can't?" How are you trying to display? What
> are you using? A CGI
> script? A database utility? Something else? We
> need a bit more information
>
Hello,
I want a debuggable compiled library. Is Deug version
of embedded server available.
Karam
--- Victor Medina <[EMAIL PROTECTED]> wrote:
> Karam Chand wrote:
> > Hello,
> >
> > I want to use embedded MySQL server library. I
> > downloaded the latest MySQL 4.1.1 source and
> unzipped.
> > I
Hi,
Found that error in .err log file:
read_key: Got error 146 when reading table './databasename/tablename'
Its an InnoDB table that gets a lot of reads/write with multiple
millions records.
Does someone as more informations on that error ?
Philippe
--
On 04/05/2004 6:16 PM, Brad Tilley <[EMAIL PROTECTED]> wrote:
> I've tried to make the server start at boot by copying the mysql.server file
> (from support-files) to /etc/init.d and /etc/rc.d ... neither worked. I also
> tried appending "/usr/local/mysql/bin/mysqld_safe --user=mysql &" to the
> r
Hi,
This is what HAVING is for. :-)
Matt
- Original Message -
From: "Joe Rhett"
Sent: Monday, April 05, 2004 8:59 PM
Subject: Re: Why can't I use an "AS" value in the WHERE clause.
> On Mon, Apr 05, 2004 at 08:03:33PM -0500, Paul DuBois wrote:
> > At 17:29 -0700 4/5/04, Daevid Vince
On Mon, Apr 05, 2004 at 08:03:33PM -0500, Paul DuBois wrote:
> At 17:29 -0700 4/5/04, Daevid Vincent wrote:
> >I'm curious when will I be able to do something like this:
> >
> >SELECT *, IF(( (unix_timestamp()-unix_timestamp(last_seen)) < 600),1,0) as
> >active FROM wifi_table WHERE active = 1;
>
Mark,
You may have a corrupt table. I would recommend printing the $query just
before mysql_query() is ran. This will give you the query that is failing
and the table that it is attempting to write to. May want to try a "check
table" on this table.
Bryan
- Original Message -
From: "M
MySQL is very stable on large databases...I would suspect inefficient indexes.
What does your query look like? What is the output when you put "EXPLAIN" in
front of your query?
I don't know anything about SQLYog blob display, so can't comment there.
j- k-
On Monday 05 April 2004 05:4
You "can't?" How are you trying to display? What are you using? A CGI
script? A database utility? Something else? We need a bit more information
to answer the question.
j- k-
On Monday 05 April 2004 05:19 pm, Rodrigo Galindez said something like:
> Hello list,
> Recently I've b
I'm working with a script that is made for phpBB to rebuild the search
engine. The script does work. I've been able to use it with limited success.
The problem is I haven't been able to use it with complete success.
The problem I'm having is that when it attempts to run its query, which
selects X
Hello list,
Recently I've been in the job of migrating a large (about 1.5GB)
database build in MSSQL Server to MYSQL. The migration was done OK, I
used the "SQLYog" utility to do this. The problem is that one table has
image column types ... I tried to view this column types (blob data
types
At 17:29 -0700 4/5/04, Daevid Vincent wrote:
I'm curious when will I be able to do something like this:
SELECT *, IF(( (unix_timestamp()-unix_timestamp(last_seen)) < 600),1,0) as
active FROM wifi_table WHERE active = 1;
I think you'll never be able to do it.
The stuff after the SELECT is calculat
I'm curious when will I be able to do something like this:
SELECT *, IF(( (unix_timestamp()-unix_timestamp(last_seen)) < 600),1,0) as
active FROM wifi_table WHERE active = 1;
It's so obnoxious, especially since I can do this:
SELECT *, IF(( (unix_timestamp()-unix_timestamp(last_seen)) < 600),1,0
Hi again,
I became frustrated with a RH9 mysql server install so I removed it and
installed the latest stable from mysql.com on the machine. Things are working
much better now, but I'm having problems with 2 things:
I've tried to make the server start at boot by copying the mysql.server file
(
Hi,
I am trying to do code coverage for mysql tests and for that using
Bullseye Code coverage tool. I enable the code coverage and then try to
build mysql, but I am getting following compilation error:
--
note cov902: running /usr
Karam Chand wrote:
Hello,
I want to use embedded MySQL server library. I
downloaded the latest MySQL 4.1.1 source and unzipped.
I opened up mysql.dsw and set libmysqld as active
project. Using Build->Rebuild All.. I started
compiling it.
After all the related projects were compiled I am
getting th
Hello,
I want to use embedded MySQL server library. I
downloaded the latest MySQL 4.1.1 source and unzipped.
I opened up mysql.dsw and set libmysqld as active
project. Using Build->Rebuild All.. I started
compiling it.
After all the related projects were compiled I am
getting the following error
Hi,
> Help Me!!
> I must create this simple stored procedure :
You might want to read some documentation on this...
http://www.mysql.com/doc/en/Stored_Procedures.html
> create procedure simpleproc (out param1 INT)
> begin
> select count(*) from clz.articoli;
> end;
select count(*) into param1 f
Has anyone been successful installing the develoment release of MySQL (4.1.1 I
believe) on Panther? I'm running 10.3.3, full updates and all of that, and I tried
for days to get the latest MySQL running on my machine. I ran into permission
problems, couldn't get mysqld to run. I finally settl
Hello,
Help Me!!
I must create this simple stored procedure :
create procedure simpleproc (out param1 INT)
begin
select count(*) from clz.articoli;
end;
I use MySql Control Center Editor and database MySql 5.0.0-alpha-max-nt
for compile this procedure!
this is the error:
[root] ERROR 1064: You
Hi People!!
I'm have something so curious:
In my application on Java I defined a Statement like this:
stmt =
con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATAB
LE);
and execute this query:
stmt.executeQuery("select * from us
I broke it and can't fix it or reinstall it.
I installed the MacOS X package, 'mysql-standard-4.0.18'. It seemed to
be working. I started 'mysqld_safe'. Nothing happened but the prompt no
longer appeared. As per the instructions, I hit control-z and it said
the process was suspended, so I figur
"Ugo Bellavance" <[EMAIL PROTECTED]> wrote:
> Hi,
>
>I'm trying to do a replication of two servers (one is mysql version =
> 4.1.0-alpha-debug-debug (slave) on debian and the other is =
> 4.1.0-alpha-debug-debug-log (master) on RH9). No I can't upgrade for =
> now.
>
> What I've done is
> does MySQL have an equilivent for the WHERE Unique_id IN ('1',' 2', '3')
as
> used in oracle.
MySQL supports this syntax exactly. See
http://www.mysql.com/doc/en/Comparison_Operators.html (halfway the page)
Regards, Jigal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.
It's tough comparing databases that are not in the same class. MySQL is
better than FileMaker (even v7) in lots of way, but then, Filemaker is
better in some ways too. MySQL will be far more scalable than
FileMaker. But you'll be more productive in FileMaker based on it's
ease of use. At least
Hello joe,
Monday, April 5, 2004, 3:17:27 PM, you wrote:
jc> does MySQL have an equilivent for the WHERE Unique_id IN ('1',' 2', '3') as
jc> used in oracle.
Yes.
--
Best regards,
Richard Davey
http://www.phpcommunity.org/wiki/296.html
--
MySQL General Mailing List
For list archives: htt
does MySQL have an equilivent for the WHERE Unique_id IN ('1',' 2', '3') as
used in oracle.
select *
from tableX
where tableX_id IN ('1', '2', '3')
i.e. if I have a comma delimited list of values for a certain field on a
table...I can search for all records that have the values in my comma
delim
mysqldump
Maru, Mulugeta wrote:
How can I copy all the tables in a database that I am developing using 5.0 to a production database that uses 4.1.8? All the tables are InnoDB tables.
Regards,
Maru
--
|...|
| _ _|Vi
How can I copy all the tables in a database that I am developing using 5.0 to a
production database that uses 4.1.8? All the tables are InnoDB tables.
Regards,
Maru
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PRO
> If you are unsure you should make a copy of the table and perform you test
> actions on that table. The answer is yes you can convert your unsigned
integer
> column to a varchar column.
Yep, first make a backup copy of your table, then alter the column to
varchar type.
To convert the existing dec
If you are unsure you should make a copy of the table and perform you test
actions on that table. The answer is yes you can convert your unsigned integer
column to a varchar column.
On Mon, 05 Apr 2004, joe collins wrote:
>
> I have a table that has a column :
> session_id INTEGER UNSIGNED NOT
I have a table that has a column :
session_id INTEGER UNSIGNED NOT NULL,
I now want to store a hexadecimal value in this column instead.
the column already contains values for some records.can I alter the data
type of this column (make it a varchar) without loosing the data already
stored?
o
A million rows is not a lot for mysql.
The pro of doing it in one table is that the coding is much easier.
Reporting is much easier.
The pro of doing it as individual databases would be easier locking,
quicker responses on
queries (not so much), and the ability to secure it much more (dynamica
I am going to have a web hosted MySQL database. It will hopefully have 100+
users.
I was thinking of having one database to store all records for all users.
I would store a user_id against records where appropriate to relate them to
a particular user.
The database will have a contacts table, users
Michael Stassen wrote:
Christine Ross wrote:
I had to install a source version of mysql and one of the install docs
strongly suggests using
CXXFLAGS="03 -felide-constructors -fno-exceptions -fno-rtti"
---8><
It's not a CERO, it's an letter O, the correct syntax is:
CXXFLAGS="-O3 -felide-const
Chris Nolan wrote:
The answers are wide and varied:
* History - MySQL has been an open source product for longer
* Flexibility - MySQL's different table types are ideal for some situations
* Performance - MySQL is the fastest database on the planet for most tasks
* Support - There are massive amou
Hi
MySQL 5.0.0, Mandrake 9.2 and the error pointed to my alter table statement
where tried to add a foreign key constraint.
I have been fiddling a little bit with replication priot to this error but
I
commented all of that data out of the my.cnf file.
Regards
/Jonas
- Original Message
Jonas Lind?n <[EMAIL PROTECTED]> wrote:
> hello, I came upon a strange thing just recently. I was trying to pipe a few sql
> statements but got a 1025 error all the time. I restarted, erased database manually
> but nothing worked so I tried deleting the binlogs and then my error disapered and
>
BTW, when I start Winmysqladmin from a new installation, it always asks me
for a username and password. Since this is a single-user machine I simply
use root and a password. Does this setup those passwords in MySQL?
From: Egor Egorov <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: I ne
The answers are wide and varied:
* History - MySQL has been an open source product for longer
* Flexibility - MySQL's different table types are ideal for some situations
* Performance - MySQL is the fastest database on the planet for most tasks
* Support - There are massive amounts of software out
Why would you want to?
Although the easiest way I know of if to rename and take of
auto_increment from the one field. Then recreate the field.
Andy B wrote:
would anybody know how to reindex an auto_increment field in a table??
--
With regards,
Say_Ten
===
Hi Friends,
I am working on a pilot project that
will introduce open source databases in my organisation.
In my search I have found that MySQL
and MaxDB both are open source databases, but MaxDB is being used very
less in comparison to MySQL. If I link this with the fact that MaxDB provides
many
"muhammad alqama" <[EMAIL PROTECTED]> wrote:
> hello
> a few days ago i had this problem in starting mysql daemon.. (described below by
> previous messages).. which was solved.
> i changed the permissions of the data directory.
>
> but now again i am facing the same problem.
> but the error mess
would anybody know how to reindex an auto_increment field in a table??
hello, I came upon a strange thing just recently. I was trying to pipe a few sql
statements but got a 1025 error all the time. I restarted, erased database manually
but nothing worked so I tried deleting the binlogs and then my error disapered and
everything was as normal. In what way does the b
Try this one:
Copy share/mysql/my-medium.cnf file to /etc/my.cnf and run
"mysql_install_db" and "chown -R mysql " and "mysqld_safe"
command.
Find the mysql datadir from mysql_install_db file (line no 77 : e.g.
ldata=/var/opt/mysql)
Thanks,
Mathan
- Original Message -
From: "muhammad
"kim&andy" <[EMAIL PROTECTED]> wrote:
> I can only connect to mysql with the username root and no password I have the ini
> file configured with a username and password but I can't connect with them.
> I am using win xp and winmysqladmin ver. 1.4
> I cant genarate a report because it says I must b
hello
a few days ago i had this problem in starting mysql daemon.. (described below by
previous messages).. which was solved.
i changed the permissions of the data directory.
but now again i am facing the same problem.
but the error message is of binding the unix socket.
something like this..(no
Hi,
Can I ask MySQL to GROUP BY id on MAX(something). For example, the query
below:
mysql> SELECT diary.date, diary.time, diary.id AS diary_id, diary.title,
-> link.to_id AS friend_id
-> FROM link
-> JOIN diary ON diary.member_id = link.to_id
-> WHERE link.from_id=10
-> ORD
Christine Ross wrote:
I had to install a source version of mysql and one of the install docs
strongly suggests using
CXXFLAGS="03 -felide-constructors -fno-exceptions -fno-rtti"
because of some instances of mysql crashing.
When I did that I noticed in the compile a line that said it wasn't
suppo
51 matches
Mail list logo
