Setup trackback - Database

14 August 2009

Open phpMyAdmin or another database configuration application for your online database, and enter the following SQL query:

CREATE TABLE IF NOT EXISTS `trackbacks` (
`id` int(11) NOT NULL auto_increment,
`url` varchar(255) NOT NULL,
`title` varchar(50) NOT NULL,
`trackback_url` varchar(255) NOT NULL,
`blog_name` varchar(50) NOT NULL,
`excerpt` varchar(255) NOT NULL,
`blog_id` int(11) NOT NULL,
`date` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE="MyISAM" DEFAULT CHARSET="latin1";


This SQL query code will create the table “trackbacks” along with all the fields needed for our new functionality.

If you don't have any MySQL databases you will need to setup another method for holding the trackbacks. Maybe use random access files on your web server – just be sure to set the permissions correctly so that anyone can write to the file.

http://www.peternichol.com/entry/trackback/132/

Please leave a comment using the form provided.