Re: URGENT: Change Default Location of where Database Files get written?

2011-05-13 Thread Andrew Moore
There absolutely is;

there is a configuration file belonging to MySQL named `my.cnf`. It can
exist in many places and there's a hierarchal order of precedense. The most
common of which is /etc/my.cnf.

Within this file you may specify the `datadir` option to identify location
you wish your data to reside. This is a static variable that can't be
altered whilst the server is in motion and there are things you may need to
do before considering changing this value. There is a wealth of
documentation on this configuration file that can be found at...

http://dev.mysql.com/doc/refman/5.5/en/mysqld-option-tables.html

HTH

Andy

On Fri, May 13, 2011 at 4:21 PM, Tina Matter  wrote:

> I have a MySQL question that I'm hoping someone can help answer.
>
> We have a linux machine which has MySQL 5.5.8 installed.
> It is currently installed in this location:/opt/mysql
>
> When creating a new database, a folder (with the name of the databas) gets
> created in this location:
> /opt/mysql/data
>
> Is there any way to change the location of where data is stored?
> The database that I need to create is going to have over a billion records
> in it,
> so it needs to be in a specific place.
>
> I want the database folder to get created here:
>
> /science/databases/databasename
>
> Thanks for any help.
> Tina
>
> --
> Tina Matter
> Web Applications Developer
> University of Michigan
> Department of Epidemiology
> 1415 Washington Heights, Suite 4605
> Ann Arbor, MI 48109
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=eroomy...@gmail.com
>
>


Re: URGENT: Change Default Location of where Database Files get written?

2011-05-13 Thread Larry Martell
On Fri, May 13, 2011 at 9:21 AM, Tina Matter  wrote:
> I have a MySQL question that I'm hoping someone can help answer.
>
> We have a linux machine which has MySQL 5.5.8 installed.
> It is currently installed in this location:    /opt/mysql
>
> When creating a new database, a folder (with the name of the databas) gets
> created in this location:
> /opt/mysql/data
>
> Is there any way to change the location of where data is stored?
> The database that I need to create is going to have over a billion records
> in it,
> so it needs to be in a specific place.
>
> I want the database folder to get created here:
>
> /science/databases/databasename

http://lmgtfy.com/?q=mysql+location+of+database+files

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



Re: URGENT: Change Default Location of where Database Files get written?

2011-05-13 Thread Wm Mussatto
On Fri, May 13, 2011 08:21, Tina Matter wrote:
> I have a MySQL question that I'm hoping someone can help answer.
>
> We have a linux machine which has MySQL 5.5.8 installed.
> It is currently installed in this location:/opt/mysql
>
> When creating a new database, a folder (with the name of the databas)
> gets created in this location:
> /opt/mysql/data
>
> Is there any way to change the location of where data is stored?
> The database that I need to create is going to have over a billion
> records in it,
> so it needs to be in a specific place.
>
> I want the database folder to get created here:
>
> /science/databases/databasename
>
> Thanks for any help.
> Tina
>
> --
> Tina Matter
> Web Applications Developer
> University of Michigan
> Department of Epidemiology
> 1415 Washington Heights, Suite 4605
> Ann Arbor, MI 48109
Since your are on a linux box, the simplest method is to create the
database, but no tables and then replace the directory with a symbolic
link to the desired location.  Make sure the permissions at the new
directory match that of the other directories.  If you are using innodb
you will need to set it to use separate files for each table.

Hope this helps.

--
William R. Mussatto
Systems Engineer
http://www.csz.com
909-920-9154


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



RE: URGENT: Change Default Location of where Database Files get written?

2011-05-13 Thread David Brian Chait
Add:
datadir=/path/to/datadir/mysql

to your my.cnf file and restart mysql.

-Original Message-
From: Tina Matter [mailto:ti...@umich.edu] 
Sent: Friday, May 13, 2011 8:22 AM
To: mysql@lists.mysql.com
Subject: URGENT: Change Default Location of where Database Files get written?

I have a MySQL question that I'm hoping someone can help answer.

We have a linux machine which has MySQL 5.5.8 installed.
It is currently installed in this location:/opt/mysql

When creating a new database, a folder (with the name of the databas) 
gets created in this location:
/opt/mysql/data

Is there any way to change the location of where data is stored?
The database that I need to create is going to have over a billion 
records in it,
so it needs to be in a specific place.

I want the database folder to get created here:

/science/databases/databasename

Thanks for any help.
Tina

-- 
Tina Matter
Web Applications Developer
University of Michigan
Department of Epidemiology
1415 Washington Heights, Suite 4605
Ann Arbor, MI 48109


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=dch...@invenda.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



Re: URGENT! up2date -u deleted mysql...safest way to recover on production server

2008-05-04 Thread Ian M. Evans

Glyn Astill wrote:

I'd back up the data directories then try and then re-install mysql (sorry, I 
know little about red hat and it's package management). It shouldn't overwrite 
your data if it's already present anyway.


Great. Thought that would be the case, but without sleep, I wasn't sure. :-)

Worked fine.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently

2007-01-22 Thread ViSolve DB Team

Hi,

Here, threads_connected is considerable and below the preset value.
The threads_connected and threads_running are the good indicators to see how 
loaded the server is.  In your case it is good numbers.


So use 'iostat'/relavant utility to monitor the DB activity.

Also threads_created is more, which should be low.  so to average it 
increase the thread_cache size to some 64 or more.


Ref: 
http://www.mysql.com/news-and-events/newsletter/2004-01/a000301.html


Thanks
ViSolve DB Team

- Original Message - 
From: "Ratheesh K J" <[EMAIL PROTECTED]>

To: 
Sent: Tuesday, January 23, 2007 11:59 AM
Subject: Urgent - MySQL 5 - mysqld using a lot of memory consistently


Hello all,

Recently we upgraded from MySQL 4.1.11 to MySQL 5.0.22. The queries are 
taking a lot of time to execute in the newer version. The queries which were 
executing within 10 secs are now taking more than 100 secs.


Running an expalin on the queries showed that an index_merge optimization is 
being used which is a new concept in MySQL 5. My initial doubt was on this 
but now when I checked top it shows that mysqld is consistently using 59% of 
Memory and 25% of cpu even when there is no load.


the SHOW STATUS command in mysql shows:

Threads_created21863
Threads_cached1
Threads_connected38
Connections5784350


Running a SHOW VARIABLES shows:

thread_cache_size8

It is evident that mysqld is creating a lots of threads... Could this be the 
problem?


Thanks,

Ratheesh K J 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently

