GeoDataSource World Cities Database Gold Edition MYSQL CODE TO LOAD DATA

My own reference for future . Need to write the code like below , if not file not found. LOAD DATA LOCALINFILE 'C:\\Program Files (x86)\\EasyPHP-DevServer-14.1VC11\\binaries\\mysql\\bin\\GEODATASOURCE-CITIES-GOLD.TXT' — Create table “world_cities_gold”CREATE TABLE `world_cities_gold`( `region_code` INT, `sub_region_code` VARCHAR(2), `ufi` INT, `uni` INT, `dsg` CHAR(5), `cc_fips` VARCHAR(2), `cc_iso` VARCHAR(2), `full_name` VARCHAR(200), `full_name_nd` VARCHAR(200), `sort_name` VARCHAR(200), `adm1_code` VARCHAR(3), `adm1_full_name` VARCHAR(200),…


Strict Standards: Non-static method JLoader::import() should not be called statically in

I was getting lot's of error messages for my joomla installation, after my php version for my shared hosting company upgraded the php version . Strict Standards: Non-static method JLoader::import() should not be called statically in. To stop the error message, just added the following code in my index.php file for my front end and…


Dumping large database into mysql sql using console

Dumping large database into mysql sql using console Change the directory where your mysql folder is located for easyphp. Mine is as followC:\Program Files\EasyPHP5.3.0\mysql\bin>Type the following command, i am accessing via root.C:\Program Files\EasyPHP5.3.0\mysql\bin>mysql -p -u root;Enter the password:Drop the current database.mysql > drop database [database name] ;mysql > show databases;mysql > create database [database name] ;mysql…


Free Press Release DB, Helps You To Reach Out To Global Audition

Just developed a press release site Submit Press Release @ Free Press Release DB You can submit press release easily, no restriction to the number of press release. Not easy developing the system. Quite hard also. You can browse for the latest press release based on country. Enjoy posting your press release. http://freepressreleasedb.com/country/Latest-France-Press-Release-CC-FR/ http://freepressreleasedb.com/country/Latest-Ireland-Press-Release-CC-IE/ http://freepressreleasedb.com/country/Latest-Malaysia-Press-Release-CC-MY/


How to access EasyPhp MySql Command Line

Whatever you do, always back you file using php admin all the database first before accessing mysql via command line. You don't want to screw up your database if anything happen. I did.Go to Ms Dos command line.Change the directory where your mysql folder is located for easyphp. Mine is as followC:\Program Files\EasyPHP5.3.0\mysql\bin>Type the following…