Delete Joomla sample data using SQL

Please take a backup of the database if you have any reusable data in tables.

This is the screen shot after a fresh installation of Joomla.




After executing the following query , the page will look like this.


Remeber if you had entered any additional data other than default , then it may deleted.

Run the following SQL queries.

TRUNCATE TABLE `jos_banner`;
TRUNCATE TABLE `jos_bannerclient`;
TRUNCATE TABLE `jos_bannertrack`;
TRUNCATE TABLE `jos_categories`;
TRUNCATE TABLE `jos_content`;
TRUNCATE TABLE `jos_content_frontpage`;
TRUNCATE TABLE `jos_newsfeeds`;
TRUNCATE TABLE `jos_polls`;
TRUNCATE TABLE `jos_poll_data`;
TRUNCATE TABLE `jos_poll_date`;
TRUNCATE TABLE `jos_sections`;
TRUNCATE TABLE `jos_weblinks`;
TRUNCATE TABLE `jos_contact_details`;
TRUNCATE TABLE `jos_menu`;
INSERT INTO `jos_menu` VALUES (1, 'mainmenu', 'Home', 'home', 'index.php?option=com_content&view=frontpage', 'component', 1, 0, 20, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'num_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=front\nshow_pagination=2\nshow_pagination_results=1\nshow_feed_link=1\nshow_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 1);
TRUNCATE TABLE `jos_modules`;

INSERT INTO `jos_modules` VALUES (1, 'Main Menu', '', 1, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 1, 'menutype=mainmenu\nmoduleclass_sfx=_menu\n', 1, 0, '');
INSERT INTO `jos_modules` VALUES (2, 'Login', '', 1, 'login', 0, '0000-00-00 00:00:00', 1, 'mod_login', 0, 0, 1, '', 1, 1, '');
INSERT INTO `jos_modules` VALUES (3, 'Popular','',3,'cpanel',0,'0000-00-00 00:00:00',1,'mod_popular',0,2,1,'',0, 1, '');
INSERT INTO `jos_modules` VALUES (4, 'Recent added Articles','',4,'cpanel',0,'0000-00-00 00:00:00',1,'mod_latest',0,2,1,'ordering=c_dsc\nuser_id=0\ncache=0\n\n',0, 1, '');
INSERT INTO `jos_modules` VALUES (5, 'Menu Stats','',5,'cpanel',0,'0000-00-00 00:00:00',1,'mod_stats',0,2,1,'',0, 1, '');
INSERT INTO `jos_modules` VALUES (6, 'Unread Messages','',1,'header',0,'0000-00-00 00:00:00',1,'mod_unread',0,2,1,'',1, 1, '');
INSERT INTO `jos_modules` VALUES (7, 'Online Users','',2,'header',0,'0000-00-00 00:00:00',1,'mod_online',0,2,1,'',1, 1, '');
INSERT INTO `jos_modules` VALUES (8, 'Toolbar','',1,'toolbar',0,'0000-00-00 00:00:00',1,'mod_toolbar',0,2,1,'',1, 1, '');
INSERT INTO `jos_modules` VALUES (9, 'Quick Icons','',1,'icon',0,'0000-00-00 00:00:00',1,'mod_quickicon',0,2,1,'',1,1, '');
INSERT INTO `jos_modules` VALUES (10, 'Logged in Users','',2,'cpanel',0,'0000-00-00 00:00:00',1,'mod_logged',0,2,1,'',0,1, '');
INSERT INTO `jos_modules` VALUES (11, 'Footer', '', 0, 'footer', 0, '0000-00-00 00:00:00', 1, 'mod_footer', 0, 0, 1, '', 1, 1, '');
INSERT INTO `jos_modules` VALUES (12, 'Admin Menu','', 1,'menu', 0,'0000-00-00 00:00:00', 1,'mod_menu', 0, 2, 1, '', 0, 1, '');
INSERT INTO `jos_modules` VALUES (13, 'Admin SubMenu','', 1,'submenu', 0,'0000-00-00 00:00:00', 1,'mod_submenu', 0, 2, 1, '', 0, 1, '');
INSERT INTO `jos_modules` VALUES (14, 'User Status','', 1,'status', 0,'0000-00-00 00:00:00', 1,'mod_status', 0, 2, 1, '', 0, 1, '');
INSERT INTO `jos_modules` VALUES (15, 'Title','', 1,'title', 0,'0000-00-00 00:00:00', 1,'mod_title', 0, 2, 1, '', 0, 1, '');

TRUNCATE TABLE `jos_modules_menu`;
INSERT INTO `jos_modules_menu` VALUES (1,0);
TRUNCATE TABLE `jos_menu_types`;
INSERT INTO `jos_menu_types` VALUES (1, 'mainmenu', 'Main Menu', 'The main menu for the site');
TRUNCATE TABLE `jos_templates_menu`;

# Dumping data for table `jos_templates_menu`
INSERT INTO `jos_templates_menu` VALUES ('rhuk_milkyway', '0', '0');
INSERT INTO `jos_templates_menu` VALUES ('khepri', '0', '1');

drupal view system implementation

http://drupal.org/project/module_template_system

http://gftp.seul.org/

gFTP is a free multithreaded file transfer client for *NIX based machines. It has the following features:

* Distributed under the terms of the GNU Public License Agreement
* Written in C and has a text interface and a GTK+ 1.2/2.x interface
* Supports the FTP, FTPS (control connection only), HTTP, HTTPS, SSH and FSP protocols
* FTP and HTTP proxy server support
* Supports FXP file transfers (transferring files between 2 remote servers via FTP)
* Supports UNIX, EPLF, Novell, MacOS, VMS, MVS and NT (DOS) style directory listings
* Bookmarks menu to allow you to quickly connect to remote sites
* Fully Internationalized. The following translations of gFTP that are available: Albanian (sq), Amharic (am), Arabic (ar), Azerbaijan (az), Bangla (bn), Belarusian (be), Bulgarian (bg), Catalan (ca), Chinese (zh_CN,zh_HK,zh_TW), Croatian (hr), Czech (cs), Danish (da), Dutch (nl), Dzongkha (dz), English (en_CA, en_GB, en_US), Finnish (fi), French (fr), Galician (gl), German (de), Greek (el), Gujarati (gu), Hebrew (he), Hungarian (hu), Irish (ga), Italian (it), Kinyarwanda (rw), Korean (ko), Japanese (ja), Latvian (lv), Lithuanian (lt), Macedonian (mk), Malayalam (ml), Malay (ms), Nepali (ne), Norwegian (no), Norwegian bokmål (nb), Occitan (oc), Polish (pl), Portuguese (pt,pt_BR), Punjabi (pa), Romanian (ro), Russian (ru), Serbian (sr,sr@Latn), Slovak (sk), Spanish (es), Swedish (sv), Tamil (ta), Thai (th), Turkish (tr) and Ukrainian (uk) translations available.

High Availability MySQL: Drizzle beta is here!

High Availability MySQL: Drizzle beta is here!: "- Sent using Google Toolbar"

using compression in linux with command

Using command line is faster than GUI.


compresses file

gzip -c file1 > foo.gz


Gunzip and import to mysql using gzip

gunzip < outputfile.sql.gz | mysql < mysql options>

Send mail with joomla jmail class using gmail smtp account

jimport('joomla.mail.mail');

$mail = new JMail();

$mail->setsender("useremail");

$mail->addRecipient("destination@email.com");

$mail->setSubject("Here goes the subject");

$mail->setbody("The body of mail");

$mail->addAttachment('c:\\1.pdf');

$mail->useSMTP(true, "smtp.gmail.com", "useremail", "password",'ssl',465);

$mail->send();

Performance comparison test between MySQL and PostgreSql

Step 1)

