There is only one thread for replication on the slave. It does one step a
time. If you use mysqlbinlog on one of your binary files on your master,
you will see exactly how it all works.
Multi-threaded would probably cause thousands of problems. Unless it was
threaded per table, but that would s
Hi,
I have 2 DB server, running as master and slave. I just add an index to
one of my table on master, it took about 12 minutes. During adding the
index, I have insert/update queries to other tables. On master this has
no problem at all. The problem is, on slave these queries were blocked
by the p
This leads me to another question. What are the valid
ASCII characters that XML parser understands.
Are they only a-1,A-Z,0-9,., etc or some other
characters.
Regards,
Karam
--- Karam Chand <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Hmmm. I was figuring that out. mysql_escape_string()
> only esca
Hello,
Hmmm. I was figuring that out. mysql_escape_string()
only escapes characters like \r, \n, \\, 0 etc. it
still keep other non-character data same like it keep
ascii 15 to ascii 15 that no parser is able to handle.
Isnt there any better way then base64 to handle this.
Just like replacin < to
On Wed, 11 Aug 2004, Jeremy Rice wrote:
> > ./configure --prefix=/usr/local --sysconfdir=/etc/mysql
> > --localstatedir=/var --enable-shared --enable-static --with-libwrap
> > --with-berkeley-db --enable-thread-safe-client --with-mysqld-user=mysql
> > --with-openssl --with-openssl-includes=/usr
Hello,
You can try SQLyog at http://www.webyog.com/ .
Its not free but it has got some really powerful
features.
Regards,
Karam
--- "Kirti S. Bajwa" <[EMAIL PROTECTED]> wrote:
>
> This is my first attempt to design and test MySQL. I
> have used MS SQL for
> number of years. I do appreciate i
Michael Stassen wrote:
What hardware and OS?
How did you get and install mysql? MySQL supplied binary? 3rd party
binary? Built from source? If the answer is not "MySQL supplied
binary", my first suggestion would be to try that to see if the problem
goes away.
Michael
That did end up being the
Bump
Mysql 4, this has been bothering me for some time now...
I made a mailing list archiver, I "thread" discussions by subject. I chose
to not use message-id's since so many people hijack threads. In most cases,
I ORDER BY id, which is simply a auto-inc that is set as they come in, in
orde
I am 100% convinced that mysql 4.1.3 beta is not properly reading the my.cnf
configuration files. If i remove the /etc/my.cnf file and try to start mysql
4.1.3 with (im working from /usr/local/mysql-4.1.3/bin)
> ./mysqld_safe
i get the following output: (mccoy is the name of the machine im on)
Hi Sean,
Have you checked the pid file? Have you given it a unique path for this
server?
Regards
David Logan
Database Administrator
HP Managed Services
139 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
F
I am trying to run two different MySQL server versions on the same solaris
machine. I already have a 4.0.2 running, and i have successfully installed
4.1.3 beta. I ran mysql_install_db successfully (after setting
LD_LIBRARY_PATH), but when i try to run
>mysqld_safe --user=mysql &
I get the err
Hi,
I am having trouble trying to figure out the reason of this. The query (explained) is:
EXPLAIN SELECT * FROM news,users WHERE news.user_id=users.user_id ORDER BY date DESC
I divided the result table in two parts to improve readability:
++-+--+--+---
At 14:40 -0700 8/12/04, V. M. Brasseur wrote:
Paul DuBois wrote:
At 8:06 -0700 8/12/04, V. M. Brasseur wrote:
Paul DuBois wrote:
At 13:03 -0700 8/11/04, V. M. Brasseur wrote:
Assuming a my.cnf file which looks like this:
[client]
port=3306
socket=/path/to/mysql.sock
[app]
user=appuser
p
Paul DuBois wrote:
At 8:06 -0700 8/12/04, V. M. Brasseur wrote:
Paul DuBois wrote:
At 13:03 -0700 8/11/04, V. M. Brasseur wrote:
Assuming a my.cnf file which looks like this:
[client]
port=3306
socket=/path/to/mysql.sock
[app]
user=appuser
password=apppwd
host=my.host.com
Ignore for n
At 8:06 -0700 8/12/04, V. M. Brasseur wrote:
Paul DuBois wrote:
At 13:03 -0700 8/11/04, V. M. Brasseur wrote:
Assuming a my.cnf file which looks like this:
[client]
port=3306
socket=/path/to/mysql.sock
[app]
user=appuser
password=apppwd
host=my.host.com
Ignore for now the insecurity o
What else is in the my.cnf file? For instance, when I run `mysqld
--print-defaults` on my system I see this:
mysqld would have been started with the following arguments:
--basedir=/path/to/mysql-4.0 --datadir=/path/to/mysql-4.0/data
--port=1032 --socket=/path/to/mysql-4.0/mysql.sock --user=user
Are you sure that the server is using the my.cnf file which you are
changing? After making the change, what is the output of
--print-defaults for mysqld? If it's not as expected, odds are good
that the server is getting its defaults from a different location.
--V
[EMAIL PROTECTED] wrote:
Hi a
Wow, thanks Brent, nice to learn something new (I'm not much of a 'server' guy)
Tried the iostat and got some results while performing a general query:
mysql> SELECT count(*) FROM product_fulltext WHERE MATCH(search_text) AGAINST('DISK');
+--+
| count(*) |
+--+
| 4975 |
+--
INTERSECT sound very much like UNION DISTINCT
(http://dev.mysql.com/doc/mysql/en/UNION.html) because this query should
give you what you asked for and is very similar to yours:
(SELECT ID_ENTRY FROM table WHERE ID_AGE = 1)
UNION DISTINCT
(SELECT ID_ENTRY FROM table WHERE ID_AGE=2)
However, I ca
Grumble, grumble. I was hoping vmstat would tell us more. In a
"nutshell", every system has a bottleneck and the bottleneck is always
CPU, RAM, I/O or Network. Nutshells are great since they make things
seem so simple. You've got a 1 in 4 chance sf picking the right piece
that is your bottlenec
If you are using a MyISAM table type, the entire table is either locked or
it isn't. Normally this isn't a problem most statements happen quickly.
However, yours takes a couple of hours to finish so the entire table has
to stay locked until your statement completes.
The way I see it, you have o
Hi all:
I am running MySQL 4.1.3 under Debian. I have the problem that my
options in my.cnf are not going into effect. I want to increase
max_heap_table_size from the default of 16M to 400M (I have 4GB of
memory), but putting that line into my.cnf doesn't do anything. (Yes
it is in the mysq
Karam Chand wrote:
i have a table with a LONGBLOB column. We store some
small images in it. I want to export them in XML
format with schema like:
data
data
...
...
Now the problem is even if I mysql_real_escape() and
changing entities like <,> to < & > the data
some of the characters are of ascii v
Michael Stassen wrote:
What hardware and OS?
Pentium II 300, 192 MB RAM, almost-brand-new 80GB hard drive, running Gentoo
Linux (kernel 2.4.25-gentoo).
How did you get and install mysql? MySQL supplied binary? 3rd party
binary? Built from source? If the answer is not "MySQL supplied
binary",
What hardware and OS?
How did you get and install mysql? MySQL supplied binary? 3rd party binary?
Built from source? If the answer is not "MySQL supplied binary", my first
suggestion would be to try that to see if the problem goes away.
Michael
Matt Winckler wrote:
Hi,
I'm running into trouble
Mayuran Yogarajah wrote:
From the MySQL docs:
Each |MyISAM| table is stored on disk in three files. The files have
names that
begin with the table name and have an extension to indicate the file
type.
An `.frm' file stores the table definition. The data file has an `.MYD'
(MYData) extension. The
matt ryan wrote:
SQL is, replace delayed into table c1, c1, c3 select c1, c2, c3 from
temp table.
This takes 2 hours to comlete, the temp table is rather large.
The table being updated is locked, the whole time, all web requests
are locked and the pages time out.
Is there any way to get this t
Jeff Meyer wrote:
I have the following table:
+-+-+
| ID_AGE | ID_ENTRY |
+-+-+
| 1 | 1 |
| 1 | 4 |
| 1 | 5 |
| 2 | 1 |
| 2 |
hi all. In my struggles to buildl MySQL 4.1.3deta, i read a lot of online
documentation, and in the process i found a lot of info about various
configure flags in writeups all over the web. One problem i encountered, that
i finally figured out was that some documentation names the flag
--with-e
Thanks for the vmstat tip. I ran vmstat 1 on the query on a slightly quicker query so
I wouldn't have a ton of numbers to post from the vmstat.
mysql> SELECT COUNT(*) FROM product_fulltext WHERE MATCH(search_text) AGAINST('Pink');
+--+
| COUNT(*) |
+--+
|12231 |
+--+
1
I have the following table:
+-+-+
| ID_AGE | ID_ENTRY |
+-+-+
| 1 | 1 |
| 1 | 4 |
| 1 | 5 |
| 2 | 1 |
| 2 | 2 |
|
I would suggest DBDesigner available on
http://www.fabforce.net/
-Mensaje original-
De: Kirti S. Bajwa [mailto:[EMAIL PROTECTED]
Enviado el: Jueves, 12 de Agosto de 2004 12:09 p.m.
Para: '[EMAIL PROTECTED]'
Asunto: GUI for MySQL
This is my first attempt to design and test MySQL. I ha
Kirti
Have a look at the free DBManager Pro from DBTools :
http://www.dbtools.com.br/EN/dbmanagerpro.php
Freddie
> -Ursprüngliche Nachricht-
> Von: Kirti S. Bajwa [mailto:[EMAIL PROTECTED]
> Gesendet: Donnerstag, 12. August 2004 20:09
> An: '[EMAIL PROTECTED]'
> Betreff: GUI for MySQL
>
This is my first attempt to design and test MySQL. I have used MS SQL for
number of years. I do appreciate if members of this list can recommend a
good GUI application for MySQL. I want the GUI application to design DB,
design Quiries, etc.
Thanks.
Kirti
--
MySQL General Mailing List
For list
At 11:07 AM 8/12/2004, David Perron wrote:
Im looking for a way to output a file into true CSV format (with quoted
fields) using the Perl DBI.
Does anyone know of a way to do this (in either native MySQL or Perl)?
Thanks as always!
You could try DBD::CSV http://search.cpan.org/search?query=DBD%3A%
Those times shouldn't be that far apart. What is the hardware (RAM,
CPU, etc.) and OS you are running this on? Is there anything else
running on it that might be causing memory to page out?
If you are running Unix, try running: vm_stat 1
That will show you memory stats every second. Watch the
You can use mysqldump with the --fields-terminated by= option.
-Original Message-
From: David Perron
To: [EMAIL PROTECTED]
Sent: 8/12/04 1:07 PM
Subject: CSV Output
Im looking for a way to output a file into true CSV format (with quoted
fields) using the Perl DBI.
Does anyone know of a
As is the case for all things Perl, CPAN is your answer:
http://search.cpan.org/~alancitt/Text-CSV-0.01/CSV.pm
NAME
Text::CSV - comma-separated values manipulation routines
SYNOPSIS
use Text::CSV;
$version = Text::CSV->version(); # get the module version
$cs
Hi,
I'm running into troubles trying to connect to MySQL (version 4.0.18) via
TCP/IP. Connecting on the actual machine via Unix sockets works just
fine--it's solid as a rock. But as soon as I attempt to connect via TCP
(from either the local machine or a remote machine), mysqld crashes and I
get th
Check it out
mysql> start slave;
Query OK, 0 rows affected (0.00 sec)
mysql> start slave;
ERROR 1198: This operation cannot be performed with a running slave, run
SLAVE S
TOP first
mysql> start slave;
ERROR 1198: This operation cannot be performed with a running slave, run
SLAVE S
TOP first
mysql
Im looking for a way to output a file into true CSV format (with quoted
fields) using the Perl DBI.
Does anyone know of a way to do this (in either native MySQL or Perl)?
Thanks as always!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
SQL is, replace delayed into table c1, c1, c3 select c1, c2, c3 from
temp table.
This takes 2 hours to comlete, the temp table is rather large.
The table being updated is locked, the whole time, all web requests are
locked and the pages time out.
Is there any way to get this to run without lock
Hello,
i have a table with a LONGBLOB column. We store some
small images in it. I want to export them in XML
format with schema like:
data
data
...
...
Now the problem is even if I mysql_real_escape() and
changing entities like <,> to < & > the data
some of the characters are of ascii value 12,1
I deleted every table off the slave, and reloaded them, I do this twice
a week because it wont replicate
The master server has a check & optimize every sunday
I had a similar situation one week ago. Found one of the tables (MyISAM) had a
corrupt index. After fixing it, everything was fine again.
Anyone know how to use access as front end for accessing blobs in mysql.
I have found some sample code for storing blobs in mysql, but for
whatever reason when I export the tables to mysql and link them it stops
working. Even though the blobs remain and can be accessed without
corruption from o
From the MySQL docs:
Each |MyISAM| table is stored on disk in three files. The files have
names that
begin with the table name and have an extension to indicate the file type.
An `.frm' file stores the table definition. The data file has an `.MYD'
(MYData) extension. The index file has an `.MYI' (
Thanks for all your help guys,
Using COUNT(*) I get the following:
mysql> SELECT COUNT(*) FROM product_fulltext WHERE MATCH(search_text) AGAINST('blue
jeans');
+--+
| COUNT(*) |
+--+
|51513 |
+--+
1 row in set (48.58 sec)
The EXPLAIN for the fulltext queries look like
I have some large tables (hundreds of millions of rows) that are extremely
active. They have heavy read and heavy modify activity. But, all
modifications are only on recent records (data added within the last month
is very volatile, but data earlier than that never changes).
We use the InnoDB en
El Jueves, 12 de Agosto de 2004 09:22, matt ryan escribió:
> I cant keep the slave up for more than 10 minutes
>
> constantly getting these errors
>
> 040812 10:32:25 Error reading packet from server: binlog truncated in
> the middle of event (server_errno=1236)
> 040812 10:32:25 Got fatal error
If you really want to test the raw query speed, then do a SELECT
COUNT(*). That will return just a count of the number of records found,
eliminating any speed issues caused by display processing or transfer
speeds from the database to the interface. Adding a limit usually
speeds things up since
Victor Pendleton wrote:
Can you reset the slave to read the next event its relay log? If this is not
possible, is refreshing the data from the master a viable option?
I can start slave, and it runs a little while, then stops again.
I can refresh the data from the master, iv'e done it 25 times at
Nope, no idea why it crashed, and I don't know enough about redhat to bother
investigating.
It seemed to hang so it got a kick, when it came backup was bit screwy... so
far this has been only problem. It's only a dev box so I'll keep my fingers
crossed it's a freak occurrence :)
chris
-Ori
Can you reset the slave to read the next event its relay log? If this is not
possible, is refreshing the data from the master a viable option?
-Original Message-
From: matt ryan
To: [EMAIL PROTECTED]
Sent: 8/12/04 10:22 AM
Subject: Help, slave wont stay running!
I cant keep the slave up f
I'd go along with that recommendation.
Terry
- Original Message -
> Welling & Thomson is terrific.
> - Original Message -
> From: Kerry Frater
> To: "MySQL List"
> Sent: Thursday, August 12, 2004 8:09 AM
> Subject: recommended books for web app.
>
>
> I am looking t
Jeroen,
One minor caveat here. You are grouping by gene_name, but selecting
non-aggregate values from the chr and strand columns. Since they aren't
part of the list of grouped columns, you'll get effectively randomly chosen
values (probably the first found per group) for each from among the po
I cant keep the slave up for more than 10 minutes
constantly getting these errors
040812 10:32:25 Error reading packet from server: binlog truncated in
the middle of event (server_errno=1236)
040812 10:32:25 Got fatal error 1236: 'binlog truncated in the middle
of event' from master when readin
This line probably should have been a good hint:
>>InnoDB: File operation call: 'tmpfile'.
Any idea why the server crashed in the first place? That's not the sort
of thing you want just randomly happening, I'd imagine. Although it
might make life a bit more interesting...
Cheers.
--V
Chris Bla
Paul DuBois wrote:
At 13:03 -0700 8/11/04, V. M. Brasseur wrote:
Assuming a my.cnf file which looks like this:
[client]
port=3306
socket=/path/to/mysql.sock
[app]
user=appuser
password=apppwd
host=my.host.com
Ignore for now the insecurity of putting a password in the my.cnf
file. T
It would probably be better to post this to the Lasso
discussion list at Blueworld.com as for Lasso, this
will require you to use tags but it's been ages since
I coded with Lasso (3.6 and FileMaker. :) and I
can't recall/never knew, the tag modifications.
Good luck
--- maggie chloe <[EMAIL PROTE
The problem you point out is one of the reasons this isn't the best way to
organize your data. A better way would be to keep your events table:
events
event_id
event_name
event_description
but properly normalize the sequences table by putting one event per row like
this:
table sequenc
Hi Brent,
Oops, sorry about forgetting to post the key buffer size, its:
> key_buffer_size 262144000
As far as the "combined column" I'm using, I did it to make the fulltext as simple as
possible and keep the index at only 1 column. I am aware that I can create an index
for multiple columns but
I have resolved this issue now, it was actually the permission on /tmp that
had become corrupted as a result of the crash I can only assume
chmod 777 /tmp
chmod +t /tmp
this fixed the problem
but could have been fixed within minutes not days if the error message had
told me which directory was
On your two word plus searches, `New York` for example, have you tried using
`IN BOOLEAN MODE` to reduce the number of false positives?
AGAINST("New York" IN BOOLEAN MODE)
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/12/04 8:33 AM
Subject: RE: Fulltext Search ta
It's not one from your list but I can recommend you this one:
http://www.oreilly.com/catalog/webdbapps2/index.html
Gives you a nice overview about PHP/MySQL and a nice case study which
explains how to create a Online Winestore.
Regards
Olivier
-Ursprüngliche Nachricht-
Von: Peter Brawley
Thanks for your recommendation Peter
Kerry
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: 12 August 2004 14:23
To: Kerry Frater; "MySQL List"
Subject: Re: recommended books for web app.
Welling & Thomson is terrific.
- Original Message -
Hi Victor,
The fulltext index was created on 1 column only that is of type "text".
The benchmarks I get are very inconsistant...
SELECT product_id FROM product_fulltext WHERE MATCH ( search_text ) AGAINST ('China')
>Query took 20.17 seconds
SELECT product_id FROM product_fulltext WHERE MATCH
Missed your original message. What do you mean you concatenated the
columns you wanted to search on and placed them in a table? You should
just create the full text index on multiple columns. For instance, in a
contacts table, you may have firstname, lastname. So you would create a
full text in
Are you using InnoDB tables? If so, have you properly configured the
directories?
-Original Message-
From: Jevos, Peter
To: '[EMAIL PROTECTED]'
Sent: 8/12/04 6:02 AM
Subject: Problem after crash
Hello
Please help me. Im newbie in the database and I got one crash after
outage.
Now my mysql
Welling & Thomson is terrific.
- Original Message -
From: Kerry Frater
To: "MySQL List"
Sent: Thursday, August 12, 2004 8:09 AM
Subject: recommended books for web app.
I am looking to port an app from an existing web environment to MySQL. The
requirement is relatively easy.
Philippe, If he is pre-4 (I assume that as he does not seem to have the
GROUP_CONCAT() function) and UDFs aren't available until 5+, how exactly
would he do this as a UDF? :-D
Paul, I believe you are going to have to combine those fields during some
form of post-query processing (macro, script,
I am looking to port an app from an existing web environment to MySQL. The
requirement is relatively easy. The Tables are read only and the data is to
be only accessed via login & password. The login will give a limited view of
records based on a master/detail table relationship. I need to be aware
Keep in mind that it is not a ood idea to get (not sure how to get the last
value for auto_increment column) last id with a statement like "SHOW TABLE
STATUS". Because this will return allways the some for different connections
which might create problems for you. My point is. last_insert_id() retu
We Fulltext index multi million rows with very good response time. The
cardinality of `1` is okay. Did you fulltext index the rows as is or did you
create some sort of combined field?
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/12/04 7:43 AM
Subject: RE: Fullte
Encontré qué aparece ser una buena clase particular de MySQL de los
novatos en http://www.programatium.com/. Navega con Manuales - Bases de
Datos - MySQL y usted lo verá.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Yusdaniel Rodriguez Espinosa" <[EMAIL PROTECTED]> wro
Hmmm... looks like it may be impossible to do fulltext searching on 3 million rows as
few have chimed in on this one.
Just to add some background to my setup, I am currently running on MySQL 4.0.17 (plan
to upgrade soon.. will this help??) and I created the index that took 9 minutes to
process
Well actually I want it in a stored procedure. However due to a bug in
version 5.0.0 alpha (posted on the bugs database by me ID 5017) I cannot
get the LAST_INSERT_ID() in the stored procedures. So I want an
alternate way of getting LAST_INSERT_ID(). I thought auto_increment
column of SHOW table st
| Subject: Auto Increment Column
|
| Hi,
|
| Does anyone know how to extract only the Auto_Increment column from the
| command results of "SHOW TABLE STATUS"
Do you mean that you want a command that will run on the command line that
will show the value of the Auto_Increment column? Or are you try
Hi list
environment:
host:/ # uname -a
Linux host 2.4.19-4GB #1 Fri Sep 13 13:14:56 UTC 2002 i686 unknown
host:/ #
host:/ # /usr/local/mysql/bin/mysqld -v
/usr/local/mysql/bin/mysqld Ver 4.0.12-max for pc-linux on i686
host:/ #
an php application of ours prepares customer data on the screen in a
Well.. I had the same issue 2 weeks ago with another server from my
DC. I told them it was their hardware, they didnt believe it, so i had to
order a new
server, and ... The same problem occurs...
Thats like one on a million that its the hardware...
- Original Message -
From: "Egor Egoro
Hi,
Does anyone know how to extract only the Auto_Increment column from the
command results of "SHOW TABLE STATUS"
Regards
Naresh
--
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom
they are addressed.
If you hav
Hello
Please help me. Im newbie in the database and I got one crash after outage.
Now my mysql.server cant start. Im my log is nothing . And in err log in
database directory is:
**
040811 20:26:59 mysqld started
InnoDB: The first specifi
> -w, --where=nameDump only selected records; QUOTES mandatory!
>
> :)
The more options the merrier for MySQL and the end-users :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Aug 12, 2004, at 2:38, Issac Goldstand wrote:
What if a company hires me to build an application for them. They
already
have MySQL downloaded and installed. Do I/they need a license?
What if the software is open-source, but not free?
Hi Issac,
We always recommend that proprietary applications
Philippe Poelvoorde <[EMAIL PROTECTED]> wrote:
>>>If I am not running 4, is there another way to achieve the same result as
>>>GROUP_CONCAT(myField)
>>>?
>>
>> I don't think so. :(
>
> Except if you are ready to make a User-defined function to make a simple
> group_concat...
> http://dev.mysq
"Chris Blackwell" <[EMAIL PROTECTED]> wrote:
> now when ever i try to start mysql i get the following error in log
>
> 040812 09:52:34 mysqld started
> 040812 9:52:34 Warning: Asked for 196608 thread stack, but got 126976
> 040812 9:52:34 InnoDB: Error: unable to create temporary file
> 0408
"Feedback" <[EMAIL PROTECTED]> wrote:
> Besides that, the server has also a lot of trouble with the fact that =
> sometimes the MySQLd just stops functionizing somehow, and the only way =
> to kill the (all child processes broke down, so i mean the parent) =
> process is 'killall -9 mysqld'. 'kill
Egor Egorov wrote:
"Paul McNeil" <[EMAIL PROTECTED]> wrote:
If I am not running 4, is there another way to achieve the same result as
GROUP_CONCAT(myField)
?
I don't think so. :(
Except if you are ready to make a User-defined function to make a simple
group_concat...
http://dev.mysql.com/doc/m
"SciBit MySQL Team" <[EMAIL PROTECTED]> wrote:
> select * from accounts; -- as an example
>
> but because you can customize the source sql script for MyRun, you can go like:
>
> select * from accounts where AccountDate>YEAR(CURDATE()); --
>
> i.e. limit the inserts you going to get to that whic
Hi,
I have been running 4.1.3 on redhat9,
installed from the mysql rpm package. It has been running great until the
server crashed for an unknown reason 2 days ago.
now when ever i try to start mysql i get the
following error in log
040812 09:52:34 mysqld
started040812 9:52:34 Warn
What if a company hires me to build an application for them. They already
have MySQL downloaded and installed. Do I/they need a license?
What if the software is open-source, but not free?
- Original Message -
From: "Lachlan Mulcahy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wedn
> Great, MyCon produces "SQL statements ready to recreate just your schema and/or all
> data as well", now did I miss something, or does MyCon actually write the SQL one
> needs to create and populate a set of system tables for the schema?
>
> PB
> .
Nope Peter, you didn't miss a beat ;)
Jus
91 matches
Mail list logo
