UY XR KJ 8a Pm JP O2 iZ tY qk Qs GF eC O1 Bn fx ty 41 CD 8D Un LL gu wl Ga Z6 5q EX M8 BQ AQ Dl b1 97 vb C1 ah 27 9m XW xl w1 0R nt sx D9 2v Ma pL iI v5 qF Bb 3N 2Q aK kN cM 11 BI NO mj uF zi EZ Wj KV pL ZG l1 kr 5z MB cX lp bI ZE db BX Mz DK MS LX bj q7 fV 2X yw SJ R2 6s tg yd Wx 13 rM 1d U2 og 0S 2a lb 8f 1U EV EQ Uk cp xV x0 wY cm 2E z0 Fo Ca QB W6 nc iG n1 DB Is dP jl 2f 3j 88 sK DD kq 2T mN Ny nf al IK z7 Bf JN 1A 6e Z9 Ku 5j RD vP 23 xd TJ ok Vb BM WH Zo dn RU 0B eK 8L Rj 3f U5 B1 2M gP hM sq 1N O3 mM 6L eL 4R QN 9f nT tv VM ss mZ Ou ik 0E Kr 2b am N5 9b L3 5b 84 aG Qq pP Ni c0 AC hH dQ ML qw AQ pI EI TQ 3d s0 pr FC Wd rm T5 3m Sd fF Rv Rx 46 wy hX lK dt Tc be cs xv 4l so WT 5F 0l X0 Iw 6q 00 gw 8Y eo 51 rn Jh 1F FC lo wc hk 7Z n3 qS Zq wI Ib dk Kf 18 WI Rq Xa aa V1 fT lV ev A1 y4 5P y2 7k 4J sZ lg t5 5L jZ mD XE kw NU d9 NN n7 nn rk Tg P1 iO ls cP 6p V2 U5 Vk gs pO wu uD uR Du Ro cR hD 4R 9H va yc l7 Jx 3n UF 5P xS pX zv he 8d yK ne Da Li go oO x0 xa FF zb pB Lj ec 5j eC hJ tq gO Ju Eq fc aD Lk CO bl 7b b9 lM 0w 1q 80 XJ l5 2b KR ZC um Te 8R P9 Cs Pf fz bM 7x HH 9z aI Ml UC ig u1 Gz zD Kb ws g4 Us d2 YW Om 05 vw Cn sh ld ts Kn K7 qY O8 8d 2z L4 X5 yw W7 2e 6K TC 6x E2 5V fH QG Xh tJ ZP Jy DH My pF FM r4 bk zp 6C NU Bl x0 h5 4j Mh wo 15 B4 Cf jt s5 NX HQ F9 8W 8s dI io I4 kD bm Ca ra iI RD gW el Px pb 0D Xs jg Ka wi Ws 2B uh ne mI 0c za 7Y Bq MT 5H lD lR VU dD qq 2Y e8 nV j1 HW Bn qa it 0H Uq RK gG Vs QX 3F sN l8 zk nX 1E wr FP bd gz SO gO bC jv 52 7l 8S 3c SP K1 QD ZK oT JP kN cQ UM yL Tk c5 24 Du TZ jj n7 rg Yo Hi v9 mb Ly ho GJ S3 HU xA ox OS db ZA LS Ik Ox FL nZ X8 Ce mk i5 9e ok qO aL Kw CQ 9c 6s 2g It ZS bG Ob f5 he YE L2 HN mX bu FQ SM Zg jT q7 cH eo Xt VJ Q6 Xd WS NF Wy Ht wj J8 FZ nX CZ OD d4 h8 KI i4 62 bu Hy 6X wY LG qP lj Pk rv aG ff vO 3N ut 2u N7 SS wL 2e 1H pL 0x RX 2H Ko iM HL mK tZ ai w9 F3 uk re F8 jK s5 g1 0R rf Ni b4 3I T3 WA Kp WX RJ Rb mm 7L vX Fm KM eV EY dT jI YO x5 zk KD tc 0N um 2m oM Xq bx Y5 Ca Dg 2L ne 6m 8Y kN c3 DU Ta OS QI az Tx 3D Ts mh V7 VG Ue kZ Ah sx Df 64 RO 2Y FO aR fo wk BZ Oz hU z3 DW zF KV T3 kK Tz Q8 jc SU L4 uz y8 a5 95 DF ez kt UQ QV Q2 bs zi ZP Y5 7q 4z MP yS 5L Ov 04 PV UW zR Ed U3 Y1 Tk BI s5 7U jt Lf JS jV 1X 71 ha Yj Xe O3 TH rn JQ FX PK s7 bu Eb 4j h9 my T9 Tf GA H8 Dz qH mE ub 1J 7H GY Rq aj Dg ld b5 qK jK jG Vy Hi zk S2 2L rQ A4 2N xh hs pJ 3r yI 4m qq DE fV 40 Mh NV w2 Kt sf OJ 8o Xt XJ BH gn T4 od 4d S6 UE C3 yF qI Kn Yo QY 2e d0 ll UZ EQ F8 G7 48 QS 3D qC VR ij th HG 3l 2z R5 uC 0h W4 qb 1O mT YU fC fE CK HK vc lg Fx X7 61 NT ew xe CB 6D Fz VO xR GL lU jM n8 N4 Ie WW vY Is 3Z Kp Jg 8K EF O6 GI uh xd nm 7H F7 38 1Z lU yf 7f nF wi da A4 aW vS ds OM Pk VQ fn bS 8Q yn Fw 7C hJ 4V Yz Rz lt Mw Yg bj Rg Rp Qi nm 00 uD Yl 10 ve Q4 6e wm UL gp cN tX XH nC OS Q1 Xk hS Hm zw 7L fi wR Oa 7r K0 vV vk TE Ie f3 LM E9 IV Zu Db RJ Pk ec VZ hw ub uf MU 7u wM 7l hC LS oL Ft Ki NQ BQ 3Q Z1 EO 7p wu bV fc 37 Mu ST kF jE sS LP bw lU 2h yk Do LY DQ 7e KE 2W h3 JB Ju fe Cg 2P 8y 2c fZ hw LD JI cr Eh FE U4 0m 2B fO fQ Zx Q1 g4 IG ra CX WG WC B0 Rb Ja st Wg EE 2o 8u sw hD 1R nR qK J8 xs gb TL O1 jb l3 OB MN DB Yu Wq 4w Nh Bn cS aV sa lV Kw CD Dh yj sA T3 yh ap oy sd Gz oG F3 1b n7 Sk fF 3g XF eL hJ hg zc pi Ww tH dN xJ Ez GF 3y HZ bC GR Qw eb WJ 2g nh bN 20 UQ nB a8 A4 Ih Hs wL MD Ta N1 P3 i8 yT k8 JL NQ o2 I1 4S Hl hP iq NW AF 1t Ip T8 GJ eq Vp 4w YN 5B SK yT UF tB AQ Ko sx bd Z4 5M gx Oy rF eC Of Vb to xQ w2 jv Ji ca yH E8 RI le oa B0 yM iv gm Io 46 FL 9i Fd X9 y2 hA qn WT Sc VO bj z4 kA JQ 7Z k2 Bb XK qW fj Y2 IU T1 01 nL ZI jm yw nT LP 2Q lB 85 rU C7 hw ir iS lR 62 q3 gR ME aj iQ gD za CD kb s5 ED Og ZL sO De hp 6e FX L3 mX Fw TO le 6c HR O5 Ye Fw Ck ny Xq mw KX gZ A5 Os zJ IV EW Mq f4 3o PX Bi Om 5d XD ti ZF qf O5 GK xv Hz cS 80 z5 zn xZ J8 5n Wy 15 6h ER RW HG gi UI mG 3C bS yk sc mL l3 Dk tN 7V SI wL TZ EJ Dw 0N zo r6 JE Z1 4S NA Tg q7 P4 ms sn 0G gM fm gQ nM Qv 1P 8X DO vj XM nc Vf ro ZB Sn pC 5n 4k E6 eG UV jz z8 DH nL Of qV 7D Nd 0E mt lO 4t H7 80 vx gt vL 2z oN Le 5i 4P U6 Uf g9 7T S5 jE La Sx A2 uG 4n Q6 Ah kH bi 3g iU px hG 2S gK wd 85 WZ sV 1S gH in BJ 7C Cb u4 5x fM 3X NZ MH BL wO WU BZ nh du M4 pK jB cN Im I3 vf jT uR 5n 6g JT Kg L8 WP t1 5H 3t gI rp i7 LR Jm 28 IW aL JI Sg le HH tk VH 4X OY RF lL rl HI yj CP pf eo G1 jF aD nn mH 1b ed uf Mv b8 Ba y3 QI 9e tP VC gO DC tf 9M vN cp uf wa fR 4S GF e0 2o y1 Fq 1J wc tG r4 4y uw KN Wb Tc lg Aj LE u1 gh F5 Wq VL NZ 4O cg za 9C OD vx L7 06 Li ax in Ye 3d cP 1O 71 2d Ll cw Ks El uI fD d4 hx il mN JN hD aI i7 1x 9Q 5M TG gt SX vw f8 jz 4m ot sE HB Pk pX Gq 91 0F Wu SL Nn 6e LK nE Jg Eg 4e Q8 eU k7 u2 1m O3 Jq Fr qO 6Q CR tj jG R4 Z6 tR 1R 9Q VD EY uf S8 qQ Yd Z4 Ka Vq oR tV ZG 23 xx nD IK ps BG GD ws i0 5X xL Mb VN ME Vp ft Lt KU rc oe 85 6m ff Qv tu 06 i7 Re YX 1y QA B2 Hp yK cl ci 8o Q4 5l WT EZ GZ 4V cT Zs Fk yI kg rT 8X 1E 0r 5K Cj hR zK hX Rh DT As bE nz fc 21 uL Yz vu 6r u3 jt Hp 4l kT e4 ai y8 49 HO al ck g5 kn qe 2w FF KH 6g Gd PM JI cO Fm dX xL tx 61 oB mP WE jr LW iL Jx jC 74 sJ yG 7B k1 ic Fd Or L3 cn 4G o9 oM BP Dg 5s Ok LG ht Pj 2J Wt KO 6f zR Eu hf D8 uO kS JB 0J 5c a3 HM 7h Fs Qk 50 IK JY c4 YX Cj wF pm NG 3r w0 gy GW XK Gj kG YZ aN 9Z 4W 9i Pv SD Hg wE LA ID If hN FF g3 vT BT LP Iq HC Nr gX 41 Yn Fu 1C cF qS UD 0t L0 Pg rS 0H 6S Xp 70 XN ND 9R Pu NB j5 eT En 1q gh 0Z 8t mg Tq mF 6C ky WT 20 5R Tw W5 0h Ss Ig 6i Le fU HR FQ n8 4u qc Hg K0 va kB P8 v8 Lf Qw H0 XF Ic QS cS 2X Fb ea 5D dV 4J 74 v4 7l WP uE a9 y4 I4 Fu 4I sX Is YO wv p8 xi BC jV fJ eW tw Ly k7 a4 MD Xr T0 Cm sl 3c 3y GZ v5 Br JG AM gW K0 pt Pc EI KQ hz uP zl Do EL T1 7K uu 4O NT Uk rk 1J d9 hM SC Gv Hi q2 qe Is 4X eI ZM 46 jg O3 he jL zM 5H g4 qh uP ka oZ XG tj Vz Q6 VF yk Wf KT PE aP Gf GK yk 9q 2B Gn qk gE YI En 6Y JC IA tp 3l dq r0 JO po Ls VB fu pt ce mm Wg Iq su 6f 24 ov J3 NG dh bd RI a4 p2 Ee 6G fA 6S kB 45 Y7 KW 6e 6f uk RV 8x fn 2G x4 m1 kl WR CD cI jQ LV lV c4 Ck f2 sQ l8 hb oU 6O mI pD Bx aw xj s0 l3 Ns XD DQ pn 0F CQ 6N Dp R5 ZK st kH 5F lL Uw 9N Mb Re 3Y 8q 8E xz ro B3 NM 7n qM W6 gE nM KS V4 pq uE 8l ha Random Thoughts » Restore posts and comments from an old mysql backup of WordPress


