Month: May 2008

  • MySQL database of geographical countries

    CREATE TABLE `geo_country` ( `CountryId` int(10) unsigned NOT NULL default ‘0’, `Country` varchar(100) NOT NULL default ”, `FIPS104` char(2) NOT NULL default ”, `ISO2` char(2) NOT NULL default ”, `ISO3` char(3) NOT NULL default ”, `ISON` int(10) unsigned NOT NULL default ‘0’, `Internet` char(2) NOT NULL default ”, `Capital` varchar(100) NOT NULL default ”, `MapReference`…

  • MySQL database for geographical regions

    CREATE TABLE `geo_region` ( `RegionId` int(10) unsigned NOT NULL default ‘0’, `CountryId` int(10) unsigned NOT NULL default ‘0’, `Region` varchar(100) NOT NULL default ”, `Code` char(2) NOT NULL default ”, `ADM1Code` varchar(4) NOT NULL default ”, PRIMARY KEY (`RegionId`), KEY `CountryId` (`CountryId`), KEY `Region` (`Region`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT=’Regions from GeoBytes’; — — Dumping…

  • Geographical city MySQL database

    CREATE TABLE `geo_city` ( `CityId` int(10) unsigned NOT NULL default ‘0’, `CountryId` int(10) unsigned NOT NULL default ‘0’, `RegionId` int(10) unsigned NOT NULL default ‘0’, `City` varchar(100) NOT NULL default ”, `Latitude` float NOT NULL default ‘0’, `Longitude` float NOT NULL default ‘0’, `TimeZone` varchar(6) NOT NULL default ”, `DmaId` int(10) unsigned NOT NULL default…

  • MySQL replication problem with 5.0.46-48

    For CentOS 4.x, if you want MySQL 5.0.x then you would probably use CentOS Plus. And the current MySQL distribution goes with it is often 5.0.46 or 5.0.48, they both have a problem when acting as a slave replication. At every reboot, the replication breaks because the relay log and some other important files is…

  • Updating fields in Microsoft Word

    To update a cross-reference field, click it and press F9. If you want to update all of the fields in your document, press Ctrl+A to select the entire document before pressing F9.