Sebastien,
please consult
http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html.
For InnoDB, the following is the most important upgrade note:
"
Upgrading: If you have stored characters < ASCII(32) to non-latin1
non-BINARY indexed columns in MySQL versions <= 4.1.2, then you have to
rebuild t
oh, ok. thank you!
On Thu, 4 Nov 2004 01:16:21 -0600, Dan Nelson <[EMAIL PROTECTED]> wrote:
> In the last episode (Nov 04), Louie Miranda said:
>
>
> > I did create a table and a fieldname of 1 and 2. when i did enter
> > this query to insert on my sql, it causes error.
> >
> > insert into rate
In the last episode (Nov 04), Louie Miranda said:
> I did create a table and a fieldname of 1 and 2. when i did enter
> this query to insert on my sql, it causes error.
>
> insert into rates_fedex (weight_kg,a,b,c,d,e,f,g,h,1,2) values **
>
> error: ERROR 1064: You have an error in your SQL synta
I did create a table and a fieldname of 1 and 2.
when i did enter this query to insert on my sql, it causes error.
insert into rates_fedex (weight_kg,a,b,c,d,e,f,g,h,1,2) values **
error: ERROR 1064: You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server ver
Right, I upgraded my version of MySQL last night after a lot of digging about, found a
few bugs to do with table coruption that possibly could have been the problem.
I am re-runing my script and its seems to be going fine this time.
I am now using 4.0.28, I was using an early version of 4 can't
On a whim, I removed the --disable-shared from the configure options and
was greeted by a lot of unresolved symbols from libz.a and this pleasant
message:
ld: fatal: relocations remain against allocatable but non-writable sections
collect2: ld returned 1 exit status
Google search says to use GNU
Hi,
I am about to upgrade from mysql-standard-4.0.14 to
mysql-standard-4.1.7 on two Red Hat ES 3 server (master/slave circular
relationship).
I would like to know about any glitches I might face while doing so...
Has anyone had any problems or bugs with any incompatible directives.
Here is the co
- Original Message -
From: "Schalk Neethling" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 03, 2004 5:59 PM
Subject: Upgrade - Downgrade problems
> Since installing the latest 4.1 version of MySQL I have not been able to
> run phpMyAdmin.
>
> I have since gather
Since installing the latest 4.1 version of MySQL I have not been able to
run phpMyAdmin.
I have since gathered that the current version of phpMyAdmin is not
compatible. I therefore ran Add/Remove programs on Windows and installed
4.0.22 but nothing is working correctly, the server starts as a s
Haitao,
are you using MyISAM or InnoDB tables?
There were only two weeks between the 4.1.6 and 4.1.7 releases, and
filesort.cc was not modified at all in that time. The error 'Sort aborted'
comes if the sort function fails for some reason.
Can you find out what query is causing these errors?
Bes
Do you use POST or GET in the form?
Try with a post.
Santino
At 8:31 -0500 3-11-2004, Ed Curtis wrote:
I'm trying to get a slash in a variable into my database and am having
some trouble. If the variable = "1 1/2" it echoes to the screen correctly
but it seems to strip the 1/2 off the variable when
Search '+ford +focus' [in boolean mode]
Santino
At 13:22 + 3-11-2004, Lee Denny wrote:
Hello,
I'm doing fairly straight forward fulltext searches, but I want to nest
them - basically do a keyword search on 'phrase 1' and then search the
results this returns for 'phrase 2', for example if phrase
Unfortunately, the --disable-shared is intentional. For various
reasons, our programs use static libraries whenever possible rather than
dynamically linking.
Do you think the LDFLAGS and/or --enable-libgcc still help for static
libraries?
Many thanks for your help so far,
--V
Ken Menzel wrote
Spenser wrote:
I'm trying to use the C++ API (a.k.a. MySQL++).
There's a mailing list dedicated to MySQL++. If you were subscribed,
you would have seen the messages announcing the changes that are causing
you problems.
The on-line manual
...is badly outdated.
when I downloaded the latest ver
Hi,
We were using MySQL 4.1.6g without this kind of error, but after we
upgrade to 4.1.7, we are having following errors:
041103 9:35:35 [ERROR] /var/opt/mysql4/11000/pkgroot/bin/mysqld: Sort aborted
041103 9:35:35 [ERROR] /var/opt/mysql4/11000/pkgroot/bin/mysqld: Sort aborted
What do these me
On Wednesday 03 November 2004 02:43 pm, Mark Hennessy wrote:
> I have three mail servers, on each is a MySQL DBMS. I want to set up a
> replication ring between the three MySQL DBMS on these machines so they
> will constantly share the same data in near real-time. But, the chance
> exists that a
I have three mail servers, on each is a MySQL DBMS. I want to set up a
replication ring between the three MySQL DBMS on these machines so they will
constantly share the same data in near real-time. But, the chance exists
that any one of those three mail servers may be completely down or have
serv
We are in the process of upgrading our installation of MySQL 4.0 to
4.1.7 and are having an issue in our testing.
We have an internal CMS that was developed with MySQL 4.0 and PHP. We
very often insert Text with extended characters (trademark, copyright,
registered, etc) into latin1 tables with
Hi Yves,
Administrator is intended for server maintenance and configuration,
while with Query Browser you execute SQL queries and do related SQL
scripting work. As a set, they do the same as mysqlcc, but are much
better (we hope).
MySQLCC will be replaced by Administrator and Query Browser
and w
I don't see a way to ask MySQL what the "full" name of a table is... the
equivalent of this:
SELECT CONCAT(DATABASE(), ".", "table_name")
which would return something like this (assuming the current database is
called "my_database":
my_database.table_name
The reason I want this is to ensure tha
Hello, MySQL Gurus,
I have a mysql server (4.0.20) that has been flaky these days. I
can't connect to it by 'mysql -p' or shutdown thru mysqladmin. It just
hangs there forever without doing anything. I tried to 'ps -Aef | grep
mysql' and sees nothing but the mysqld_safe and the mysqld_max
For the archives:
Well, I may be onto my own solution to why I can't find sqlplus.hh. As
of version 1.7.11, sqlplus.hh is now called mysql++.hh. This was
announced on August 17, 2004. Of course, I'm still having problems
getting that header file to work, but at least I have a fighting
chance.
We're trying to get 4.1.7 to play nicely with our code, but something
isn't cooperating.
First of all, the MySQL installation: Version 4.1.7, compiled from
source using GCC 3.3. The source compile is required because we need a
lot of default settings to use our own paths. This is the configu
Hi.
See:
http://dev.mysql.com/doc/mysql/en/Problems_with_character_sets.html
http://dev.mysql.com/doc/mysql/en/Cannot_initialize_character_set.html
Svein Kristiansen <[EMAIL PROTECTED]> wrote:
> ! use MySQL 4.1 in Windows 2000 and don't get connect with MySQL
> Administrator.
>
> T
Hi.
By using DATA DIRECTORY='directory' or INDEX DIRECTORY='directory' in CREATE TABLE
clause, you can specify where the MyISAM storage engine should put table's data and
index file[s].
See:
http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html
Also,you may use 'datadir' server variable
Hi.
> is "Where does InnoDB data get stored?"
> table type since it describes it as "default">"
Use:
show variables like '%innodb_data%';
show variables like 'storage_engine';
Anders Green <[EMAIL PROTECTED]> wrote:
> Sequence of events:
> -had an MS Acce
Hi.
What type of the field in which you insert?
Send us output of
SHOW CREATE TABLE 'table'.
Ed Curtis <[EMAIL PROTECTED]> wrote:
>
> I'm trying to get a slash in a variable into my database and am having
> some trouble. If the variable = "1 1/2" it echoes to the screen correctly
>
Thanks to all of you who replied.
Yves
On Wed, 3 Nov 2004 13:57:33 + (GMT), andy thomas <[EMAIL PROTECTED]> wrote:
> On Wed, 3 Nov 2004, Yves Arsenault wrote:
>
> > Thanks for the reply,
> >
> > Is there any information on the mysql.com website on how to store data
> > on 2 separate partiti
Trying to build from IDE. Unicode Editor will not compile because of
missing StringContainers.dcu
Where can find StringContainers unit?
Thanks
- Original Message -
From: "Alfredo Kengi Kojima" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 02, 2004 7:17 PM
Subject:
All - I got my answers. Thanks.
-Original Message-
From: [EMAIL PROTECTED]
Sent: Wednesday, November 03, 2004 10:18 AM
To: Mysql General (E-mail)
Subject: RE: Production instances down - MySQL got signal 11
All
I have discovered that I had a memory problem on this server which caused
On Wed, 3 Nov 2004, Anders Green wrote:
> Tobias Asplund wrote:
> >If you installed MySQL 4.1.7 on Windows with the new installer
>
> Yes I did.
>
> >it will automatically use InnoDB tables as the default
>
> Ah ha. Thanks. :)
>
>
> That just leaves this:
>
> > > So now my question "Where does Inn
On Wed, 3 Nov 2004, Chaitra Yale wrote:
> ...how can union be the same as intersect..iam trying to get the names
> of comapnies that are in both queries.for example the first query
> gives me companies A, B AND C and the second query gives A , B..i want
> the intersect of these 2 queriesso
Wouldn't
SELECT p.csymbol
FROM tblavgPrice p JOIN tblAssets a ON p.csymbol = a.csymbol
WHERE p.avg > 1 AND p.avg < 10
AND a.assets > 100 AND a.assets < 500
do what you want?
Michael
Chaitra Yale wrote:
...how can union be the same as intersect..iam trying to get the names
of comapnies that
Hey Gabe,
I saw that this came through the public lists - the you might want to
just post to support as it's more than covered by your contract.
My own take is that you've got an OS issue allocating disk space.
According to perror, error 11 is "Resource temporarily unavailable". I
actually hit
On Wednesday 03 November 2004 09:59 am, Yves Goergen wrote:
> Ehm - what please is the difference between MySQLCC and MySQL
> Administrator? And what is Query Browser again? It's confusing to have
> three products that all do the same.
No, they are not all the same..
MySQLCC is depricated..
MyS
On 03.11.2004 04:17 (+0200), Alfredo Kengi Kojima wrote:
MySQL Administrator is a GUI management console for MySQL,
with support for tasks such as managing users,
configuring MySQL, editing table definitions etc.
Ehm - what please is the difference between MySQLCC and MySQL
Administrator? And what
...how can union be the same as intersect..iam trying to get the names
of comapnies that are in both queries.for example the first query
gives me companies A, B AND C and the second query gives A , B..i want
the intersect of these 2 queriesso i get companies A and B...if i
did a union i wil
All
I have discovered that I had a memory problem on this server which caused the crash.
I reduced the initial memory requirements for Innodb and now it is running.
I am curious why it crashed in the first place. If anyone has insight on this, I
world appreciate hearing it...
Thanks - Gabe
! use MySQL 4.1 in Windows 2000 and don't get connect with MySQL
Administrator.
The message what get is:
Could not connect to the specified host.
MySQL Error Nr.1115
Unknown character set: 'utf8'
Details of the my connection:
Username: root
Password:
Hostname: localhost
Port: 3306
hi,
I've just installed MySQL 4.1.7
when I try to launch phpMyAdmin I see this:
Witamy w phpMyAdmin 2.5.5-pl1
phpMyAdmin próbowal polaczyc sie z serwerem MySQL, a serwer odrzucil polaczenie.
Powinienes sprawdzic nazwe hosta, nazwe uzytkownika i haslo w pliku
config.inc.php i upewnic sie, ze odp
Assuming you have access to MySQL 4.0+
select csymbol from tblavgPrice where avg > 1 and avg < 10
UNION
select csymbol from tblAssets where assets > 100 and assets < 500
Unless you say UNION ALL, you won't get duplicate values.
For more details: http://dev.mysql.com/doc/mysql/en/UNION.html
Just
Hi all
I am on Solaris 8 using mysql.4.0.16 standard.
My instances crashed with the following in the .err file:
041103 07:44:16 mysqld started
041103 7:44:17 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint
Ah,
Thank you all so much.
:-)
My purpose for asking was some concerne with the possibility of
growing DB sizes..
Question answered.
Score one for the list.
Yves
On Wed, 3 Nov 2004 14:52:35 +0100 (CET), Thomas Spahni <[EMAIL PROTECTED]> wrote:
> On Wed, 3 Nov 2004, Yves Arsenault wrote:
>
Check here: http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html
Look for the IN and NOT IN comparators :-)
DELETE FROM the_table WHERE `ID` IN(1,2,3,4,5,6)
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
-{ Rene Brehmer }- <[EMAIL PROTECTED]> wrote on 11/02/2004
07
On Wed, 3 Nov 2004, Yves Arsenault wrote:
> Thanks for the reply,
>
> Is there any information on the mysql.com website on how to store data
> on 2 separate partitions?
There is something in the manual. The title is 'Symbolic links to
databases'.
Using Symbolic Links
You
Tobias Asplund wrote:
If you installed MySQL 4.1.7 on Windows with the new installer
Yes I did.
it will automatically use InnoDB tables as the default
Ah ha. Thanks. :)
That just leaves this:
> So now my question "Where does InnoDB data get stored?"
Cheers,
Anders
+===
I'm trying to get a slash in a variable into my database and am having
some trouble. If the variable = "1 1/2" it echoes to the screen correctly
but it seems to strip the 1/2 off the variable when updating the value to
the database. I'm using php and a form select list to get this value from
a pre
Thanks for the reply,
Is there any information on the mysql.com website on how to store data
on 2 separate partitions?
I'll be doing a bit of research on this soon...
Thanks again,
Yves
On Wed, 3 Nov 2004 13:21:59 + (GMT), andy thomas <[EMAIL PROTECTED]> wrote:
> On Wed, 3 Nov 2004, Yve
If you installed MySQL 4.1.7 on Windows with the new installer, it will
automatically use InnoDB tables as the default unless you specify different.
(This is different from earlier versions), so the error was probably not in
the Query Browser, but in the server settings in this case.
On Wed, 3
Hello,
I'm doing fairly straight forward fulltext searches, but I want to nest
them - basically do a keyword search on 'phrase 1' and then search the
results this returns for 'phrase 2', for example if phrase 1 is 'ford' and
phrase 2 is 'focus' - I search once for 'ford' and then go through the
re
On Wed, 3 Nov 2004, Yves Arsenault wrote:
> Hello all,
>
> I have MySQL installed on a Mandrake Linux system, it is installed on
> the /usr partition.
>
> I was wondering, is it possible to store some databases on the /var
> partition while MySQL is installed on the /usr partition?
Yes. In fact,
Hello all,
I have MySQL installed on a Mandrake Linux system, it is installed on
the /usr partition.
I was wondering, is it possible to store some databases on the /var
partition while MySQL is installed on the /usr partition?
And, if it is possible, can you store DB_A on /usr and DB_B on /var
(
On Tue, Nov 02, 2004 at 11:57:35PM -0800, Karam Chand wrote:
> I had checked google before posting. As you can see
> none of the images are original and the clarity is not
> good. They dont look good in my app.
>
> Can I get an original one from MySQL AB?
The official MySQL logos can be download
hi
i have a PHP/MYSQL site in witch i have some scripts creating some tables.
my host crashed several times this week and then many of my already
created databases corrupted.the error is can't find file MYDB.MYI
i can't repair them by REPAIR TABLE script and i do not have ACCESS to
SHELL in order
Sequence of events:
-had an MS Access db
-converted it to MySQL 4.1.7 with a utility
-everything worked
-using MySQL Query Browser 1.0.1, added three tables
-everything worked
-comes time to deploy to another machine for testing,
copy directory of database over to other machine
-any queries involv
I see 4.1.1 is new im downloading 4.1.7 now...
On Wed, 03 Nov 2004 09:23:53 +0200, Gleb Paharenko
<[EMAIL PROTECTED]> wrote:
> Hi.
>
> What version of MySQL do you use?
>
> To make it easier to reload dump files for tables that have foreign key
>
> relationships, mysqldump automatically includ
From: "Gleb Paharenko" <[EMAIL PROTECTED]>
> Send us versions of software you use, and output of
The MySQL server is hosted on a windows machine.
No remote access to that. just an read only account to the database.
> show create table 'table'.
> Hi all, I whould like to know if there is a
> way to create Foreign Key╢s between Parent and Child table, I realy dont
> know if is it possible to do it and if OK, how will be a simple SQL code
> of it.
Only for InnoDB tables - see:
http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constra
sorry I should over put my verision number in.
4.0.21-standard
On Wed, 03 Nov 2004 09:23:53 +0200, Gleb Paharenko
<[EMAIL PROTECTED]> wrote:
> Hi.
>
> What version of MySQL do you use?
>
> To make it easier to reload dump files for tables that have foreign key
>
> relationships, mysqldump aut
Hi all, I whould like to know if there is a
way to create Foreign Key╢s between Parent and Child table, I realy dont
know if is it possible to do it and if OK, how will be a simple SQL code
of it.
---
Christopher Chamber
http://gem-hs.org/c.html
--
MySQL General Mailing List
Hi.
Remove ';' from the end of the line.
[EMAIL PROTECTED] wrote:
> [-- text/plain, encoding 8bit, charset: US-ASCII, 22 lines --]
>
> I am trying to utilize MySQL's batch execution functionality by using build scripts
> to create tables in my database (ref:
> http://dev.mysql.com/doc/mys
Hi.
System error: 2 = No such file or directory
Check if file exists. Do you have permissions to read this file?
[EMAIL PROTECTED] wrote:
> [-- text/plain, encoding 8bit, charset: US-ASCII, 22 lines --]
>
> I am trying to utilize MySQL's batch execution functionality by using build s
Hi.
Send us versions of software you use, and output of
show create table 'table'.
Can you read non-blob field from this table (or others)?
"Danny Terweij" <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Just hooked up to this list as last resort
> Searched internet for some wee
Hi.
See:
http://dev.mysql.com/doc/mysql/en/Charset.html
http://dev.mysql.com/doc/mysql/en/Charset-connection.html
Eben <[EMAIL PROTECTED]> wrote:
> I'm running mysql 4.1.7 on linux. I recently made the upgrade from 4.0.1
> to 4.1.7 to get the additional character sets support. I have
Hi.
You should really read the FAQ:
http://mysql.ensita.net/doc/mysql/en/Replication_FAQ.html
In case you want us to fine-tune replication for you, you may want to order commercial
support, go to: https://order.mysql.com/?ref=ensita.
ian douglas <[EMAIL PROTECTED]> wrote:
> Hi everyo
Hi.
What version of MySQL do you use?
To make it easier to reload dump files for tables that have foreign key
relationships, mysqldump automatically includes a statement in the dump
output to set FOREIGN_KEY_CHECKS to 0 as of MySQL 4.1.1.
spiv007 <[EMAIL PROTECTED]> wrote:
> I jus
Hi.
It looks very strange.
So give us the information about version of MySQL and operating system.
If you use MySQL compiled manually, it will be helpful
to use official binaries of the latest release.
John Smith <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I have built a search applic
Hi.
COUNT(*) is optimised to return the result very quickly for MyISAM tables,
as the quantity of rows is stored and updated separately. (Not true for other table
types, though).
So in most cases use it.
Rob Best <[EMAIL PROTECTED]> wrote:
> I have a database that contains a cable of
Hi all
We have the following setup:
- Master mySQL Server 4.0.11-gamma (sun-solaris2.9-sparc-64bit)
- Slave mySQL Server 4.1.7 (sun-solaris2.9-sparc-64bit)
Everything worked fine with both servers having the same Version
(4.0.11-gamma). As a first step in updating to Rel. 4.1 we migrated the
repl
69 matches
Mail list logo