SQL Image Viewer helps you retrieve, view, convert and export images and
binary data stored in SQL Server, Firebird, MySQL, Oracle, SQLite, and
various ODBC-supported databases (e.g. DB2 and PostgreSQL).
It supports the following image formats: BMP, GIF, JPG, PNG, PSD, and TIFF,
and
Hi
are there any doc's on how to migrate DB in 3.23.58 format to 5.0.45
moving from a Fedora Core3 to Centos5.2 server.
Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi
while testing an upgrade from 3.23.58 to 4.1.22 on an FC3 test box
SELECT * FROM Contacts WHERE Categories=Services and BusinessCodes REGEXP
^R and gold_id=2 ORDER BY Company ASC
on mysql server3.23.58 i get company result in ASC order.
on mysql server4.1.22 i get non ASC order for
Categories=Services and BusinessCodes
REGEXP
^R and gold_id=2 ORDER BY Company ASC
-Original Message-
From: Obantec Support [mailto:[EMAIL PROTECTED]
Sent: Friday, July 11, 2008 9:29 AM
To: mysql@lists.mysql.com
Subject: ORDER BY problem
Hi
while testing an upgrade from 3.23.58 to 4.1.22
Hi
FC3 test box running mysql 3.23.58 and php 4.3.9 worked ok. (i know they are
old but is only a local test box server for testing before i update a live
version).
installed mysql 4.1.22 and it starts up ok
080626 20:14:58 mysqld started
080626 20:14:59 InnoDB: Started; log sequence
Dear Person in charge:
We recently replaced mysql 4.0.16 with the free version of mysql 5.0.45 and the
access from Tomcat 4 to the database has stopped working. It says
java.sql.SQLException: Communication failure during handshake. Is there a
server running on 192.168.2.34:3306?
The server
Hello,
We recently moved to a new cluster plattform, setup by one external IT
company
at present (early stage):
2 XEON computers with a fibre channel link to a Network Storage. The mysql
directories are located on the Network storage and mounted into
/var/lib/mysql on each machine. So, every
Hello,
Is there anything we can do to help the MySQL project, we are firm believers
and would like to contribute in some way.
We have a several 100 mps connections and server space.
Thank you,
Charles
DWHS Inc. Manager
http://www.dwhs.com
http://www.dwhs.com/hostingforum/
Thank you for your email support request.
Our support team will respond with the recommended solution in the quickest
time possible, but may be delayed due to the complexity of the problem or
volume of requests for support.
Once we have replied to your initial question, please be sure to use
Hi
1 user has requested InnoDB support. can i simple get the mysql-max rpm an
use yum to install over the existing mysql server.
currently running FC3 with default 3.23.58
I would upgrade to 4.x but a lot of user databases and i am worried about
loosing data, so for now a quick fix is in order
Hi
I found upgrading info but no info on how to install a second mysql server.
Mark
- Original Message -
From: Gleb Paharenko [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, September 12, 2005 12:42 PM
Subject: Re: Adding InnoDB support
Hello.
Usually it is not so simple
My original question was how to add InnoDB support to 3.23.58 server.
It was suggested that i could run a second server. as i have FC3 i use yum
to add / update programs.
are you suggesting i get the source , unpack and build the server setting
some configs to run it on a different port?
Mark
WebService (Datasheet StatusBar)
p.. Dump Tables now Dumps triggers of the selected table correctly
(SQLITE)
q.. When Dumping only one table do not dump objects that are not table
children
New Features
a.. Servers Sorted By Name
b.. Added Role Support for Interbase/Firebird (Server Properties
at regular
intervals
* ODBC Import - Wizard driven painless migration to MySQL
Please visit the following link for to view the feature comparison between
SQLyog and SQLyog Enterprise.
http://www.webyog.com/sqlyog/featurematrix.html
Thanks for your attention!
Webyog Support
http://www.webyog.com
. Doing SLAVE STOP; SLAVE START; has no effect.
Fix:
Unknown (except to work around it as shown above).
Submitter-Id: submitter ID
Originator:root
Organization:
NewsNow Publishing Limited
MySQL support: none
Synopsis: SHOW PROCESSLIST displays incorrect slave latency in MySQL 3.23
Please read the attached file.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
they are the
recent one for othertableid = 1 and 2 respectively.
Please be sure that I want to retrive all fields
including RecordId. The result should not depend on
any other fields but EffectiveDate only.
I am using MySQL 4.0.12 and it does not support
SUBQUERIES which is now given support
Hi,
I also faced this kind of error in sub query,
any solution for this?:
-Aman.
On Mon, 19 Jan 2004, Director General: NEFACOMP wrote:
Hi group, I have discovered this morning a strange behaviour of MySQL 4.1.1
When the SUB-SELECT contains more than one field, it does not work (this works
Unknown Sender [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi,
I recently upgraded from MySQL v3.23 to MySQL 4, and converted
my tables from MyISAM to InnoDB by using the ALTER TABLE
command. I did this for 16 tables. I know that MyISAM creates
seperate data/index files for
Hello,
My HDD is running low and I MyISAM tables are keep crashing... I think that
converting to InnoDB will be more stable, but what about the data files
sizes? convertion to InnoDB will need more or less disk space than MyISAM?
-thanks, Eli
--
MySQL General Mailing List
For list archives:
Michael Shuler [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
What would be the rules for deciding if id 3 should be fr or de?
if 'en' does not exist, then it does not matter which language is returned
(even be the first available language in the rows order in the DB). But
would be
Thanks for your help, but it is not giving the result.
The problem is that when you make GROUP BY id then the row representing
the group is the first row in the group, and adding ORDER BY ... after the
group by part just orders the grouped rows, but the grouped rows are in the
wrong languages,
I save as CSV (MS-DOS).
I then import into MySQL using SqlYog and the following parameters:
Line terminator \r\n
Delimiter ,
Strings Optionally surrounded by
That gives me a successful import every time. I have tried other variations
and achieved same results as you - 'jumbled'
- Original Message -
From: Nils Valentin [EMAIL PROTECTED]
To: Obantec Support [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, July 27, 2003 2:05 AM
Subject: Re: A little SQL query help
Hi Mark,
2003 7 27 06:09Obantec Support :
Hi
I have a database supplied to me
Hi
I have a database supplied to me that was excel but now uploaded to mysql.
(the data is out of my hands.)
i need to search for 1 of 2 categories against 3 fields with user inputted
data.
example Categories=Lessor , searchtype = BusinessCity searchdata = (user
input)
$sql = SELECT * FROM
Hi
http://www.mysql.com/doc/en/Fulltext_Search.html
the create and insert of data went ok but when i do
SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database');
i get SQL-query
I am using RH8.0 and mysql 3.23.56 and php 4.3.2
I connect ok and my other code works SELECT term,
Hi
I have 2 servers both with 3.23.56-1 installed via rpm's
proteus2 which is running RedHat 7.2 on 1 cpu and has been in use for over 1
year works as expected.
[EMAIL PROTECTED] [/var/lib/mysql]# mysqladmin status
Uptime: 515357 Threads: 1 Questions: 2412696 Slow queries: 782 Opens:
19654
Hi all.
I have spent some time studying the manual and previous posts, trying to get
a grip on the whole date_format issue... I am VERY new to MySQL having been
converted from an ADO/DAO environment with Access dBs...
Where I am having trouble is coming up for a syntax to
SELECT *
FROM tableA
I just installed the most recent version of MySQL with an RPM (through
webmin interface), but it doesn't seem to have installed a
mysqladmin.anyone know why? :)
Thanks!
-Mike
-
Before posting, please check:
PROTECTED]
Subject: RE: MysQL Installation
Mysqladmin is seperate rpm
~K Black
-Original Message-
From: SpyProductions Support Team [mailto:support;spyproductions.com]
Sent: Friday, November 08, 2002 11:13 AM
To: [EMAIL PROTECTED]
Subject: MysQL Installation
I just installed
: SpyProductions Support Team [mailto:support;spyproductions.com]
Sent: Friday, November 08, 2002 12:51 PM
To: Black, Kelly W [PCS]
Cc: [EMAIL PROTECTED]
Subject: RE: MysQL Installation
Well hells bells!
Would that be the 'Client programs (i386) (2.3M)' mentioned on
the download
page
From what I heard, yes.
If you stop MySQL, then rename the
dir/database.
It may work. Worked for me (did it
about 3 months ago).
HTH,
Ricardo.
- Original Message -
From: Jorge Martinez [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 27, 2002 11:57 AM
Subject: rename
Hi,
we have an application that connect to MySQL via MyODBC.
Sometimes, we have this error:
[TCX][MyODBC] Got error 5 from table handler
and MySQL drops.
When it comes back up, it first gives an error with BDB tables (the type we
use):
020911 15:10:17 bdb: page 0: illegal page type or format
Shouldn't this come up with a list of names from each table that matches?
SELECT * FROM table1,table2 WHERE table1.name = table2.name;
Does anyone see anything wrong with this query? It keeps giving me an empty
set - but there definitely matches. I even did a LIKE instead of =, takes
Hi,
I work with cyrillic alphabet (Russian) and found that SQL query ORDER BY towns
with Russian entries doesn't work properly. Is there an easy way to resolve
this and sort rows by Russian alphabet?
Vyacheslav
-
Hello,
A real SQL-query works well
SELECT MAX(date_value) AS date_value FROM dates WHERE version_id='2'
But the problem is, that I can't get a value of another column, i.e.
the row in a table consists of three columns - id, date_value and
version_id
The task - to get a value of id column
Hello, everybody!
Please give me a hint at some resources about synchronization of two
MySQL databases, situated in different places.
The point is, I have my local and providers' versions of the same
database. And need to synchronize them at a daily basis with the least
traffic involved.
Hello,
I am wondering if there is any way to determine the character set used for
data in a table.
For example, a single database has 10 tables, six with 'latin1' characters,
two with 'cp1251' characters, and two with 'greek' characters. The
character_set variable is set to 'latin1' on this
Hello,
This is an announcement of a new product that will interest some of you.
I have completed work for the first Beta release of a native ADO.NET
provider to MySQL.
You can find the details at http://www.mattculbreth.com/eidmysql.
Thank you,
Matt Culbreth
Hi
Anyone know if its possible to have mysql databases under $HOME for users.
I am running RH7.2 and have virtualhosts under apache 1.3.22 so i am hoping
i can put databases under each user account in order to control (quota's)
etc.
Mark
--
Obantec Support
www.obantec.net
WebHosting and Domains
Hi
Thanks for the tip! it works fine.
Now all i need to do is modify my create database code to use $HOME/mysql
and make symbolic link
Mark
--
Obantec Support
www.obantec.net
WebHosting and Domains
Nominet UK Tag Holder
- Original Message -
From: Andreas Frøsting [EMAIL PROTECTED
Looking through the MySQL stuff online, I still can't come up with a
statement to pull data from one table based on data from another.
Table1 Contains:
orderid
Table2 Contains:
orderid
otherfield1
otherfield2
I want to get the data from table 2 based on a matching orderid first pulled
from
Jeremy Zawodny wrote :
I'm getting duplicate messages separated by several hours. Am I alone
in this, or are others seeing it too?
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408)
Hey there!
Hoping someone can help me out when it comes to granting privileges for a
user in MySQL.
Basically, I have granted privileges to a user who I do not want to have
root access and I want to minimize his access to only his databases.
Using the MySQL manual, I granted him basic
This is going to be a very basic question, so please excuse me.
I have a MySQL server running, but when I added users I inadvertently
gave them all permissions to everything. They can all access every one
else's databases and make what ever changes they want and even delete.
How do I lock it
MySQL 3.23.39
RH6.2
Apache 1.3.12
2 weeks ago mysql stopped with the following example error.(repeated on
other sites that use mysql on my server)
Warning: Host 'localhost' is blocked because of many connection errors.
Unblock with 'mysqladmin flush-hosts' in
.
It is prob caused by more of my users having php forums.
What i need to find out is root of the cause
Mark
- Original Message -
From: [EMAIL PROTECTED]
To: Support [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, November 30, 2001 3:50 PM
Subject: Re: many connection errors
Support wrote
Greetings - I believe I have a new flavor of this error. I am running
mysql Ver 11.13 Distrib 3.23.36, for redhat-linux-gnu (i386) on Red Hat
Linux release 7.0 (Guinness) Kernel 2.4.2-2smp on an i686 (the database
host) I have two machines running mysql Ver 11.12 Distrib 3.23.32, for
I'm using Free Pascal 1.0.4 and MySQL 3.22.32
System is RedHat 7.2 (but the same is on RH 6.2)
The Free Pascal package contains mysql unit which makes able to pipe sql
queryes from pascal to mysql.
All worked fine until 3.22.32.
But in 3.23.xx (tested on 3.23.38 and 3.23.44),the error with
a message that the package is not installed. at
this point i tried to reinstall the MySql and i got a message that Mysql 3.23 is
already installed. it would be helpful if anyone could throw some light on this..
regards
Support
Madame, Monsieur,
Suite à notre rachat par VERIO Leader Mondial de l'hébergement cette adresse n'est
plus valide. Pour joindre notre
support vous devrez désormais suivre cette procédure :
1/ envoyez vos emails à l'adresse suivante : « [EMAIL PROTECTED] »
2/ Le sujet devra être libellé de
Hello,
Your field(column) is a CHAR and therefore the parameter to it should be in
single
quotes:
Change your query to:
SELECT * FROM customers WHERE Customer_No = 'CMET3558539239'
*
* Visit http://www.computerstaff.net -
You are using PHP. Well PHP is not ASP :-) clever and you can enclose your
variable in single quotes as in:
$customer_select=SELECT * FROM customers WHERE Customer_No = '$id';
Hope this helps.
*
* Visit
Hello,
Has anyone managed to compile the BETA version of MySQL 4 for Windows?
I have downloaded the source however, it appears to be for LINUX or UNIX.
*
* Visit http://www.computerstaff.net - Computer Jobs at all LEVELS *
Hello All,
When I insert data submitted via a web page into mySQL, the pound (£)
symbol gets converted to something like 8916.
I am using PHP and Apache on the Server side.
Has anyone else encountered this strange problem?
*
Hello All,
I have tried the settings as suggested in this FORUM like using htmlentities
etc... however, my pound sign in the database is displayed as: ú
Any more tips help etc...
-Original Message-
From: technical Support [mailto:[EMAIL PROTECTED]]
Sent: 07 June 2001 21:53
Hello,
Does anyone know of any tool that will take an ORACLE database and port
it to mySQL?
*
* Visit http://www.computerstaff.net - Computer Jobs at all LEVELS *
Golubchik [mailto:[EMAIL PROTECTED]]
Sent: 20 May 2001 22:44
To: technical Support
Subject: Re: Fulltext Strange Results...
Hi!
On May 20, technical Support wrote:
I have just done this:
select * from indexed_table where match(indexed_col)
against ('visual basic
Hello,
I did the following query against my indexed table:
select * from indexed_table where match(indexed_col)
against ('oracle +sybase +london')
It returned 16 rows of which only 4 rows included all words.
I then did:
select * from indexed_table where match(indexed_col)
against ('+oracle
I have just done this:
select * from indexed_table where match(indexed_col)
against ('visual basic')
This returns rows with either visual or basic. I read
phrase searching was allowed in mySQL v4.0? Can someone please advise.
Hello,
I have just downloaded version 4 of mySQL. Compiled it with ft_min_word_len
= 0.
However, my a query like select * from table_name where match(col)
against('asp')
returns nothing, when a similar like query returns several rows of data.
Also a
query like select * from table_name where
Jackpot' link at the top of the screen.
And then select 'Real Money Games'.
Go for the US$13662.57 Jackpot now!!
Please do let us know if we can ever be of assistance!
Regards,
The Support Staff
TheCasino.com Corporation
http://www.TheCasino.com
[EMAIL PROTECTED]
TheCasino.com - Better Than Life
heCasino.com Monhtly Prize Drawings.
Please let us know if we can be of further assistance.
The Support Staff
TheCasino.com, Corp.
[EMAIL PROTECTED]
http://www.theCasino.com
-
Before posting, please check:
http://www.
heCasino.com Monhtly Prize Drawings.
Please let us know if we can be of further assistance.
The Support Staff
TheCasino.com, Corp.
[EMAIL PROTECTED]
http://www.theCasino.com
-
Before posting, please check:
http://www.
**
After months of development We are proud to announce the first public version of MySQL
Studio.
http://dba-tools.com/
MySQL Studio provides an extremely easy to use interface to MySQL servers.
A
65 matches
Mail list logo