Ask your WordPress questions! Pay money and get answers fast! (more info)

How to import a wp_posts.sql file WordPress

  • SOLVED

HI Guys

I have just created a site and imported all of the post from the old site. However my client still had his old site live and while I was working on the new one he created two new blog posts.

the old site is no longer up but the IT guy has sent me an .sql file with the latest posts os i can import.

When I try and run an import in MyphpAdmin I get this error

http://screencast.com/t/Eu3qBZ1jUm

I am importing directly into the wp_posts table, is that correct?

Can you explain my error for me please?

Many thanks
Steve

Answers (4)

2013-08-27

Eric P. answers:

Since this is only two posts, I think you're trying to do a lot of extra work to "import" the data.

Find the text of the two new posts in the exported SQL. Go in and just create two new posts on your new site and paste the content into the new posts. Don't sweat the SQL. You can manually set the meta data correctly.

Now, if this were 200 posts, then I'd work on some way to merge the two. For 2 post, you'll do less total work if you just create two new posts and paste in the content.


Steve Watson comments:

is that just a matter of opening the .sql file with those two posts in notepad or similar?


Eric P. comments:

Pretty much. Is the file just those two posts? Or is it everything?

The data will be somewhat encoded, but the actual content should be readable.


Steve Watson comments:

Just the 2 posts (I think)

This is the content:

-- phpMyAdmin SQL Dump
-- version 4.0.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 27, 2013 at 02:34 AM
-- Server version: 5.0.95
-- PHP Version: 5.2.17

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `coachbarrow_cb20`
--

-- --------------------------------------------------------

--
-- Table structure for table `wp_posts`
--

