 | | | MySQL General | | -----BEGIN PGP SIGNED MESSAGE-----
Hash SHA1
Stefan Kuhn wrote
> Hi all
> I have a Java webapp using a mysql database. It all used to run well but I
> now frequently get the following error
>
Scott Haneda <lists@(protected) > wrote on 15/09/2005 10 31 48
> I have moved my data from mysql 3 to 4 across various updates over the
> past few years. I use phpmyadmin generally and it defaults Hello.
As far as I see mysqldump doesn 't support this feature. Here is the
thread where people discuss this issue may be it will be interesting
for you. See
http //lists.mysql.com/mysq2005/9/15 Dave <davemg@(protected) >
> MySQL General List
>
> Server specifications
> MySQL 4.1.3-beta phpMyAdmin 2.5.7-pl1 PHP 4.3.8
> My specifications
> MySQL beginner PHP intermJames wrote
> I had set up the following
>
> I have a MYSQL server running on let 's say 123.xx.xx.xx
>
> User user1
> Host 111.xx.xx.xx
>
> and gave that user the appropriate priveleges.
How Andrew stolarz wrote
>Hello Everyone
> Hopefully easy question
> What is the Max size of a MySQL server database?
>
>
>
The answer to that question depends more on your OS than mysql. A quick
On Sep 14 2005 at 6 16 PM Chris Kantarjiev wrote
> I 'd like to spread the disk arm load across multiple drives. At
> the moment we mostly use MyISAM tables but we are also
> experimenting with Hello
I hope you can help....
I installed mysql-4.1.14-ia64-11.23.depot on a HP-UX Itanium rx4640 11.23
O.S. without a problem.
I used the following install command
swinstall -s /tmp/mysql-4.1.Hi people
do you know any site with a tutorial from sap or any good book any resource?
Thanks in advance
--
lancer emotion 16
--
MySQL General Mailing List
For list archives http //lists.mysql.Hi!
I have copied all the files from mysql/data folder and burned them
on CD. Then i 've formated old hard drive. Now i 'm trying to copy
them back on the fresh mysql installation. Unfortunately after Hi
> Now as expected it 's an dependent subquery and makes use of the index on
> document_id. BUT If we change the "SELECT id " in the subquery to
> "SELECT document_id " or "SELECT 1 " we get
>
> *Scott Noyes wrote
> >I have a table like this
> >name email_1 email_2
> >
> >and I want to display in a web page
> >name email_1 if it exists or email_2 if email_1 do NOT exist.
What if email_2 doeSchalk <schalk@(protected) > wrote on 09/14/2005 09 31 23 AM
> Greetings
>
> Is there a way to get the last update date for an entire table not just
> a single row? More specifically is there a waEli wrote
> Is it possible or probably will be possible to define indexes spanned
> on more than one table?
> I mean that if I have column col_a from table tbl_A and col_b from
> table tbl_B.. CI am currenly using JSF as the front end of a J2EE
application. Data go through many business logic
layers and reach the database through the iBatis.
The iBatis is new to me. To pass a query "String "Matthias Pigulla wrote
> Hi all
>
> can someone explain me why this query gets executed the way it is? I
> simplified it as much as possible and think it 's a conceptual/logical
> thing so I 'll omiHallo Thorsten
Op 14 Sep 05 schreef Thorsten Moeller aan MySQL Mailinglist
TM > i am trying to load a csv file with "LOAD DATA INFILE ". This File
TM > contains columns with decimal values with thequeries locked in the following fashion
1. SELECT on table OHMYGOD - "Sending data " state
2. UPDATE on the same table OHMYGOD - "Locked " state
3. SELECT on table OHMYGOD - "Locked " state
and subsHello.
For a pity your question isn 't clear enough. Please could
describe the issue more widely.
$ $ <liulian0588@(protected) > wrote
> Hello every one.
>
> Is there a current criEd Collins wrote
> >Description
>
> I get the following message "error 'Can 't connect to local MySQL
> server through socket '/tmp/mysql.sock ' (61) ' "
This is the error the client gives wh >Description
I get the following message "error 'Can 't connect to local MySQL
server through socket '/tmp/mysql.sock ' (61) ' " Everything has run
fine for along time. This is running on OS Hello.
Sometimes after an upgrade it is necessary to rebuild indexes
in the tables (I 'm not sure if it always produces an error if
you haven 't done it). In general - usual recommendations foBill Whitacre wrote
> > printf( " <tr > <td > {$thearray[org]} </td >
> > <td align right > {$thearray[ "COUNT(*) "]} </td >
> > <td align right > $ {$thearray[cost]} </td > </tr > ")
> If I rAt 11 31 AM 9/13/2005 you wrote
>Hi all
>
>I found that load infile should not take this much time(6 hrs) to load 5.5
>million queries. Some people are saying it should not even take more than
>10Indexing can play a big role in the load time differential. When
loading .45 million rows MySQL may be able to handle the sorting for
indexes in memory. With 5.5 million it 's more likely to haveHi all
Willing to test an upgrading path from 4.0 to 4.1 database of MySQL.
Could someone provide a link or some slice of unload from a 4.0 with
encodings different from "latin1 " ?
Thanks in advancehi
I need to have 2 DB in our development/production environment which require both InnoDB and MyISAM engines. This is bacasue DB1 contains spatial/geom data which has to be on MyISAM engine and DB
> Have you tried removing the brackets ( ) from around the fields in the
> SELECT part of the query?
I did as you suggested and ran the query without brackets and it worked
perfectly.
Thank you
While the basic issue of correct syntax is still open this issue has
boiled down to a specific error message so I 've moved to a new thread
called
" "Operand should contain 1 column " error "
HowevAt 13 19 +0900 9/13/05 Dave wrote
>(Topic moved from "Copying data stored in different field formats
>from one table to another ")
>
>MySQL General List
>
> Server specifications
> MySQL 4.1.3 |
|
|
