Just installed the mysql binary. It runs fine.
However the only way i can administrate it is if I use
the root account which is fine. But when I try to
Grant other users any privilages the following
happens:
My Query: Grant ALL on dbName.* to userName
Response: Query Ok, 0 rows affected.
I can copy the
latin2.conf into new one, but I need to know what each codefrom the conf
file represents and how can I obtain the relation from thesecodes and the
chars.So that's two problems:1) Can I use asc function or what function I
need to know to obtain thecodes from the chars?2) How is
At 19:58 +0100 7/29/03, David Otton wrote:
Hi, small but disturbing oddity, this.
I have a simple table:
CREATE TABLE musician (
musicianid int(10) unsigned NOT NULL auto_increment,
name varchar(60) NOT NULL default '',
PRIMARY KEY (musicianid)
) Type=MyISAM;
There are 50
At 13:08 -0700 7/29/03, b b wrote:
Most web hosting companies run the mysql standard.
Which means one can't run transactions. If that is the
Depends. As of MySQL 4, InnoDB (which provides transactional
tables) is included by default.
case, then how do you handle many to many
relationships with tr
At 22:08 -0400 7/29/03, Asif Iqbal wrote:
I just decided to use my.cnf and bumped into this error message
030729 22:04:22 mysqld started
InnoDB: Error: data file /usr/local/mysql/data/ibdata1 is of a different size
InnoDB: 81024 pages (rounded down to MB)
InnoDB: than specified in the .cnf file 1
I am attempting to use the LOAD DATA feature. At the end it reports
that I have several warnings but there does not appear to be a way to
determine what the warnings are. I installed V4.1 which has the SHOW
WARNINGS feature, but, it returns empty sets after the load command.
I have 30+ tables wi
At 15:53 +0100 7/29/03, Matthew McNicol wrote:
The recommended way to quickly check all tables is:
myisamchk --silent --fast /path/to/datadir/*/*.MYI
isamchk --silent /path/to/datadir/*/*.ISM
that's from the mysql manual, sectio 4.4.6 Using myisamchk for Table
Maintenance and Crash Recovery
That'l
At 16:26 +0200 7/29/03, Sigurd Urdahl wrote:
I need to do CHECK TABLE on a lot of tables (actually on all tables in
several databases), and hoped to do something like
mysql> CHECK TABLE reports.*
which ddn't work. The only thing that seems to work is using
cut'n'paste (or some scritpting)
At 14:53 + 7/29/03, <[EMAIL PROTECTED]> wrote:
Hi all,
i want to know if the system parameter somaxconn affect the capabalities
of MySQL
to maintain more than five thousands of HTTP connections ?
If so , any clarifications may help.
think in advance
MySQL doesn't have anything to do with HTTP c
At 9:27 +0100 7/29/03, Peter Lovatt wrote:
SELECT * FROM TABLE
That will perform a complete table scan and transfer the entire
contents of the table over the network. Much better to run
SELECT COUNT(*) FROM tbl_name
Which will be very quick (for MyISAM tables, at least), and in all
cases will ret
I use rpm to update the previous version. I can use innodb in redhat 9
with version 2.23.56. But it failed in redhat 7.2. I wonder it is the
kernel problem.
BTW, I want to ask whether I can do replication in the following case.
innodb (master) --replication --> myisam (slave)
unplug
Jerem
I'm about to dig a bit deeper into Celko's articles
and love the idea of nested sets. Still trying to pull
some time to start implementing this myself.
Anyway, I don't really have an answer for you but you
might want to take a look at PEAR::DB_NestedSet, as it
sounds very able to work with nested
I've been working on something similar to this for quite a while (few
more steps, maybe), and this list helped me through it, so I suppose I
can at least return the favor.
You basically need to do the following (I'm using temporary tables to
help me think through it - and because of the lack of
I've been browsing through posts here, but I haven't found anything relevant
to my issue, so I guess I'll just post it myself:
I have three tables: users, groups (which define collections of users),
messages, and replies (replies are completely different from messages and
warrant their own table).
Hi, Rachel,
It seems most people have missed this message.
Since you didn't give enough information in your question, in order to answer
your question, I need to make up some assumptions, which might or might not be
correct :-(
Suppose the same favsub could appear in either or both tabl
Good point. However, I disagree with you on
fundemental points. Subsystems within an application
should remain indepedant for a easier maintanance and
better software development process.
Here we have a multi tiered system whereby the
database can't guarantee it's integrity without good
client
I just decided to use my.cnf and bumped into this error message
030729 22:04:22 mysqld started
InnoDB: Error: data file /usr/local/mysql/data/ibdata1 is of a different size
InnoDB: 81024 pages (rounded down to MB)
InnoDB: than specified in the .cnf file 16384 pages!
InnoDB: Could not open data f
Petre,
What I think you want is,
For each main, with at least one fof,pub... in the date range,
a row with the id and for fof,pub a value within range or null
What you are probably getting is,
For each main, with at least one fof,pub... in the date range,
several rows, where fof,pub
Well said Dan. While foreign keys, cascades and built-in transactions are
convenient, atomicity and referential integrity are readily attained by
proper implementation and the appropriate code.
Setting buffers,dirty flags and commit functions really is the
responsibility of the applicatio
Nick,
- Original Message -
From: "Nick Arnett" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, July 30, 2003 1:24 AM
Subject: RE: Really slow shutdown with Innodb, db not accessible?
> FYI, as I looked at the code that led up to this, I h
FYI, as I looked at the code that led up to this, I have realized that MySQL
was doing a huge rollback, which ended up taking about five hours. It was
rolling back about 2 million INSERTs, I think. The rollback really was not
necessary, so I've changed the appropriate code so that it's no longer
Hello mysql,
mysql version: 4.0.14-standard for linux
linux kernel: 2.4.21
mysqladmin -umef -p shutdown
Enter password:
./bin/mysqld_safe: line 1: 31500 Segmentation fault nohup
/usr/local/mysql/bin/mysqld --defaults-file=/var/lib/mysql/my.cnf
--basedir=/usr/local/mysql --datadir=/var/lib/my
* Petre Agenbag
> I'm trying to return from multiple tables, the records that have field
> "information_sent" between two dates.
> The tables are all related by means of the id of the entry in the main
> table, ie..
>
> main
> identity_name ...
>
> fof
> id_fofid information
In the last episode (Jul 29), b b said:
> Most web hosting companies run the mysql standard. Which means one
> can't run transactions. If that is the case, then how do you handle
> many to many relationships with truely normalized manner without
> risking data corruption
>
> For example: You have
In the last episode (Jul 29), Peter L. Berghold said:
> On Tue, 2003-07-29 at 15:19, azamka wrote:
> >
> > [EMAIL PROTECTED] usr]# mysql security < select * from machine;
> > -bash: select: No such file or directory
> >
>
>
> EEK! What you told the shell to do was open a file called "select" a
> -Original Message-
> From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 29, 2003 12:58 PM
> crash recovery is usually much faster than purge and merge.
>
> Killing the mysqld process is a legal (and the fastest :)) way of shutting
> down InnoDB.
That's good to hear. W2
Hi.
Have one table with FIXED row length.
Table name: "thetable".
Field 1: MemID (mediumint). (relates to another table members)
Field 2: TheID (smallint).
Primary key: MemID, TheID.
Lots of fields. Fixed table length.
I want to make it possible for users to search for records in this table
relat
On Tue, 2003-07-29 at 15:19, azamka wrote:
>
> [EMAIL PROTECTED] usr]# mysql security < select * from machine;
> -bash: select: No such file or directory
>
EEK! What you told the shell to do was open a file called "select" and
redirect it to mysql.
What you meant to do was "echo 'select * fr
Most web hosting companies run the mysql standard.
Which means one can't run transactions. If that is the
case, then how do you handle many to many
relationships with truely normalized manner without
risking data corruption
For example: You have an org, ctry tables and a
middle table orgCtry. T
Hi All;
These might be of interest to some on this list:
http://www.vbmysql.com/articles/microserverhp.html
I recently got my hands on a MicroServer HP by NorhTec in Calgary. It is an
interesting box and could be useful for certain MySQL related applications.
http://www.vbmysql.com/articles/my
Nick,
- Original Message -
From: ""Nick Arnett"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, July 29, 2003 8:54 PM
Subject: Really slow shutdown with Innodb, db not accessible?
> For the last four hours or so, I've been waiting for MySQL (4.0.12 on W2K)
> to co
azamka wrote:
I am trying to right sql statement on the shell prompt but its not going
through.
Here is the statement:
[EMAIL PROTECTED] usr]# mysql security < select * from machine;
-bash: select: No such file or directory
echo "select * from machine" | mysql security
or put your select s
Chris Nighswonger wrote:
>Hi All,
> Is it possible in MySQL to use UPDATE to update fields in one table with
>data from another table? For example, the following code seems to be the
>answer but fails with a syntax error in MySQL:
>
>UPDATE test_demo1.products SET nontaxable=(SELECT IMFSalesTax
Dermot Frost wrote:
Hi all,
I have a table with the following data:
++---+--+
| lpcval | smiles_id | crhash |
++---+--+
| 0.81 | 996 | 0597b6f84e0feaf9596869284e6e0
Sergei,
Thank you for the nice help.
> Try to experiment with bulk_insert_buffer variable. You need both big
> keycache and big bulk_insert_buffer.
I lowered key_buffer_size from 512M to 256M and increased bulk_insert_buffer_size
from 8M to 128M.
> When MERGE tables will support fulltext sear
I am trying to right sql statement on the shell prompt but its not going
through.
Here is the statement:
[EMAIL PROTECTED] usr]# mysql security < select * from machine;
-bash: select: No such file or directory
It is asking for the text file. And it works fine with the text file. I am
wondering
Hi, small but disturbing oddity, this.
I have a simple table:
CREATE TABLE musician (
musicianid int(10) unsigned NOT NULL auto_increment,
name varchar(60) NOT NULL default '',
PRIMARY KEY (musicianid)
) Type=MyISAM;
There are 50 or so lines in the table. I inserted 2 new
You could do it many different ways. Here's one that I would consider:
Create a table to store the business sections (buss_section) and a table to
relate the apps with the business sections (app_buss_section). The design
would abstract the app info from its usage and create a manageable table of
bu
The following is my guess, give it a try if you want:
Make sure that in your config file, "log-bin" isn't present, delete all
the log files, as well as the -bin.index file and restart MySQL.
I utilize my log files, so I can't say how to stop them totally.
--
Tony Evans
Webmaster/DNS Admin
We've been using MySQLD for a few years now quite happily. It's amazing
how well it performs. However, I have a minor issue, and I'm not sure how
to deal with it. I've scoured the manual, searched list archives, the
web, etc., and am coming up empty.
Somehow, the server is recording the Binary
I'm using Slackware GNU/Linux 9.0 on an Intel PII 266 machine that's SMP
capable, but only with one CPU installed, and 64MB of RAM. It's
basically a small test system that I play around with in some free time
before installing things on my larger systems.
I am trying to do a fresh install of MySQL
the configure command for courier-imap is the ff:
./configure --prefix=/usr/lib/courier-imap --with-authmysql --without-pgsql
--with-mysql-libs=/usr/local/mysql/lib --with-mysql-includes=/usr/local/mysql/include
the actual errors are the ff:
configure: error: --with-authmysql specified but no mys
I installed the 4.1 alpha release, which I probably shouldn't have, but I did because
the 4.0 was giving me access denied error (before I found your mailing list). However
my problem got complicated because I installed this on a server which would eventually
be a web mail server. So I installed
Make sure your firewall isn't blocking port 3306 (the default tcp port)
on localhost (127.0.0.1). Firewalls DO matter.
> I have tried to install mysql 4.0.14 and previous version on my machine.
>
> After installation when I try to run mysql, i get error:
>
> "Cannot connect to localhost port..."
This is, as you guess, a very basic issue for relational databases. You
never want to put multiple entries in one column, as you describe it.
That's the scenario in which you create another table and use a key to join
the two. For your project, you should have a column in the nms_apps table
that
For the last four hours or so, I've been waiting for MySQL (4.0.12 on W2K)
to complete a shutdown. The fast shutdown flag is not set
(innodb_fast_shutdown=0), so I assume it is doing a purge and merge... but
in the meantime, I don't have any access to the server -- clients simply
can't connect. T
Hello,
DB novice checking in here with a basic design
question. I have a table called 'nms_apps' which
stores information about all of our applications which
we have developed/maintained for our client. One
column which I would like to use is called 'used_by',
which would store information about
Karam
If your installed MySQL version supports sub-query, try this:
Delete your_table t
where (t.email, t.version) not in
( select s.email, min(s.version)
from your_table s
group by s.email
)
Hope this helps.
Lin
-Original Message-
From: Karam Cha
Hi!
On Jul 29, Niels Larsen wrote:
> Sergei,
>
> I had two columns indexes of type BTREE where the .MYI file was ~5 gb.
> Then I decided to drop one of them and replace it with a fulltext index. The
> dropping took 4 hours and fulltext indexing also 4 hours. There were about
You should've done i
Hi,
When installing the mysql4 binary it works fine. When
installing the mysql max4 binary I get the following
message when I try to run mysqld_safe. I am running
linux redhat 9.1. Would anyone know why this is
happening?
030728 23:54:57 mysqld started
030728 23:54:58 bdb:
/usr/local/mysql/d
Hi All,
Is it possible in MySQL to use UPDATE to update fields in one table with
data from another table? For example, the following code seems to be the
answer but fails with a syntax error in MySQL:
UPDATE test_demo1.products SET nontaxable=(SELECT IMFSalesTax FROM
IDX.InvMasFile);
Here th
Sorry, I maight not have been clear about what I wrote, there is only
one user account in mysql and that user is ola, I was saying that
username Administrator only exist in Windows 2000 Server and not in
MYSQL, and that because each time, I log into the PC as Administrator
and not as user ola who i
Hi!
On Jul 29, Sigurd Urdahl wrote:
> "Matthew McNicol" <[EMAIL PROTECTED]> writes:
>
> > The recommended way to quickly check all tables is:
> >
> > myisamchk --silent --fast /path/to/datadir/*/*.MYI
> > isamchk --silent /path/to/datadir/*/*.ISM
>
> I thought the recommended way was using CHEC
Hi,
When installing the mysql4 binary it works fine. When
installing the mysql max4 binary I get the following
message when I try to run mysqld_safe. I am running
linux redhat 9.1. Would anyone know why this is
happening?
030728 23:54:57 mysqld started
030728 23:54:58 bdb:
/usr/local/mysql/d
Hi all,
I have a table with the following data:
++---+--+
| lpcval | smiles_id | crhash |
++---+--+
| 0.81 | 996 | 0597b6f84e0feaf9596869284e6e0660 |
| 0.86 |
If your query has worked in one account, but not in another, then your 1064 error is
probably related to privileges granted to the second account.
HTH
>>> "Ola Ogunneye" <[EMAIL PROTECTED]> 07/29/03 09:08AM >>>
I am running mysql 4.0.13 and using a weblog(Geeklog) to do my web.
Using geeklog as
I have tried to install mysql 4.0.14 and previous version on my machine.
After installation when I try to run mysql, i get error:
"Cannot connect to localhost port..."
my machine is not connected to internet. I also have firewall installed on my
machine, but this should not matter.
Any suggest
"> I thought the recommended way was using CHECK/ REPAIR TABLE from
> inside mysql for the supported backends? Also, (my)isamchk can't be
> run while the database is running, can it? (I might be confused here)"
I'm just reading from the manual... it's not totally clear... perhaps
someone else will
On Tue, 29 Jul 2003, Dyego Souza do Carmo wrote:
>
>I would like to know if you could fix the bug I reported to you
>some days ago.
>
>The error is: "ERROR 1030: Got error 139 from table handler" after
>running an update command using several blobs.
>
>Now I am using mySql 4.0.1
"Matthew McNicol" <[EMAIL PROTECTED]> writes:
> The recommended way to quickly check all tables is:
>
> myisamchk --silent --fast /path/to/datadir/*/*.MYI
> isamchk --silent /path/to/datadir/*/*.ISM
I thought the recommended way was using CHECK/ REPAIR TABLE from
inside mysql for the supported b
Dyego,
but now it works right.
[EMAIL PROTECTED]:~/mysql-standard-4.0.8-gamma-pc-linux-i686/bin> perror 139
Error code 139: Unknown error 139
139 = Too big row (>= 16 M)
The error message text above is wrong, though :). This has nothing to do
with 16 MB.
You should not put THAT many BLOBs in t
In the last episode (Jul 29), Asif Iqbal said:
> On my E420R with 4 x 450MHz and 4 gb mem what mysql variables should I need to
> play with to improve the following output
>
> mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye"));
> +--+
> | BENCHMA
Since you are putting a wild card at the front of the phrase, indexes
can't be used. You definitely want to change that to a full text index
if you want to search on words or phrases contained in a field.
I use a full text search on a database with 15k records and growing.
Each record contains
On my E420R with 4 x 450MHz and 4 gb mem what mysql variables should I need to
play with to improve the following output
mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye"));
+--+
| BENCHMARK(100,ENCODE("hello","goodbye")) |
+-
Hi all,
i want to know if the system parameter somaxconn affect the capabalities
of MySQL
to maintain more than five thousands of HTTP connections ?
If so , any clarifications may help.
think in advance
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
The recommended way to quickly check all tables is:
myisamchk --silent --fast /path/to/datadir/*/*.MYI
isamchk --silent /path/to/datadir/*/*.ISM
that's from the mysql manual, sectio 4.4.6 Using myisamchk for Table
Maintenance and Crash Recovery
- Original Message -
From: "Sigurd Urd
In the last episode (Jul 29), Asif Iqbal said:
> Now I am running these processes for my mysql serever
>
> /bin/sh /usr/local/mysql/bin/safe_mysqld --datadir=/usr/local/mysql/data
> --pid-file=/usr/local/mysql/data/webrt.pid
>
> /usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc/bin/mysqld
> -
I need to do CHECK TABLE on a lot of tables (actually on all tables in
several databases), and hoped to do something like
mysql> CHECK TABLE reports.*
which ddn't work. The only thing that seems to work is using
cut'n'paste (or some scritpting) to get a comme seperated list. Is
there rea
Hi List
Me again.
I'm trying to return from multiple tables, the records that have field
"information_sent" between two dates.
The tables are all related by means of the id of the entry in the main
table, ie..
main
id entity_name ...
fof
id_fof id information_sent ...
pub
id_pub
Hi
I have a varchar field to search. There are 5k records.
I'm using: WHERE name LIKE '%outer banks%'
It seems to be very slow. I was reading about full text searches.
Maybe I could do something like: WHERE MATCH ('name') AGAINST ('outer
banks')
I'm looking for a quick way to search.
Does an
Richard Bolen wrote:
This gives the count per job which is always 1.
Oops! Quite right. I don't see a way to get the total off-hand.
Bruce
-Original Message-
From: Bruce Feist [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 7:42 PM
To: Richard Bolen
Cc: [EMAIL PROTECTED]; [EM
This gives the count per job which is always 1. I'm using the 'having'
clause which requires the 'status' field in the select list. This makes
it difficult to get a total. I'll play with the 'where' clause example
to see if that works.
Thanks again!
-Original Message-
From: Bruce Feist
I give in my slave PC a file privilege in the same user as the master but
there is still error in my log file. Deferent these time:
Slave: connected to master '[EMAIL PROTECTED]:192', replication started in
log 'FIRST' at position 4
Error reading packet from server: Binary log is not open (server
I am running mysql 4.0.13 and using a weblog(Geeklog) to do my web.
Using geeklog as been okay until I tried creating moderators to my forum
and then I got the following error:
1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right
Hi,
I would like to know if you could fix the bug I reported to you
some days ago.
The error is: "ERROR 1030: Got error 139 from table handler" after
running an update command using several blobs.
Now I am using mySql 4.0.15 and Linux. If you try to do the same
with mySql 4.0.1
Try never to use formulas or functions in your WHERE clause, indexing
can't be used if you have to perform a function on field data first. It
looks like you are trying to filter on the id, so you shouldn't be
using concat and substring in your filter. Change you WHERE clause to
look like th
b b <[EMAIL PROTECTED]> wrote:
> 030728 23:54:58 bdb:
> /usr/local/mysql/data/log.01: Permission
> denied
> 030728 23:54:58 bdb: PANIC: Permission denied
do chown -R mysql.mysql /usr/local/mysql as root.
Replace user/group by appropriate.
--
For technical support contracts, goto
"Andrew L. Davydov" <[EMAIL PROTECTED]> wrote:
>I have a 2xPIV Xeon box under RedHat 8 system and want to
> use mysql 4.0.14. How I should setting mysql for best perfomance ?
First, you should download the official binary release from
http://www.mysql.com/
Then, there is nothing so speci
Wakan <[EMAIL PROTECTED]> wrote:
> is there a way to obtain only the affected columns after an update query?
Instant answer: no. You could do some selects and compare the difference.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensi
"powercola" <[EMAIL PROTECTED]> wrote:
> hello
>
>I have a OpenBSD3.3 box ,defautl installed, with mysql-server 4.0.13, the
> mysql-server runs normally at the beginnig . Trouble come up these days that the
> mysqld server will down , and will come up sometimes but can not some other tim
MaFai,
>> But the ip address would change too
If this system is running on a LAN why would it be a problem to change
the DNS or are you trying to connect other clients (e.g. from the web?)
- Andy
MaFai wrote:
>
> Hello, mysql,
>
> We have 1 master and salve in my lan.
>
> If the master failed,c
> rpm -ivt MySQL-server-4.0.13-0.i386.rpm
> returns " Only one major mode may be specified "
this message is from the rpm utility and means that is it not being used
correctly, there is no problem with mysql.
maybe just try "rpm -i MySQL-server-4.0.13-0.i386.rpm"
- Original Message -
I haven't seen anything in the mysql manual that will give you that
information (to the best of my knowledge).
You might have to do a get before the update and compare the fields
manually.
An elegant solution would be to use table triggers but this functionality is
not yet available in mysql.
myisamchk is another option
see 4.4.6 Using myisamchk for Table Maintenance and Crash Recovery in the
mysql manual
- Original Message -
From: "Cecil Brand" <[EMAIL PROTECTED]>
To: "<" <[EMAIL PROTECTED]>
Sent: Tuesday, July 29, 2003 10:30 AM
Subject: Rebuilding Indexs on tables
> H
Hello!
I have a 2xPIV Xeon box under RedHat 8 system and want to
use mysql 4.0.14. How I should setting mysql for best perfomance ?
--
Mr. Andrew L. Davydov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROT
HI,
is there a way to obtain only the affected columns after an update query?
After an update query, that involves 10 columns, I know that only 2 columns are
really updated (because the values of the other cols don't change).
I need to know the names of that changed cols, for logging purpose.
Someo
Hi,
join two tables in your select. Might look like
insert into mm_tagrules
select ID, 'NIL', 'D' from mm_Tag
left join mm_tagrules on mm_Tag.ID = mm_tagrules.Tagid
where mm_tagrules.Tagid IS NULL;
Regards,
Thomas Spahni
On Tue, 29 Jul 2003, jsmurthy wrote:
> Hello All,
>
> I need to
Hello,
Am Dienstag, 29. Juli 2003 11:15 schrieb ΝΙΚΟΣ ΓΑΤΣΗΣ:
> Hello.
> I have MySQL 3.23.41 on a RH-7.2 Linux used as local server.
> I'm trying to replicate the databases from server (192.168.0.1) to another
> linux PC (192.168.0.3).
> Following the manual, i grant to the master a user with fil
Iulian,
take the source code, go to 'sql/share/charsets' and create your own
character set 'romanian.conf' departing from 'latin2.conf' (or whatever is
closest to what you need).
Regards,
Thomas Spahni
On Mon, 28 Jul 2003, Primaria Falticeni wrote:
> Hello,
>
> Simply I made a table with romani
Hi,
I was wandering is there an easy way to rebuild indexs on tables
I have the .frm and .MYD files.
I read in the mysql manuals about backup_tables and Restore_table that
rebuild the index but
is there any other way to rebuild them.
I'm using Mysql 3.23.53a
on linux 2.1 AS
thx
Cecil
Mnr Ceci
HI,
is there a way to obtain only the affected columns after an update query?
After an update query, that involves 10 columns, I know that only 2 columns are
really updated (because the values of the other cols don't change).
I need to know the names of that changed cols, for logging purpose.
Someo
Hello.
I have MySQL 3.23.41 on a RH-7.2 Linux used as local server.
I'm trying to replicate the databases from server (192.168.0.1) to another
linux PC (192.168.0.3).
Following the manual, i grant to the master a user with file privileges, and
edit both my.cnf files.
The master starts fine but the
I have read in past postings that UTF8 is not yet working with MySQL 4.1 on the
Windows build.
Can anyone verify this?
If it is not yet working, can anyone give an estimate when a build will be available
that should work?
thanks, Jon
Hello, mysql,
We have 1 master and salve in my lan.
If the master failed,coze the unrecoverable disaster.
At that time,I want to make the slave to be the master instead of the orginial one.
Do you agree my
HI,
is there a way to obtain only the affected columns after an update query?
After an update query, that involves 10 columns, I know that only 2 columns are
really updated (because the values of the other cols don't change).
I need to know the names of that changed cols, for logging purpose.
Someo
Hello All,
I need to insert into mm_tagrules table from mm_tag table, in the
following way. I am using mysql 4.0.12 version. But Mysql is not supporting
subqueries. Can any one help mysql query for the following query.
insert into mm_tagrules
select ID, 'NIL', 'D' from mm_Tag where mm_Tag
you need at least 3 fields
CategoryID
ParentID
Name
CategoryID is the key, and identifies the category
ParentID is the CategoryID of the parent category
Name is the category name
When you add a sub category you set its ParentID to the CategoryID
To show all sub categories of CategoryID 99
SEL
SELECT * FROM TABLE
if( mysql_num_rows() == 0) table is empty
HTH
Peter
-Original Message-
From: D. K. [mailto:[EMAIL PROTECTED]
Sent: 29 July 2003 08:12
To: [EMAIL PROTECTED]
Subject:
Hello List;
I am developing a php-mysql application for my term project at school and
this is where
Hi List,
My head is not on right today.
I have something like this:
main_table
id namemain_type
1 joe type1
2 johntype2
3 jacktype1
table type1
id_type1id action
1 1 2003-07-01
2 1 2003-08-03
3
Greetings
I have a table with the following table structure -
mysql> desc email_table;
+-+---+---+--+-+-+---+
| Field | Type | Collation | Null |
Key | Default | Extra |
+-+---+---+-
1 - 100 of 106 matches
Mail list logo