CREATE TABLE IF NOT EXISTS `wp_posts` (
`ID` bigint(20) unsigned NOT NULL auto_increment,
`post_author` bigint(20) unsigned NOT NULL default '0',
`post_date` datetime NOT NULL default '0000-00-00 00:00:00',
`post_date_gmt` datetime NOT NULL default '0000-00-00 00:00:00',
`post_content` longtext NOT NULL,
`post_title` text NOT NULL,
`post_excerpt` text NOT NULL,
`post_status` varchar(20) NOT NULL default 'publish',
`comment_status` varchar(20) NOT NULL default 'open',
`ping_status` varchar(20) NOT NULL default 'open',
`post_password` varchar(20) NOT NULL default '',
`post_name` varchar(200) NOT NULL default '',
`to_ping` text NOT NULL,
`pinged` text NOT NULL,
`post_modified` datetime NOT NULL default '0000-00-00 00:00:00',
`post_modified_gmt` datetime NOT NULL default '0000-00-00 00:00:00',
`post_content_filtered` longtext NOT NULL,
`post_parent` bigint(20) unsigned NOT NULL default '0',
`guid` varchar(255) NOT NULL default '',
`menu_order` int(11) NOT NULL default '0',
`post_type` varchar(20) NOT NULL default 'post',
`post_mime_type` varchar(100) NOT NULL default '',
`comment_count` bigint(20) NOT NULL default '0',
PRIMARY KEY (`ID`),
KEY `post_name` (`post_name`),
KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
KEY `post_parent` (`post_parent`),
KEY `post_author` (`post_author`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10912 ;

--
-- Dumping data for table `wp_posts`
--

INSERT INTO `wp_posts` (`ID`, `post_author`, `post_date`, `post_date_gmt`, `post_content`, `post_title`, `post_excerpt`, `post_status`, `comment_status`, `ping_status`, `post_password`, `post_name`, `to_ping`, `pinged`, `post_modified`, `post_modified_gmt`, `post_content_filtered`, `post_parent`, `guid`, `menu_order`, `post_type`, `post_mime_type`, `comment_count`) VALUES
(10909, 3, '2013-08-21 10:41:55', '2013-08-21 10:41:55', '<a href="http://coachbarrow.com/wp-content/uploads/2013/08/gone-fishing.jpg"><img class="alignleft size-full wp-image-10910" alt="gone fishing" src="http://coachbarrow.com/wp-content/uploads/2013/08/gone-fishing.jpg" width="225" height="225" /></a>My first observation today is to report two situations that occurred in the last few days and give you my thoughts:\r\n\r\nA dental receptionist refuses to attend one of our Saturday TCO training courses (at her Employer''s expense) because she has a Saturday "hobby".\r\n\r\nA nurse who we thought wanted to become the practice "social media champion" tells her Principal that she will read a book I have recommended "provided he babysits her child while she reads it"\r\n\r\nIn both cases we are talking about nicely done mixed practices, with decent pay and surroundings, not some Death Star Dental Corporate where minimum wages and systems apply.\r\n\r\nMy thoughts are that both of these young ladies have just delivered what I describe as a verbal "suicide note" on their careers.\r\n\r\nI pause and ask myself whether my increasingly intolerant attitude towards off-brand employees and clinicians is a sign of old age?\r\n\r\nOr a response to harsh economic reality - that the business of dentistry is tougher in 2013 than at any time in the last 20 years - and that folks need to be glad they have a job at all?\r\n\r\nProvided pay and conditions are fair - it doesn''t seem unreasonable to ask team members to demonstrate that "indispensability" that Seth Godin talks about in his book "Linchpin".\r\n<blockquote>“The job is what you do when you are told what to do. The job is showing up at the factory, following instructions, meeting spec, and being managed.\r\n\r\nSomeone can always do your job a little better or faster or cheaper than you can.\r\n\r\nThe job might be difficult, it might require skill, but it''s a job.\r\n\r\nYour art is what you do when no one can tell you exactly how to do it. Your art is the act of taking personal responsibility, challenging the status quo, and changing people.\r\n\r\nI call the process of doing your art ''the work.'' It''s possible to have a job and do the work, too. In fact, that''s how you become a linchpin.\r\n\r\nThe job is not the work.”</blockquote>\r\nOn a more positive note - a shout out for the team(s) at Dental Excellence in Northern Ireland, who welcomed me to their Portadown and Derry practices yesterday for team training sessions.\r\n\r\nWe talked about the "state of the nation" as far as dentistry is concerned.\r\n\r\nThe rise of corporates and retailers.\r\n\r\nThe most popular products.\r\n\r\nThe best patient types.\r\n\r\nMost importantly, the ATTITUDE to be demonstrated by all team members towards patients.\r\n\r\nWe agreed that successful dental business is 98% understanding people and 2% clinical skill.\r\n\r\nThat you have to have 100% of the 2%.\r\n\r\nBut that its the 98% "knowing what makes people tick" that will ensure prosperity in an increasingly competitive market.\r\n\r\nI thank everyone at "DE" for their attitude towards me yesterday. I know they "get it".\r\n\r\nFinally - disconnection.\r\n\r\nAfter the events of the last week, we have decided to take a break from "The Connected World" - for just 7 days.\r\n\r\nNo internet, no devices, no social media.\r\n\r\nNot even an iPhone.\r\n\r\nJust 10 days unplugged from The Matrix.\r\n\r\nSo don''t worry if you don''t hear from us - we are safe and secure - we just want a breather before the Autumn season starts on 1st September.\r\n\r\n&nbsp;', 'Suicide notes, enthusiasm and disconnections', '', 'publish', 'open', 'open', '', 'suicide-notes-enthusiasm-and-disconnections', '', '', '2013-08-21 10:41:55', '2013-08-21 10:41:55', '', 0, 'http://coachbarrow.com/?p=10909', 0, 'post', '', 1),
(10911, 3, '2013-08-21 10:40:32', '2013-08-21 10:40:32', '<a href="http://coachbarrow.com/wp-content/uploads/2013/08/gone-fishing.jpg"><img class="alignleft size-full wp-image-10910" alt="gone fishing" src="http://coachbarrow.com/wp-content/uploads/2013/08/gone-fishing.jpg" width="225" height="225" /></a>My first observation today is to report two situations that occurred in the last few days and give you my thoughts:\r\n\r\nA dental receptionist refuses to attend one of our Saturday TCO training courses (at her Employer''s expense) because she has a Saturday "hobby".\r\n\r\nA nurse who we thought wanted to become the practice "social media champion" tells her Principal that she will read a book I have recommended "provided he babysits her child while she reads it"\r\n\r\nIn both cases we are talking about nicely done mixed practices, with decent pay and surroundings, not some Death Star Dental Corporate where minimum wages and systems apply.\r\n\r\nMy thoughts are that both of these young ladies have just delivered what I describe as a verbal "suicide note" on their careers.\r\n\r\nI pause and ask myself whether my increasingly intolerant attitude towards off-brand employees and clinicians is a sign of old age?\r\n\r\nOr a response to harsh economic reality - that the business of dentistry is tougher in 2013 than at any time in the last 20 years - and that folks need to be glad they have a job at all?\r\n\r\nProvided pay and conditions are fair - it doesn''t seem unreasonable to ask team members to demonstrate that "indispensability" that Seth Godin talks about in his book "Linchpin".\r\n<blockquote>“The job is what you do when you are told what to do. The job is showing up at the factory, following instructions, meeting spec, and being managed.\r\n\r\nSomeone can always do your job a little better or faster or cheaper than you can.\r\n\r\nThe job might be difficult, it might require skill, but it''s a job.\r\n\r\nYour art is what you do when no one can tell you exactly how to do it. Your art is the act of taking personal responsibility, challenging the status quo, and changing people.\r\n\r\nI call the process of doing your art ''the work.'' It''s possible to have a job and do the work, too. In fact, that''s how you become a linchpin.\r\n\r\nThe job is not the work.”</blockquote>\r\nOn a more positive note - a shout out for the team(s) at Dental Excellence in Northern Ireland, who welcomed me to their Portadown and Derry practices yesterday for team training sessions.\r\n\r\nWe talked about the "state of the nation" as far as dentistry is concerned.\r\n\r\nThe rise of corporates and retailers.\r\n\r\nThe most popular products.\r\n\r\nThe best patient types.\r\n\r\nMost importantly, the ATTITUDE to be demonstrated by all team members towards patients.\r\n\r\nWe agreed that successful dental business is 98% understanding people and 2% clinical skill.\r\n\r\nThat you have to have 100% of the 2%.\r\n\r\nBut that its the 98% "knowing what makes people tick" that will ensure prosperity in an increasingly competitive market.\r\n\r\nI thank everyone at "DE" for their attitude towards me yesterday. I know they "get it".\r\n\r\nFinally - disconnection.\r\n\r\nAfter the events of the last week, we have decided to take a break from "The Connected World" - for just 7 days.\r\n\r\nNo internet, no devices, no social media.\r\n\r\nNot even an iPhone.\r\n\r\nJust 10 days unplugged from The Matrix.\r\n\r\nSo don''t worry if you don''t hear from us - we are safe and secure - we just want a breather before the Autumn season starts on 1st September.\r\n\r\n&nbsp;', 'Suicide notes, enthusiasm and disconnections', '', 'inherit', 'open', 'open', '', '10909-revision-v1', '', '', '2013-08-21 10:40:32', '2013-08-21 10:40:32', '', 10909, 'http://coachbarrow.com/10909-revision-v1/', 0, 'revision', '', 0),
(10910, 3, '2013-08-21 10:39:12', '2013-08-21 10:39:12', '', 'gone fishing', '', 'inherit', 'open', 'open', '', 'gone-fishing', '', '', '2013-08-21 10:39:12', '2013-08-21 10:39:12', '', 10909, 'http://coachbarrow.com/wp-content/uploads/2013/08/gone-fishing.jpg', 0, 'attachment', 'image/jpeg', 0),
(10908, 5, '2013-08-20 06:59:43', '0000-00-00 00:00:00', '', 'Auto Draft', '', 'auto-draft', 'open', 'open', '', '', '', '', '2013-08-20 06:59:43', '0000-00-00 00:00:00', '', 0, 'http://coachbarrow.com/?p=10908', 0, 'post', '', 0),
(10906, 2, '2013-08-19 13:06:18', '2013-08-19 13:06:18', 'Welcome back! To download your book just click on the picture here then save the PDF somewhere safe on your computer.<a href="http://coachbarrow.com/members/wp-content/uploads/2013/08/ThePerfectImperfectionistPDF-1.pdf"><img class="aligncenter size-full wp-image-149" alt="perfect_imperfectionist_3d_half" src="http://coachbarrow.com/wp-content/uploads/2012/12/perfect_imperfectionist_3d_half.jpg" width="311" height="370" /></a>\r\n\r\n&nbsp;', 'TY Perfect Imperfectionist', '', 'publish', 'open', 'open', '', 'ty-perfect-imperfectionist', '', '', '2013-08-19 13:06:18', '2013-08-19 13:06:18', '', 0, 'http://coachbarrow.com/?page_id=10906', 0, 'page', '', 0),
(10907, 2, '2013-08-19 13:06:18', '2013-08-19 13:06:18', 'Welcome back! To download your book just click on the picture here then save the PDF somewhere safe on your computer.<a href="http://coachbarrow.com/members/wp-content/uploads/2013/08/ThePerfectImperfectionistPDF-1.pdf"><img class="aligncenter size-full wp-image-149" alt="perfect_imperfectionist_3d_half" src="http://coachbarrow.com/wp-content/uploads/2012/12/perfect_imperfectionist_3d_half.jpg" width="311" height="370" /></a>\r\n\r\n&nbsp;', 'TY Perfect Imperfectionist', '', 'inherit', 'open', 'open', '', '10906-revision-v1', '', '', '2013-08-19 13:06:18', '2013-08-19 13:06:18', '', 10906, 'http://coachbarrow.com/10906-revision-v1/', 0, 'revision', '', 0),
(10905, 2, '2013-08-19 13:00:11', '2013-08-19 13:00:11', '<h2>The Perfect Imperfectionist</h2>\r\n<strong>11 Steps To The Best Version Of Yourself</strong>\r\n\r\nI want to share with you some thoughts and ideas that I published at the end of one year recently for 11 days, as a way to end the old year and begin the new.\r\n\r\nThe concept of this short series of blog posts arose from a conversation I had in Liverpool with Brendon and Marita Macdonald, who suggested a ‘Christmas series’ for the sad people (like myself ) who cannot resist checking the internet daily, even during a holiday season.\r\n\r\nWhat I wanted to avoid, however, was yet another to do list of resolutions.\r\n\r\nI was aware that at this time of year everyone is bombarded with ezines, blog posts, tweets, status updates and vlogs that will ask you to make some sort of resolution...\r\n\r\n<img class="alignright size-full wp-image-149" alt="The Perfect Perfectionist" src="http://184.173.197.210/~swo/coachbarrow.com/wp-content/themes/dynamik/css/images/perfect-imperfectionist-home.jpg" />\r\n<ul>\r\n <li>to become smarter at life: ?</li>\r\n <li>get your cash flow sorted ?</li>\r\n <li>pay off those debts ?</li>\r\n <li>go on a diet ?</li>\r\n <li>stop eating that crap ?</li>\r\n <li>drink less alcohol ?</li>\r\n <li>start some exercise ?</li>\r\n <li>end or begin a relationship(s) ?</li>\r\n <li>listen more ?</li>\r\n <li>speak more ?</li>\r\n <li>upgrade your web site ?</li>\r\n <li>adopt a new brand ?</li>\r\n <li>raise your prices ?</li>\r\n <li>improve your leadership skills ?</li>\r\n <li>build your managers ?</li>\r\n <li>set goals ?</li>\r\n <li>set targets ?</li>\r\n <li>set boundaries ?</li>\r\n <li>remove tolerations ?</li>\r\n <li>tidy up ?</li>\r\n <li>be nicer!</li>\r\n</ul>\r\nTo summarise - stop being the less confident ‘you’ and start being the allsinging, all-dancing, shiny new ‘you’.\r\n\r\nAnd, of course, there is a book, video, 12-step programme, form to fill in, on-line check in - for all of these worthy pursuits. In fact, you could spend all year just getting coached and never go to work.\r\n\r\nAll of this advice is rather like laser tooth whitening: It takes you up a few shades for a while - the shiny new look - and then quickly fades back to something like the original, sometimes with ‘zingers’ along the way.\r\n\r\nI personally have resolved to carry on being “me” in 2011.\r\n\r\nYou see, I’m pretty good already (well, most of the time). That year I did get my trainers back on and committed to the London Marathon and Kilimanjaro (and the New York Marathon if I am spared) but I DID NOT intend to significantly change my lifestyle along the way, because I’m a human being and it’s just not sustainable, especially when you run your own business and/or are raising a family.\r\n\r\nIf that sounds like the kind of Christmas &amp; New Year thinking you like, then do feel free to download my ebook "The Perfect Imperfectionist" right now - my gift to you - and I really hope you enjoy it.\r\n\r\n<script type="text/javascript" src="https://ps146.infusionsoft.com/app/form/iframe/44482e1f9ee7e14eebb7ca77dc6c2ed4"></script>', 'The Perfect Imperfectionist', '', 'inherit', 'open', 'open', '', '150-revision-v1', '', '', '2013-08-19 13:00:11', '2013-08-19 13:00:11', '', 150, 'http://coachbarrow.com/150-revision-v1/', 0, 'revision', '', 0),
(10901, 3, '2013-08-19 13:00:08', '2013-08-19 13:00:08', '<a href="http://coachbarrow.com/wp-content/uploads/2013/08/flybe.jpg"><img class="alignleft size-full wp-image-10903" alt="flybe" src="http://coachbarrow.com/wp-content/uploads/2013/08/flybe.jpg" width="189" height="267" /></a>On Friday Tim Caudrelier and I took a flight to Belfast with Flybe to meet successfully with a prospective business partner for 2014 and beyond (more of that another day).\r\n\r\nAs the flight prepared for departure and the stewardess demonstrated our "safety procedures", a couple of passengers on seats 2A &amp; 2B engaged in a loud and distracting conversation.\r\n\r\nWe wondered (from 2C &amp; 2D) how she was going to handle it.\r\n\r\nThe commentary paused as she calmly stepped forward, reached into the seat pocket in front of passenger 2B, pulled out the airline''s laminated card and politely asked:\r\n\r\n<em>"could you read this and follow the safety instructions please sir?"</em>\r\n\r\nHe was surprised into silence and then sat there reading the card as she continued, with about 30 other people silently smirking behind him as if he had been "caught by teacher".\r\n\r\nThe reaction of the other passengers was perhaps childish, but not the concern of the stewardess.\r\n\r\nWhat Flybe had done was to give her a system with which to deal with a difficult "patient".\r\n\r\nTurning to Tim after the event, I speculated  on whether a dental receptionist, facing unacceptable behaviour, could simply pass over a laminated sheet on standards of behaviour and ask them to read it?\r\n\r\nMuch later that day, our return flight was delayed by three hours (ouch!).\r\n\r\nOur 16:40 became a 19:30 - all part of Friday afternoon in British airports - but anarchy very nearly broke out when the 16:35 flight to the same destination boarded and left on schedule.\r\n\r\nAt that point, the British rules for queueing were broken - and passengers started to lose it.\r\n\r\nWe had to laugh at the communication style of one red-faced lady who attended the Flybe Executive Lounge desk and conducted this piece of masterful negotiation:\r\n\r\nLady: Hello how are you?\r\n\r\nMan on Desk: I''m very well thank you - how are you?\r\n\r\nLady: Well actually I don''t really care how you are at all - because I want to complain about my flight being delayed!\r\n\r\nMan on Desk: I see madam - well I don''t work for Flybe so can I suggest that you take it up with them?\r\n\r\nWhat did she expect?\r\n\r\nGiven recent events - I continue to wonder how anyone thinks that aggression can bring about a negotiated settlement?\r\n\r\nPeople are very strange.', 'Read the instructions', '', 'publish', 'open', 'open', '', 'read-the-instructions', '', '', '2013-08-19 13:00:08', '2013-08-19 13:00:08', '', 0, 'http://coachbarrow.com/?p=10901', 0, 'post', '', 0),
(10904, 3, '2013-08-19 13:00:08', '2013-08-19 13:00:08', '<a href="http://coachbarrow.com/wp-content/uploads/2013/08/flybe.jpg"><img class="alignleft size-full wp-image-10903" alt="flybe" src="http://coachbarrow.com/wp-content/uploads/2013/08/flybe.jpg" width="189" height="267" /></a>On Friday Tim Caudrelier and I took a flight to Belfast with Flybe to meet successfully with a prospective business partner for 2014 and beyond (more of that another day).\r\n\r\nAs the flight prepared for departure and the stewardess demonstrated our "safety procedures", a couple of passengers on seats 2A &amp; 2B engaged in a loud and distracting conversation.\r\n\r\nWe wondered (from 2C &amp; 2D) how she was going to handle it.\r\n\r\nThe commentary paused as she calmly stepped forward, reached into the seat pocket in front of passenger 2B, pulled out the airline''s laminated card and politely asked:\r\n\r\n<em>"could you read this and follow the safety instructions please sir?"</em>\r\n\r\nHe was surprised into silence and then sat there reading the card as she continued, with about 30 other people silently smirking behind him as if he had been "caught by teacher".\r\n\r\nThe reaction of the other passengers was perhaps childish, but not the concern of the stewardess.\r\n\r\nWhat Flybe had done was to give her a system with which to deal with a difficult "patient".\r\n\r\nTurning to Tim after the event, I speculated  on whether a dental receptionist, facing unacceptable behaviour, could simply pass over a laminated sheet on standards of behaviour and ask them to read it?\r\n\r\nMuch later that day, our return flight was delayed by three hours (ouch!).\r\n\r\nOur 16:40 became a 19:30 - all part of Friday afternoon in British airports - but anarchy very nearly broke out when the 16:35 flight to the same destination boarded and left on schedule.\r\n\r\nAt that point, the British rules for queueing were broken - and passengers started to lose it.\r\n\r\nWe had to laugh at the communication style of one red-faced lady who attended the Flybe Executive Lounge desk and conducted this piece of masterful negotiation:\r\n\r\nLady: Hello how are you?\r\n\r\nMan on Desk: I''m very well thank you - how are you?\r\n\r\nLady: Well actually I don''t really care how you are at all - because I want to complain about my flight being delayed!\r\n\r\nMan on Desk: I see madam - well I don''t work for Flybe so can I suggest that you take it up with them?\r\n\r\nWhat did she expect?\r\n\r\nGiven recent events - I continue to wonder how anyone thinks that aggression can bring about a negotiated settlement?\r\n\r\nPeople are very strange.', 'Read the instructions', '', 'inherit', 'open', 'open', '', '10901-revision-v1', '', '', '2013-08-19 13:00:08', '2013-08-19 13:00:08', '', 10901, 'http://coachbarrow.com/10901-revision-v1/', 0, 'revision', '', 0),
(170, 2, '2013-08-19 12:58:52', '2013-08-19 12:58:52', '<h2>The Perfect Imperfectionist</h2>\n<strong>11 Steps To The Best Version Of Yourself</strong>\n\nI want to share with you some thoughts and ideas that I published at the end of one year recently for 11 days, as a way to end the old year and begin the new.\n\nThe concept of this short series of blog posts arose from a conversation I had in Liverpool with Brendon and Marita Macdonald, who suggested a ‘Christmas series’ for the sad people (like myself ) who cannot resist checking the internet daily, even during a holiday season.\n\nWhat I wanted to avoid, however, was yet another to do list of resolutions.\n\nI was aware that at this time of year everyone is bombarded with ezines, blog posts, tweets, status updates and vlogs that will ask you to make some sort of resolution...\n\n<img class="alignright size-full wp-image-149" alt="The Perfect Perfectionist" src="http://184.173.197.210/~swo/coachbarrow.com/wp-content/themes/dynamik/css/images/perfect-imperfectionist-home.jpg" />\n<ul>\n <li>to become smarter at life: ?</li>\n <li>get your cash flow sorted ?</li>\n <li>pay off those debts ?</li>\n <li>go on a diet ?</li>\n <li>stop eating that crap ?</li>\n <li>drink less alcohol ?</li>\n <li>start some exercise ?</li>\n <li>end or begin a relationship(s) ?</li>\n <li>listen more ?</li>\n <li>speak more ?</li>\n <li>upgrade your web site ?</li>\n <li>adopt a new brand ?</li>\n <li>raise your prices ?</li>\n <li>improve your leadership skills ?</li>\n <li>build your managers ?</li>\n <li>set goals ?</li>\n <li>set targets ?</li>\n <li>set boundaries ?</li>\n <li>remove tolerations ?</li>\n <li>tidy up ?</li>\n <li>be nicer!</li>\n</ul>\nTo summarise - stop being the less confident ‘you’ and start being the allsinging, all-dancing, shiny new ‘you’.\n\nAnd, of course, there is a book, video, 12-step programme, form to fill in, on-line check in - for all of these worthy pursuits. In fact, you could spend all year just getting coached and never go to work.\n\nAll of this advice is rather like laser tooth whitening: It takes you up a few shades for a while - the shiny new look - and then quickly fades back to something like the original, sometimes with ‘zingers’ along the way.\n\nI personally have resolved to carry on being “me” in 2011.\n\nYou see, I’m pretty good already (well, most of the time). That year I did get my trainers back on and committed to the London Marathon and Kilimanjaro (and the New York Marathon if I am spared) but I DID NOT intend to significantly change my lifestyle along the way, because I’m a human being and it’s just not sustainable, especially when you run your own business and/or are raising a family.\n\nIf that sounds like the kind of Christmas &amp; New Year thinking you like, then do feel free to download my ebook "The Perfect Imperfectionist" right now - my gift to you - and I really hope you enjoy it.', 'The Perfect Imperfectionist', '', 'inherit', 'open', 'open', '', '150-autosave-v1', '', '', '2013-08-19 12:58:52', '2013-08-19 12:58:52', '', 150, 'http://coachbarrow.com/150-autosave/', 0, 'revision', '', 0),
(10903, 3, '2013-08-19 12:58:49', '2013-08-19 12:58:49', '', 'flybe', '', 'inherit', 'open', 'open', '', 'flybe', '', '', '2013-08-19 12:58:49', '2013-08-19 12:58:49', '', 10901, 'http://coachbarrow.com/wp-content/uploads/2013/08/flybe.jpg', 0, 'attachment', 'image/jpeg', 0);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;


Eric P. comments:

I see several posts there.

One titled "'Suicide notes, enthusiasm and disconnections" and the second titled "'The Perfect Imperfectionist". There are a few others as well, some blank, some very small "Thank you" note pages.

There are a couple things you could do.

You could copy/paste those into your new blog. Just copy the "content" part into the content of new posts, set the dates, authors and whatnot to match what they should be in the new environment. The Content is the stuff after the dates on the lines that start with '(1090.....' and continues until the closing single quote followed by a title, and usually 'inherit'...

You could just change the id#'s to something that isn't in your new blog. That would be the '10909' like numbers right after the opening parentheses. You could try changing every occurance of '1090' to '21090' in that file and then import, that would most likely work.

As others have noted, you don't have the matching "wp_postmeta" table data in that SQL. So any meta data ("custom fields") for those posts is not included. If you just import wp_posts, you should still see the posts, I think. If you create the two large posts and just paste the content and titles in, then the blank/default wp_postmeta data will definitely be created.

2013-08-27

Navjot Singh answers:

You should drop the table wp_posts first and then import. Because the existing posts already are there and you are trying to overwrite them.

Ofcourse make a backup first.


Steve Watson comments:

I dont want to drop the posts that are already there i need to keep them. I just need to add the last two posts from the old blog but only have them in wp_posts.sql format


Navjot Singh comments:

I am assuming that the new sql file contains all the posts plus 2 new posts? Then you can safely delete the wp_posts table first and reimport. Also like Arnav said, you will also need to do the same for wp_postmeta table as well. Delete the old one and reimport from the new one.

2013-08-27

Arnav Joy answers:

This problem is because in new db you have any post whoose id is same as that any if the record in old db.

means as you said the new site has already all the posts from the old site so when you import the db then you got all previous records there and they sre with duplicate key.

so if you have not make any changes in the new installation then take backup of the new wp_posts and wp_postmeta table and then empty theses two tables and then import theses two tables from the old sites.

Let me know if you have understood whst I want to say


Arnav Joy comments:

Please remember wp_postmeta tables are also necessary to create correct entries


Steve Watson comments:

Is it not possible to merge two tables?

I dont really understand what you are saying.

2013-08-27

Hariprasad Vijayan answers:

Hi,

Reason for this error is the record with same id(primary key) already in database.

To solve this issue,
Delete already existing record from the file before importing it( It is possible if the tables having same kind of records and you need to update few more post with existing one)

please ask if you have doubt in this


Hariprasad Vijayan comments:

If you have any difficulties in deleting posts from notepad, import it into a database in localhost, delete unwanted posts and export it. Then you can import the file directly into your server database

Hope this will help you