2007-01-22 Thread Ratheesh K J
CLOSED` (`FLD_ISSUE_CLOSED`), 

KEY `FLD_REPLY_FLAG` (`FLD_REPLY_FLAG`), 

KEY `FLD_SUBJECT` (`FLD_SUBJECT`), 

KEY `FLD_WORKFLOW_TYPE` (`FLD_WORKFLOW_TYPE`), 

KEY `FLD_PRODUCT_ID` (`FLD_PRODUCT_ID`), 

KEY `FLD_SUB_CONTACT_ID` (`FLD_SUB_CONTACT_ID`), 

KEY `FLD_ESCALATED_FLAG` (`FLD_ESCALATED_FLAG`), 

KEY `FLD_BOUNCED_MAIL_FLAG` (`FLD_BOUNCED_MAIL_FLAG`) 

) ENGINE=InnoDB DEFAULT CHARSET=latin1 

  - Original Message - 
  From: Alex Arul 
  To: Ratheesh K J 
  Cc: mysql@lists.mysql.com 
  Sent: Tuesday, January 23, 2007 12:20 PM
  Subject: Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently


  the monitor the threads-connected variable over a period of time and calcuate 
the value. you can even look at max used connections status variable and allot 
accordingly. BTW, is you application using demand based connections or 
connection pooling ? If it is using connection pooling then bumping 
thread-cache might not help.

  Please provide create table statement of the tables in question also.

  Thanks
  Alex


  On 1/23/07, Ratheesh K J <[EMAIL PROTECTED]> wrote: 
Thanks,

By how much should I be increasing the thread_cache? currently it is 8...

Currently I can provide the EXPLAIN result of a query using index_merge on 
MySQL 5.0.22.

EXPLAIN SELECT IFNULL(TAEM.FLD_FULL_NAME, TFMM.FLD_ASSIGNED_TO) AS ELE1 , 
TFMM.FLD_ASSIGNED_TO AS KEY_ID, SUM(1) AS ELE2, SUM( 
IF(TFMM.FLD_ESCALATED_FLAG= 0 , 1 , 0) ) AS ELE3, SUM( 
IF(TFMM.FLD_ESCALATED_FLAG = 0 AND ( TFMM.FLD_ISSUE_CLOSED IN ( 2, 4,5,1 ) ) , 
1, 0) ) AS ELE4, SUM( IF(TFMM.FLD_ESCALATED_FLAG = 0 AND TFMM.FLD_ISSUE_CLOSED 
= 3, 1, 0) ) AS ELE5, SUM( IF(TFMM.FLD_ESCALATED_FLAG = 1 , 1, 0) ) AS 
ELE6,SUM( IF(TFMM.FLD_ESCALATED_FLAG = 1 AND ( TFMM.FLD_ISSUE_CLOSED IN ( 2, 
4,5,1 ) ) , 1, 0) ) AS ELE7, SUM( IF(TFMM.FLD_ESCALATED_FLAG = 1 AND 
TFMM.FLD_ISSUE_CLOSED = 3, 1, 0) ) AS ELE8, ROUND(( SUM( 
IF(TFMM.FLD_ESCALATED_FLAG = 1 , 1, 0) )/SUM(1)) * 100 ,2 ) AS ELE9 FROM 
TBL_FORUMS_MSG_MAIN TFMM LEFT JOIN TBL_ADMIN_EMP_MASTER TAEM ON TAEM.FLD_EMP_ID 
= TFMM.FLD_ASSIGNED_TO INNER JOIN TBL_FORUMS_MSG_OP_TRACK TFMOT ON ( 
TFMM.FLD_MSG_ID=TFMOT.FLD_MSG_ID AND TFMOT.FLD_OP_ID=15 AND 
TFMOT.FLD_LAST_FLAG=1 ) WHERE TFMM.FLD_ACC_ID IN ( 6, 375 ) AND 
TFMM.FLD_MARK_AS_DELETED = 0 AND TFMM.FLD_BOUNCED_MAIL_FLAG = 0 AND 
TFMM.FLD_BLOCK_STATE = 0 AND TFMM.FLD_PARENT_ID = 0 AND TFMM.FLD_ASSIGNED_TO IN 
( 
935,805,563,543,1352,670,571,530,655,577,355,885,392,155,1579,693,1577,509,199,770,1535,78,54,993,594,557,132,859,99,1557,645,527,79,181,1520,200,1350,1534,1591,545,70,191,1550,189,726,40,228,97,196,860,303,1321,394,363,1412,597,1013,1377,1250,1299,3,301,756,170,1553,1578,1343,953,593,250,600,1552,494,311,146,664,589,631,495,4,1254,678,511,931,1020,410,592,822,933,1531,1507,858,453,1257,555,897,352,188,546,1544,291,1529,370,765,963,356,1303,1328,354,414,1581,1030,382,1356,1521,227,396,1333,591,1249,760,1334,1034,51,80,1276,794,145,295,934,544,165,1594,886,929,558,685,880,831,1592,882,320,566,174,796,1593,5,1361,1522,435,388,951,1362,369,806,20,1336,330,77,907,754,507,1330,1364,1,202,1501,289,1296,1378,1061,1500,952,1439,1369,1358,373,1548,294,338,30,1351,1575,728,207,1558,406,837,210,970,620,387,450,1586,38,1227,460,455,1347,841,386,318,130,492,961,590,229,463,284,1380,1580,422,362,1337,581,1490,568,950,1083,960,1329,825,532,404,936,1251,552,1089,1585,1225,708,1564,817,260,372,965,305,456,847,192,1465,962,1523,1590,745,180,1540,753,585,890,1537,1099,225,750,230,7,413,1554,578,572,820,1549,883,810,1105,1403,423,1524,969,542,286,797,1582,1301,384,930,308,854,742,1107,1108,1555,1338,1562,947,673,1506,417,236,798,1576,63,27,1210,371,1485,82,272,1274,529,1277,381,1342,689,185,1118,235,1120,37,598,724,205,946,203,608,405,610,19,958,126,307,967,1360,218,954,1525,891,116,135,75,715,1547,431,1138,879,1498,211,1140,1463,6,1528,344,956,595,91,826,1145,1584,1545,1258,443,643,632,1526,267,1530,58,945,314,1470,763,1491,1595,968,385,955,282,684,179,178,666,409,663,390,1447,1341,1546,1587,125,358,173,279,957,50,182,840,107,580,807,133,1248,892,690,513,898,365,821,325,669,121,62,827,106,219,1253,633,41,562,1489,162,101,861,561,839,153,1565,1583,395,447,217,1551,888,1574,1176,743,446,556,787,263,949,1178,1331,209,134,1505,1354,55,306,31,964,1348,850,1252,862,966,100,521,175,709,1542,942,1335,297,445,296,411,525,420,266,102,1559,418,438,109,661,804,662,1543,984,1556,1409,522,195,1471,439,341,1209,878,838,1464,881,271,36,83,1379,857,944,656,959,538,2,764,1588,672,520,503,531,462,729,528,204,201,93,677,564,426,606,855,234,676,889)
 AND TFMOT.FLD_OP_DATE_TIME BETWEEN '2007-01-19 00:00:00' AND '2007-01-23 
23:59:59' AND TFMM.FLD_MEDIUM IN ( 1 ) AND TFMM.FLD_MSG_ID > 0 GROUP BY 
IFNULL(TAEM.FLD_FULL_NAME, TFMM.FLD_ASSIGNED_TO) ORDER BY 
IFNULL(TAEM.FLD_FULL_NAME, TFMM.FLD_ASSIGNED_TO):

*** row 1 ***
  table:  TFMM
   type:  index_merge
  possible_keys:  
PRIMARY,FLD_MEDIUM,FLD_PAR

Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently

2007-01-22 Thread Alex Arul
   type:  ref
  possible_keys:  FLD_MSG_ID,FLD_OP_ID,FLD_OP_DATE_TIME,FLD_LAST_FLAG
key:  FLD_MSG_ID
key_len:  4
ref:  tallydb.TFMM.FLD_MSG_ID
   rows:  1
  Extra:  Using where

- Original Message -
*From:* Alex Arul <[EMAIL PROTECTED]>
*To:* Ratheesh K J <[EMAIL PROTECTED]>
*Sent:* Tuesday, January 23, 2007 11:57 AM
*Subject:* Re: Urgent - MySQL 5 - mysqld using a lot of memory
consistently

you threads connected is 38 but your thread cache has only 8. So please do
bump it up. Also generate explain plan on both versions of mysql and provide
create table statement of the tables and the query.

FYI, index_merge_optimization is used when more than one index can be used
for execution.

Thanks
Alex

On 1/23/07, Ratheesh K J <[EMAIL PROTECTED]> wrote:
>
> Hello all,
>
> Recently we upgraded from MySQL 4.1.11 to MySQL 5.0.22. The queries are
> taking a lot of time to execute in the newer version. The queries which were
> executing within 10 secs are now taking more than 100 secs.
>
> Running an expalin on the queries showed that an index_merge
> optimization is being used which is a new concept in MySQL 5. My initial
> doubt was on this but now when I checked top it shows that mysqld is
> consistently using 59% of Memory and 25% of cpu even when there is no load.
>
> the SHOW STATUS command in mysql shows:
>
> Threads_created21863
> Threads_cached1
> Threads_connected38
> Connections5784350
>
>
> Running a SHOW VARIABLES shows:
>
> thread_cache_size8
>
> It is evident that mysqld is creating a lots of threads... Could this be
> the problem?
>
> Thanks,
>
> Ratheesh K J
>




Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently

2007-01-22 Thread Ratheesh K J
Thanks,

By how much should I be increasing the thread_cache? currently it is 8...

Currently I can provide the EXPLAIN result of a query using index_merge on 
MySQL 5.0.22.

EXPLAIN SELECT IFNULL(TAEM.FLD_FULL_NAME, TFMM.FLD_ASSIGNED_TO) AS ELE1 , 
TFMM.FLD_ASSIGNED_TO AS KEY_ID, SUM(1) AS ELE2, SUM( 
IF(TFMM.FLD_ESCALATED_FLAG= 0 , 1 , 0) ) AS ELE3, SUM( 
IF(TFMM.FLD_ESCALATED_FLAG = 0 AND ( TFMM.FLD_ISSUE_CLOSED IN ( 2, 4,5,1 ) ) , 
1, 0) ) AS ELE4, SUM( IF(TFMM.FLD_ESCALATED_FLAG = 0 AND TFMM.FLD_ISSUE_CLOSED 
= 3, 1, 0) ) AS ELE5, SUM( IF(TFMM.FLD_ESCALATED_FLAG = 1 , 1, 0) ) AS 
ELE6,SUM( IF(TFMM.FLD_ESCALATED_FLAG = 1 AND ( TFMM.FLD_ISSUE_CLOSED IN ( 2, 
4,5,1 ) ) , 1, 0) ) AS ELE7, SUM( IF(TFMM.FLD_ESCALATED_FLAG = 1 AND 
TFMM.FLD_ISSUE_CLOSED = 3, 1, 0) ) AS ELE8, ROUND(( SUM( 
IF(TFMM.FLD_ESCALATED_FLAG = 1 , 1, 0) )/SUM(1)) * 100 ,2 ) AS ELE9 FROM 
TBL_FORUMS_MSG_MAIN TFMM LEFT JOIN TBL_ADMIN_EMP_MASTER TAEM ON TAEM.FLD_EMP_ID 
= TFMM.FLD_ASSIGNED_TO INNER JOIN TBL_FORUMS_MSG_OP_TRACK TFMOT ON ( 
TFMM.FLD_MSG_ID=TFMOT.FLD_MSG_ID AND TFMOT.FLD_OP_ID=15 AND 
TFMOT.FLD_LAST_FLAG=1 ) WHERE TFMM.FLD_ACC_ID IN ( 6, 375 ) AND 
TFMM.FLD_MARK_AS_DELETED = 0 AND TFMM.FLD_BOUNCED_MAIL_FLAG = 0 AND 
TFMM.FLD_BLOCK_STATE = 0 AND TFMM.FLD_PARENT_ID = 0 AND TFMM.FLD_ASSIGNED_TO IN 
( 
935,805,563,543,1352,670,571,530,655,577,355,885,392,155,1579,693,1577,509,199,770,1535,78,54,993,594,557,132,859,99,1557,645,527,79,181,1520,200,1350,1534,1591,545,70,191,1550,189,726,40,228,97,196,860,303,1321,394,363,1412,597,1013,1377,1250,1299,3,301,756,170,1553,1578,1343,953,593,250,600,1552,494,311,146,664,589,631,495,4,1254,678,511,931,1020,410,592,822,933,1531,1507,858,453,1257,555,897,352,188,546,1544,291,1529,370,765,963,356,1303,1328,354,414,1581,1030,382,1356,1521,227,396,1333,591,1249,760,1334,1034,51,80,1276,794,145,295,934,544,165,1594,886,929,558,685,880,831,1592,882,320,566,174,796,1593,5,1361,1522,435,388,951,1362,369,806,20,1336,330,77,907,754,507,1330,1364,1,202,1501,289,1296,1378,1061,1500,952,1439,1369,1358,373,1548,294,338,30,1351,1575,728,207,1558,406,837,210,970,620,387,450,1586,38,1227,460,455,1347,841,386,318,130,492,961,590,229,463,284,1380,1580,422,362,1337,581,1490,568,950,1083,960,1329,825,532,404,936,1251,552,1089,1585,1225,708,1564,817,260,372,965,305,456,847,192,1465,962,1523,1590,745,180,1540,753,585,890,1537,1099,225,750,230,7,413,1554,578,572,820,1549,883,810,1105,1403,423,1524,969,542,286,797,1582,1301,384,930,308,854,742,1107,1108,1555,1338,1562,947,673,1506,417,236,798,1576,63,27,1210,371,1485,82,272,1274,529,1277,381,1342,689,185,1118,235,1120,37,598,724,205,946,203,608,405,610,19,958,126,307,967,1360,218,954,1525,891,116,135,75,715,1547,431,1138,879,1498,211,1140,1463,6,1528,344,956,595,91,826,1145,1584,1545,1258,443,643,632,1526,267,1530,58,945,314,1470,763,1491,1595,968,385,955,282,684,179,178,666,409,663,390,1447,1341,1546,1587,125,358,173,279,957,50,182,840,107,580,807,133,1248,892,690,513,898,365,821,325,669,121,62,827,106,219,1253,633,41,562,1489,162,101,861,561,839,153,1565,1583,395,447,217,1551,888,1574,1176,743,446,556,787,263,949,1178,1331,209,134,1505,1354,55,306,31,964,1348,850,1252,862,966,100,521,175,709,1542,942,1335,297,445,296,411,525,420,266,102,1559,418,438,109,661,804,662,1543,984,1556,1409,522,195,1471,439,341,1209,878,838,1464,881,271,36,83,1379,857,944,656,959,538,2,764,1588,672,520,503,531,462,729,528,204,201,93,677,564,426,606,855,234,676,889)
 AND TFMOT.FLD_OP_DATE_TIME BETWEEN '2007-01-19 00:00:00' AND '2007-01-23 
23:59:59' AND TFMM.FLD_MEDIUM IN ( 1 ) AND TFMM.FLD_MSG_ID > 0 GROUP BY 
IFNULL(TAEM.FLD_FULL_NAME, TFMM.FLD_ASSIGNED_TO) ORDER BY 
IFNULL(TAEM.FLD_FULL_NAME, TFMM.FLD_ASSIGNED_TO):

*** row 1 ***
  table:  TFMM
   type:  index_merge
  possible_keys:  
PRIMARY,FLD_MEDIUM,FLD_PARENT_ID,FLD_ASSIGNED_TO,FLD_MARK_AS_DELETED,FLD_ACC_ID,FLD_BLOCK_STATE,FLD_BOUNCED_MAIL_FLAG
key:  
FLD_BLOCK_STATE,FLD_MEDIUM,FLD_MARK_AS_DELETED,FLD_BOUNCED_MAIL_FLAG,FLD_PARENT_ID
key_len:  2,1,2,2,4
ref:  NULL
   rows:  34468
  Extra:  Using 
intersect(FLD_BLOCK_STATE,FLD_MEDIUM,FLD_MARK_AS_DELETED,FLD_BOUNCED_MAIL_FLAG,FLD_PARENT_ID);
 Using where; Using temporary; Using filesort
*** row 2 ***
  table:  TAEM
   type:  eq_ref
  possible_keys:  PRIMARY
key:  PRIMARY
key_len:  4
ref:  tallydb.TFMM.FLD_ASSIGNED_TO
   rows:  1
  Extra:  NULL
*** row 3 ***
  table:  TFMOT
   type:  ref
  possible_keys:  FLD_MSG_ID,FLD_OP_ID,FLD_OP_DATE_TIME,FLD_LAST_FLAG
key:  FLD_MSG_ID
key_len:  4
ref:  tallydb.TFMM.FLD_MSG_ID
   rows:  1
  Extra:  Using where

  - Original Message - 
  From: Alex Arul 
  To: Ratheesh K J 
  Sent: Tuesday, January 23, 2007 11:57 AM
  Subject: Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently


  you threads connected is 38 bu

RE: URGENT: Question on table storage

2006-12-19 Thread Tom Horstmann
Hi,

> I have the following table in mysql 5.0.20...
> 
> employ
> ==
> empid
> date_time
> site
> 
> I am using this table to store all the websites accessed by each
> employees. There is no primary key on that table since the same
> employee will access more than 100 sites per day. If there is 100
> employees then the rows inserted per day will be  ~ 100*100= 1. If
> it grows till 2 months or 3 months then the table size will become
> larger. As we all know the default table size in MySQl is 4 GB.
> 
> Can anyone explain will it produce issues in the future? How to
> overcome this? How to design a table for this scenario?

maybe this is still correct:
http://jeremy.zawodny.com/blog/archives/000796.html

But perhaps you don't need it at all:

1 records * e.g. 300 byte = 300 byte/day
4GB = 4294967296 byte
4294967296 byte / 300 byte/day = 1431 days

No issues for about 3 years. And after that time you could simply create a
new table.

hth,

Tom Horstmann




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: URGENT: Question on table storage

2006-12-19 Thread Christian Hammers


On 2006-12-19 Prem wrote:
> I am using this table to store all the websites accessed by each employees.
I hope you're aware that your country might have data privacy laws, too..

> There is no primary key on that table since the same employee will access 
> more than 
> 100 sites per day. If there is 100 employees then the rows inserted per day 
> will be  
> ~ 100*100= 1. If it grows till 2 months or 3 months then the table size 
> will 
> become larger. As we all know the default table size in MySQl is 4 GB.
Default table size maybe but a MyISAM table can grow beyond 4GB without 
problems.
(just try it by inserting lines with a script)

The general advice for handling such big tables is to either build a map table 
that maps
long hostnames to numbers ("4" = "www.google.com") to safe space or to use one 
table per
day and use a "Merge-Table" to access them all in one SELECT.

bye,

-christian-

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Urgent please..

2006-11-15 Thread Renish

Thank you very much..excellent support
- Original Message - 
From: "Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]>

To: "Renish" <[EMAIL PROTECTED]>
Cc: ; "Joshua J. Kugler" <[EMAIL PROTECTED]>
Sent: Thursday, November 16, 2006 12:16 PM
Subject: RE: Urgent please..


Hi Renish,

Perhaps these might be a more appropriate forum and also get you the
result you need. This being a database list (I'm sure there are php
experts on here) is probably not quite the right place to be asking. One
of the php lists may produce a more relevant response.

http://www.php.net/mailing-lists.php

Regards 



---
** _/ **  David Logan 
***   _/ ***  ITO Delivery Specialist - Database

*_/*  Hewlett-Packard Australia Ltd
_/_/_/  _/_/_/    E-Mail: [EMAIL PROTECTED]
   _/  _/  _/  _/     Desk:   +61 8 8408 4273
  _/  _/  _/_/_/  Mobile: +61 417 268 665
*_/   **
**  _/    Postal: 148 Frome Street,

   _/ **  Adelaide SA 5001
 Australia 
invent   
---


-Original Message-
From: Renish [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 16 November 2006 2:38 PM

To: Joshua J. Kugler
Cc: mysql@lists.mysql.com
Subject: Re: Urgent please..

Ocourse i read the manual . I was unable to do so..ie the reason I
asked...I 
also knew this location mysql@lists.mysql.com
- Original Message - 
From: "Joshua J. Kugler" <[EMAIL PROTECTED]>

To: 
Cc: "Renish" <[EMAIL PROTECTED]>
Sent: Thursday, November 16, 2006 11:20 AM
Subject: Re: Urgent please..



On Wednesday 15 November 2006 18:14, Renish wrote:

 Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on
php.exe and nothing seems to happen.
 I have intalled
1) webserver-Apache2
2) MySql-41.1


Please read the documentation before asking questions such as these. 
Thanks.


http://www.php.net/manual/en/install.windows.php

j

--
Joshua Kugler
Lead System Admin -- Senior Programmer
http://www.eeinternet.com
PGP Key: http://pgp.mit.edu/  ID 0xDB26D7CE
PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax:
907-456-3111 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: Urgent please..

2006-11-15 Thread Logan, David (SST - Adelaide)
Hi Renish,

Perhaps these might be a more appropriate forum and also get you the
result you need. This being a database list (I'm sure there are php
experts on here) is probably not quite the right place to be asking. One
of the php lists may produce a more relevant response.

http://www.php.net/mailing-lists.php

Regards 


---
** _/ **  David Logan 
***   _/ ***  ITO Delivery Specialist - Database
*_/*  Hewlett-Packard Australia Ltd
_/_/_/  _/_/_/    E-Mail: [EMAIL PROTECTED]
   _/  _/  _/  _/     Desk:   +61 8 8408 4273
  _/  _/  _/_/_/  Mobile: +61 417 268 665
*_/   **
**  _/    Postal: 148 Frome Street,
   _/ **  Adelaide SA 5001
  Australia 
invent   
---

-Original Message-
From: Renish [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 16 November 2006 2:38 PM
To: Joshua J. Kugler
Cc: mysql@lists.mysql.com
Subject: Re: Urgent please..

Ocourse i read the manual . I was unable to do so..ie the reason I
asked...I 
also knew this location mysql@lists.mysql.com
- Original Message - 
From: "Joshua J. Kugler" <[EMAIL PROTECTED]>
To: 
Cc: "Renish" <[EMAIL PROTECTED]>
Sent: Thursday, November 16, 2006 11:20 AM
Subject: Re: Urgent please..


> On Wednesday 15 November 2006 18:14, Renish wrote:
>>  Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on
>> php.exe and nothing seems to happen.
>>  I have intalled
>> 1) webserver-Apache2
>> 2) MySql-41.1
>
> Please read the documentation before asking questions such as these. 
> Thanks.
>
> http://www.php.net/manual/en/install.windows.php
>
> j
>
> -- 
> Joshua Kugler
> Lead System Admin -- Senior Programmer
> http://www.eeinternet.com
> PGP Key: http://pgp.mit.edu/  ID 0xDB26D7CE
> PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax:
907-456-3111 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Urgent please..

2006-11-15 Thread Renish
Ocourse i read the manual . I was unable to do so..ie the reason I asked...I 
also knew this location mysql@lists.mysql.com
- Original Message - 
From: "Joshua J. Kugler" <[EMAIL PROTECTED]>

To: 
Cc: "Renish" <[EMAIL PROTECTED]>
Sent: Thursday, November 16, 2006 11:20 AM
Subject: Re: Urgent please..



On Wednesday 15 November 2006 18:14, Renish wrote:

 Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on
php.exe and nothing seems to happen.
 I have intalled
1) webserver-Apache2
2) MySql-41.1


Please read the documentation before asking questions such as these. 
Thanks.


http://www.php.net/manual/en/install.windows.php

j

--
Joshua Kugler
Lead System Admin -- Senior Programmer
http://www.eeinternet.com
PGP Key: http://pgp.mit.edu/  ID 0xDB26D7CE
PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: Urgent please..

2006-11-15 Thread Logan, David (SST - Adelaide)
Try http://www.php.net/manual/en/install.windows.php 


---
** _/ **  David Logan 
***   _/ ***  ITO Delivery Specialist - Database
*_/*  Hewlett-Packard Australia Ltd
_/_/_/  _/_/_/    E-Mail: [EMAIL PROTECTED]
   _/  _/  _/  _/     Desk:   +61 8 8408 4273
  _/  _/  _/_/_/  Mobile: +61 417 268 665
*_/   **
**  _/    Postal: 148 Frome Street,
   _/ **  Adelaide SA 5001
  Australia 
invent   
---

-Original Message-
From: Renish [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 16 November 2006 1:44 PM
To: mysql@lists.mysql.com
Subject: Urgent please..

All,

 Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on
php.exe 
and nothing seems to happen.
 I have intalled
1) webserver-Apache2
2) MySql-41.1

I want to use PHP as sever side scripting.

Cheers,
Renish.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Urgent please..

2006-11-15 Thread Joshua J. Kugler
On Wednesday 15 November 2006 18:14, Renish wrote:
>  Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on
> php.exe and nothing seems to happen.
>  I have intalled
> 1) webserver-Apache2
> 2) MySql-41.1

Please read the documentation before asking questions such as these.  Thanks.

http://www.php.net/manual/en/install.windows.php

j

-- 
Joshua Kugler   
Lead System Admin -- Senior Programmer
http://www.eeinternet.com
PGP Key: http://pgp.mit.edu/  ID 0xDB26D7CE
PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Urgent: How to decode base64 via mysql V 5.0.x

2006-10-27 Thread abhishek jain

Hi,
Initially i thought it solved the problem but then i realized that the
encoding done by PERL and this mysql function is different.I compated and
found that the  difference is in a new line , in this function the encoded
output is all in one line and the same done via PERL via MIME::Base64 module
gives in a different line after some same no of characters.

Pl. someone give me  a sol. to it.
I coould have attached the files but the mailing list wont support that.
Also pl. forgive mine top posting.
--
Regards,
Abhishek jain


On 10/17/06, Ady Wicaksono <[EMAIL PROTECTED]> wrote:


http://firestuff.org/wordpress/wp-content/uploads/2006/03/base64.sql

On 10/17/06, abhishek jain < [EMAIL PROTECTED]> wrote:
> Hi,
> I want to decode base 64 string via mysql .
> Also i am using aspx .net .
> Pl. help me.
> Urgent reply will be appreciated
> --
> Regards,
> Abhishek jain
>
>



Re: Urgent: How to decode base64 via mysql V 5.0.x

2006-10-17 Thread abhishek jain

Hi,
Yes that solved the problem and was fast.
I would like to know now that is there anyother way for the same in earlier
versions of mysql.
Thanks again,
--
Regards,
Abhishek jain

On 10/17/06, Ady Wicaksono <[EMAIL PROTECTED]> wrote:


http://firestuff.org/wordpress/wp-content/uploads/2006/03/base64.sql

On 10/17/06, abhishek jain <[EMAIL PROTECTED]> wrote:
> Hi,
> I want to decode base 64 string via mysql .
> Also i am using aspx .net .
> Pl. help me.
> Urgent reply will be appreciated
> --
> Regards,
> Abhishek jain
>
>



Re: Urgent problem

2006-05-24 Thread Michael Widenius

Hi!

> "Peter" == Peter Lauri <[EMAIL PROTECTED]> writes:

Peter> Best group member,
Peter> My computer stopped working. And I was able to install Windows on another
Peter> partition and now I face one problem. I was running Windows with MySQL 
4.1.

Peter> I have all C: working, and can access all files.

Peter> The first question: Can I recover that data from MySQL?

Peter> The second question: How can I do that? (All attempts to repair Windows 
has
Peter> failed, so that option is gone)

Peter> I have gone thru the manual but all information there seems to be 
related to
Peter> if the database crashes. And some options are there when you do make
Peter> backups, but I do not have the backups.

Peter> A "desperate" soul...

In principle you can just copy the tables from one partition/computer to
another and start using them. (The MySQL version doesn't have to
exactly the same, as long as the new one is newer than the old one).

To fix this:

- Install MySQL on your new partition (computer)
- Copy all files in the MySQL data directory (normally C:\mysql\data)
  to your new partition. If the path is different, you may have to
  create a my.cnf file that includes the --basedir and --datadir
  options to your new path.
- Restart MySQL.
- Check/repair your tables by using from the command line:
  C:\mysql\bin\mysqlcheck --all-databases --auto-repair 

Regards,
Monty
CTO of MySQL AB

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Urgent Fetch and updation in single step/query

2006-04-21 Thread Barry

WEBBEE . BIZ wrote:

Hi all,
Can we run a query like UPDATE table_name set abc='1'; and still fetch the
value from a column from table .
I mean Can we run select And update query in one statement. If yes how.

Pl. tell me for versions 4.x and 5.x
Pl. do help me.


Hmm should work with PROCEDURE in both versions.

--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Urgent Fetch and updation in single step/query

2006-04-21 Thread WEBBEE . BIZ
Hi all,
Can we run a query like UPDATE table_name set abc='1'; and still fetch the
value from a column from table .
I mean Can we run select And update query in one statement. If yes how.

Pl. tell me for versions 4.x and 5.x
Pl. do help me.
--
Regards
Abhishek Jain

On 4/20/06, abhishek jain <[EMAIL PROTECTED]> wrote:
>
> No i do not want an autoincrement key , as i want to be only one row in
> the table and it value gets incremented / updated and i to know whats its
> current value.
>  --
> Regards
> Abhishek Jain
>
>
> On 4/19/06, Michael Kruckenberg < [EMAIL PROTECTED]> wrote:
> >
> > Seems like what you need is an auto-increment key. Is that out of the
> > question?
> >
> > On Apr 18, 2006, at 1:34 AM, abhishek jain wrote:
> > > Dear Friends,
> > > I run several processes and they need to query the mysql 5.0.8
> > > database
> > > simultaneously .I have a config table which have the record id. I
> > > need to
> > > fetch that and increment that .What I feel that the same record id is
> > > fetched by different simultaneosly before i update .Can anyone help
> > > me in
> > > either:
> > > 1)telling me a single query which will fetch and incr. in the same
> > > query. so
> > > the problem of simultaneously queries are solved.
> > > 2)A system by which delaying the other queries are done, I use PHP .
> > > Expecting a quick reply.
> > > Thanks,
> > > Abhishek Jain
> >
> >
>


Re: Urgent help using logon to mySQL

2005-12-28 Thread SGreen
Aftab Khan <[EMAIL PROTECTED]> wrote on 12/28/2005 02:15:33 PM:

> Can some one please tell me what I am doing wrong here I have 
installed
> and configured users in the database.  I am using ODBC driver to logon.
> When I use the password, it does not work but surprisingly the logon is
> allowed without a password.  I have tried to use MySQL Administrator to
> logon remotely but same thing.  I reset user's password and Flushed but
> still could not get the logon with blank password go away.  Any help is
> appreciated.


Depending on how you installed MySQL, you may or may not have performed 
this step of the installation process:
http://dev.mysql.com/doc/refman/4.1/en/default-privileges.html

It sounds to me that you have the anonymous account still in your 
mysql.user table.

Try this:

SELECT id, user, host, password from mysql.user;

You should be able to identify the odd account pretty easily. Just DELETE 
the account and FLUSH PRIVILEGES again and you should no longer be able to 
login without both a user name and a password.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine




RE: urgent : PLEASE HELP - problems with back up and restore

2005-11-24 Thread Barak Mery
Hi,

 

Thanks Again. You are really helping me

 

Well it get a lot of "query ok, 0 rows affected <0.00 sec>"

 

And one like this :

query ok, 2 rows affected <0.01 sec> 

Records: 2 Duplicates: 0 Warnings: 0

 

But it look like everything is in the Database now ?

What is this "Source" Command ?

 

Another thing I noticed is that My Original databes my Sp's Got "Delimiter
$$"

But on the backup file it replaced with ;;

 

Barak

 

  _  

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, November 24, 2005 7:21 AM
To: Barak Mery
Cc: mysql@lists.mysql.com
Subject: RE: urgent : PLEASE HELP - problems with back up and restore

 


I saw both views and stored procedures in the dump file. What error do you
get if you process the script with the "source" command within the MySQL
CLI? 

mysql -uroot -pmypass 
(login welcome) 
mysql> CREATE DATABASE IF NOT EXISTS bcm; 
mysql> USE bcm; 
mysql> source myback1.sql 

There is another option to drop/create the database. Your dump didn't have
that so you need to do it manually in order to restore it. 

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine 

"Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 07:18:02 PM:

> Wel I read the manual but didn't find something that I really need to add 
> I suspect it is something with the script itself. 
>   
> Now I'm using 
> mysqldump -uroot -pmypass --routines -q -x bcm>myback1.sql 
> 
> but after i run 
> mysqldump -uroot -pmypass --routines bcm>myback1.sql 
>   
> it now restore the tables but not the views or sp's 
>   
> here is the backup file 
>   
> thanks 
> Barak 
 
>   
> 
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, November 23, 2005 9:30 PM
> To: Barak Mery
> Cc: mysql@lists.mysql.com
> Subject: RE: urgent : PLEASE HELP - problems with back up and restore 
>   
> 
> There's a new option added in 5.0.13: 
> 
>  -R (--routines) 
> 
> It's designed designed specifically to dump SPROCs and FUNCTIONs. I 
> thought it would have been turned on by default but I guess it 
> wasn't. Add that to the list of options and check your dump results 
> again. I refer you again to the manual for additional warnings and
cautions. 
> 
> http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html 
> 
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine 
> 
> 
> 
> "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 02:23:42 PM:
> 
> > Well Shawn, 
> >   
> > First of thanks for the quick result. 
> >   
> > I tried your suggestion but it didn't help no sp and no restore. 
> >   
> > It only shrinked the backup file (by deleting the cr). 
> >   
> > Is there any log file where I can trace that kind of erros ? 
> >   
> > Barak 
> >   
> >   
> >   
> > 
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
> > Sent: Wednesday, November 23, 2005 9:07 PM
> > To: Barak Mery
> > Cc: mysql@lists.mysql.com
> > Subject: Re: urgent : PLEASE HELP - problems with back up and restore 
> >   
> > 
> > 
> > "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM:
> > 
> > > Hi,
> > > 
> > >  
> > > 
> > > I'm really desperate on this on.
> > > 
> > > After struggling with some really weird bugs I finally finished 
> my project.
> > > 
> > >  
> > > 
> > > Buut I can't perform a good backup and restore.
> > > 
> > >  
> > > 
> > > I'm using  :
> > > 
> > > MySql 5.0.16-nt (essentials version)
> > > 
> > > Windows xp
> > > 
> > > The DB contains tables, vw's and sp's.
> > > 
> > > It is a very small one and at the moment I don't have any data inside.
> > > 
> > > The whole backup file size is 100Kb.
> > > 
> > >  
> > > 
> > > 1.   I backed up my db using mysql administrator.
> > > It created a back up file with all tables, views and sp's, but 
> when I tried
> > > a restore it got errors like.
> > > "Could not handle this statement etc.
> > > 
> > > 
> > > 2.   I tried : mysqldump -uroot -pmypassword dbname > backup.sql
> > > And then mysqldump -uroot -pmypassword newDbName < backup.sql
> > > I didn't get any error.
> > > The shell printed to the screen the backup file completely only 
> without the
> >

RE: urgent : PLEASE HELP - problems with back up and restore

2005-11-23 Thread SGreen
I saw both views and stored procedures in the dump file. What error do you 
get if you process the script with the "source" command within the MySQL 
CLI?

mysql -uroot -pmypass
(login welcome)
mysql> CREATE DATABASE IF NOT EXISTS bcm;
mysql> USE bcm;
mysql> source myback1.sql

There is another option to drop/create the database. Your dump didn't have 
that so you need to do it manually in order to restore it.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

"Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 07:18:02 PM:

> Wel I read the manual but didn’t find something that I really need to 
add
> I suspect it is something with the script itself.
> 
> Now I’m using
> mysqldump -uroot -pmypass --routines -q -x bcm>myback1.sql 
> 
> but after i run 
> mysqldump -uroot -pmypass --routines bcm>myback1.sql
> 
> it now restore the tables but not the views or sp’s
> 
> here is the backup file
> 
> thanks 
> Barak

> 
> 
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, November 23, 2005 9:30 PM
> To: Barak Mery
> Cc: mysql@lists.mysql.com
> Subject: RE: urgent : PLEASE HELP - problems with back up and restore
> 
> 
> There's a new option added in 5.0.13: 
> 
>  -R (--routines) 
> 
> It's designed designed specifically to dump SPROCs and FUNCTIONs. I 
> thought it would have been turned on by default but I guess it 
> wasn't. Add that to the list of options and check your dump results 
> again. I refer you again to the manual for additional warnings and 
cautions. 
> 
> http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html 
> 
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine 
> 
> 
> 
> "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 02:23:42 PM:
> 
> > Well Shawn, 
> > 
> > First of thanks for the quick result. 
> > 
> > I tried your suggestion but it didn’t help no sp and no restore. 
> > 
> > It only shrinked the backup file (by deleting the cr). 
> > 
> > Is there any log file where I can trace that kind of erros ? 
> > 
> > Barak 
> > 
> > 
> > 
> > 
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
> > Sent: Wednesday, November 23, 2005 9:07 PM
> > To: Barak Mery
> > Cc: mysql@lists.mysql.com
> > Subject: Re: urgent : PLEASE HELP - problems with back up and restore 
> > 
> > 
> > 
> > "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM:
> > 
> > > Hi,
> > > 
> > > 
> > > 
> > > I'm really desperate on this on.
> > > 
> > > After struggling with some really weird bugs I finally finished 
> my project.
> > > 
> > > 
> > > 
> > > Buut I can't perform a good backup and restore.
> > > 
> > > 
> > > 
> > > I'm using  :
> > > 
> > > MySql 5.0.16-nt (essentials version)
> > > 
> > > Windows xp
> > > 
> > > The DB contains tables, vw's and sp's.
> > > 
> > > It is a very small one and at the moment I don't have any data 
inside.
> > > 
> > > The whole backup file size is 100Kb.
> > > 
> > > 
> > > 
> > > 1.   I backed up my db using mysql administrator.
> > > It created a back up file with all tables, views and sp's, but 
> when I tried
> > > a restore it got errors like.
> > > "Could not handle this statement etc.
> > > 
> > > 
> > > 2.   I tried : mysqldump -uroot -pmypassword dbname > backup.sql
> > > And then mysqldump -uroot -pmypassword newDbName < backup.sql
> > > I didn't get any error.
> > > The shell printed to the screen the backup file completely only 
> without the
> > > table script part.
> > > 
> > > It Created a backup file only for the tables (why ? a minute agoI 
did the
> > > backup with the same tool).
> > > But after restoring, the new db was still empty.
> > > 
> > > 
> > > 3.   I tried to restore with mysql > -uroot -pmypassword newDbName <
> > > backup.sql
> > > But I got the same results.
> > > 
> > > 
> > > 
> > > 
> > > 
> > > It should be a very simple and basic issue.
> > > Why everything is so hard with mysql ?
> > > 
> > > 
> > > 
> > > Is there any really good and quick forum for mySql ? I posted some 
new
> > > thread i

RE: urgent : PLEASE HELP - problems with back up and restore

2005-11-23 Thread Barak Mery
Thanks Marko :)

-Original Message-
From: Marko Knezevic [mailto:[EMAIL PROTECTED] 
Sent: Thursday, November 24, 2005 12:29 AM
To: MySQL list
Subject: Re: urgent : PLEASE HELP - problems with back up and restore

Dear Barak,

Save yourself year or two of your life and try using MySQL Front not that 
command line tools. Its really nice tool for handling MySQL databases

Regards
Marko 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: urgent : PLEASE HELP - problems with back up and restore

2005-11-23 Thread Barak Mery
Thanks again,

 

I will try this and read the manual again.

 

  _  

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 23, 2005 9:30 PM
To: Barak Mery
Cc: mysql@lists.mysql.com
Subject: RE: urgent : PLEASE HELP - problems with back up and restore

 


There's a new option added in 5.0.13: 

 -R (--routines) 

It's designed designed specifically to dump SPROCs and FUNCTIONs. I thought
it would have been turned on by default but I guess it wasn't. Add that to
the list of options and check your dump results again. I refer you again to
the manual for additional warnings and cautions. 

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html 

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine 



"Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 02:23:42 PM:

> Well Shawn, 
>   
> First of thanks for the quick result. 
>   
> I tried your suggestion but it didn't help no sp and no restore. 
>   
> It only shrinked the backup file (by deleting the cr). 
>   
> Is there any log file where I can trace that kind of erros ? 
>   
> Barak 
>   
>   
>   
> 
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, November 23, 2005 9:07 PM
> To: Barak Mery
> Cc: mysql@lists.mysql.com
> Subject: Re: urgent : PLEASE HELP - problems with back up and restore 
>   
> 
> 
> "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM:
> 
> > Hi,
> > 
> >  
> > 
> > I'm really desperate on this on.
> > 
> > After struggling with some really weird bugs I finally finished my
project.
> > 
> >  
> > 
> > Buut I can't perform a good backup and restore.
> > 
> >  
> > 
> > I'm using  :
> > 
> > MySql 5.0.16-nt (essentials version)
> > 
> > Windows xp
> > 
> > The DB contains tables, vw's and sp's.
> > 
> > It is a very small one and at the moment I don't have any data inside.
> > 
> > The whole backup file size is 100Kb.
> > 
> >  
> > 
> > 1.   I backed up my db using mysql administrator.
> > It created a back up file with all tables, views and sp's, but when I
tried
> > a restore it got errors like.
> > "Could not handle this statement etc.
> > 
> > 
> > 2.   I tried : mysqldump -uroot -pmypassword dbname > backup.sql
> > And then mysqldump -uroot -pmypassword newDbName < backup.sql
> > I didn't get any error.
> > The shell printed to the screen the backup file completely only without
the
> > table script part.
> > 
> > It Created a backup file only for the tables (why ? a minute ago I did
the
> > backup with the same tool).
> > But after restoring, the new db was still empty.
> > 
> > 
> > 3.   I tried to restore with mysql > -uroot -pmypassword newDbName <
> > backup.sql
> > But I got the same results.
> > 
> >  
> > 
> >  
> > 
> > It should be a very simple and basic issue.
> > Why everything is so hard with mysql ?
> > 
> > 
> > 
> > Is there any really good and quick forum for mySql ? I posted some new
> > thread in mysql.com at the past few days but never got answered.
> > 
> >  
> > 
> > Is it just me or that's the life on the mysql planet ?
> > 
> > 
> > 
> > I now try this mailing-list. I hope you can help me.
> > 
> >  
> > 
> > Thanks in advance
> > 
> > Barak
> 
> You are in luck as the mailing list is quite active. 
> 
> Look at your actual dump file. It is simply a SQL script that will 
> create all of the "elements" of the database and populate them with 
> data (if you had any). My suspicion is that you have something that 
> isn't quoted that needed to be. 
> 
> mysqldump has several options. You can see them with the command: 
> 
> mysqldump --help 
> 
> -or- refer to the manual 
> 
> http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html 
> 
> try dumping your database again, this time use the -r= and -Q 
> options. That does two things: 
> 
> a) it avoids adding CR characters at the end of every line 
> b) it puts backticks around EVERYTHING that needs them (table names,
> column names, etc) 
> 
> 
> mysqldump -uroot -pmypassword -r backup.sql -Q dbname 
> 
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine 



RE: urgent : PLEASE HELP - problems with back up and restore

2005-11-23 Thread SGreen
There's a new option added in 5.0.13:

 -R (--routines) 

It's designed designed specifically to dump SPROCs and FUNCTIONs. I 
thought it would have been turned on by default but I guess it wasn't. Add 
that to the list of options and check your dump results again. I refer you 
again to the manual for additional warnings and cautions.

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine



"Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 02:23:42 PM:

> Well Shawn, 
> 
> First of thanks for the quick result.
> 
> I tried your suggestion but it didn’t help no sp and no restore.
> 
> It only shrinked the backup file (by deleting the cr).
> 
> Is there any log file where I can trace that kind of erros ?
> 
> Barak
> 
> 
> 
> 
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, November 23, 2005 9:07 PM
> To: Barak Mery
> Cc: mysql@lists.mysql.com
> Subject: Re: urgent : PLEASE HELP - problems with back up and restore
> 
> 
> 
> "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM:
> 
> > Hi,
> > 
> > 
> > 
> > I'm really desperate on this on.
> > 
> > After struggling with some really weird bugs I finally finished my 
project.
> > 
> > 
> > 
> > Buut I can't perform a good backup and restore.
> > 
> > 
> > 
> > I'm using  :
> > 
> > MySql 5.0.16-nt (essentials version)
> > 
> > Windows xp
> > 
> > The DB contains tables, vw's and sp's.
> > 
> > It is a very small one and at the moment I don't have any data inside.
> > 
> > The whole backup file size is 100Kb.
> > 
> > 
> > 
> > 1.   I backed up my db using mysql administrator.
> > It created a back up file with all tables, views and sp's, but when I 
tried
> > a restore it got errors like.
> > "Could not handle this statement etc.
> > 
> > 
> > 2.   I tried : mysqldump -uroot -pmypassword dbname > backup.sql
> > And then mysqldump -uroot -pmypassword newDbName < backup.sql
> > I didn't get any error.
> > The shell printed to the screen the backup file completely only 
without the
> > table script part.
> > 
> > It Created a backup file only for the tables (why ? a minute ago I did 
the
> > backup with the same tool).
> > But after restoring, the new db was still empty.
> > 
> > 
> > 3.   I tried to restore with mysql > -uroot -pmypassword newDbName <
> > backup.sql
> > But I got the same results.
> > 
> > 
> > 
> > 
> > 
> > It should be a very simple and basic issue.
> > Why everything is so hard with mysql ?
> > 
> > 
> > 
> > Is there any really good and quick forum for mySql ? I posted some new
> > thread in mysql.com at the past few days but never got answered.
> > 
> > 
> > 
> > Is it just me or that's the life on the mysql planet ?
> > 
> > 
> > 
> > I now try this mailing-list. I hope you can help me.
> > 
> > 
> > 
> > Thanks in advance
> > 
> > Barak
> 
> You are in luck as the mailing list is quite active. 
> 
> Look at your actual dump file. It is simply a SQL script that will 
> create all of the "elements" of the database and populate them with 
> data (if you had any). My suspicion is that you have something that 
> isn't quoted that needed to be. 
> 
> mysqldump has several options. You can see them with the command: 
> 
> mysqldump --help 
> 
> -or- refer to the manual 
> 
> http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html 
> 
> try dumping your database again, this time use the -r= and -Q 
> options. That does two things: 
> 
> a) it avoids adding CR characters at the end of every line 
> b) it puts backticks around EVERYTHING that needs them (table names,
> column names, etc) 
> 
> 
> mysqldump -uroot -pmypassword -r backup.sql -Q dbname 
> 
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine


RE: urgent : PLEASE HELP - problems with back up and restore

2005-11-23 Thread Barak Mery
Well Shawn, 

 

First of thanks for the quick result.

 

I tried your suggestion but it didn't help no sp and no restore.

 

It only shrinked the backup file (by deleting the cr).

 

Is there any log file where I can trace that kind of erros ?

 

Barak

 

 

 

  _  

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 23, 2005 9:07 PM
To: Barak Mery
Cc: mysql@lists.mysql.com
Subject: Re: urgent : PLEASE HELP - problems with back up and restore

 



"Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM:

> Hi,
> 
>  
> 
> I'm really desperate on this on.
> 
> After struggling with some really weird bugs I finally finished my
project.
> 
>  
> 
> Buut I can't perform a good backup and restore.
> 
>  
> 
> I'm using  :
> 
> MySql 5.0.16-nt (essentials version)
> 
> Windows xp
> 
> The DB contains tables, vw's and sp's.
> 
> It is a very small one and at the moment I don't have any data inside.
> 
> The whole backup file size is 100Kb.
> 
>  
> 
> 1.   I backed up my db using mysql administrator.
> It created a back up file with all tables, views and sp's, but when I
tried
> a restore it got errors like.
> "Could not handle this statement etc.
> 
> 
> 2.   I tried : mysqldump -uroot -pmypassword dbname > backup.sql
> And then mysqldump -uroot -pmypassword newDbName < backup.sql
> I didn't get any error.
> The shell printed to the screen the backup file completely only without
the
> table script part.
> 
> It Created a backup file only for the tables (why ? a minute ago I did the
> backup with the same tool).
> But after restoring, the new db was still empty.
> 
> 
> 3.   I tried to restore with mysql > -uroot -pmypassword newDbName <
> backup.sql
> But I got the same results.
> 
>  
> 
>  
> 
> It should be a very simple and basic issue.
> Why everything is so hard with mysql ?
> 
> 
> 
> Is there any really good and quick forum for mySql ? I posted some new
> thread in mysql.com at the past few days but never got answered.
> 
>  
> 
> Is it just me or that's the life on the mysql planet ?
> 
> 
> 
> I now try this mailing-list. I hope you can help me.
> 
>  
> 
> Thanks in advance
> 
> Barak

You are in luck as the mailing list is quite active. 

Look at your actual dump file. It is simply a SQL script that will create
all of the "elements" of the database and populate them with data (if you
had any). My suspicion is that you have something that isn't quoted that
needed to be. 

mysqldump has several options. You can see them with the command: 

mysqldump --help 

-or- refer to the manual 

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html 

try dumping your database again, this time use the -r= and -Q options. That
does two things: 

a) it avoids adding CR characters at the end of every line 
b) it puts backticks around EVERYTHING that needs them (table names, column
names, etc) 


mysqldump -uroot -pmypassword -r backup.sql -Q dbname 

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine



Re: urgent : PLEASE HELP - problems with back up and restore

2005-11-23 Thread SGreen
"Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM:

> Hi,
> 
> 
> 
> I'm really desperate on this on.
> 
> After struggling with some really weird bugs I finally finished my 
project.
> 
> 
> 
> Buut I can't perform a good backup and restore.
> 
> 
> 
> I'm using  :
> 
> MySql 5.0.16-nt (essentials version)
> 
> Windows xp
> 
> The DB contains tables, vw's and sp's.
> 
> It is a very small one and at the moment I don't have any data inside.
> 
> The whole backup file size is 100Kb.
> 
> 
> 
> 1.   I backed up my db using mysql administrator.
> It created a back up file with all tables, views and sp's, but when I 
tried
> a restore it got errors like.
> "Could not handle this statement etc.
> 
> 
> 2.   I tried : mysqldump -uroot -pmypassword dbname > backup.sql
> And then mysqldump -uroot -pmypassword newDbName < backup.sql
> I didn't get any error.
> The shell printed to the screen the backup file completely only without 
the
> table script part.
> 
> It Created a backup file only for the tables (why ? a minute ago I did 
the
> backup with the same tool).
> But after restoring, the new db was still empty.
> 
> 
> 3.   I tried to restore with mysql > -uroot -pmypassword newDbName <
> backup.sql
> But I got the same results.
> 
> 
> 
> 
> 
> It should be a very simple and basic issue.
> Why everything is so hard with mysql ?
> 
> 
> 
> Is there any really good and quick forum for mySql ? I posted some new
> thread in mysql.com at the past few days but never got answered.
> 
> 
> 
> Is it just me or that's the life on the mysql planet ?
> 
> 
> 
> I now try this mailing-list. I hope you can help me.
> 
> 
> 
> Thanks in advance
> 
> Barak

You are in luck as the mailing list is quite active. 

Look at your actual dump file. It is simply a SQL script that will create 
all of the "elements" of the database and populate them with data (if you 
had any). My suspicion is that you have something that isn't quoted that 
needed to be.

mysqldump has several options. You can see them with the command: 

mysqldump --help

-or- refer to the manual

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

try dumping your database again, this time use the -r= and -Q options. 
That does two things:

a) it avoids adding CR characters at the end of every line
b) it puts backticks around EVERYTHING that needs them (table names, 
column names, etc)


mysqldump -uroot -pmypassword -r backup.sql -Q dbname

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Re: URGENT --- OSX 10.4 ODBC driver error

2005-09-11 Thread Josh Chamas

Andrew stolarz wrote:

Hello All,
 I am downloading and installing the "Installer package (Mac OS X v10.3)" 
from the mysql site.
I am installing on a OSX 10.4 machine, at the end of the install I get an 
error message saying
 "The application MYODBCConfig quit unexpedically after it was reopened, max 
OSX and other applications are not effected etc. etc."

 its version : 3.51.11-1
 so this ODBC driver will not work on the 10.4 machine? as right next to the 
download it states OSX v10.3

 (installing on 10.3 works no problem)


Sorry, I can't help here, but noted this was an urgent request.
If you need urgent help, please contact MySQL Support at:

  https://support.mysql.com

Regards,

Josh
--
Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL!  www.mysql.com/consulting

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Urgent Pls....

2005-07-27 Thread Gleb Paharenko
Hello.





> chown: `mysql:mysql': invalid user