I have created a table in mysql with following query.

CREATE TABLE `latlong` (

`id` int(10) NOT NULL auto_increment,

`lat` decimal(12,9) NOT NULL,

`lng` decimal(12,9) NOT NULL,

`place_name` varchar(253) NOT NULL,

PRIMARY KEY (`id`),

KEY `lat` (`lat`),

KEY `lng` (`lng`),

KEY `id` (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=800001 DEFAULT CHARSET=latin1;

I made the similar structure in PostgreSQL too.

CREATE TABLE latlong

(

id integer NOT NULL,

lat numeric(12,9) NOT NULL,

lng numeric(12,9) NOT NULL,

place_name character varying NOT NULL,

CONSTRAINT latlong_pkey PRIMARY KEY (id)

)

WITH (

OIDS=FALSE

);

ALTER TABLE latlong OWNER TO postgres;

-- Index: lat

-- DROP INDEX lat;

CREATE INDEX lat

ON latlong

USING btree

(lat);

-- Index: lng

-- DROP INDEX lng;

CREATE INDEX lng

ON latlong

USING btree

(lng);

Step 2 ) I entered 70 lakhs of random data to the table using a stored procedure.

In that i kept 1 lakh of duplicate data for testing purpose.

After that, i exported the mysql data to csv and imported to Postgresql.

Now both the table has same data and structure.

Then i ran the query on both and the time differences were amazing.

select count(*) from

(select max(id),count(id) from latlong group by lat,lng

having count(id) >1

) as tmp;

The result was 99998 in both tables.

Time taken for the outputs are,

Mysql > 29.297 seconds

PostgreSQL > 7.922 seconds

In the above test, PostgreSQL showed better performance than MySql.