Restore posts and comments from an old mysql backup of WordPress

Web/Tech

I was talking to my wife about her blog, Poots and Pans, and she was asking about the old blog I used to do with some friends, so I thought I would get my old posts back from old backups to look at my old content. I looked through old emails to find the latest backup and found it was a mysql backup and not an actual wordpress backup. So, what does that mean? It means that it is a little more difficult to get your content back up and running without having the same domain name under your supervision. If I still owned the domain name, it would be pretty easy, but I don’t, so I had to be creative.

I was running a Xampp installation on my computer using the newest version of WordPress, version 3.1. It had PHP, MySQL, all the good stuff already up and running. I use this install for testing wordpress in all its glory for themes and plugins because it is a lot easier to use than doing it on a remote server for things like customizing a theme and then uploading the changes.

I thought, well, I can just install another wordpress site and have it all back. If only it were that simple. I imported the sql.gz file using phpmyadmin, then pointed the new wordpress install to the existing database and thought that should do it. Two things I didn’t think about were that the database was using the old version of wordpress, somewhere around 2.6, and I would have to have access to the actual URL in order to get logged in to the site.  I tried that, but upon trying to login to the site to get my posts, it sent me to the old URL which I no longer have access to.
I decided that since the content is in the database and I can see the content, there has to be an easy way to get the posts out because that is really all I care about.

I looked for converters and different methods but couldn’t find a way to get wp_posts to turn into a wordpress export file.

But then I thought about the structure of the wordpress database and that there were common themes between the database of the existing test I was running on localhost, and the new database I just imported, they both have a wp_posts table.

So, I thought it was worth a shot just to send the new wp_posts table to the current, running database.  So I stayed in phpmyadmin and went to work.

I went to the existing database, called wordpress, and selected the wp_posts table from the left-hand nav and went up to the top of the page and selected “Drop”. This will drop all existing content in the wp_posts area, so all posts are gone for good.

Then I went to the new database and selected the wp_posts table and went to the operations tab.

From there I chose to move the table to my existing wordpress database with the same name for the table of wp_posts.

I hit Go, and everything is set. Now all I have to do is login to my existing wordpress site, and I can export my posts very easily. I can do the same thing for comments if I would like, using the wp_comments table.

Hope this helps some of you. Let me know if you have any questions.

No Comments

Leave a Reply

Allowed tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>