I M Looking For Scripts/softwares To Convert Ordinary Database Into Wordpress Database. If You Have Any Knowledge Abt Such Software Plz Do Share ! Regards
Hi. You mean, from any other blog database to Wordpress? Please explain something about your previous Database.
what do you understand by ordinary database? It's not like you can convert apples into oranges. It has to be a blog right?
i've got a database of jokes and i want to use it on my wordpress cms site . i cannot cut and copy each jokes as it will take me the whole dayto do it. here is the sample of database .. will be very grateful to u guys if u can help me out. INSERT INTO `JOKES_BIG` VALUES (5332, 'Animal Jokes', 'Got Any Grapes?', 'A ducks walks into a bar and asks, "Got any grapes?" The bartender, confused, tells the ducks that no, his bar doesn''t serve grapes. The duck thanks him and leaves. The next day, the duck returns and says, "Got any grapes?" Again, the bartender tells him that, no, the bar does not serve grapes, has never served grapes, and, furthermore, will never serve grapes. The duck, a little ruffled, thanks him and leaves. The next day, the duck returns, but before he can say anything, the bartender begins to yell: ''''Listen, duck! This is a bar! We do not serve grapes! If you ever ask for grapes again, I will nail your stupid duck beak to the bar!'''' The duck is silent for a moment, and then asks, ''''Got any nails?'''' Confused, the bartenders says no. ''''Good!'''' says the duck. ''''Got any grapes?''''', 0, 0, 0, 'Active'); INSERT INTO `JOKES_BIG` VALUES (5333, 'Animal Jokes', 'Grape and Elephant', 'Q: What sound does a grape make when an elephant steps on it?A: None. It just lets out a little wine.', 0, 0, 0, 'Active');
-- phpMyAdmin SQL Dump -- version 2.10.0.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Aug 22, 2007 at 02:20 AM -- Server version: 4.1.22 -- PHP Version: 4.4.4 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `jokersha_db` -- -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` int(11) NOT NULL auto_increment, `category` varchar(30) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=78 ; -- -- Dumping data for table `categories` -- INSERT INTO `categories` VALUES (1, 'Animal Jokes'); INSERT INTO `categories` VALUES (2, 'Animal World'); INSERT INTO `categories` VALUES (3, 'April Fools Jokes'); INSERT INTO `categories` VALUES (4, 'At Work'); INSERT INTO `categories` VALUES (5, 'Aviation Jokes'); INSERT INTO `categories` VALUES (6, 'Bar Jokes'); INSERT INTO `categories` VALUES (7, 'Blonde Jokes'); INSERT INTO `categories` VALUES (8, 'Blonds'); INSERT INTO `categories` VALUES (9, 'Business Jokes'); INSERT INTO `categories` VALUES (10, 'Camping Jokes'); INSERT INTO `categories` VALUES (11, 'Celebrities'); INSERT INTO `categories` VALUES (12, 'Children'); INSERT INTO `categories` VALUES (13, 'Christmas Jokes'); INSERT INTO `categories` VALUES (14, 'Clean Jokes'); INSERT INTO `categories` VALUES (15, 'Comedian Jokes'); INSERT INTO `categories` VALUES (16, 'Common Jokes'); INSERT INTO `categories` VALUES (17, 'Computer Jokes'); INSERT INTO `categories` VALUES (18, 'Computers'); INSERT INTO `categories` VALUES (19, 'Computing Jokes'); INSERT INTO `categories` VALUES (20, 'Dirty Jokes'); INSERT INTO `categories` VALUES (21, 'Doctor Jokes'); INSERT INTO `categories` VALUES (22, 'Drunks'); INSERT INTO `categories` VALUES (23, 'Dumb Jokes'); INSERT INTO `categories` VALUES (24, 'Elderly'); INSERT INTO `categories` VALUES (25, 'Elderly Jokes'); INSERT INTO `categories` VALUES (26, 'Ethnic'); INSERT INTO `categories` VALUES (27, 'Ethnical Jokes'); INSERT INTO `categories` VALUES (28, 'Farming Jokes'); INSERT INTO `categories` VALUES (29, 'Festival Jokes'); INSERT INTO `categories` VALUES (30, 'Food Jokes'); INSERT INTO `categories` VALUES (31, 'Foreigners'); INSERT INTO `categories` VALUES (32, 'Free Jokes'); INSERT INTO `categories` VALUES (33, 'Funny Jokes'); INSERT INTO `categories` VALUES (34, 'Gender Jokes'); INSERT INTO `categories` VALUES (35, 'Golf Jokes'); INSERT INTO `categories` VALUES (36, 'Instrument Jokes'); INSERT INTO `categories` VALUES (37, 'Irish Jokes'); INSERT INTO `categories` VALUES (38, 'Job/Office Jokes'); INSERT INTO `categories` VALUES (39, 'Kids Jokes'); INSERT INTO `categories` VALUES (40, 'Language Jokes'); INSERT INTO `categories` VALUES (41, 'Lawyer Jokes'); INSERT INTO `categories` VALUES (42, 'Legal'); INSERT INTO `categories` VALUES (43, 'Marriage Jokes'); INSERT INTO `categories` VALUES (44, 'Medicine'); INSERT INTO `categories` VALUES (45, 'Men'); INSERT INTO `categories` VALUES (46, 'Men Jokes'); INSERT INTO `categories` VALUES (47, 'Military Jokes'); INSERT INTO `categories` VALUES (48, 'Miscellaneous'); INSERT INTO `categories` VALUES (49, 'Mixed Jokes'); INSERT INTO `categories` VALUES (50, 'Mom/Dad Jokes'); INSERT INTO `categories` VALUES (51, 'Other Jokes'); INSERT INTO `categories` VALUES (52, 'Ouch'); INSERT INTO `categories` VALUES (53, 'Police Jokes'); INSERT INTO `categories` VALUES (54, 'Political Jokes'); INSERT INTO `categories` VALUES (55, 'Politics'); INSERT INTO `categories` VALUES (56, 'Practical Jokes'); INSERT INTO `categories` VALUES (57, 'Real Jokes'); INSERT INTO `categories` VALUES (58, 'Red Indian Jokes'); INSERT INTO `categories` VALUES (59, 'Redneck Jokes'); INSERT INTO `categories` VALUES (60, 'Relationships'); INSERT INTO `categories` VALUES (61, 'Religion'); INSERT INTO `categories` VALUES (62, 'School'); INSERT INTO `categories` VALUES (63, 'Science'); INSERT INTO `categories` VALUES (76, 'More Jokes'); INSERT INTO `categories` VALUES (66, 'Situations'); INSERT INTO `categories` VALUES (67, 'Sport Jokes'); INSERT INTO `categories` VALUES (68, 'Sports'); INSERT INTO `categories` VALUES (69, 'Stats/Math Jokes'); INSERT INTO `categories` VALUES (70, 'Travel'); INSERT INTO `categories` VALUES (71, 'Travel Jokes'); INSERT INTO `categories` VALUES (72, 'War'); INSERT INTO `categories` VALUES (73, 'Women'); INSERT INTO `categories` VALUES (74, 'Women Jokes'); INSERT INTO `categories` VALUES (75, 'Yo Mama Jokes'); -- -------------------------------------------------------- -- -- Table structure for table `comments` -- CREATE TABLE `comments` ( `id` bigint(20) NOT NULL auto_increment, `jokeid` varchar(15) NOT NULL default '', `poster` varchar(20) NOT NULL default '', `site` varchar(255) NOT NULL default '', `email` varchar(60) NOT NULL default '', `comment` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; -- -- Dumping data for table `comments` -- INSERT INTO `comments` VALUES (4, '5457', 'Free jokes', 'http://www.jokershaven.com', 'edpudol1973@gmail.com', 'This is cool lol'); -- -------------------------------------------------------- -- -- Table structure for table `JOKES_BIG` -- CREATE TABLE `JOKES_BIG` ( `id` bigint(11) NOT NULL auto_increment, `JokeCategory` varchar(255) default NULL, `JokeName` varchar(255) default NULL, `Joke` text, `hits` int(11) NOT NULL default '0', `rating` double NOT NULL default '0', `comments` int(11) NOT NULL default '0', `stat` varchar(10) NOT NULL default 'Active', PRIMARY KEY (`id`), FULLTEXT KEY `JokeCategory` (`JokeCategory`,`JokeName`,`Joke`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ; -- -- Dumping data for table `JOKES_BIG` -- INSERT INTO `JOKES_BIG` VALUES (1, 'Animal Jokes', 'Vampire Bat', 'A vampire bat came flapping in from the night covered in fresh blood and parked himself on the roof of the cave to get some sleep. Pretty soon all the other bats smelled the blood and began hassling him about where he got it. He told them to go away and let him get some sleep but they persisted until finally he gave in."OK, follow me" he said and flew out of the cave with hundreds of bats behind him. Down through the valley they went, across a river and into a forest full of trees. Finally he slowed down and all the other bats excitedly milled around him. "Now, do you see that tree over there?" he asked. "Yes, Yes, Yes!" the bats all screamed in a frenzy. "Good" said the bat, "Because I sure as hell didn''t!"', 0, 0, 0, 'Active'); INSERT INTO `JOKES_BIG` VALUES (2, 'Animal Jokes', 'Dog named Sex', 'Everybody I know who has a dog usually calls him "Rover" or "Spot". I call mine Sex. Now, Sex has been very embarrassing to me. When I went to the City Hall to renew the dog''s license, I told the clerk that I would like a license for Sex. He said, "I would like to have one too!" Then I said, "But she is a dog!" He said he didn''t care what she looked like. I said, "You don''t understand. ... I have had Sex since I was nine years old." He replied, "You must have been quite a strong boy." When I decided to get married, I told the minister that I would like to have Sex at the wedding.He told me to wait until after the wedding was over. I said, "But Sex has played a big part in my life and my whole world revolves around Sex." He said he didn''t want to hear about my personal life and would not marry us in his church. I told him everyone would enjoy having Sex at the wedding. The next day we were married at the Justice of the Peace. My family was barred from the church from then on. When my wife and I went on our honeymoon, I took the dog with me. When we checked into the motel, I told the clerk that I wanted a room for me and my wife and a special room for Sex. He said that every room in the motel is a place for sex. I said, "You don''t understand. ... Sex keeps me awake at night." The clerk said, "Me too!" One day I entered Sex in a contest. But before the competition began, the dog ran away. Another contestant asked me why I was just looking around. I told him that I was going to have Sex in the contest. He said that I should have sold my own tickets. "You don''t understand," I said, "I hoped to have Sex on TV." He called me a show off. When my wife and I separated, we went to court to fight for custody of the dog. I said, "Your Honor, I had Sex before I was married but Sex left me after I was married." The Judge said, "Me too!" Last night Sex ran off again. I spent hours looking all over for her. A cop came over and asked me what I was doing in the alley at 4 o''clock in the morning. I said, "I''m looking for Sex." -- My case comes up next Thursday. Well now I''ve been thrown in jail, been divorced and had more damn troubles with that dog than I ever foresaw.Why just the other day when I went for my first session with the psychiatrist, she asked me, "What seems to be the trouble?" I replied, "Sex has been my best friend all my life but now it has left me for ever. I couldn''t live any longer so lonely." and the doctor said, "Look mister, you should understand that sex isn''t a man''s best friend so get yourself a dog."', 0, 0, 0, 'Active'); INSERT INTO `JOKES_BIG` VALUES (3, 'Animal Jokes', 'Ant and Elephant have romance', 'An ant and an elephant share a night of romance. The next morning the ant wakes up and the elephant is dead. "Shit!" says the ant. "One night of passion and I will spend the rest of my life digging a grave!"', 0, 0, 0, 'Active'); INSERT INTO `JOKES_BIG` VALUES (4, 'Animal Jokes', 'Difference between a cat and a dog...', 'A dog thinks: Hey, these people I live with feed me, love me, provide me with a nice warm, dry house, pet me, and take good care of me... They must be Gods! A cat thinks: Hey, these people I live with feed me, love me, provide me with a nice warm, dry house, pet me, and take good care of me... I must be a God!', 0, 0, 0, 'Active'); INSERT INTO `JOKES_BIG` VALUES (5, 'Animal Jokes', 'rabbits chased by wolf', 'Two rabbits were being chased by a pack of wolves. The wolves chased the rabbits into a thicket. After a few minutes, one rabbit turned to the other and said, "Well, do you want to make a run for it or stay here a few days and outnumber them?"', 0, 0, 0, 'Active'); INSERT INTO `JOKES_BIG` VALUES (6, 'Animal Jokes', 'horse', 'This horse walks in to a bar and asks for a bit to eat!', 0, 0, 0, 'Active'); INSERT INTO `JOKES_BIG` VALUES (7, 'Animal Jokes', 'bear and a rabbit', 'A bear is chasing a rabbit through a forest. They find a bottle and decide to rub it. A genie pops out. He says "I will grant each of you three wishes."The bear says "I wish all the bears in the forest were females." *poof* It''s done.The rabbit says "I wish for a motorcycle." *poof* It''s done.The bear says "I wish all the bears in this country were females." *poof* It''s done.The rabbit says "I wish for a lifetime supply of carrots back at my house." *poof* It''s done.The bear is thinking to himself "why is the rabbit wasting his wishes on stupid small things? oh well." "And for my third wish, I wish that all the bears in the world were female." *poof* It''s done.The rabbit says "For MY last wish, I want the bear to be gay." And he rides off on his motorcycle.', 0, 0, 0, 'Active'); INSERT INTO `JOKES_BIG` VALUES (8, 'Animal Jokes', 'Do Elephants Ever Forget?', 'Q: Does an elephant ever forget?A: Only if you loan him money.', 0, 0, 0, 'Active');
there are no such programs made because your database is not something standard. You will have to pay somebody to do it for you, if you are too lazy.
what if i want to do it myself.... how / where do i start ... any tips .. tricks .. there is a script to do the same but its not working for me... can u plz help me out with this ! http://forums.digitalpoint.com/showthread.php?t=908180&highlight=database
there is no such software to transfer a database to word press however you can make csv file of the existing database make changes to it according to the table of wordpress where you want the data to be exported save it and run import on the specific table
Finally i got a way to convert a database to wordpress database ,,, but time consuming .... Those who wants to convert thier database to wordpress database, i can do it for a little amount...