Re: URGENT: Change Default Location of where Database Files get written?
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?
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?
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?
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
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
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
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
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
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
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
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..
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..
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..
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..
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..
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
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
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
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
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
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
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
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
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
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
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
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
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
"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
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....
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....
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
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...
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...
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 !
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 !
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
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
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
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
- 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
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
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
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
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
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
"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....
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....
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....
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
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
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
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
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
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
> 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
> 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
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...
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...
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...
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!!
> 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!!
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!!
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!!
[.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!!
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!!
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!!
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 ...
"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,
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,
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
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++
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
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++
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!!!
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
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
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
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.
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.
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.
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
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
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
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.
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
