I am my own boss!!

[Angela liu]

pHi friend...brI wish I had been more prepared this helped me get back on 
my feet miracles really do exist imagine what you could dobra 
href=http://www.emballagedigest.fr/advertising/redirect.php?jalucamp;69neb=google.comamp;69qefy=twitter.comamp;url=7daily-business-news.ru/profile/;http://www.emballagedigest.fr/advertising/redirect.php?jalucamp;69neb=google.comamp;69qefy=twitter.comamp;url=7daily-business-news.ru/profile//abrsee
 you later/p

OFF TOPIC - Looking for Consultant

[Carl]

We are looking for a consultant to set up Master - Master replication between 
two sites (both in US.)  Both sites run MySQL version 5.5 (Innodb) in Slackware 
Linux.  Local traffic at each site is on the low side of moderate and is from a 
Java based web application.  There is a VPN between the sites and the remote 
site is currently running as a slave.

We are looking for a consultant to do this as our staff simply does not have 
the time.

Reply directly to me c...@etrak-plus.com.

Thanks,

Carl

parsing a .sql file

[Fahim Mohammad]

I have the following info in a text file called  file.sql
Is there a way to extract table name and all the fields in this table.

Thanks.

Fahim


-- MySQL dump 10.11
--
-- Host: localhostDatabase: ailMel1
-- --
-- Server version 5.0.67

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `all_est`
--

DROP TABLE IF EXISTS `all_est`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `all_est` (
  `bin` smallint(5) unsigned NOT NULL,
  `matches` int(10) unsigned NOT NULL,
  `misMatches` int(10) unsigned NOT NULL,
  `repMatches` int(10) unsigned NOT NULL,
  `nCount` int(10) unsigned NOT NULL,
  `qNumInsert` int(10) unsigned NOT NULL,
  `qBaseInsert` int(10) unsigned NOT NULL,
  `tNumInsert` int(10) unsigned NOT NULL,
  `tBaseInsert` int(10) unsigned NOT NULL,
  `strand` char(2) NOT NULL,
  `qName` varchar(255) NOT NULL,
  `qSize` int(10) unsigned NOT NULL,
  `qStart` int(10) unsigned NOT NULL,
  `qEnd` int(10) unsigned NOT NULL,
  `tName` varchar(255) NOT NULL,
  `tSize` int(10) unsigned NOT NULL,
  `tStart` int(10) unsigned NOT NULL,
  `tEnd` int(10) unsigned NOT NULL,
  `blockCount` int(10) unsigned NOT NULL,
  `blockSizes` longblob NOT NULL,
  `qStarts` longblob NOT NULL,
  `tStarts` longblob NOT NULL,
  KEY `tName` (`tName`(8),`bin`),
  KEY `qName` (`qName`(12))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2011-04-18  4:14:26

Inserting a new row

[drive view]

Hi,

I'm a novice to MySQL and am currently facing the following difficulty.
I'm trying to update a table with a row of data the primary key of which is
an ID which I believe is an auto incrementing serial number.  My first
question is how to check if this is the case.

Secondly while trying to insert such a row leaving out this column mySql is
inserting the row at ID 0 (the previous ID's in the table are from 1 to 9),
but then will not take further inserts.

Thanks for any help available.


Regards

Toni