Add mysql user and group (though, I thought that RPM package

automatically does this). Please, next time send you replies 

to the list as well.





Ashok Kumar wrote:

> Hi Gleb,

>  Thank u for ur reply. I downloaded the following

> files.

> 

> MySQL-server-4.1.13-0.i386.rpm

> MySQL-client-4.1.13-0.i386.rpm

> MySQL-devel-4.1.13-0.i386.rpm

> MySQL-shared-4.1.13-0.i386.rpm

> 

>  When i tried to install the server following messages

> are coming. (In previous time i installed the same

> files in other PC, there it was working well. but here

> it's not working).

> 

> [EMAIL PROTECTED] Mysql4.1]# rpm -ia

> MySQL-server-4.1.13-0.i386.rpm

> warning: MySQL-server-4.1.13-0.i386.rpm: V3 DSA

> signature: NOKEY, key ID 5072e1f5

> chown: `mysql:mysql': invalid user

> chown: `mysql': invalid user

> 050722  8:43:31 [Warning] Asked for 196608 thread

> stack, but got 126976

> 050722  8:43:31 [ERROR] Fatal error: Can't change to

> run as user 'mysql' ;  Please check that the user

> exists!

>  

> 050722  8:43:31 [ERROR] Aborting

>  

> 050722  8:43:31 [Note] /usr/sbin/mysqld: Shutdown

> complete

>  

> /usr/bin/mysql_create_system_tables: line 663:  4260

> Broken pipe cat  < use mysql;

> set table_type=myisam;

> $c_d

> $i_d

>  

> $c_h

> $i_h

>  

> $c_u

> $i_u

>  

> $c_f

> $i_f

>  

> $c_t

> $c_c

>  

> $c_ht

> $c_hc

> $c_hr

> $c_hk

>  

> $c_tzn

> $i_tzn

> $c_tz

> $i_tz

> $c_tzt

> $i_tzt

> $c_tztt

> $i_tztt

> $c_tzls

> $i_tzls

> END_OF_DATA

>  

> Installation of system tables failed!

>  

> Examine the logs in /var/lib/mysql for more

> information.

> You can also try to start the mysqld daemon with:

> /usr/sbin/mysqld --skip-grant &

> You can use the command line tool

> /usr/bin/mysql to connect to the mysql

> database and look at the grant tables:

>  

> shell> /usr/bin/mysql -u root mysql

> mysql> show tables

>  

> Try 'mysqld --help' if you have problems with paths.

> Using --log

> gives you a log in /var/lib/mysql that may be helpful.

>  

> The latest information about MySQL is available on the

> web at

> http://www.mysql.com

> Please consult the MySQL manual section: 'Problems

> running mysql_install_db',

> and the manual section that describes problems on your

> OS.

> Another information source is the MySQL email archive.

> Please check all of the above before mailing us!

> And if you do mail us, you MUST use the

> /usr/bin/mysqlbug script!

