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 recognises
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]
ompany
SELECT * FROM Contacts WHERE 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:
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 f
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 numbe
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 ma
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/
https://dwhs.net/secu
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 t
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
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:
Sent: Monday, September 12, 2005 12:42 PM
Subject: Re: Adding InnoDB support
> Hello.
>
> Usually it
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
or MySQL 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 Pr
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
64 days - not sure if that's
significant. Doing SLAVE STOP; SLAVE START; has no effect.
>Fix:
Unknown (except to work around it as shown above).
>Submitter-Id:
>Originator:root
>Organization:
NewsNow Publishing Limited
>MySQL support: none
>Synopsis: SHOW PROCESSLIST disp
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]
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
"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 in latest
> MySQL edition. But I have read in the manual of MySQL
>
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: h
"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 f
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,
""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
woul
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:09、Ob
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 Con
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, expl
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
uery
>
> ~Kelly W. Black
>
> PS IN the future check out http://www.rpmfind.net/
>
> -Original Message-
> From: SpyProductions Support Team [mailto:support@;spyproductions.com]
> Sent: Friday, November 08, 2002 12:51 PM
> To: Black, Kelly W [PCS]
> Cc: [EMAIL PROTECTED]
>
;[EMAIL PROTECTED]'; [EMAIL 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
&
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:
http://www
>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: renam
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
020
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
020
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
longe
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
-
Befor
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 where
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.
Thank
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 dat
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
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" <[EM
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 Do
gt; Subject: RE: Getting Data From One Table Based On Another - Agh!
>
>
> SELECT Table1.orderid, Table2.otherfield1, Table2.otherfield2
> FROM Table1, Table2
> WHERE Table1.orderid = Table2.orderid;
>
> --Greg Johnson
>
> -Original Message-
> From: SpyProductions S
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 t
> 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
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 privileg
In searching for multimedia-content and multimedia related webistes/content we
recently came across your site MySQL | Documentation | MySQL | Full -
http://www.mysql.com/documentation/mysql/full/index.html
MySQL | Documentation | MySQL | Full - http://www.mysql.com/documentation/mysql/full/
MyS
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 down
happened.
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
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
/home/domain/domain42/web/drwho/php/
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
redhat
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 incor
e, i get 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 lig
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
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 http://www.computerstaf
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 - Compu
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,
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 2
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,
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 *
*
; From: Sergei 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
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.
***
*
> -Original Message-
> From: Sergei Golubchik [mailto:[EMAIL PROTECTED]]
> Sent: 20 May 2001 20:51
> To: technical Support
> Subject: Re: Fulltext Strange Results...
>
>
> Hi!
>
> On May 20, technical Support wrote:
> > Hello,
&g
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
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 match
on the 'Progressive 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 PROTE
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.mysql.c
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.mysql.c
**
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 straig
I have a user that I want to grant create,drop on %_ext to user@localhost but it does
not like the wildcard in the tablename. I am creating heap tables and then dropping
them but I want the user to have create and drop privileges only on those tables not
all of them in the database. Is this pos
70 matches
Mail list logo