> chown: `mysql:mysql': invalid user

> Starting MySQL..ERROR!

> 

>  I'm totally confused. Since i'm new to Linux i can't

> find the errors on that.

> 

>  I'm waiting for ur reply.

> 

> Thanks and Regards,

>  Ashok.

> 

> 

> 

> 

> --- Gleb Paharenko <[EMAIL PROTECTED]> wrote:

> 

> 

>>Hello.

>>

>>Use Linux x86 RPM downloads for 4.1.13: Server,

>>Client programs, Libraries and

>>header files, Dynamic client libraries. See:

>>

>>http://dev.mysql.com/doc/mysql/en/which-version.html

>>

>>

>>

>>Ashok Kumar <[EMAIL PROTECTED]> wrote:

>>

>>>Dear Sir/Madam,

>>>I'm totally strugling on choosing the mysql

>>>distribution for my "RedHat Linux9.0". My system

>>>config is as follows.

>>>

> 

> 

> 

> 

>   

> 

> Start your day with Yahoo! - make it your home page 

> http://www.yahoo.com/r/hs 

>  



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Urgent Pls....

2005-07-21 Thread Gleb Paharenko
Hello.



Use Linux x86 RPM downloads for 4.1.13: Server, Client programs, Libraries and

header files, Dynamic client libraries. See:

http://dev.mysql.com/doc/mysql/en/which-version.html







Ashok Kumar <[EMAIL PROTECTED]> wrote:

> Dear Sir/Madam,

> I'm totally strugling on choosing the mysql

> distribution for my "RedHat Linux9.0". My system

> config is as follows.

> 

> 1.Pentium 4 and Intel845 Chipset (Intel Original

> Board)

> 2.gcc version - (GCC) 3.2.2 20030222 (Red Hat Linux

> 3.2.2-5)

> 

> I'm trying to develop the client programs.

> 

> Pls, help me on this as soon as possible.

> 

> Thanks and Regards,

> Ashok.

> 

> 

> __

> Do You Yahoo!?

> Tired of spam?  Yahoo! Mail has the best spam protection around 

> http://mail.yahoo.com 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: urgent 4.1.11 / 4.1.12 upgrade

2005-06-09 Thread Douglas K. Fischer

Chris Knipe wrote:


Hi,

We've just upgraded (via FreeBSD Ports) our one database from 4.1.11 
to 4.1.12, and we are being hit by 
http://bugs.mysql.com/bug.php?id=10674 - only on certain queries, 
using rather large temp tables.


Now, from what I understand, there is a 4.1.12-1 available?  Where is 
the source?  It seems there is only a source RPM available on 
dev.mysql.com, the source tar ball will be good though.


As far as I know, 4.1.12-1 is just the repackaged RPM for 4.1.12 (the 
original RPM was flawed and required repackaging). Nothing with the code 
changed for the RPM repackaging, just the RPM package itself. This was 
also specific to the Linux packages, so the FreeBSD packages were not 
affected. You can download the FreeBSD pre-compiled binaries as well as 
the source tarball from http://dev.mysql.com/downloads/mysql/4.1.html


Cheers,

Doug



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Urgent help...

2005-05-13 Thread Gleb Paharenko
Hello.



In my previous post I gave you a link to the thread where had

been described how to create the my_global.h. Have you tried that?





>Hi,

> U replied me without any contents. pls help me by giving some tips.

>  

>   Thanks and Regards,

>Ashok Kumar.P.S.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Urgent help...

2005-05-13 Thread Gleb Paharenko
Hello.



See:

  http://lists.mysql.com/mysql/180308





Ashok Kumar <[EMAIL PROTECTED]> wrote:

> [-- text/plain, encoding 7bit, charset: us-ascii, 11 lines --]

> 

> Hello Friends,

>  I wrote one simple pgm to connect and disconnect the database in 
> TC(Windows). when compiling the program, it's giving the error, unable to 
> open the my_global.h and giving some more errors from the header files 
> my_sys.h and mysql.h. I copied all the header files from the mysql\include to 
> tc\include. but i'm getting this error repeatedly. What can i do for that.

> 

> Thanks and Regards,

> Ashok Kumar.P.S

> 

> 

>

> -

> Do you Yahoo!?

> Yahoo! Mail - Find what you need with new enhanced search. Learn more.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: URGENT !! InnoDB Constraint problem !

2004-06-07 Thread Heikki Tuuri
Dimitri,

please upgrade to a newer MySQL version.

"
Starting from MySQL 4.0.13, you can use SHOW INNODB STATUS to display a
detailed explanation of the latest InnoDB foreign key error in the server.
"

Best regards,

Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php

Order MySQL technical support from https://order.mysql.com/



- Original Message - 
From: "Dimitri Bosiers" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, June 07, 2004 12:56 PM
Subject: URGENT !! InnoDB Constraint problem !


> i dont have that section in my status report (ill tried it before)
> here's the report
> *** 1. row ***
> Status:
> =
> 040607 10:04:41 INNODB MONITOR OUTPUT
> =
> Per second averages calculated from the last 5 seconds
> --
> SEMAPHORES
> --
> OS WAIT ARRAY INFO: reservation count 24, signal count 24
> Mutex spin waits 4, rounds 41, OS waits 0
> RW-shared spins 48, OS waits 24; RW-excl spins 1, OS waits 0
> 
> TRANSACTIONS
> 
> Trx id counter 0 22817
> Purge done for trx's n:o < 0 22815 undo n:o < 0 0
> Total number of lock structs in row lock hash table 0
> LIST OF TRANSACTIONS FOR EACH SESSION:
> 
> FILE I/O
> 
> I/O thread 0 state: waiting for i/o request
> I/O thread 1 state: waiting for i/o request
> I/O thread 2 state: waiting for i/o request
> I/O thread 3 state: waiting for i/o request
> Pending normal aio reads: 0, aio writes: 0,
>   ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
> Pending flushes (fsync) log: 0; buffer pool: 0
> 78 OS file reads, 157 OS file writes, 94 OS fsyncs
> 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
> -
> INSERT BUFFER AND ADAPTIVE HASH INDEX
> -
> Ibuf for space 0: size 1, free list len 0, seg size 2,
> 0 inserts, 0 merged recs, 0 merges
> Hash table size 34679, used cells 0, node heap has 1 buffer(s)
> 0.00 hash searches/s, 0.00 non-hash searches/s
> ---
> LOG
> ---
> Log sequence number 0 1345367
> Log flushed up to   0 1345367
> Last checkpoint at  0 1345367
> 0 pending log writes, 0 pending chkp writes
> 53 log i/o's done, 0.00 log i/o's/second
> --
> BUFFER POOL AND MEMORY
> --
> Total memory allocated 16796660; in additional pool allocated 673536
> Buffer pool size   512
> Free buffers   473
> Database pages 38
> Modified db pages  0
> Pending reads 0
> Pending writes: LRU 0, flush list 0, single page 0
> Pages read 38, created 0, written 103
> 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
> No buffer pool activity since the last printout
> --
> ROW OPERATIONS
> --
> 0 queries inside InnoDB, 0 queries in queue; main thread: waiting for
> server activity
> Number of rows inserted 6, updated 0, deleted 5, read 1264
> 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
> 
> END OF INNODB MONITOR OUTPUT
> 
> On 06 Jun 2004, at 16:37, Josh Trutwin wrote:
>
> > On Sun, 6 Jun 2004 15:48:37 +0200
> > Dimitri Bosiers <[EMAIL PROTECTED]> wrote:
> >
> > 
> >
> >> INSERT INTO
> >> pages(hidden,name,page_number,data,is_section_root,layout_id,group_
> >> id)  VALUES(1,'nieuwe pagina',100,'',2,1,@LID);
> >>
> >> this fails with a "ERROR 1216: Cannot add a child row: a foreign key
> >>
> >> constraint fails"
> >
> > Run:
> >
> > SHOW INNODB STATUS;
> >
> > And post the results in the "Latest Foreign Key Error" section.
> >
> > Josh
> >
> > -- 
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: URGENT !! InnoDB Constraint problem !

2004-06-06 Thread Josh Trutwin
On Sun, 6 Jun 2004 15:48:37 +0200
Dimitri Bosiers <[EMAIL PROTECTED]> wrote:



> INSERT INTO  
> pages(hidden,name,page_number,data,is_section_root,layout_id,group_
> id)  VALUES(1,'nieuwe pagina',100,'',2,1,@LID);
> 
> this fails with a "ERROR 1216: Cannot add a child row: a foreign key
>  
> constraint fails"

Run:

SHOW INNODB STATUS;

And post the results in the "Latest Foreign Key Error" section.

Josh

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: urgent: how to increase the database size

2004-04-29 Thread kamlesh pandey
If you are getting table full error,may be your table
size is exceeding the maximum default size allowed.
check the table size and default size.

You can change the maximum size of the table using
Alter table command.
Somthing like following,but it is better so back up
the database before doing this,otherwise if the  new
size(MAX_ROWS*AVG_ROW_LENGHT)
is smaller ,your data will be lost.
examle:

ALTER TABLE tbl_name MAX_ROWS=10
AVG_ROW_LENGTH=nnn;

ALso check the table status

Show table status "tablename";

kam...
--- [EMAIL PROTECTED] wrote:
> 
> 
> 
> 
> Hi,
> 
> I am trying to insert the records in the database.
> After the insertion of
> 3millions records, it fails to insert the records
> further. Can someone help
> me in this problem. How do I go and increase the
> capacity of the database.
> Moreover if someone can provide me the maximum size
> of the database which
> is possible.
> 
> Regards,
> Anup Mahansaria
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:   
>
http://lists.mysql.com/[EMAIL PROTECTED]
> 


=
"Don't worry about the world coming to an end today. It's already tomorrow in 
Australia."

¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°¤º°
Do You Yahoo !
¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°¤º°




__
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs  
http://hotjobs.sweepstakes.yahoo.com/careermakeover 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: urgent: how to increase the database size

2004-04-29 Thread Eric
Hi,

Unless he is having some weird nightmare that doesn't involve reality, then I am 
pretty sure he is talking about this in the my.cnf:

innodb_data_file_path = ibdata1:400M:autoextend

A while back I remember that the autoextend was not in the sample my.cnf files. I 
think this was around 4.0.1 or something like that. 
So in that case, if you don't have autoextend, you could have a db with a max size. 

Or maybe he is just running out of disk space :) 

Thanks,

Eric 

At 08:29 AM 4/29/2004, Paul DuBois wrote:
>At 23:32 +0530 4/28/04, [EMAIL PROTECTED] wrote:
>>Hi,
>>
>>I am trying to insert the records in the database. After the insertion of
>>3millions records, it fails to insert the records further. Can someone help
>>me in this problem. How do I go and increase the capacity of the database.
>>Moreover if someone can provide me the maximum size of the database which
>>is possible.
>
>Databases don't have a maximum size.
>
>You'll probably get a better answer if you provide information more specific
>than "it fails."  For example, do you get an error message?  If so, what is
>it?
>
>-- 
>Paul DuBois, MySQL Documentation Team
>Madison, Wisconsin, USA
>MySQL AB, www.mysql.com
>
>-- 
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: urgent: how to increase the database size

2004-04-29 Thread Paul DuBois
At 23:32 +0530 4/28/04, [EMAIL PROTECTED] wrote:
Hi,

I am trying to insert the records in the database. After the insertion of
3millions records, it fails to insert the records further. Can someone help
me in this problem. How do I go and increase the capacity of the database.
Moreover if someone can provide me the maximum size of the database which
is possible.
Databases don't have a maximum size.

You'll probably get a better answer if you provide information more specific
than "it fails."  For example, do you get an error message?  If so, what is
it?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


Re: urgent: how to increase the database size

2004-04-28 Thread Rhino

- Original Message - 
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 28, 2004 2:02 PM
Subject: urgent: how to increase the database size


[snip]

> Moreover if someone can provide me the maximum size of the database which
> is possible.
>
Have you tried looking in the MySQL manual? The maximum size is right there
in section 1.2.4. http://dev.mysql.com/doc/mysql/en/Table_size.html

That should be the FIRST place you look if your need is urgent. Or does
"urgent" just mean "I can't be bothered to look in the manual"?

You would probably also find information on increasing the size of your
table in the manual, assuming you haven't exceeded the maximum size.

Rhino


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: urgent help needed on replication on windows 2000

2004-03-31 Thread amahansaria




Hi,

I am using release 5.

What is the release you recommend for such a scenario.

Regards,
Anup Mahansaria


   
 "Dathan Vance 
 Pattishall"   
 <[EMAIL PROTECTED]  To 
 r.com><[EMAIL PROTECTED]>,  
   <[EMAIL PROTECTED]> 
 04/01/04 11:40 AM  cc 
   
   Subject 
           RE: urgent help needed on   
   replication on windows 2000 
   
   
   
   
   
   




What version of mySQL are you using, 4.0.19 (not yet released) fixes
something similar to what you have described.


--
DVP

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 31, 2004 7:49 PM
> To: [EMAIL PROTECTED]
> Subject: urgent help needed on replication on windows 2000
>
>
>
>
>
> Hi,
>
> I am working on mysql repliction on windows 2000.
>
> I am trying to make the slave as master when the master goes down. When I
> execute the io thread shutdown on slave after master goes down, it hangs.
> Even the slave server does not stop on executing the shutdown command
> using
> mysqladmin and root user.
>
>
> Regards,
> Anup Mahansaria
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]






-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: urgent help needed on replication on windows 2000

2004-03-31 Thread Dathan Vance Pattishall
What version of mySQL are you using, 4.0.19 (not yet released) fixes
something similar to what you have described.


--
DVP

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 31, 2004 7:49 PM
> To: [EMAIL PROTECTED]
> Subject: urgent help needed on replication on windows 2000
> 
> 
> 
> 
> 
> Hi,
> 
> I am working on mysql repliction on windows 2000.
> 
> I am trying to make the slave as master when the master goes down. When I
> execute the io thread shutdown on slave after master goes down, it hangs.
> Even the slave server does not stop on executing the shutdown command
> using
> mysqladmin and root user.
> 
> 
> Regards,
> Anup Mahansaria
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: URGENT: Trying to recover MySQL DB on OSX 10.3.3

2004-03-24 Thread Sasha Pachev
Marc Boorshtein wrote:
Hello,

I am urgently trying to restore a mysql database that was corrupted when
upgrading from OSX 10.3.2 to 10.3.3.  I have tried downloading MySQL 4.0.14
and coping the original data files for the db into the appropriate "data"
directory, but the datetime fields are still corrupted.  Does anyone know if
this data is recoverable?
Marc:

Any chance you can rebuild the original system with the pre-upgrade data? Then 
you can use mysqldump and load it back in. That would be the best option.

If not, check to see if the timestamps are offset in some pattern, and if so, 
correct it with an update query.

--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


Re: urgent help required for mysql

2004-02-26 Thread Victor Medina
Hi!

It seems that you have installed mysql, but you did not run the
mysql_install_db, this script will create mysql "internal" databases(the
ones that carries user and config info), the script is usually in
"install_prefix/bin/mysql_install_db"

If you have no recently installed mysql, and the server has sometime
working already before this message, there is some serius problem here.
But i sencerely doubt it, innodb is recreating the tables and indices,
this looks like a fresh install to me =)

Best Regards!
 
On Wed, 2004-02-25 at 19:48, Soni, Sanjay K wrote:

> 040225 13:57:20  mysqld started
> InnoDB: The first specified data file ./ibdata1 did not exist:
> InnoDB: a new database to be created!
> 040225 13:57:21  InnoDB: Setting file ./ibdata1 size to 10 MB
> InnoDB: Database physically writes the file full: wait...
> 040225 13:57:22  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
> InnoDB: Setting log file ./ib_logfile0 size to 5 MB
> InnoDB: Database physically writes the file full: wait...
> 040225 13:57:22  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
> InnoDB: Setting log file ./ib_logfile1 size to 5 MB
> InnoDB: Database physically writes the file full: wait...
> InnoDB: Doublewrite buffer not found: creating new
> InnoDB: Doublewrite buffer created
> InnoDB: Creating foreign key constraint system tables
> InnoDB: Foreign key constraint system tables created
> 040225 13:57:25  InnoDB: Started
> 040225 13:57:25  Fatal error: Can't open privilege tables: Table 'mysql.host' 
> doesn't exist
> 040225 13:57:25  Aborting
>  
> 040225 13:57:25  InnoDB: Starting shutdown...
> 040225 13:57:27  InnoDB: Shutdown completed

-- 

 |...|
 |  _    _|Victor Medina M   |
 |\ \ \| |  _ \ / \   |Linux - Java - MySQL  |
 | \ \ \  _| | |_) / _ \  |Dpto. Sistemas - Ferreteria EPA   |
 | / / / |___|  __/ ___ \ |[EMAIL PROTECTED]  |
 |/_/_/|_|_| /_/   \_\|ext. 325 - Tél: +58-241-8507325   |
 ||geek by nature - linux by choice  |
 |...|






















RE: urgent help required for mysql

2004-02-26 Thread Ansari, Raza \(GEI, GEFA\)
Sanjay,
  It seems you didn't run mysql_install_db script which is located in /scripts 
directory. This script creates Grant tables for you when you first install mysql. 
Basically the error says you missing those grant tables, you can re-run the script and 
recreate them.

Hope that helps!!

Raza
GE Financial Assurance

-Original Message-
From: Soni, Sanjay K [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 25, 2004 6:48 PM
To: [EMAIL PROTECTED]
Subject: urgent help required for mysql


040225 13:57:20  mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
040225 13:57:21  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
040225 13:57:22  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
040225 13:57:22  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
040225 13:57:25  InnoDB: Started
040225 13:57:25  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't 
exist
040225 13:57:25  Aborting
 
040225 13:57:25  InnoDB: Starting shutdown...
040225 13:57:27  InnoDB: Shutdown completed

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: urgent help required for mysql

2004-02-26 Thread Victoria Reznichenko
"Soni, Sanjay K" <[EMAIL PROTECTED]> wrote:
> 040225 13:57:20  mysqld started
> InnoDB: The first specified data file ./ibdata1 did not exist:
> InnoDB: a new database to be created!
> 040225 13:57:21  InnoDB: Setting file ./ibdata1 size to 10 MB
> InnoDB: Database physically writes the file full: wait...
> 040225 13:57:22  InnoDB: Log file ./ib_logfile0 did not exist: new to be =
> created
> InnoDB: Setting log file ./ib_logfile0 size to 5 MB
> InnoDB: Database physically writes the file full: wait...
> 040225 13:57:22  InnoDB: Log file ./ib_logfile1 did not exist: new to be =
> created
> InnoDB: Setting log file ./ib_logfile1 size to 5 MB
> InnoDB: Database physically writes the file full: wait...
> InnoDB: Doublewrite buffer not found: creating new
> InnoDB: Doublewrite buffer created
> InnoDB: Creating foreign key constraint system tables
> InnoDB: Foreign key constraint system tables created
> 040225 13:57:25  InnoDB: Started
> 040225 13:57:25  Fatal error: Can't open privilege tables: Table =
> 'mysql.host' doesn't exist
> 040225 13:57:25  Aborting
> =20
> 040225 13:57:25  InnoDB: Starting shutdown...
> 040225 13:57:27  InnoDB: Shutdown completed
> 

Look into MySQL data dir and check if files host.frm, host.MYI, host.MYD exist in the 
directory of 'mysql' database.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Urgent: Prepared Statements C API hangup the Server - Help Urgent....

2004-02-24 Thread Arunachalam
hi,

I have created the COBOL coding to test those C API from
MySQL. Upon executing this COBOL program too hangup the server
but here using mysql_error() I got the error message in a
variable as 
  *Can't open shared memory. Request event don't create  (2)*

These Error I captured after running the Prepared statement 
mysql_prepare() when executing mysql_bind_param().

What does this error mean to say

I missed to quote the memory usage error when I try the mysqld from
console once after the server hangup when running C program is

C:\>mysqld --debug
Can't start server: Bind on TCP/IP port: No error
040223 19:18:22  Do you already have another mysqld server running 
 on port: 3306?
040223 19:18:22  Aborting
040223 19:18:23  mysqld: Shutdown Complete
Maximum memory usage: 20726 bytes (21k)

Is i need to make changes in *my.ini* for the memory buffers?

Pls reply with detail

Thanks

Arun.

 --- Arunachalam <[EMAIL PROTECTED]> wrote: > hi,
> 
> I wish to provide some more information too regarding MySQL 
> Server hangup.
> 
> Once after I execute the C sample program, WinMySQLAdmin tool 
> and  query commands from *mysql>* console never responds. 
> During this time if I try to start mysqld from another console 
> produce the following error message;
> 
> C:\>mysqld --debug
> Can't start server: Bind on TCP/IP port: No error
> 040223 19:18:22  Do you already have another mysqld server 
>  running on port: 3306?
> 040223 19:18:22  Aborting
> 040223 19:18:23  mysqld: Shutdown Complete
> 
> What could make the server become inactive or hangup while
> executing Client C API functions.
> 
> thank you
> 
> Expecting your valuable reply.
> 
> regards,
> Arun.
> 
> 
>  --- Arunachalam <[EMAIL PROTECTED]> wrote: > Hi,
> > 
> > I have written in intermediate, on the appropriate position in this 
> > discussion, please go thru in full.
> > 
> >  --- Michael Widenius <[EMAIL PROTECTED]> wrote: > 
> > > hi!
> > > 
> > > > "A" == Arunachalam  <[EMAIL PROTECTED]> writes:
> >  
> > > A> As per my searching I have found the right C API in libmysql.lib from
> > > A> MySQL 5.0.0, (i have doubt: Is any eariler version 4.0.xx provides this???)
> > > A> C API routines are: mysql_prepare(), mysql_bind_param(), mysql_execute(), 
> > > A> mysql_stmt_affected_rows(), mysql_fetch(), mysql_stmt_close()...
> > > 
> > > You should probablty use MySQL 4.1 instead of MySQL 5.0 for testing
> > > this as we make more often releases for 4.1 than for 5.0 (until 4.1 is
> > > production ready).
> > 
> > 
> > I didn't find the API's what I have specified above in MySQL 4.1.1 in 
> > *libmysql.dll*,  but those API's are provided by *mysqlclient.lib* in 
> > this version. 
> > 
> > I have created COBOL specific *libmysql.lib* from existing *libmysql.dll* 
> > becaz libmysql is Dynamic Access Library - right.  
> > 
> > (what I have did to convert libmysql.dll file into COBOL compiler 
> > specific *libmysql.lib* is by using an utility *pexports.exe*, i have
> > convert given libmysql.dll into libmysql.def file then by using LIB.EXE
> > of COBOL compiler convert libmysql.def into libmysql.lib file.)
> > 
> > 
> > 
> > > A> I have installed MySQL 5.0.0-alpha for Windows and I have properly linked 
> > > A> thelibmysql.lib into my COBOL compiler... To verify the Parameter Passing 
> > > A> mechanism to the API routines i have taken the sample C code from MySQL 
> > > A> manual (URL: * http://www.mysql.com/doc/en/mysql_execute.html * )
> > > 
> > > A> When I compiled this sample coding using VC++, it ask for *typelib.h* header 
> > > A> file, it is not given with insatllation pack, under the Mysql folder 
> > > A> (C:/MySQL/Include), I have searched on the net and include it accordingly.
> > > 
> > > Thanks for notifying us about this. typelib.h should be included in
> > > the MySQL folder and we will do that for next MySQL windows release.
> > > (4.1.2)
> > > 
> > > A> After that i have made changes in some variable names becaz of it follows 
> > > A> other header files variable name as such.
> > > 
> > > What changes did you have to make ?
> > > Including typelib.h should be enough.
> > 
> > When I try to first compile this program in VC++ it notify the mismatch
> > variable as 
> > 
> > MYSQL_BINDbind[3];
> > which is already used by  header file, so I have change this variable
> > into *Pbind* like this. (I have doubt: after your discussion i once again compiled
> > it with previous name(i.e, bind) it never produce any error).
> > 
> > The variable mysql used in other API's to be changed to *&mysql*, I have changed 
> > this after meeting the following errors;
> > 
> > D:\vcprojects\mysql\src\source.c(41) : error C2115: 'function' :  incompatible 
> > types
> > D:\vcprojects\mysql\src\source.c(41) : warning C4024: 'mysql_query' : different 
> > types for
> formal
> > and actual parameter 1
> > D:\vcprojects\mysql\src\source.c(44) : error C2115: 'function' : incompatible types
> > D:\vcprojects

Re: Urgent: Prepared Statements C API hangup the Server - Help Urgent....

2004-02-24 Thread Arunachalam
hi,

I wish to provide some more information too regarding MySQL 
Server hangup.

Once after I execute the C sample program, WinMySQLAdmin tool 
and  query commands from *mysql>* console never responds. 
During this time if I try to start mysqld from another console 
produce the following error message;

C:\>mysqld --debug
Can't start server: Bind on TCP/IP port: No error
040223 19:18:22  Do you already have another mysqld server 
 running on port: 3306?
040223 19:18:22  Aborting
040223 19:18:23  mysqld: Shutdown Complete

What could make the server become inactive or hangup while
executing Client C API functions.

thank you

Expecting your valuable reply.

regards,
Arun.


 --- Arunachalam <[EMAIL PROTECTED]> wrote: > Hi,
> 
> I have written in intermediate, on the appropriate position in this 
> discussion, please go thru in full.
> 
>  --- Michael Widenius <[EMAIL PROTECTED]> wrote: > 
> > hi!
> > 
> > > "A" == Arunachalam  <[EMAIL PROTECTED]> writes:
>  
> > A> As per my searching I have found the right C API in libmysql.lib from
> > A> MySQL 5.0.0, (i have doubt: Is any eariler version 4.0.xx provides this???)
> > A> C API routines are: mysql_prepare(), mysql_bind_param(), mysql_execute(), 
> > A> mysql_stmt_affected_rows(), mysql_fetch(), mysql_stmt_close()...
> > 
> > You should probablty use MySQL 4.1 instead of MySQL 5.0 for testing
> > this as we make more often releases for 4.1 than for 5.0 (until 4.1 is
> > production ready).
> 
> 
> I didn't find the API's what I have specified above in MySQL 4.1.1 in 
> *libmysql.dll*,  but those API's are provided by *mysqlclient.lib* in 
> this version. 
> 
> I have created COBOL specific *libmysql.lib* from existing *libmysql.dll* 
> becaz libmysql is Dynamic Access Library - right.  
> 
> (what I have did to convert libmysql.dll file into COBOL compiler 
> specific *libmysql.lib* is by using an utility *pexports.exe*, i have
> convert given libmysql.dll into libmysql.def file then by using LIB.EXE
> of COBOL compiler convert libmysql.def into libmysql.lib file.)
> 
> 
> 
> > A> I have installed MySQL 5.0.0-alpha for Windows and I have properly linked 
> > A> thelibmysql.lib into my COBOL compiler... To verify the Parameter Passing 
> > A> mechanism to the API routines i have taken the sample C code from MySQL 
> > A> manual (URL: * http://www.mysql.com/doc/en/mysql_execute.html * )
> > 
> > A> When I compiled this sample coding using VC++, it ask for *typelib.h* header 
> > A> file, it is not given with insatllation pack, under the Mysql folder 
> > A> (C:/MySQL/Include), I have searched on the net and include it accordingly.
> > 
> > Thanks for notifying us about this. typelib.h should be included in
> > the MySQL folder and we will do that for next MySQL windows release.
> > (4.1.2)
> > 
> > A> After that i have made changes in some variable names becaz of it follows 
> > A> other header files variable name as such.
> > 
> > What changes did you have to make ?
> > Including typelib.h should be enough.
> 
> When I try to first compile this program in VC++ it notify the mismatch
> variable as 
> 
> MYSQL_BINDbind[3];
> which is already used by  header file, so I have change this variable
> into *Pbind* like this. (I have doubt: after your discussion i once again compiled
> it with previous name(i.e, bind) it never produce any error).
> 
> The variable mysql used in other API's to be changed to *&mysql*, I have changed 
> this after meeting the following errors;
> 
> D:\vcprojects\mysql\src\source.c(41) : error C2115: 'function' :  incompatible types
> D:\vcprojects\mysql\src\source.c(41) : warning C4024: 'mysql_query' : different 
> types for formal
> and actual parameter 1
> D:\vcprojects\mysql\src\source.c(44) : error C2115: 'function' : incompatible types
> D:\vcprojects\mysql\src\source.c(44) : warning C4024: 'mysql_error' : different 
> types for formal
> and actual parameter 1
> D:\vcprojects\mysql\src\source.c(48) : error C2115: 'function' : incompatible types
> D:\vcprojects\mysql\src\source.c(58) : warning C4024: 'mysql_prepare' : different 
> types for
> formal
> and actual parameter 1
> D:\vcprojects\mysql\src\source.c(62) : error C2115: 'function' : incompatible types
>  
> > I will ask our windows team to verify that the example works ok with
> > VC++
> > 
> > A> Upon all the changes I can able to execute succcessfully the coding and it 
> > A> does the function properly on the MySQL server database.
> > 
> > A> The PROBLEM I met is, Once this sample code executed and inserted data to 
> > A> the Database the server get's hanged - why???
> 
> 
> After the discussion with you only i came to listen mysqld.trace, but it's content 
> cann't be understand by me, herewith I have attached that file for your reference.
> anyhow i understand that there is some Memory alloca/dealloc problem hangs up my
> MySQL server.
> 
>  
> > This shouldn't happen.
> > Can you please describe exactly what you mean with a 'hang' ?

Re: Urgent: Prepared Statements C API hangup the Server - Help Urgent....

2004-02-23 Thread Arunachalam
Hi,

I have written in intermediate, on the appropriate position in this 
discussion, please go thru in full.

 --- Michael Widenius <[EMAIL PROTECTED]> wrote: > 
> hi!
> 
> > "A" == Arunachalam  <[EMAIL PROTECTED]> writes:
 
> A> As per my searching I have found the right C API in libmysql.lib from
> A> MySQL 5.0.0, (i have doubt: Is any eariler version 4.0.xx provides this???)
> A> C API routines are: mysql_prepare(), mysql_bind_param(), mysql_execute(), 
> A> mysql_stmt_affected_rows(), mysql_fetch(), mysql_stmt_close()...
> 
> You should probablty use MySQL 4.1 instead of MySQL 5.0 for testing
> this as we make more often releases for 4.1 than for 5.0 (until 4.1 is
> production ready).


I didn't find the API's what I have specified above in MySQL 4.1.1 in 
*libmysql.dll*,  but those API's are provided by *mysqlclient.lib* in 
this version. 

I have created COBOL specific *libmysql.lib* from existing *libmysql.dll* 
becaz libmysql is Dynamic Access Library - right.  

(what I have did to convert libmysql.dll file into COBOL compiler 
specific *libmysql.lib* is by using an utility *pexports.exe*, i have
convert given libmysql.dll into libmysql.def file then by using LIB.EXE
of COBOL compiler convert libmysql.def into libmysql.lib file.)



> A> I have installed MySQL 5.0.0-alpha for Windows and I have properly linked 
> A> thelibmysql.lib into my COBOL compiler... To verify the Parameter Passing 
> A> mechanism to the API routines i have taken the sample C code from MySQL 
> A> manual (URL: * http://www.mysql.com/doc/en/mysql_execute.html * )
> 
> A> When I compiled this sample coding using VC++, it ask for *typelib.h* header 
> A> file, it is not given with insatllation pack, under the Mysql folder 
> A> (C:/MySQL/Include), I have searched on the net and include it accordingly.
> 
> Thanks for notifying us about this. typelib.h should be included in
> the MySQL folder and we will do that for next MySQL windows release.
> (4.1.2)
> 
> A> After that i have made changes in some variable names becaz of it follows 
> A> other header files variable name as such.
> 
> What changes did you have to make ?
> Including typelib.h should be enough.

When I try to first compile this program in VC++ it notify the mismatch
variable as 

MYSQL_BINDbind[3];
which is already used by  header file, so I have change this variable
into *Pbind* like this. (I have doubt: after your discussion i once again compiled
it with previous name(i.e, bind) it never produce any error).

The variable mysql used in other API's to be changed to *&mysql*, I have changed 
this after meeting the following errors;

D:\vcprojects\mysql\src\source.c(41) : error C2115: 'function' :  incompatible types
D:\vcprojects\mysql\src\source.c(41) : warning C4024: 'mysql_query' : different types 
for formal
and actual parameter 1
D:\vcprojects\mysql\src\source.c(44) : error C2115: 'function' : incompatible types
D:\vcprojects\mysql\src\source.c(44) : warning C4024: 'mysql_error' : different types 
for formal
and actual parameter 1
D:\vcprojects\mysql\src\source.c(48) : error C2115: 'function' : incompatible types
D:\vcprojects\mysql\src\source.c(58) : warning C4024: 'mysql_prepare' : different 
types for formal
and actual parameter 1
D:\vcprojects\mysql\src\source.c(62) : error C2115: 'function' : incompatible types
 
> I will ask our windows team to verify that the example works ok with
> VC++
> 
> A> Upon all the changes I can able to execute succcessfully the coding and it 
> A> does the function properly on the MySQL server database.
> 
> A> The PROBLEM I met is, Once this sample code executed and inserted data to 
> A> the Database the server get's hanged - why???


After the discussion with you only i came to listen mysqld.trace, but it's content 
cann't be understand by me, herewith I have attached that file for your reference.
anyhow i understand that there is some Memory alloca/dealloc problem hangs up my
MySQL server.

 
> This shouldn't happen.
> Can you please describe exactly what you mean with a 'hang' ?
> 
> - Does the connection in your test program stop respoding ?
Yes, if I run the client C program again, the console ouput stay blank
with out any message.

> - Can you connect to mysqld with other clients ?
No, WinMySQLAdmin tool won't allow me to right click on it
mysql -u user -ppass also stay as such when i try it from console 

> - Does the MySQL server take all cpu
No, I can work with other application with out any trouble.

I hope I have given here enough information to identify my trouble, suggest me 
in detail ASAP please...

Thanks a lot...

Regards,
Arun.


Yahoo! India Insurance Special: Be informed on the best policies, services, tools and 
more. 
Go to: http://in.insurance.yahoo.com/licspecial/index.html
-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq

Re: Urgent help needed - SCO Unix binary

2004-02-17 Thread Boyd Gerber
On Tue, 10 Feb 2004 [EMAIL PROTECTED] wrote:
> Hi,
>
> I could not find the binary for SCO Unixware (Intel based) in download
> section. I suppose mysql supports this environment too. May I know as to
> where can I find this binary. Do I need to build this myself?

There are some version on ftp.zenez.com in the pub/zenez/prgms directory.
You may want to try one of them.

--
Boyd Gerber <[EMAIL PROTECTED]>
ZENEZ   1042 East Fort Union #135, Midvale Utah  84047

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Urgent help needed - SCO Unix binary

2004-02-10 Thread amahansaria




Thanks Chris. Will get back to you if I get some problem.

Regards,
Anup Mahansaria



   
 Chris Nolan   
 <[EMAIL PROTECTED] 
 >  To 
   [EMAIL PROTECTED] 
 02/11/04 09:32 AM  cc 
   [EMAIL PROTECTED]   
   Subject 
       Re: Urgent help needed - SCO Unix   
   binary  
   
   
   
   
   
   




Basically, the stability of the build is dependant on the following
factors:

* Suitable functions in your C library for threaded applications.

UnixWare is apparently fine in this category and doesn't require any
workarounds. Installing the latest patches and things would be in your
best interest though.

* The compiler you use.

I'm pretty sure that Skunkware includes GCC 2.95.x . This is one of the
recommended compilers for building MySQL binaries. If you install this
and can get a clean compile, you'll probably be fine.

Regards,

Chris

[EMAIL PROTECTED] wrote:

>
>
>Hi Chris,
>
>I want it on SCO Unixware 7.1.1 (intel based)
>
>I did see it in the installation manual of MySQL where they give some
>instructions for building the binaries for SCO Unixware. Can I go ahead
and
>build it. How do you see the stability factor of such builds.
>
>Regards,
>Anup Mahansaria
>
>
>
>
>

> Chris Nolan

> <[EMAIL PROTECTED]

> >  To

>   [EMAIL PROTECTED]

> 02/10/04 07:47 PM  cc

>   [EMAIL PROTECTED]

>       Subject

>   Re: Urgent help needed - SCO Unix

>   binary

>

>

>

>

>

>

>
>
>
>
>Hi!
>
>If memory serves me correctly, MySQL AB have stopped issuing SCO
>OpenServer and SCO UnixWare binaries publicly and will only be providing
>them to customers who take out commercial licences. This is probably due
>to the fact that OpenServer and UnixWare cost a lot compared ot other
>OSes, don't represent a huge percentage of the MySQL userbase and that
>the UDK for each is some disgusting amount to purchase.
>
>Which version of UnixWare is it? A workaround might be available in the
>form of the Linux Kernel Personality. Additionally, the Skunkware
>repository might be able to help you out if SCO's servers are currently
>accessible in this virus-infested internet we all wade in.
>
>I recently migrated a customer from UnixWare 7.1.1 to Redhat AS 2.1
>(they had a copy that a mate sold them cheap) for this and a few other
>reasons (including "Wow! The Redhat desktop looks pretty!").
>
>Regards,
>
>Chris
>
>[EMAIL PROTECTED] wrote:
>
>
>
>>Hi,
>>
>>I could not find the binary for SCO Unixware (Intel based) in download
>>section. I suppose mysql supports this environment too. May I know as to
>>where can I find this binary. Do I need to build this myself?
>>
>>TIA
>>
>>Regards,
>>Anup Mahansaria
>>
>>
>>
>>
>>
>>
>
>
>
>
>
>





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Urgent help needed - SCO Unix binary

2004-02-10 Thread Chris Nolan
Basically, the stability of the build is dependant on the following factors:

* Suitable functions in your C library for threaded applications.

UnixWare is apparently fine in this category and doesn't require any 
workarounds. Installing the latest patches and things would be in your 
best interest though.

* The compiler you use.

I'm pretty sure that Skunkware includes GCC 2.95.x . This is one of the 
recommended compilers for building MySQL binaries. If you install this 
and can get a clean compile, you'll probably be fine.

Regards,

Chris

[EMAIL PROTECTED] wrote:



Hi Chris,

I want it on SCO Unixware 7.1.1 (intel based)

I did see it in the installation manual of MySQL where they give some
instructions for building the binaries for SCO Unixware. Can I go ahead and
build it. How do you see the stability factor of such builds.
Regards,
Anup Mahansaria


  
Chris Nolan   
<[EMAIL PROTECTED] 
>  To 
  [EMAIL PROTECTED] 
02/10/04 07:47 PM  cc 
  [EMAIL PROTECTED]   
  Subject 
          Re: Urgent help needed - SCO Unix   
  binary  
  
  
  
  
  
  



Hi!

If memory serves me correctly, MySQL AB have stopped issuing SCO
OpenServer and SCO UnixWare binaries publicly and will only be providing
them to customers who take out commercial licences. This is probably due
to the fact that OpenServer and UnixWare cost a lot compared ot other
OSes, don't represent a huge percentage of the MySQL userbase and that
the UDK for each is some disgusting amount to purchase.
Which version of UnixWare is it? A workaround might be available in the
form of the Linux Kernel Personality. Additionally, the Skunkware
repository might be able to help you out if SCO's servers are currently
accessible in this virus-infested internet we all wade in.
I recently migrated a customer from UnixWare 7.1.1 to Redhat AS 2.1
(they had a copy that a mate sold them cheap) for this and a few other
reasons (including "Wow! The Redhat desktop looks pretty!").
Regards,

Chris

[EMAIL PROTECTED] wrote:

 

Hi,

I could not find the binary for SCO Unixware (Intel based) in download
section. I suppose mysql supports this environment too. May I know as to
where can I find this binary. Do I need to build this myself?
TIA

Regards,
Anup Mahansaria


   





 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


Re: Urgent help needed - SCO Unix binary

2004-02-10 Thread Chris Nolan
Hi!

If memory serves me correctly, MySQL AB have stopped issuing SCO 
OpenServer and SCO UnixWare binaries publicly and will only be providing 
them to customers who take out commercial licences. This is probably due 
to the fact that OpenServer and UnixWare cost a lot compared ot other 
OSes, don't represent a huge percentage of the MySQL userbase and that 
the UDK for each is some disgusting amount to purchase.

Which version of UnixWare is it? A workaround might be available in the 
form of the Linux Kernel Personality. Additionally, the Skunkware 
repository might be able to help you out if SCO's servers are currently 
accessible in this virus-infested internet we all wade in.

I recently migrated a customer from UnixWare 7.1.1 to Redhat AS 2.1 
(they had a copy that a mate sold them cheap) for this and a few other 
reasons (including "Wow! The Redhat desktop looks pretty!").

Regards,

Chris

[EMAIL PROTECTED] wrote:



Hi,

I could not find the binary for SCO Unixware (Intel based) in download
section. I suppose mysql supports this environment too. May I know as to
where can I find this binary. Do I need to build this myself?
TIA

Regards,
Anup Mahansaria
 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


RE: Urgent problem

2003-11-13 Thread Victor Pendleton
restart mysql with the skip-grants option

-Original Message-
From: Rainer M. Krug [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 3:03 AM
To: [EMAIL PROTECTED]
Subject: Urgent problem


Hi

I did something very stupid: I locked myself out of the 
MySQL server (all accounts, incl administrator)...

My problem: I use MySQLFront to change the allowed 
hosts and did it for all users. They were 'localhost' 
and I set them to 'localhost; EcolMod1' where the 
EcolMod1 is the name of my computer where the MySQL 
server is installed on. After these changes, I 
couldn't log on any more.

Windows 2000, MySQL 4.012.

Any help welcome what I could do to access the data 
again,

Rainer

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: Urgent problem

2003-11-13 Thread Tom Horstmann
> I did something very stupid: I locked myself out of the 
> MySQL server (all accounts, incl administrator)...
> 
> My problem: I use MySQLFront to change the allowed 
> hosts and did it for all users. They were 'localhost' 
> and I set them to 'localhost; EcolMod1' where the 
> EcolMod1 is the name of my computer where the MySQL 
> server is installed on. After these changes, I 
> couldn't log on any more.
> 
> Windows 2000, MySQL 4.012.
> 
> Any help welcome what I could do to access the data 
> again,

One mail should be enough in most cases!

You may try to edit your host.mid file in \mysql-dir\data\mysql.
Make a backup of that file before you start and use a hex-editor
for doing so. The first chars in there should look like 
"ÿlocalhost; EcolMod1". Simply overwrite (not erase) what you don't
need with spaces (20 hex).

You need to restart mysql to apply changes made.

Regards,

TomH

--
PROSOFT EDV-Lösungen GmbH & Co. KG
Ladehofstraße 28, D-93049 Regensburg
Geschäftsführer: Axel-Wilhelm Wegmann
AG Regensburg HRA 6608 USt.183/68311
www  : http://www.proSoft-Edv.de
email: [EMAIL PROTECTED]
phone: +49 941 / 78 88 7 - 121
fax  : +49 941 / 78 88 7 - 20
cellphone: +49 174 / 41 94 97 0

--


> -Original Message-
> From: Rainer M. Krug [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, November 13, 2003 10:03 AM
> To: [EMAIL PROTECTED]
> Subject: Urgent problem
> 
> 
> Hi
> 

> 
> Rainer
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=mysql-list@> 7thweb.de
> 
> 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Urgent Pl: problem with rename the field name: IN

2003-11-08 Thread Fred van Engen
On Fri, Nov 07, 2003 at 06:58:58PM -0500, karthikeyan wrote:
> how to rename a field name "IN" to something else..
> I could not use
> 
> alter table tbl_name change IN NEW mediumtext;
> 

I suppose this complains about a syntax error?

You can use any reserved word as fieldname (or tablename) by putting
backticks around it:

alter table tbl_name change `IN` NEW mediumtext;

> Pl. suggest how to rename particular "field name" for all the tables in
> a database
> 

Repeat the alter table for each table. :/


Regards,

Fred.

-- 
Fred van Engen  XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC  Almere
fax: +31 36 5462424 The Netherlands

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: URGENT : Benchmark

2003-07-22 Thread Phil Bitis
Does your university have a webpage indicating what advice is acceptable and
not considered plagarism?

- Original Message -
From: "Antonio Jose Rodrigues Neto" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, July 22, 2003 9:54 PM
Subject: URGENT : Benchmark


> Help me ...
>
> Antonio Jose Rodrigues Neto <[EMAIL PROTECTED]>
wrote:Hi All,
>
> I almost finish my MSC Thesis and my thesis is iSCSI Performance. I would
like to make tests using Fibre Channel and iSCSI with MYSQL. Please I will
need informations (cookbook) how does implement tunning on MySQL - Linux
RedHat 9.
>
> I install sql-bench and I ran tests against iscsi and nfs (just a test)
and generate the files RUN-iscsi and RUN-nfs. How does use the tool
compare-results?
>
> What book (the best book) do you recommend for me about mysql?
>
> Please help me?
>
>
> -
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
>
>
> -
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: URGENT problem with mysql processes

2003-06-27 Thread Keith Bussey
Quoting Nils Valentin <[EMAIL PROTECTED]>:

> When you said you modified the scripts, are these the scripts on the 12 
> webservers (mysql clients) ?

Yes, when I mention modifying my scripts, I mean the scripts/pages on the 12
webservers
 
> If not, then these mysql clients (webservers) would still be wanting to send
> 
> to IP addres 192.168.1.71 as configured for php or in your client.
> 
> Best regards
> 
> Nils Valentin
> Tokyo/Japan
> 
> 
> 2003年 6月 27日 金曜日 14:58、Keith Bussey さんは書きました:
> > Neither of these two machines send the request.
> >
> > I have 12 webservers, which send the requests.
> > I have 5 database servers, 1 master(for updates/inserts/deletes) and 4
> > slaves(for selects).
> >
> > Machine A below was the current Master DB server, however it is old and
> was
> > being replaced by machine B
> >
> >
> > --
> > Keith Bussey
> >
> > Wisol, Inc.
> > Chief Technology Manager
> > (514) 398-9994 ext.225
> >
> > Quoting Nils Valentin <[EMAIL PROTECTED]>:
> > > Hi Keith,
> > >
> > > soory now I got confused. Which machine is sending the requests (client)
> > > and
> > >
> > > which machine is the mysql server (server). Do you use php or something
> > > like
> > >
> > > this (webinterface) on the client ?
> > >
> > > If yes, than my suggestions below apply.
> > > If no than I we will have to think the next step.
> > >
> > > Best regards
> > >
> > > Nils Valentin
> > > Tokyo/Japan
> > >
> > > 2003年 6月 27日 金曜日 11:29、Keith Bussey 
> さんは書きました:
> > > > Ok but that's not what I meant.
> > > >
> > > > I'll try to explain better.
> > > >
> > > > Machine A: IP = 192.168.1.71
> > > > Machine B: IP = 192.168.1.79
> > > >
> > > > 1) Scripts goto 192.168.1.71 - Everything is OK
> > > > 2) Changed scripts to 192.168.1.79 - Site works at first, but
> processes
> > > > pile up until server is killed
> > > > 3) Halt machine B
> > > > 4) Give machine A IP 192.168.1.79 (so now it has 2 IPs)
> > > > 5) Problem persists even though it's a different machine, site works
> > > > but then processes pile up and kill machine
> > > > 6) Change scripts to use 192.168.1.71 again
> > > > 7) Site works fine
> > > >
> > > >
> > > > What I don't get is why do processes run normally with IP
> 192.168.1.71,
> > >
> > > but
> > >
> > > > NOT with IP 192.168.1.79 even when they are on the same machine ?
> > > >
> > > > --
> > > > Keith Bussey
> > > >
> > > > Wisol, Inc.
> > > > Chief Technology Manager
> > > > (514) 398-9994 ext.225
> > > >
> > > > Quoting Nils Valentin <[EMAIL PROTECTED]>:
> > > > > Hi Keith,
> > > > >
> > > > > The wrong IP address could only avoid a client to connect to the
> > >
> > > database
> > >
> > > > > server.
> > > > >
> > > > > If you have the TCP/IP address specified in /etc/php.ini or for
> > > > > phpmyadmin in
> > > > >
> > > > > config.inc.php or which ever tool you use than of course it will try
> > > > > to connect to this IP address.
> > > > >
> > > > > Best regards
> > > > >
> > > > > Nils Valentin
> > > > > Tokto/Japan
> > > > >
> > > > > 2003年 6月 27日
> 金曜日 11:02、Keith
> > > > > Bussey
> > >
> > >
>
さんは書きました:
> > > > > > Hrmmmeaning if I do "id mysql", that information (group etc..)
> > > > > > ?
> > > > > >
> > > > > > I've halted that server and moved everything back to my original
> > >
> > > server
> > >
> > > > > for
> > > > >
> > > > > > now, I had too much downtime. I did notice something else
> > > > > > interesting though:
> > > > > >
> > > > > > The old mahcine's IP is 192.168.1.71
> > > > > > New machine's IP is 192.168.1.79
> > > > > >
> > > > > > Now that it's halted, instead of changing the IP back to .71 in my
> > > > > > pages/scripts I added .79 to the .71 machine so it has both
> > > > > >
> > > > > > Now that machine experienced the exact same problem. Switching my
> > > > > > code to use .71 again however, and no problems.
> > > > > >
> > > > > > Could somehow there be a problem with the IP address
> 192.168.1.79??
> > > > > > It seems very strange, however tomorrow I will try putting the .71
> > > > > > on the new machine and see if it works or not
> > > > >
> > > > > --
> > > > > ---
> > > > > Valentin Nils
> > > > > Internet Technology
> > > > >
> > > > >  E-Mail: [EMAIL PROTECTED]
> > > > >  URL: http://www.knowd.co.jp
> > > > >  Personal URL: http://www.knowd.co.jp/staff/nils
> > > > >
> > > > >
> > > > > --
> > > > > MySQL General Mailing List
> > > > > For list archives: http://lists.mysql.com/mysql
> > > > > To unsubscribe:   
> > > > > http://lists.mysql.com/[EMAIL PROTECTED]
> > >
> > > --
> > > ---
> > > Valentin Nils
> > > Internet Technology
> > >
> > >  E-Mail: [EMAIL PROTECTED]
> > >  URL: http://www.knowd.co.jp
> > >  Personal URL: http://www.knowd.co.jp/staff/nils
> 
> -- 
> ---
> Valentin Nils
> Internet Technology
> 
>  E-Mail: [EMAIL PROTECTED]
>  URL: http://www.knowd.co.jp
>  Personal URL: http://www.knowd.co.jp/staff/nils
> 
> 
> --
> MySQL 

Re: URGENT problem with mysql processes

2003-06-27 Thread Keith Bussey
No, replication is fine I can see those processes as they should be. The problem
processes all come from the webservers' requests.

-- 
Keith Bussey

Wisol, Inc.
Chief Technology Manager
(514) 398-9994 ext.225


Quoting Dominicus Donny <[EMAIL PROTECTED]>:

> If it is the replication problem...::
> Check the replication account on the master server:
> ...[EMAIL PROTECTED] identified by ...
> ...[EMAIL PROTECTED] identified by ...
> ...[EMAIL PROTECTED] identified by ...
> ...
> ...[EMAIL PROTECTED] identified by ...
> 
> or perhaps simply set to
> ...replication_account@"%" identified by ...
> 
> make sure the account has access to the specified db.tables, too.
> 
> "Me fail English? That's unpossible"
> ###___Archon___###
> 
> - Original Message -
> From: "Nils Valentin" <[EMAIL PROTECTED]>
> To: "Keith Bussey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Friday, June 27, 2003 1:30 PM
> Subject: Re: URGENT problem with mysql processes
> 
> 
> Hi Keith,
> 
> from your last e-mail I understand now finally that we are talking about
> replication here. Would have been a short cut to mention it in your first
> e-mail.
> 
> The failed login attempts couldn't be from your slaves trying to login, but
> you havent set them up on the master yet ?
> 
> Just a guess, so.
> 
> 2003年 6月 27日 金曜日 09:05、Keith Bussey さんは書きました:
> > | 106 | unauthenticated user | 192.168.1.59:1925 | NULL | Connect | NULL |
> > | login NULL
> > |
> > | 115 | unauthenticated user | 192.168.1.53:2041 | NULL | Connect | NULL |
> > | login NULL
> > |
> > | 118 | unauthenticated user | 192.168.1.56:4172 | NULL | Connect | NULL |
> > | login NULL
> > |
> > | 119 | unauthenticated user | 192.168.1.56:4173 | NULL | Connect | NULL |
> > | login NULL
> 
> Best regards
> 
> Nils Valentin
> Tokyo/Japan
> 
> --
> ---
> Valentin Nils
> Internet Technology
> 
>  E-Mail: [EMAIL PROTECTED]
>  URL: http://www.knowd.co.jp
>  Personal URL: http://www.knowd.co.jp/staff/nils
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: URGENT problem with mysql processes

2003-06-27 Thread Keith Bussey
No, the slaves replicate fine and I can see their entries in the processlist
normally (as their hostname), not as "unauthenticated user"..

-- 
Keith Bussey

Wisol, Inc.
Chief Technology Manager
(514) 398-9994 ext.225


Quoting Nils Valentin <[EMAIL PROTECTED]>:

> Hi Keith,
> 
> from your last e-mail I understand now finally that we are talking about 
> replication here. Would have been a short cut to mention it in your first 
> e-mail.
> 
> The failed login attempts couldn't be from your slaves trying to login, but 
> you havent set them up on the master yet ?
> 
> Just a guess, so.
> 
> 2003年 6月 27日 金曜日 09:05、Keith Bussey さんは書きました:
> > | 106 | unauthenticated user | 192.168.1.59:1925 | NULL | Connect | NULL |
> > | login NULL
> > |
> > | 115 | unauthenticated user | 192.168.1.53:2041 | NULL | Connect | NULL |
> > | login NULL
> > |
> > | 118 | unauthenticated user | 192.168.1.56:4172 | NULL | Connect | NULL |
> > | login NULL
> > |
> > | 119 | unauthenticated user | 192.168.1.56:4173 | NULL | Connect | NULL |
> > | login NULL
> 
> Best regards
> 
> Nils Valentin
> Tokyo/Japan
> 
> -- 
> ---
> Valentin Nils
> Internet Technology
> 
>  E-Mail: [EMAIL PROTECTED]
>  URL: http://www.knowd.co.jp
>  Personal URL: http://www.knowd.co.jp/staff/nils
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: URGENT problem with mysql processes

2003-06-26 Thread Dominicus Donny
If it is the replication problem...::
Check the replication account on the master server:
...[EMAIL PROTECTED] identified by ...
...[EMAIL PROTECTED] identified by ...
...[EMAIL PROTECTED] identified by ...
...
...[EMAIL PROTECTED] identified by ...

or perhaps simply set to
...replication_account@"%" identified by ...

make sure the account has access to the specified db.tables, too.

"Me fail English? That's unpossible"
###___Archon___###

- Original Message -
From: "Nils Valentin" <[EMAIL PROTECTED]>
To: "Keith Bussey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, June 27, 2003 1:30 PM
Subject: Re: URGENT problem with mysql processes


Hi Keith,

from your last e-mail I understand now finally that we are talking about
replication here. Would have been a short cut to mention it in your first
e-mail.

The failed login attempts couldn't be from your slaves trying to login, but
you havent set them up on the master yet ?

Just a guess, so.

2003年 6月 27日 金曜日 09:05、Keith Bussey さんは書きました:
> | 106 | unauthenticated user | 192.168.1.59:1925 | NULL | Connect | NULL |
> | login NULL
> |
> | 115 | unauthenticated user | 192.168.1.53:2041 | NULL | Connect | NULL |
> | login NULL
> |
> | 118 | unauthenticated user | 192.168.1.56:4172 | NULL | Connect | NULL |
> | login NULL
> |
> | 119 | unauthenticated user | 192.168.1.56:4173 | NULL | Connect | NULL |
> | login NULL

Best regards

Nils Valentin
Tokyo/Japan

--
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: URGENT problem with mysql processes

2003-06-26 Thread Nils Valentin
Hi Keith,

from your last e-mail I understand now finally that we are talking about 
replication here. Would have been a short cut to mention it in your first 
e-mail.

The failed login attempts couldn't be from your slaves trying to login, but 
you havent set them up on the master yet ?

Just a guess, so.

2003年 6月 27日 金曜日 09:05、Keith Bussey さんは書きました:
> | 106 | unauthenticated user | 192.168.1.59:1925 | NULL | Connect | NULL |
> | login NULL
> |
> | 115 | unauthenticated user | 192.168.1.53:2041 | NULL | Connect | NULL |
> | login NULL
> |
> | 118 | unauthenticated user | 192.168.1.56:4172 | NULL | Connect | NULL |
> | login NULL
> |
> | 119 | unauthenticated user | 192.168.1.56:4173 | NULL | Connect | NULL |
> | login NULL

Best regards

Nils Valentin
Tokyo/Japan

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: URGENT problem with mysql processes

2003-06-26 Thread Nils Valentin
When you said you modified the scripts, are these the scripts on the 12 
webservers (mysql clients) ?

If not, then these mysql clients (webservers) would still be wanting to send 
to IP addres 192.168.1.71 as configured for php or in your client.

Best regards

Nils Valentin
Tokyo/Japan


2003年 6月 27日 金曜日 14:58、Keith Bussey さんは書きました:
> Neither of these two machines send the request.
>
> I have 12 webservers, which send the requests.
> I have 5 database servers, 1 master(for updates/inserts/deletes) and 4
> slaves(for selects).
>
> Machine A below was the current Master DB server, however it is old and was
> being replaced by machine B
>
>
> --
> Keith Bussey
>
> Wisol, Inc.
> Chief Technology Manager
> (514) 398-9994 ext.225
>
> Quoting Nils Valentin <[EMAIL PROTECTED]>:
> > Hi Keith,
> >
> > soory now I got confused. Which machine is sending the requests (client)
> > and
> >
> > which machine is the mysql server (server). Do you use php or something
> > like
> >
> > this (webinterface) on the client ?
> >
> > If yes, than my suggestions below apply.
> > If no than I we will have to think the next step.
> >
> > Best regards
> >
> > Nils Valentin
> > Tokyo/Japan
> >
> > 2003年 6月 27日 金曜日 11:29、Keith Bussey 
さんは書きました:
> > > Ok but that's not what I meant.
> > >
> > > I'll try to explain better.
> > >
> > > Machine A: IP = 192.168.1.71
> > > Machine B: IP = 192.168.1.79
> > >
> > > 1) Scripts goto 192.168.1.71 - Everything is OK
> > > 2) Changed scripts to 192.168.1.79 - Site works at first, but processes
> > > pile up until server is killed
> > > 3) Halt machine B
> > > 4) Give machine A IP 192.168.1.79 (so now it has 2 IPs)
> > > 5) Problem persists even though it's a different machine, site works
> > > but then processes pile up and kill machine
> > > 6) Change scripts to use 192.168.1.71 again
> > > 7) Site works fine
> > >
> > >
> > > What I don't get is why do processes run normally with IP 192.168.1.71,
> >
> > but
> >
> > > NOT with IP 192.168.1.79 even when they are on the same machine ?
> > >
> > > --
> > > Keith Bussey
> > >
> > > Wisol, Inc.
> > > Chief Technology Manager
> > > (514) 398-9994 ext.225
> > >
> > > Quoting Nils Valentin <[EMAIL PROTECTED]>:
> > > > Hi Keith,
> > > >
> > > > The wrong IP address could only avoid a client to connect to the
> >
> > database
> >
> > > > server.
> > > >
> > > > If you have the TCP/IP address specified in /etc/php.ini or for
> > > > phpmyadmin in
> > > >
> > > > config.inc.php or which ever tool you use than of course it will try
> > > > to connect to this IP address.
> > > >
> > > > Best regards
> > > >
> > > > Nils Valentin
> > > > Tokto/Japan
> > > >
> > > > 2003年 6月 27日 
> > > > 金曜日 11:02、Keith
> > > > Bussey
> >
> > さんは書きました:
> > > > > Hrmmmeaning if I do "id mysql", that information (group etc..)
> > > > > ?
> > > > >
> > > > > I've halted that server and moved everything back to my original
> >
> > server
> >
> > > > for
> > > >
> > > > > now, I had too much downtime. I did notice something else
> > > > > interesting though:
> > > > >
> > > > > The old mahcine's IP is 192.168.1.71
> > > > > New machine's IP is 192.168.1.79
> > > > >
> > > > > Now that it's halted, instead of changing the IP back to .71 in my
> > > > > pages/scripts I added .79 to the .71 machine so it has both
> > > > >
> > > > > Now that machine experienced the exact same problem. Switching my
> > > > > code to use .71 again however, and no problems.
> > > > >
> > > > > Could somehow there be a problem with the IP address 192.168.1.79??
> > > > > It seems very strange, however tomorrow I will try putting the .71
> > > > > on the new machine and see if it works or not
> > > >
> > > > --
> > > > ---
> > > > Valentin Nils
> > > > Internet Technology
> > > >
> > > >  E-Mail: [EMAIL PROTECTED]
> > > >  URL: http://www.knowd.co.jp
> > > >  Personal URL: http://www.knowd.co.jp/staff/nils
> > > >
> > > >
> > > > --
> > > > MySQL General Mailing List
> > > > For list archives: http://lists.mysql.com/mysql
> > > > To unsubscribe:   
> > > > http://lists.mysql.com/[EMAIL PROTECTED]
> >
> > --
> > ---
> > Valentin Nils
> > Internet Technology
> >
> >  E-Mail: [EMAIL PROTECTED]
> >  URL: http://www.knowd.co.jp
> >  Personal URL: http://www.knowd.co.jp/staff/nils

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: URGENT problem with mysql processes

2003-06-26 Thread Keith Bussey
Neither of these two machines send the request.

I have 12 webservers, which send the requests.
I have 5 database servers, 1 master(for updates/inserts/deletes) and 4
slaves(for selects).

Machine A below was the current Master DB server, however it is old and was
being replaced by machine B


-- 
Keith Bussey

Wisol, Inc.
Chief Technology Manager
(514) 398-9994 ext.225


Quoting Nils Valentin <[EMAIL PROTECTED]>:

> Hi Keith,
> 
> soory now I got confused. Which machine is sending the requests (client) and
> 
> which machine is the mysql server (server). Do you use php or something like
> 
> this (webinterface) on the client ?
> 
> If yes, than my suggestions below apply.
> If no than I we will have to think the next step.
> 
> Best regards
> 
> Nils Valentin
> Tokyo/Japan
> 
> 
> 
> 2003年 6月 27日 金曜日 11:29、Keith Bussey さんは書きました:
> > Ok but that's not what I meant.
> >
> > I'll try to explain better.
> >
> > Machine A: IP = 192.168.1.71
> > Machine B: IP = 192.168.1.79
> >
> > 1) Scripts goto 192.168.1.71 - Everything is OK
> > 2) Changed scripts to 192.168.1.79 - Site works at first, but processes
> > pile up until server is killed
> > 3) Halt machine B
> > 4) Give machine A IP 192.168.1.79 (so now it has 2 IPs)
> > 5) Problem persists even though it's a different machine, site works but
> > then processes pile up and kill machine
> > 6) Change scripts to use 192.168.1.71 again
> > 7) Site works fine
> >
> >
> > What I don't get is why do processes run normally with IP 192.168.1.71,
> but
> > NOT with IP 192.168.1.79 even when they are on the same machine ?
> >
> > --
> > Keith Bussey
> >
> > Wisol, Inc.
> > Chief Technology Manager
> > (514) 398-9994 ext.225
> >
> > Quoting Nils Valentin <[EMAIL PROTECTED]>:
> > > Hi Keith,
> > >
> > > The wrong IP address could only avoid a client to connect to the
> database
> > > server.
> > >
> > > If you have the TCP/IP address specified in /etc/php.ini or for
> > > phpmyadmin in
> > >
> > > config.inc.php or which ever tool you use than of course it will try to
> > > connect to this IP address.
> > >
> > > Best regards
> > >
> > > Nils Valentin
> > > Tokto/Japan
> > >
> > > 2003年 6月 27日 金曜日 11:02、Keith Bussey 
> さんは書きました:
> > > > Hrmmmeaning if I do "id mysql", that information (group etc..) ?
> > > >
> > > > I've halted that server and moved everything back to my original
> server
> > >
> > > for
> > >
> > > > now, I had too much downtime. I did notice something else interesting
> > > > though:
> > > >
> > > > The old mahcine's IP is 192.168.1.71
> > > > New machine's IP is 192.168.1.79
> > > >
> > > > Now that it's halted, instead of changing the IP back to .71 in my
> > > > pages/scripts I added .79 to the .71 machine so it has both
> > > >
> > > > Now that machine experienced the exact same problem. Switching my code
> > > > to use .71 again however, and no problems.
> > > >
> > > > Could somehow there be a problem with the IP address 192.168.1.79?? It
> > > > seems very strange, however tomorrow I will try putting the .71 on the
> > > > new machine and see if it works or not
> > >
> > > --
> > > ---
> > > Valentin Nils
> > > Internet Technology
> > >
> > >  E-Mail: [EMAIL PROTECTED]
> > >  URL: http://www.knowd.co.jp
> > >  Personal URL: http://www.knowd.co.jp/staff/nils
> > >
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 
> -- 
> ---
> Valentin Nils
> Internet Technology
> 
>  E-Mail: [EMAIL PROTECTED]
>  URL: http://www.knowd.co.jp
>  Personal URL: http://www.knowd.co.jp/staff/nils
> 
> 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: URGENT problem with mysql processes

2003-06-26 Thread Keith Bussey
Ok but that's not what I meant.

I'll try to explain better.

Machine A: IP = 192.168.1.71
Machine B: IP = 192.168.1.79

1) Scripts goto 192.168.1.71 - Everything is OK
2) Changed scripts to 192.168.1.79 - Site works at first, but processes pile up
until server is killed
3) Halt machine B
4) Give machine A IP 192.168.1.79 (so now it has 2 IPs)
5) Problem persists even though it's a different machine, site works but then
processes pile up and kill machine
6) Change scripts to use 192.168.1.71 again 
7) Site works fine


What I don't get is why do processes run normally with IP 192.168.1.71, but NOT
with IP 192.168.1.79 even when they are on the same machine ?

-- 
Keith Bussey

Wisol, Inc.
Chief Technology Manager
(514) 398-9994 ext.225


Quoting Nils Valentin <[EMAIL PROTECTED]>:

> Hi Keith,
> 
> The wrong IP address could only avoid a client to connect to the database 
> server. 
> 
> If you have the TCP/IP address specified in /etc/php.ini or for phpmyadmin in
> 
> config.inc.php or which ever tool you use than of course it will try to 
> connect to this IP address.
> 
> Best regards
> 
> Nils Valentin
> Tokto/Japan
> 
> 
> 2003年 6月 27日 金曜日 11:02、Keith Bussey さんは書きました:
> > Hrmmmeaning if I do "id mysql", that information (group etc..) ?
> >
> > I've halted that server and moved everything back to my original server
> for
> > now, I had too much downtime. I did notice something else interesting
> > though:
> >
> > The old mahcine's IP is 192.168.1.71
> > New machine's IP is 192.168.1.79
> >
> > Now that it's halted, instead of changing the IP back to .71 in my
> > pages/scripts I added .79 to the .71 machine so it has both
> >
> > Now that machine experienced the exact same problem. Switching my code to
> > use .71 again however, and no problems.
> >
> > Could somehow there be a problem with the IP address 192.168.1.79?? It
> > seems very strange, however tomorrow I will try putting the .71 on the new
> > machine and see if it works or not
> 
> -- 
> ---
> Valentin Nils
> Internet Technology
> 
>  E-Mail: [EMAIL PROTECTED]
>  URL: http://www.knowd.co.jp
>  Personal URL: http://www.knowd.co.jp/staff/nils
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: URGENT problem with mysql processes

2003-06-26 Thread Nils Valentin
Hi Keith,

The wrong IP address could only avoid a client to connect to the database 
server. 

If you have the TCP/IP address specified in /etc/php.ini or for phpmyadmin in 
config.inc.php or which ever tool you use than of course it will try to 
connect to this IP address.

Best regards

Nils Valentin
Tokto/Japan


2003年 6月 27日 金曜日 11:02、Keith Bussey さんは書きました:
> Hrmmmeaning if I do "id mysql", that information (group etc..) ?
>
> I've halted that server and moved everything back to my original server for
> now, I had too much downtime. I did notice something else interesting
> though:
>
> The old mahcine's IP is 192.168.1.71
> New machine's IP is 192.168.1.79
>
> Now that it's halted, instead of changing the IP back to .71 in my
> pages/scripts I added .79 to the .71 machine so it has both
>
> Now that machine experienced the exact same problem. Switching my code to
> use .71 again however, and no problems.
>
> Could somehow there be a problem with the IP address 192.168.1.79?? It
> seems very strange, however tomorrow I will try putting the .71 on the new
> machine and see if it works or not

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: URGENT problem with mysql processes

2003-06-26 Thread Nils Valentin
Hi Keith,

2003年 6月 27日 金曜日 09:05、Keith Bussey さんは書きました:
> Major problem!
>
> I've installed mysql-standard 4.0.13 (from binary) a new DB server, it is
>
> - quad-xeon (500mhz each cpu)
> - 3 gig RAM
> - Linux Redhat 7.3
>
> When I start up mysql, processes looking like the following begin to pile
> up
>
> until it kills the server:
> | 106 | unauthenticated user | 192.168.1.59:1925 | NULL | Connect | NULL |
> | login NULL
I might be completely wrong but my guess would be that the mysql user account 
is not set up correctly.

> |
> | 115 | unauthenticated user | 192.168.1.53:2041 | NULL | Connect | NULL |
> | login NULL
> |
> | 118 | unauthenticated user | 192.168.1.56:4172 | NULL | Connect | NULL |
> | login NULL
> |
> | 119 | unauthenticated user | 192.168.1.56:4173 | NULL | Connect | NULL |
> | login NULL
>
> I need to fix this immediately as my site cannot run !
>
> Thanks in advance. I've seen this exact same situation happen to others
> (posted on various boards), however never saw any solutions ;/
>
>
>
> --
> Keith Bussey
>
> Wisol, Inc.
> Chief Technology Manager
> (514) 398-9994 ext.225

Best regards
-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: URGENT: Problems compiling mysql 3 and 4 on IRIX indy 6.5 IP22 mips

2003-06-06 Thread Jason Buchanan
Michael Widenius wrote:

Hi!

 

"Jason" == Jason Buchanan <[EMAIL PROTECTED]> writes:
   

Jason> hi,

Jason> I'm having a hard time getting mysql 4 and mysql 3 to compile on IRIX 6.5...

Jason> Does anyone have a solution to this?

Jason> Below is an example of compiling mysql 4.0.13 (looks practically 
Jason> identical for mysql 3.23.56):



Jason> g++ -DUNDEF_THREADS_HACK -I. -I. -I.. -I./../include -I../include -I./.. 
Jason> -I.. -I.. -O -DDBUG_OFF -D_BOOL -c -o mysql.o `test -f mysql.cc || 
Jason> echo './'`mysql.cc
Jason> In file included from 
Jason> /usr/local/lib/gcc-lib/mips-sgi-irix6.5/2.95.3/include/curses.h:5,
Jason>  from mysql.cc:54:
Jason> /usr/include/curses.h:112: syntax error before `,'
Jason> /usr/include/curses.h:143: syntax error before `;'



This problem is covered in the Irix section of the MySQL online
manual.  Please check it for details how to solve it.
 



I wish there was a link to the irix tips and suggestions page off of the 
mysql binaries page with the compiler switches...  but people in hell 
want icewater, too ;-)

Thanks!!
Jason


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


Re: URGENT: Problems compiling mysql 3 and 4 on IRIX indy 6.5 IP22 mips

2003-06-05 Thread vze2spjf
Look at http://gcc.gnu.org/ml/gcc-bugs/2000-11/msg00293.html

(I don't know anything about this, but that page seems very relevant.)

-S



> 
> From: Jason Buchanan <[EMAIL PROTECTED]>
> Date: 2003/06/04 Wed AM 08:22:29 CDT
> To: [EMAIL PROTECTED]
> Subject: URGENT:  Problems compiling mysql 3 and 4 on IRIX indy 6.5 IP22 mips
> 
> 
> hi,
> 
> I'm having a hard time getting mysql 4 and mysql 3 to compile on IRIX 6.5...
> 
> Does anyone have a solution to this?
> 
> Below is an example of compiling mysql 4.0.13 (looks practically 
> identical for mysql 3.23.56):
> 
> 
> g++ -DUNDEF_THREADS_HACK -I. -I. -I.. -I./../include -I../include -I./.. 
> -I.. -I.. -O -DDBUG_OFF -D_BOOL -c -o mysql.o `test -f mysql.cc || 
> echo './'`mysql.cc
> In file included from 
> /usr/local/lib/gcc-lib/mips-sgi-irix6.5/2.95.3/include/curses.h:5,
>  from mysql.cc:54:
> /usr/include/curses.h:112: syntax error before `,'
> /usr/include/curses.h:143: syntax error before `;'
> /usr/include/curses.h:285: `__curses_bool_t' was not declared in this scope
> /usr/include/curses.h:285: warning: `_meta' initialized and declared 
> `extern'
> /usr/include/curses.h:301: type specifier omitted for parameter
> /usr/include/curses.h:340: syntax error before `('
> /usr/include/curses.h:388: type specifier omitted for parameter
> /usr/include/curses.h:390: type specifier omitted for parameter
> In file included from 
> /usr/local/lib/gcc-lib/mips-sgi-irix6.5/2.95.3/include/curses.h:5,
>  from mysql.cc:54:
> /usr/include/curses.h:856: type specifier omitted for parameter
> /usr/include/curses.h:859: type specifier omitted for parameter
> /usr/include/curses.h:860: type specifier omitted for parameter
> /usr/include/curses.h:861: type specifier omitted for parameter
> /usr/include/curses.h:862: type specifier omitted for parameter
> /usr/include/curses.h:863: type specifier omitted for parameter
> /usr/include/curses.h:864: type specifier omitted for parameter
> /usr/include/curses.h:1015: type specifier omitted for parameter
> make[2]: *** [mysql.o] Error 1
> make[2]: Leaving directory `/usr/people/jsb/mysql-4.0.13/client'
> make[1]: *** [all-recursive] Error 1
> make[1]: Leaving directory `/usr/people/jsb/mysql-4.0.13'
> make: *** [all] Error 2
> 
> 
> 
> Thanks,
> Jason
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: Urgent Help needed

2002-10-18 Thread Ed Carp
> It looks like you have a dynamic IP your end and the mysql
> server is looking
> for a fixed IP.

Nope, you read it wrong, both of you.  MySQL is printing out YOUR IP
address, not the address of the server.  It's complaining that you don't
have permission to access the data you want.

sql, query.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Urgent Help needed

2002-10-18 Thread Simon Green
It looks like you have a dynamic IP your end and the mysql server is looking
for a fixed IP.
Try name based DNS form your PC. 
Simon


-Original Message-
From: [EMAIL PROTECTED] [mailto:manuvi@;eth.net]
Sent: 18 October 2002 09:38
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Urgent Help needed


Hi all,


I have used the following script to connect our remote database from my
local
machine. The PHP script is at my local machine. 

When I tried to connect the database, instead of connecting to the IP
provided
in the script, it is searching the Dynamic IP of my Internet Service
Provider.
and getting the following error.


Script in my local machine is : 



The IP 216.180.237.200 is the IP provided by my Web space provider.

The error message is,

Warning: Access denied for user: '[EMAIL PROTECTED]'
(Using password: YES) in c:\apache\htdocs\depots\temp\bomy\connect.php on
line
2

Warning: MySQL Connection Failed: Access denied for
user:'[EMAIL PROTECTED]'
(Using password: YES) inc:\apache\htdocs\depots\temp\bombay\connect.php on
line
2
cannot connect to mysqld 


The IP 203.100.234.139 is the Dynamic IP of my Internet Service Provider.

Please help me to sort out the problem.

Regards,

Vinod.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Urgent Help! Importing Data from Text File...

2002-10-10 Thread Oluwagbamila Oyekanmi

I did the following to resolve the problem.

1. Your create command didnt work for me and I changed the add(128) on line
6 to addrs varchar(128).  I suppose this was a typo since you already had a
working table.

2. Your main problem comes from the format of your input.  Use /N for
ommited column 1 which is an auto_increment and make sure you specify ""
explicitly for fields you do not have values for, and delimit carefully with
','.

3. Lastly, you dont need the LINE statement in the LOAD DATA statement since
you are going by the default.

Also notice that you will have some warnings going by your trying a null
value in the auto_increment column.  You can ignore this.

See my captured procedure and result below:

mysql>create database test;

Your Table schema file 'create.txt' :(changed add(128) to addrs
varchar(128) )

---
CREATE TABLE userdata (
  accno int(10) unsigned NOT NULL auto_increment,
  category mediumint(6) unsigned zerofill NOT NULL default '0',
  fname varchar(128) NOT NULL default '',
  lname varchar(128) NOT NULL default '',
  addrs varchar(128) NOT NULL default '',
  zip varchar(6) NOT NULL default '',
  city varchar(64) NOT NULL default '',
  telefone varchar(16) NOT NULL default '',
  homepage varchar(128) NOT NULL default '',
  email varchar(128) NOT NULL default '',
  telefax varchar(16) NOT NULL default '',
  PRIMARY KEY  (accno),
  KEY category (category),
  KEY fname (fname),
  KEY telefone (telefone),
  KEY zip (zip),
  KEY city (city),
  KEY telefax (telefax)
) TYPE=MyISAM;

--

#mysql test < create.txt


Your input file 't2t.txt':

--
/N,"1","Peter","John","512 Rennes
Road","19810","Wilmington","","http://www.mobilink.com","mailto:pjohn@mobili
nk.com","",
/N,"1","Sandra","Bridget","12th Aveneue No.
301","12548","Broklyn","(212)780101
10","","mailto:[EMAIL PROTECTED]","";,


---

mysql>
mysql> \u test
Database changed
mysql>
mysql>
mysql> LOAD DATA LOCAL INFILE 't2t.txt' INTO TABLE userdata FIELDS
TERMINATED BY ',' ENCLOSED BY '"';
Query OK, 2 rows affected (0.00 sec)
Records: 2  Deleted: 0  Skipped: 0  Warnings: 3

mysql> select * from userdata;
+---+--++-+--+---+--
--++-+--
+-+
| accno | category | fname  | lname   | addrs| zip   | city
| telefone   | homepage| email|
telefax |
+---+--++-+--+---+--
--++-+--
+-+
| 1 |   01 | Peter  | John| 512 Rennes Road  | 19810 |
Wilmington || http://www.mobilink.com |
mailto:[EMAIL PROTECTED]| |
| 2 |   01 | Sandra | Bridget | 12th Aveneue No. 301 | 12548 |
Broklyn| (212)780101 10 | |
mailto:[EMAIL PROTECTED] | |
+---+--++-+--+---+--
--++-+--
+-+
2 rows in set (0.00 sec)


Regards,
'Gbamila

- Original Message -
From: "Nasir Aziz Gill" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 10, 2002 10:26 AM
Subject: Urgent Help! Importing Data from Text File...


> Hi fellows,
>
> I got one text file of 9816 records (9816 lines) seprated by commas and
> enclosed by the inverted quotes and seprated by the end of lines. But when
I
> import the file, it only gets half of records in the table using below
> mentioned command;
>
> LOAD DATA INFILE 'user.txt' INTO TABLE userdata
> FIELDS TERMINATED BY ',' ENCLOSED BY '"'
> LINES TERMINATED BY '\n'
> (category, fname, lname, adresse, zip, city, telephone, email,
> homepage);
>
>
> I get the below mentoned message;
>
> >>Query OK, 4908 rows affected (0.91 sec)
> >>Records: 4908  Deleted: 0  Skipped: 0  Warnings: 4913
>
>
> Few records are as follow from the text file;
>
> "1","Peter","John","512 Rennes
>
Road","19810","Wilmington","","mailto:[EMAIL PROTECTED]","http://www.mobili
> nk.com"
> "1","Sandra","Bridget","12th Aveneue No. 301","12548","Broklyn","(212)780
> 101 10","mailto:[EMAIL PROTECTED]","";
>
> Note:"" fields are empty(missing data) i.e.(in some records, one is
> missing faxnumber and in some records one is missing homepage and in some
> one is missing telephone as well. That's why I have to use the empty
quotes
> for representing that f

Re: Urgent Help! Importing Data from Text File...

2002-10-10 Thread Clayburn W. Juniel, III


On Thursday, Oct 10, 2002, at 02:26 America/Phoenix, Nasir Aziz Gill  
wrote:

> Hi fellows,
>
> I got one text file of 9816 records (9816 lines) seprated by commas and
> enclosed by the inverted quotes and seprated by the end of lines. But  
> when I
> import the file, it only gets half of records in the table using below
> mentioned command;
>
> LOAD DATA INFILE 'user.txt' INTO TABLE userdata
>   FIELDS TERMINATED BY ',' ENCLOSED BY '"'
>   LINES TERMINATED BY '\n'
>   (category, fname, lname, adresse, zip, city, 
>telephone, email,
> homepage);
>
>
> I get the below mentoned message;
>
>>> Query OK, 4908 rows affected (0.91 sec)
>>> Records: 4908  Deleted: 0  Skipped: 0  Warnings: 4913
>
>
> Few records are as follow from the text file;
>
> "1","Peter","John","512 Rennes
> Road","19810","Wilmington","","mailto:[EMAIL PROTECTED]","http:// 
> www.mobili
> nk.com"
> "1","Sandra","Bridget","12th Aveneue No.  
> 301","12548","Broklyn","(212)780
> 101 10","mailto:[EMAIL PROTECTED]","";
>
> Note:"" fields are empty(missing data) i.e.(in some records, one is
> missing faxnumber and in some records one is missing homepage and in  
> some
> one is missing telephone as well. That's why I have to use the empty  
> quotes
> for representing that field.
>
> The table structure is as follow;
>
> CREATE TABLE userdata (
>   accno int(10) unsigned NOT NULL auto_increment,
>   category mediumint(6) unsigned zerofill NOT NULL default '0',
>   fname varchar(128) NOT NULL default '',
>   lname varchar(128) NOT NULL default '',
>   add(128) NOT NULL default '',
>   zip varchar(6) NOT NULL default '',
>   city varchar(64) NOT NULL default '',
>   telefone varchar(16) NOT NULL default '',
>   homepage varchar(128) NOT NULL default '',
>   email varchar(128) NOT NULL default '',
>   telefax varchar(16) NOT NULL default '',
>   PRIMARY KEY  (accno),
>   KEY category (category),
>   KEY fname (fname),
>   KEY telefone (telefone),
>   KEY zip (zip),
>   KEY city (city),
>   KEY telefax (telefax)
> ) TYPE=MyISAM;
>
> Please advise me that whey I am not getting the whole records in the  
> table
> from the text file.
>
> Your help will be highly appreciated...
> With Best Regards...

Create a table with all the restrictions removed.  No "Key", or "NOT  
NULL" or "ENUM" or anything else.  If All the data can be loaded into  
that table then you no there is some problems with the restrictions.   
When loading data from a file, I think it best to always load data into  
an unrestricted table then move it to the final one.  It may take a  
little longer, but you can then check to see if any records were  
skipped.  Of course you may want some skipped.  Or you may find errors  
in your input file.

--
Clayburn W. Juniel, III
Phone: (602) 326-7707
Email: [EMAIL PROTECTED]
http://EffectiveSoftwareSolutions.com
--


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Urgent Help! Importing Data from Text File...

2002-10-10 Thread Peter Lovatt

Hi

Two thoughts

try \r\n instead of \n

or

if you are getting warnings it may be that there is a problem with the
data - illegal characters or something?

if neither works email me offlist and I will take a look, if that helps.

HTH

Peter


---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
tel. 0121-242-1473
---

-Original Message-
From: Nasir Aziz Gill [mailto:[EMAIL PROTECTED]]
Sent: 10 October 2002 09:27
To: [EMAIL PROTECTED]
Subject: Urgent Help! Importing Data from Text File...
Importance: High


Hi fellows,

I got one text file of 9816 records (9816 lines) seprated by commas and
enclosed by the inverted quotes and seprated by the end of lines. But when I
import the file, it only gets half of records in the table using below
mentioned command;

LOAD DATA INFILE 'user.txt' INTO TABLE userdata
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n'
(category, fname, lname, adresse, zip, city, 
telephone, email,
homepage);


I get the below mentoned message;

>>Query OK, 4908 rows affected (0.91 sec)
>>Records: 4908  Deleted: 0  Skipped: 0  Warnings: 4913


Few records are as follow from the text file;

"1","Peter","John","512 Rennes
Road","19810","Wilmington","","mailto:[EMAIL PROTECTED]","http://www.mobili
nk.com"
"1","Sandra","Bridget","12th Aveneue No. 301","12548","Broklyn","(212)780
101 10","mailto:[EMAIL PROTECTED]","";

Note:"" fields are empty(missing data) i.e.(in some records, one is
missing faxnumber and in some records one is missing homepage and in some
one is missing telephone as well. That's why I have to use the empty quotes
for representing that field.

The table structure is as follow;

CREATE TABLE userdata (
  accno int(10) unsigned NOT NULL auto_increment,
  category mediumint(6) unsigned zerofill NOT NULL default '0',
  fname varchar(128) NOT NULL default '',
  lname varchar(128) NOT NULL default '',
  add(128) NOT NULL default '',
  zip varchar(6) NOT NULL default '',
  city varchar(64) NOT NULL default '',
  telefone varchar(16) NOT NULL default '',
  homepage varchar(128) NOT NULL default '',
  email varchar(128) NOT NULL default '',
  telefax varchar(16) NOT NULL default '',
  PRIMARY KEY  (accno),
  KEY category (category),
  KEY fname (fname),
  KEY telefone (telefone),
  KEY zip (zip),
  KEY city (city),
  KEY telefax (telefax)
) TYPE=MyISAM;

Please advise me that whey I am not getting the whole records in the table
from the text file.

Your help will be highly appreciated...
With Best Regards...

Nasir



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Urgent!!

2002-09-30 Thread Keith C. Ivey

> Its called Sun ONE from SUN.
> 
> http://www.chilisoft.com/

Don't most people who use ASP want to use Visual Basic?  So the 
problem isn't really lack of ASP on Linux but lack of VB.  Somehow I 
doubt that Microsoft (at least in its current incarnation) is going 
to come out with VB for Linux.

[Filter fodder: SQL]

-- 
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Urgent!!

2002-09-30 Thread Dan Donald

Chuck,

ChiliSoft ASP is actually a Linux port of ASP 3 (I think).  On the whole
we've found it to run OK but there are a few features that are not included
in the more recent Microsoft releases.  While it makes it easy for IIS users
to port their sites to a Linux server I personally wouldn't depend on it.
They've done a good job but it's not as good as it needs to be.  PHP seems
to offer a far easier way of working with a whole community behind the
development of the language so we're moving over to PHP ourselves.

My two pence...


Dan Donald
Reach Multimedia



- Original Message -
From: "Chuck Payne" <[EMAIL PROTECTED]>
To: "William R. Mussatto" <[EMAIL PROTECTED]>; "Insanely Great"
<[EMAIL PROTECTED]>
Cc: "Ibrahim Al-Tawil" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, September 30, 2002 6:03 PM
Subject: RE: Urgent!!


> There is a package called Chilisoft that will let you take your ASP pages
> and change them to PHP, I am not sure how well it works. I had a client
that
> want to run ASP on linux and told I didn't think you could but PHP works
and
> to me is better. But the price of Chilisoft was a little hight. I think a
> round $500.
>
> But hey that my 2 Cents.
>
> Chuck Payne
> Magi
>
> -Original Message-
> From: William R. Mussatto [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 30, 2002 12:29 PM
> To: Insanely Great
> Cc: Ibrahim Al-Tawil; [EMAIL PROTECTED]
> Subject: Re: Urgent!!
>
>
> On Sun, 29 Sep 2002, Insanely Great wrote:
>
> > Date: Sun, 29 Sep 2002 22:43:43 +0530
> > From: Insanely Great <[EMAIL PROTECTED]>
> > To: Ibrahim Al-Tawil <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> > Subject: Re: Urgent!!
> >
> > Greetings...
> >
> > I believe that ASP works well with MySQL thru ODBC. As of learning other
> > technologies it really depends what all you require.
> >
> > Still MySQL works best with PERL and PHP.
> Doesn't do to badly with .jsp either.
>
> ? How do you intend to run .ASP on linux?
>
> >
> > Rgs
> > Insane
> >
> > SQLyog ( http://www.webyog.com/sqlyog )
> > The Definative Front End for MySQL
> >
> > - Original Message -
> > From: "Ibrahim Al-Tawil" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Sunday, September 29, 2002 10:21 PM
> > Subject: Urgent!!
> >
> >
> > > Hi,
> > >
> > > I have a certain task to be done, which is a Database Driven website
> based
> > > on MySQL operated on Linux, my Question is:
> > > Can I develope such a site using ASP (Active Server Pages)?
> > > So, I will avoid spending a lot of time in learning other technology
> > instead
> > > of ASP. and also if there is special requirements in order to do it.
> > >
> > > Best Regards.
> > > I.M.A
> > >
> > >
> > >
> > > _
> > > Send and receive Hotmail on your mobile device: http://mobile.msn.com
> > >
> > >
> > > -
> > > Before posting, please check:
> > >http://www.mysql.com/manual.php   (the manual)
> > >http://lists.mysql.com/   (the list archive)
> > >
> > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > >
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
> Sincerely,
>
> William Mussatto, Senior Systems Engineer
> CyberStrategies, Inc
> ph. 909-920-9154 ext. 27
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Urgent!!

2002-09-30 Thread Chuck Payne

There is a package called Chilisoft that will let you take your ASP pages
and change them to PHP, I am not sure how well it works. I had a client that
want to run ASP on linux and told I didn't think you could but PHP works and
to me is better. But the price of Chilisoft was a little hight. I think a
round $500.

But hey that my 2 Cents.

Chuck Payne
Magi

-Original Message-
From: William R. Mussatto [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 12:29 PM
To: Insanely Great
Cc: Ibrahim Al-Tawil; [EMAIL PROTECTED]
Subject: Re: Urgent!!


On Sun, 29 Sep 2002, Insanely Great wrote:

> Date: Sun, 29 Sep 2002 22:43:43 +0530
> From: Insanely Great <[EMAIL PROTECTED]>
> To: Ibrahim Al-Tawil <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> Subject: Re: Urgent!!
>
> Greetings...
>
> I believe that ASP works well with MySQL thru ODBC. As of learning other
> technologies it really depends what all you require.
>
> Still MySQL works best with PERL and PHP.
Doesn't do to badly with .jsp either.

? How do you intend to run .ASP on linux?

>
> Rgs
> Insane
>
> SQLyog ( http://www.webyog.com/sqlyog )
> The Definative Front End for MySQL
>
> - Original Message -
> From: "Ibrahim Al-Tawil" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, September 29, 2002 10:21 PM
> Subject: Urgent!!
>
>
> > Hi,
> >
> > I have a certain task to be done, which is a Database Driven website
based
> > on MySQL operated on Linux, my Question is:
> > Can I develope such a site using ASP (Active Server Pages)?
> > So, I will avoid spending a lot of time in learning other technology
> instead
> > of ASP. and also if there is special requirements in order to do it.
> >
> > Best Regards.
> > I.M.A
> >
> >
> >
> > _
> > Send and receive Hotmail on your mobile device: http://mobile.msn.com
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>

Sincerely,

William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Urgent!!

2002-09-30 Thread Dan Harrington


[.snip.]
> ? How do you intend to run .ASP on linux? 
[.snip.]

Its called Sun ONE from SUN.

http://www.chilisoft.com/

Dan

> -Original Message-
> From: William R. Mussatto [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 30, 2002 10:29 AM
> To: Insanely Great
> Cc: Ibrahim Al-Tawil; [EMAIL PROTECTED]
> Subject: Re: Urgent!!
> 
> 
> On Sun, 29 Sep 2002, Insanely Great wrote:
> 
> > Date: Sun, 29 Sep 2002 22:43:43 +0530
> > From: Insanely Great <[EMAIL PROTECTED]>
> > To: Ibrahim Al-Tawil <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> > Subject: Re: Urgent!!
> > 
> > Greetings...
> > 
> > I believe that ASP works well with MySQL thru ODBC. As of learning other
> > technologies it really depends what all you require.
> > 
> > Still MySQL works best with PERL and PHP.
> Doesn't do to badly with .jsp either.
> 
> ? How do you intend to run .ASP on linux? 
> 
> > 
> > Rgs
> > Insane
> > 
> > SQLyog ( http://www.webyog.com/sqlyog )
> > The Definative Front End for MySQL
> > 
> > - Original Message -
> > From: "Ibrahim Al-Tawil" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Sunday, September 29, 2002 10:21 PM
> > Subject: Urgent!!
> > 
> > 
> > > Hi,
> > >
> > > I have a certain task to be done, which is a Database Driven website based
> > > on MySQL operated on Linux, my Question is:
> > > Can I develope such a site using ASP (Active Server Pages)?
> > > So, I will avoid spending a lot of time in learning other technology
> > instead
> > > of ASP. and also if there is special requirements in order to do it.
> > >
> > > Best Regards.
> > > I.M.A
> > >
> > >
> > >
> > > _
> > > Send and receive Hotmail on your mobile device: http://mobile.msn.com
> > >
> > >
> > > -
> > > Before posting, please check:
> > >http://www.mysql.com/manual.php   (the manual)
> > >http://lists.mysql.com/   (the list archive)
> > >
> > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > >
> > 
> > 
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> > 
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > 
> 
> Sincerely,
> 
> William Mussatto, Senior Systems Engineer
> CyberStrategies, Inc
> ph. 909-920-9154 ext. 27
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Urgent!!

2002-09-30 Thread Mike Roest

William R. Mussatto wrote:
> On Sun, 29 Sep 2002, Insanely Great wrote:
> 
> 
>>Date: Sun, 29 Sep 2002 22:43:43 +0530
>>From: Insanely Great <[EMAIL PROTECTED]>
>>To: Ibrahim Al-Tawil <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
>>Subject: Re: Urgent!!
>>
>>Greetings...
>>
>>I believe that ASP works well with MySQL thru ODBC. As of learning other
>>technologies it really depends what all you require.
>>
>>Still MySQL works best with PERL and PHP.
> 
> Doesn't do to badly with .jsp either.
> 
> ? How do you intend to run .ASP on linux? 
You should technically be able to use chillisoft on lin/unix.  But it is 
a piece of junk, it will probably save you many headaches to spend the 
small amount of time it will take you to learn php.
> 
> 
>>Rgs
>>Insane
>>
>>SQLyog ( http://www.webyog.com/sqlyog )
>>The Definative Front End for MySQL
>>
>>- Original Message -
>>From: "Ibrahim Al-Tawil" <[EMAIL PROTECTED]>
>>To: <[EMAIL PROTECTED]>
>>Sent: Sunday, September 29, 2002 10:21 PM
>>Subject: Urgent!!
>>
>>
>>
>>>Hi,
>>>
>>>I have a certain task to be done, which is a Database Driven website based
>>>on MySQL operated on Linux, my Question is:
>>>Can I develope such a site using ASP (Active Server Pages)?
>>>So, I will avoid spending a lot of time in learning other technology
>>
>>instead
>>
>>>of ASP. and also if there is special requirements in order to do it.
>>>
>>>Best Regards.
>>>I.M.A
>>>
>>>
>>>
>>>_
>>>Send and receive Hotmail on your mobile device: http://mobile.msn.com
>>>
>>>
>>>-
>>>Before posting, please check:
>>>   http://www.mysql.com/manual.php   (the manual)
>>>   http://lists.mysql.com/   (the list archive)
>>>
>>>To request this thread, e-mail <[EMAIL PROTECTED]>
>>>To unsubscribe, e-mail
>>
>><[EMAIL PROTECTED]>
>>
>>>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>>
>>
>>
>>-
>>Before posting, please check:
>>   http://www.mysql.com/manual.php   (the manual)
>>   http://lists.mysql.com/   (the list archive)
>>
>>To request this thread, e-mail <[EMAIL PROTECTED]>
>>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
> 
> 
> Sincerely,
> 
> William Mussatto, Senior Systems Engineer
> CyberStrategies, Inc
> ph. 909-920-9154 ext. 27
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Urgent!!

2002-09-30 Thread William R. Mussatto

On Sun, 29 Sep 2002, Insanely Great wrote:

> Date: Sun, 29 Sep 2002 22:43:43 +0530
> From: Insanely Great <[EMAIL PROTECTED]>
> To: Ibrahim Al-Tawil <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> Subject: Re: Urgent!!
> 
> Greetings...
> 
> I believe that ASP works well with MySQL thru ODBC. As of learning other
> technologies it really depends what all you require.
> 
> Still MySQL works best with PERL and PHP.
Doesn't do to badly with .jsp either.

? How do you intend to run .ASP on linux? 

> 
> Rgs
> Insane
> 
> SQLyog ( http://www.webyog.com/sqlyog )
> The Definative Front End for MySQL
> 
> - Original Message -
> From: "Ibrahim Al-Tawil" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, September 29, 2002 10:21 PM
> Subject: Urgent!!
> 
> 
> > Hi,
> >
> > I have a certain task to be done, which is a Database Driven website based
> > on MySQL operated on Linux, my Question is:
> > Can I develope such a site using ASP (Active Server Pages)?
> > So, I will avoid spending a lot of time in learning other technology
> instead
> > of ASP. and also if there is special requirements in order to do it.
> >
> > Best Regards.
> > I.M.A
> >
> >
> >
> > _
> > Send and receive Hotmail on your mobile device: http://mobile.msn.com
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 

Sincerely,

William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Urgent!!

2002-09-29 Thread Insanely Great

Greetings...

I believe that ASP works well with MySQL thru ODBC. As of learning other
technologies it really depends what all you require.

Still MySQL works best with PERL and PHP.

Rgs
Insane

SQLyog ( http://www.webyog.com/sqlyog )
The Definative Front End for MySQL

- Original Message -
From: "Ibrahim Al-Tawil" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, September 29, 2002 10:21 PM
Subject: Urgent!!


> Hi,
>
> I have a certain task to be done, which is a Database Driven website based
> on MySQL operated on Linux, my Question is:
> Can I develope such a site using ASP (Active Server Pages)?
> So, I will avoid spending a lot of time in learning other technology
instead
> of ASP. and also if there is special requirements in order to do it.
>
> Best Regards.
> I.M.A
>
>
>
> _
> Send and receive Hotmail on your mobile device: http://mobile.msn.com
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: urgent ...

2002-09-05 Thread walt

"Sekhar.Thota" wrote:

> Hi,
>
> I have did setup for MySQL - Innodb tables. But I am not getting support for
> row level locks. Whenever I am issuing a update the innodb tables are
> locking my tables. Please help me whether I need to set any variables in
> sqld file to get the support for row level locks ???
>
> Regards,
> Sekhar
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

SHOW TABLE STATUS LIKE 'TABLE_NAME'
should tell you if the table is innodb or not.

If not you can.
1.  ALTER TABLE tbl_name TYPE = INNODB;
2. recreate the table with type=INNODB
3. add default-table-type=innodb to the my.cnf file, restart mysql, and recreate
the table

hope this helps
walt


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Urgent: lost connections,

2002-08-17 Thread Chris Knipe

Lo Victoria

FreeBSD 4.6-STABLE (Master), MySQL 3.23.51
Windows 2000 Professional (Slave):, MySQL 3.23.49-nt

I've recompiled the master about three times now, and it still crashed.
Eventually, it came to such a extend that the moment I open port 3306 MySQL
would crash.  I can just use telnet  3306, or open a netcat on port
3306, and MySQL would die.

So far, the only way I found to keep the FreeBSD Port up, was to recompile
it with debug support.  I so far have 90 minutes uptime on the Master with
debug support compiled in, but it's needless to say not really the desired
result.

I also don't think it's got anything to do with the replication.  In my
attempts to debug this, I've disabled (shut down), the slave mysql server,
and the master would still crash the moment I open a tcp socket...  It also
doesn't seem to be a generic system library or something as the error log
states, because I have *nothing* else on my box that is giving me any
problems... If it where to be a shared lib used by many applications, surely
more than just MySQL would have been dying because of the faulty / corrupted
library.

--
me


- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 17, 2002 5:13 PM
Subject: Re: Urgent: lost connections,


> Chris,
> Saturday, August 17, 2002, 2:04:40 AM, you wrote:
>
> CK> Lo everyone,
>
> CK> I've implemented replication on my MySQL Server...  The master is
mysql 3.23
> CK> (FreeBSD Ports), and my one and only slave is mysql 3.23 (Win32).  I
added
> CK> the slave so that I can have a hardcopy / backup database in the event
that
> CK> I have a data loss on the master.
>
> "3.23" says almost nothing about MySQL server. What exact version do you
run
> at master and slave?
>
>
>
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
>  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
><___/   www.mysql.com
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Urgent: lost connections,

2002-08-17 Thread Victoria Reznichenko

Chris,
Saturday, August 17, 2002, 2:04:40 AM, you wrote:

CK> Lo everyone,

CK> I've implemented replication on my MySQL Server...  The master is mysql 3.23
CK> (FreeBSD Ports), and my one and only slave is mysql 3.23 (Win32).  I added
CK> the slave so that I can have a hardcopy / backup database in the event that
CK> I have a data loss on the master.

"3.23" says almost nothing about MySQL server. What exact version do you run
at master and slave?





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: URGENT - ISAMCHK utility - Please help me

2002-05-20 Thread Benjamin Pflugmann

Hello.

On Mon, May 20, 2002 at 07:17:55PM +0400, [EMAIL PROTECTED] wrote:
> Hello:
> 
> I was trying isamchk on my tables. Found one table with deleted blocks.

You know, there would be no reason to repair, except to reclaim the
disk space of the deleted rows?

> Used this option to check:
> ./isamchk -e ~/usr/local/var/events/events.ISM
> ###output###
> Data records: 435   Deleted blocks: 375
> - check file-size
> - check delete-chain
> - check index reference
> - check data record references index: 1
> - check data record references index: 2
> - check records and index references
> ###
> 
> And to recover
> ./isamchk -r ~/usr/local/var/events/events.ISM
> ###output msg###
> - recovering ISAM-table '/usr/local/var/events/events.ISM'
> Data records: 435
> - Fixing index 1
> - Fixing index 2
> ###
> 
> After fixing the table, the table is showing empty.

Strange. As there are reported 433 records to exist. Did you shutdown
the server while you used isamchk as I recommended in my last mail?

If not, take a backup from the table and start from scratch.

> The .ISD file has got data in that. How can I recover the contents
> in that table or should I use any other command to fix the tables.

No. What you have done should have worked.

Regards,

Benjamin.


[...]
> At 06:47 PM 5/16/02 +0200, you wrote:
[...]
> >Shut down the mysql daemon, run "isamchk" on all tables to find out
> >which are corrupted and run "isamchk -r" on those. Then restart
> >mysqld. Do not forget to make backup copies of the tables in question
> >beforehand, in case anything unexpected happens.
> >
> >You can get more information about your version of isamchk with
> >"isamchk --help".

-- 
[EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail 
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: URGENT: Update Error with MySQL++

2002-03-20 Thread Thi Cao

thank you very much

-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 8:25 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: URGENT: Update Error with MySQL++


Thi Cao writes:
> All,
> 
> I can't seem to perform an update on my database with MySQL++.  The
> execution of the query always throws an exception.  Here's a snippet of
what
> I did.
> 
> Query query(&conn);
> 
> query << "update employee set children = 3 where id = 9";
> query.execute();
> 
> The above code throws an exception everytime.  What am I doing wrong?
> Thanks.
> 
> 
> Thi
> 

Don't use streams for commands that do not return result sets.

Use exec() method instead. 

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Urgent: Please look at this error

2002-03-20 Thread Jim Philips

It looks like you don't have a path to that library. Once you find the
true location of libpthread.so, add that directory path to the file
/etc/ld.conf. After that is done, run:

ldconfig -v

as root and try again. 


On Wed, 2002-03-20 at 09:13, Amrita Basu wrote:
> Hi, I am using Redhat 6.2 kernel 2.2.20 and am getting
> this error below. I know that these paths are
> incorrect , should be /jive/usr/biosym/235 instead
> of /usr/biosym... where do I change this? Which file?
> Sorry if this is obvious, but I am new to mysql. 
> Thanks,
> Amrita
> 
> unknown user id: mysql
> Starting mysqld daemon with databases from 
> /oscar2/mysql/mysql-3.23.47-sgi-irix6.5-mips/data
> 
> 4673:/oscar2/mysql/mysql-3.23.47-sgi-irix6.5-mips/bin/mysqld:
> rld: 
> Fatal Error: Cannot Successfully map soname
> 'libpthread.so' under any of 
> the filenames 
> 
>/usr/biosym/235/irix51r4/biosymso/libpthread.so:/usr/lib32/libpthread.so:/usr/lib32/internal/libpthread.so:/lib32/libpthread.so:/opt/lib32/libpthread.so:/usr/biosym/235/irix51r4/biosymso/libpthread.so.1:/usr/lib32/libpthread.so.1:/usr/lib32/internal/libpthread.so.1:/lib32/libpthread.so.1:/opt/lib32/libpthread.so.1:
> 
> 020319 18:46:10  mysqld ended
> 
> 
> __
> Do You Yahoo!?
> Yahoo! Sports - live college hoops coverage
> http://sports.yahoo.com/
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: URGENT: Update Error with MySQL++

2002-03-20 Thread Sinisa Milivojevic

Thi Cao writes:
> All,
> 
> I can't seem to perform an update on my database with MySQL++.  The
> execution of the query always throws an exception.  Here's a snippet of what
> I did.
> 
> Query query(&conn);
> 
> query << "update employee set children = 3 where id = 9";
> query.execute();
> 
> The above code throws an exception everytime.  What am I doing wrong?
> Thanks.
> 
> 
> Thi
> 

Don't use streams for commands that do not return result sets.

Use exec() method instead. 

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Urgent Help!!!

2002-03-04 Thread James Carrier

Hi Stanley

You can get mysql to tell you what an error means by doing

perror 

In your case the result is 'Record was already deleted (or record file 
crashed)'.

You should be able to recover your table with myisamchk -r

james


At 15:09 04/03/2002 +, Stanley Joseph wrote:
>Hi ,
>When ever I am running my query it gives me
>1030- got error 134 from table handler.
>has anybody come across it.
>
>Any help will be greatly appreciated.
>
>Thanks
>Stanley
>
>
>
>This email and any attachments are confidential. They may contain privileged
>information and are intended for the named addressee (s) only. They must not
>be distributed without our consent. If you are not the intended recipient,
>please
>notify us immediately and do not disclose, distribute, or retain this email
>or any
>part of it. Unless expressly stated, opinions in this email are those of the
>individual sender, and not of The mobile republic. We believe but do not
>warrant
>that this e-mail and any attachments are virus free. You must therefore take
>full
>responsibility for virus checking. The mobile republic reserves the right to
>monitor
>all email communications through their networks
>
>*
>
>
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

James Carrier

Bullet Online :: Aim Higher [http://www.bulletonline.com]
41b Beavor Lane, London W6 9BL

Tel +44 (0) 20 8834 3442
Fax +44 (0) 20 8741 2790


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: urgent problem with mysql and phpmyadmin

2002-02-20 Thread David McInnis

My guess. . . 

I have seen this problem with other databases . . . don't know if it is
true for MySQL as well.  Try to change to your field definition to
float(5,2) as it may be counting the (.) as part of your field size.

So if you number is xx.xx you will need 5,2.  4,2 would give you xx.x

David McInnis



-Original Message-
From: Andrew Bunkell [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, February 20, 2002 5:31 PM
To: [EMAIL PROTECTED]
Subject: urgent problem with mysql and phpmyadmin

I have created a table in the mysql db, using phpmyadmin with the
following
statement:

create table books
( isbn char(13) not null,author char(30),title(60),price
float(4,2),primary
key(isbn));

which works fine and creates the table i need the problem comes when i
try
to insert some values into the price column using the phpmyadmin form,
if
for example i try to enter the price 34.99 it will only allow me to
enter
34.9, and then when i go to the browse feature it shows the value as
34.90
any ideas on what's going wrong???
any help would be much apprecited.
thanks


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: urgent : Problem in Group by clause

2002-02-16 Thread Teri Salisbury

Hi Shankar,

This is your old buddy Scott S.

Try order by rather than group byThis will get you what you are looking
for

Scott Salisbury

- Original Message -
From: "SankaraNarayanan Mahadevan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 16, 2002 3:42 PM
Subject: urgent : Problem in Group by clause


hi all,

i have a problem in mysql query...
lemme state the scenario...

i have a table 'UploadDetails' in which i am storing
data regd files...

the fields are:
FileName, Title, Designer, UploadedBy, SubmittedDate

i want to get details about whose files are designed
by who..etc...
that is i need to use group by in select statement..

i want to display the details in the web page ...

say there are 3 records as below against each field:
1. 'a.jpg','test','david','john','2002-02-14'
2. 'b.bmp','bmp file','richard','mary','2002-02-14'
3. 'c.htm','web','david','mary','2002-02-15'


now i want to display the details grouped by Designer
(the third field).

when i use the following query:

select
FileName,Title,Designer,UploadedBy,SubmittedDate
>From UploadDetails
Group By Designer

i get only one row...

why?

can anyone solve this problem...

thanks in advance

Shankar

__
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: urgent respnse

2002-01-30 Thread Michael Stassen


On Tue, 29 Jan 2002, Sasha Pachev wrote:

> On Tuesday 29 January 2002 06:20 pm, Michael Widenius wrote:
> > I think we can avoid things like this by adding some extra 'not-
> > allowed-on-the-list' words, that a non-subscribe can't use, without
> > including an extra keyword in the email.
> > 
> > Sasha, what do you think about this?
> 
> The point is that we block MOST spams, not EVERY spam that can be invented. 
> Yes, if the spammer happens to say "", his message will make it 
[ filter word hidden to prove a point ]
> through. So what? This is just one message. If the current filter system 
> proves inadequate we will consider adjusting it. But for now, requiring the 
> sender to use one of the "good" words is sufficient to maintain a good signal 
> to noise ratio in my opinion.

This begs the question, what is "a good signal to noise ratio?"  How much
spam must escape the filter before you consider it "inadequate?"  Can you
see that this threshold is subjective, and that we've already crossed it
for some (many?).  

I joined this list several months ago.  My subjective impression (I
haven't been counting) is that the amount of spam making it through the
filter is increasing.  Perhaps this is cyclical and I just happened to
join at a low point, but it doesn't *feel* that way.  The number of
complaints about the spam is also increasing.  

Your customers are telling you something.  It is easy to read the above
response as "It works well enough for me, quit whining."  I doubt that's
the professional impression you want to give.  

You say, "This is just one message."  It is not.  Six of these have
escaped the filter already today.  None of them use any of the 4 filter
words.  At the very least, I'd suggest you fix the filter to actually do
what you say it does, *require* one of the "good" *words*.

Personally, I'm not that bothered by the spam.  I find deleting the spam
just as easy as deleting the 70-100 on-topic messages per day that don't
interest me.  On the other hand, I also don't see the big deal with
requiring a subscription to post.  Seems like a reasonable cost to get
otherwise free help.  (A little cost might just encourage a little more
manual reading.)

Finally, I'll just add that I've never been on a list where suggestions
that "complaining about spam to the list only adds to the problem" has had
any positive effect (despite it's apparent truth).

Michael

For the filter: charitable stableboy's vegetable grotesquery



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Urgent Business Assistance.

2002-01-30 Thread William R. Mussatto

On Wed, 30 Jan 2002, Marjolein Katsma wrote:

> Date: Wed, 30 Jan 2002 12:33:29 +0100
> From: Marjolein Katsma <[EMAIL PROTECTED]>
> To: MySQL <[EMAIL PROTECTED]>
> Subject: RE: Urgent Business Assistance.
> 
> 
> At 03:52 2002-01-30, Todd Williamsen wrote:
> >If its so urgent and private then why are you spamming a mail list?  I
> >smell scam, or is that Spam?
> 
> It's both.
> 
> And please do not quote the *whole* spam - the loss of bandwidth (it goes to every 
>subscriber!) from the actual spam is already bad enough.
> 
> Replying to the spammer is useless, too - they do NOT subscribe. Spammers are lazy.
> 
> Grrr: database,sql,query,table
> 
Just my $0.02..
Look for the web site or email they push, not the originating we address. 
Do a traceroute to it and send to abuse@... their ISP and their ISP's ISP 
and complain.  They have to be real addresses because they want you to 
respond.  Works more effectively than unsubscibing.  Also, it a LOT of 
people do it, the ISP usually will notice.

Sincerely,

William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Urgent Business Assistance.

2002-01-30 Thread Duncan Hill

On Wed, 30 Jan 2002, Engr.Martin Douglas. wrote:

> Urgent Business Asistance.
> 
> Engr.Martin Douglas.

Ok.. I'm about to slamdunk a few phrases into my procmail filters.

However, is there any way mere mortals on this list can get the full 
headers?

(sql,mysql,database)


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Urgent Business Assistance.

2002-01-30 Thread Marjolein Katsma


At 03:52 2002-01-30, Todd Williamsen wrote:
>If its so urgent and private then why are you spamming a mail list?  I
>smell scam, or is that Spam?

It's both.

And please do not quote the *whole* spam - the loss of bandwidth (it goes to every 
subscriber!) from the actual spam is already bad enough.

Replying to the spammer is useless, too - they do NOT subscribe. Spammers are lazy.

Grrr: database,sql,query,table

-- 
Marjolein Katsma
HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools
The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Urgent Help needed

2002-01-30 Thread SubbaReddy M

Hi Srinivas,

Here is some info, may meet ur requirement.

ALTER TABLE syntax :-

ALTER [IGNORE] TABLE tbl_name alter_spec [, alter_spec ...]

alter_specification:
ADD [COLUMN] create_definition [FIRST | AFTER column_name ]
  orADD INDEX [index_name] (index_col_name,...)
  orADD PRIMARY KEY (index_col_name,...)
  orADD UNIQUE [index_name] (index_col_name,...)
  orALTER [COLUMN] col_name {SET DEFAULT literal | DROP DEFAULT}
  orCHANGE [COLUMN] old_col_name create_definition
  orMODIFY [COLUMN] create_definition
  orDROP [COLUMN] col_name
  orDROP PRIMARY KEY
  orDROP INDEX key_name
  orRENAME [AS] new_tbl_name
  ortable_option

ALTER TABLE allows you to change the structure of an existing table. For
example, you can add or delete columns, create or destroy indexes, change
the type of existing columns, or rename columns or the table itself. You can
also change the comment for the table and type of the table. See section 7.6
CREATE TABLE syntax.

If you use ALTER TABLE to change a column specification but DESCRIBE
tbl_name indicates that your column was not changed, it is possible that
MySQL ignored your modification for one of the reasons described in section
7.6.1 Silent column specification changes. For example, if you try to change
a VARCHAR column to CHAR, MySQL will still use VARCHAR if the table contains
other variable-length columns.

ALTER TABLE works by making a temporary copy of the original table. The
alteration is performed on the copy, then the original table is deleted and
the new one is renamed. This is done in such a way that all updates are
automatically redirected to the new table without any failed updates. While
ALTER TABLE is executing, the original table is readable by other clients.
Updates and writes to the table are stalled until the new table is ready.

To use ALTER TABLE, you need select, insert, delete, update, create and drop
privileges on the table.
IGNORE is a MySQL extension to ANSI SQL92. It controls how ALTER TABLE works
if there are duplicates on unique keys in the new table. If IGNORE isn't
specified, the copy is aborted and rolled back. If IGNORE is specified, then
for rows with duplicates on a unique key, only the first row is used; the
others are deleted.
You can issue multiple ADD, ALTER, DROP and CHANGE clauses in a single ALTER
TABLE statement. This is a MySQL extension to ANSI SQL92, which allows only
one of each clause per ALTER TABLE statement.
CHANGE col_name, DROP col_name and DROP INDEX are MySQL extensions to ANSI
SQL92.
MODIFY is an Oracle extension to ALTER TABLE.
The optional word COLUMN is a pure noise word and can be omitted.
If you use ALTER TABLE tbl_name RENAME AS new_name without any other
options, MySQL simply renames the files that correspond to the table
tbl_name. There is no need to create the temporary table.
create_definition clauses use the same syntax for ADD and CHANGE as for
CREATE TABLE. Note that this syntax includes the column name, not just the
column type. See section 7.6 CREATE TABLE syntax.
You can rename a column using a CHANGE old_col_name create_definition
clause. To do so, specify the old and new column names and the type that the
column currently has. For example, to rename an INTEGER column from a to b,
you can do this:
mysql> ALTER TABLE t1 CHANGE a b INTEGER;

If you want to change a column's type but not the name, CHANGE syntax still
requires two column names even if they are the same. For example:
mysql> ALTER TABLE t1 CHANGE b b BIGINT NOT NULL;

However, as of MySQL 3.22.16a, you can also use MODIFY to change a column's
type without renaming it:
mysql> ALTER TABLE t1 MODIFY b BIGINT NOT NULL;

If you use CHANGE or MODIFY to shorten a column for which an index exists on
part of the column (for instance, if you have an index on the first 10
characters of a VARCHAR column), you cannot make the column shorter than the
number of characters that are indexed.
When you change a column type using CHANGE or MODIFY, MySQL tries to convert
data to the new type as well as possible.
In MySQL 3.22 or later, you can use FIRST or ADD ... AFTER col_name to add a
column at a specific position within a table row. The default is to add the
column last.
ALTER COLUMN specifies a new default value for a column or removes the old
default value. If the old default is removed and the column can be NULL, the
new default is NULL. If the column cannot be NULL, MySQL assigns a default
value. Default value assignment is described in section 7.6 CREATE TABLE
syntax.
DROP INDEX removes an index. This is a MySQL extension to ANSI SQL92.
If columns are dropped from a table, the columns are also removed from any
index of which they are a part. If all columns that make up an index are
dropped, the index is dropped as well.
DROP PRIMARY KEY drops the primary index. If no such index exists, it drops
the first UNIQUE index in the table. (MySQL marks the first UNIQUE key as
the PRIMARY KEY if no PRIMARY KEY was 

Re: urgent respnse

2002-01-29 Thread Sasha Pachev

On Tuesday 29 January 2002 06:20 pm, Michael Widenius wrote:
> I think we can avoid things like this by adding some extra 'not-
> allowed-on-the-list' words, that a non-subscribe can't use, without
> including an extra keyword in the email.
> 
> Sasha, what do you think about this?

The point is that we block MOST spams, not EVERY spam that can be invented. 
Yes, if the spammer happens to say "database", his message will make it 
through. So what? This is just one message. If the current filter system 
proves inadequate we will consider adjusting it. But for now, requiring the 
sender to use one of the "good" words is sufficient to maintain a good signal 
to noise ratio in my opinion.

-- 
MySQL Development Team
For technical support contracts, visit https://order.mysql.com/
   __  ___ ___   __ 
  /  |/  /_ __/ __/ __ \/ /   Sasha Pachev <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Provo, Utah, USA
   <___/  

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: urgent respnse

2002-01-29 Thread Kim Kohen

G'day Michael, (I can't believe I'm _really_ replying to you:-)

> I don't agree that we should make the list subscribers only, as this
> would be a big drawback for newcomers to MySQL.

I'm a classic newcomer to mysql and have only been on the list for a week or
so. It surprised me how much spam I received in that week via the list.  I
participate in 16 other lists and not one of them allows posting by
non-subscribers.

Respectfully, I don't see having to be a subscriber as being a drawback to
newcomers - although I concede the amount of traffic and the technical level
of the posts can be somewhat daunting for a newbie. If someone wants to
learn via a list they will, as I did, find the list addresses and subscribe.

cheers

kim

PS. maybe there's room for a newbie level list for all us OSX users who are
now discovering mysql and php:-)


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Urgent Business Assistance.

2002-01-29 Thread Todd Williamsen

If its so urgent and private then why are you spamming a mail list?  I
smell scam, or is that Spam?

-Original Message-
From: Engr. Martin Douglas. [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 30, 2002 2:28 AM
To: [EMAIL PROTECTED]
Subject: Urgent Business Assistance.


Urgent Business Asistance.

Engr Martin Douglas.
No. 16 Kingsway road,
Ikoyi lagos
Nigeria.

Tel/Fax:: 234-1-7742913
  

30th,January 2002. 



Dear sir,
REQUEST FOR URGENT BUSINESS RELATIONSHIP.

First, I must solicit your confidence in this transaction. This is by
virtue of 
its nature as being 
utterly confidential and top 
secret. You have been recommended by an associate who assured me in 
confidence of 
your ability and reliability to prosecute 
a transaction of great magnitude involving a pending business
transaction 
requiring 
maximum confidence.

We are top officials of the Federal Government Contract Review Panel 
who are interested 
in importation of goods into our 
country with funds which are presently trapped in Nigeria. In order to 
commence this 
business we solicit your assistance to 
enable us RECIEVE the said trapped funds ABROAD.

The source of this fund is as follows : During the  regime of our late
head 
of state, Gen. 
Sani Abacha, the government 
officials set up companies and awarded themselves contracts which were 
grossly over-
invoiced in various Ministries. The 
NEW CIVILIAN  Government set up a Contract Review Panel (C.R.P) and 
we have 
identified a lot of inflated contract funds 
which are presently floating in the Central Bank of Nigeria (C.B.N). 
However, due to our 
position as civil servants and 
members of this panel, we cannot acquire this money in our names. I have

therefore, been 
delegated as a matter of trust by 
my colleagues of the panel to look for an Overseas partner INTO whose 
ACCOUNT the 
sum of US$31,000,000.00 (Thirty one 
Million United States Dollars) WILL BE PAID BY TELEGRAPHIC 
TRANSFER. Hence we 
are writing you this letter.

We have agreed to share the money thus:
1.  70% for us (the officials)
2.  20% for the FOREIGN PARTNER (you)
3.  10% to be used in settling taxation and all local and foreign 
expenses.

It is from this 70% that we wish to commence the importation business. 
Please note that this 
transaction is 100% safe and 
we hope THAT THE FUNDS CAN ARRIVE YOUR ACCOUNT in latest 
ten (10) banking 
days from the date of reciept of the 
following information  by TEL/FAX: 234-1-7742913: A SUITABLE NAME 
AND BANK 
ACCOUNT INTO WHICH THE FUNDS 
CAN BE PAID.

The above information will enable us write letters of claim and job 
description respectively. 
This way we will use your  
company's name to apply for payments and re-award the contract in your 
company name.

We are looking forward to doing business with you and solicit your 
confidentiality in this 
transaction.

Please acknowledge receipt of this letter using either Tel/Fax number  
234 1 7742913, I will 
bring you into the complete picture of this pending project when I have 
heard from you.

Yours Faithfully,
Engr. Martin Douglas.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




  1   2   >