Reformatting WordPress

Comments

1. Zacharias (2 comments.) says:

   2/25/2008 at 7:36 pm

   When I’m backing up, I always crack myself how all the blood, sweat, writer’s block, and carpel-tunnel end up being smaller than my wallpaper.

   Sounds like I should wait until 2.5 to do my start from zero. Thanks for blazing a trail.
2. Small Potato (19 comments.) says:

   2/25/2008 at 7:40 pm

   Same thing happened to me, but it was a blog for WordPress theme demos so I didn’t think much of it. Thanks for bringing this up. I bookmarked Otto42’s response.
3. Chris Moncus (1 comments.) says:

   2/25/2008 at 7:41 pm

   I’ve done the erase and install before and it’s stressing to say the least. What’s even more scary is moving hosting providers. I did that not too long ago and I prayed I wouldn’t lose anything. I ended up not losing anything and it was a perfect migration. Thanks be to WordPress for being built so well.
4. Jeffro2pt0 (164 comments.) says:

   2/25/2008 at 7:47 pm

   Thanks for the comments guys, I appreciate it. @Small Potatoes I know of other theme designers who have run into the same problem as you. They set up demo sites and the tags have turned into numbers. They know it’s an issue with the import/exporter but I guess most theme designers didn’t know of a solution.
   The good news is, this will be a bug fix that comes with 2.5
5. Len says:

   2/25/2008 at 7:52 pm

   Yes I’m feeling the urge to clean house as well but I’ll wait for 2.5 to do it.
6. Mohan (5 comments.) says:

   2/25/2008 at 8:34 pm

   I too had to go through a similar exercise of moving from old platform to a new one of my webhost. I used this Import/Export feature in 2.3.2 and had no trouble in doing it what so ever.. it is a very useful and cool feature! Thanks WP
7. stabani (5 comments.) says:

   2/25/2008 at 8:44 pm

   i did pretty much the same thing. Surprisingly, Database shrank from 20megs to just around 8. quite surprised actually.
8. Balaji Dutt (2 comments.) says:

   2/25/2008 at 9:46 pm

   I had a lot of trouble with importing a WXR file – the biggest problem being it doesn’t import all the posts at one go. I’m not sure if this is because of the php.ini setting. The only workaround I could find was to edit the file and remove already imported posts and save the file under a new name (Blogged about here)

   I hit the same Tags as IDs problem when I recently switched my blog to a new domain. Figured I must have screwed something up in the export and resorted to fixing it using Simple Tags. Now I’m kicking myself and wishing I had waited till you posted this article
9. Monika (40 comments.) says:

   2/26/2008 at 12:38 am

   “a born fool” that’s my new name;)
   I can’t count the numbers of migration I’ve done for customers. Often after midnight, because I know if they can see that all crash before the migration is over their heart stand still

   But to “kill” my “baby” my little webdesign-in /shocking – the whole wide world would stand still and my heart too.

   I lop and top the database of webdesign-in every six months. But I can’t delete it. To click *drop table* my fingers stand still.

   So call me a fool – because I know that WP does an excellent job if someone would do this. But I can’t do it on my own little “baby”.

   with more than one blink in my eyes

   kindly regards
   Monika
10. Arunn (1 comments.) says:

    2/26/2008 at 12:45 am

    I did wp export/import twice, moving my blog across domains. But with the first time experience, I made a How To post, which I followed in my subsequent transfer. It went like a breeze. But the recent transfer resulted in tags becoming numbers.

    Cheers,
    Arunn
11. sai (1 comments.) says:

    2/26/2008 at 2:47 am

    the first time i tried to refresh my installation, i forgot to save wp_content/uploads … and all the attachment image is gone forever ..

    lessons learned: don’t forget to save wp_login.php and any files we changed manually plus that attachment folder before you do anything fool ..

    now i prefer refreshment using database back-up.
12. Monika says:

    2/26/2008 at 3:10 am

    Hi
    the export function doesnot safe the blogroll or link categories.. or does it.. I haven’t found them?

    kindly regards
    Monika
13. mo (1 comments.) says:

    2/26/2008 at 3:40 am

    The smaller size of your database is due to the comment spam not being exported.. also the options of the old plugins you don’t use anymore are not transferred..

    I have transferred my blog a few times – losing some character formatting – having them come up as ? in my wordpress comments, due to mysql database formatting differences between my hostings. I haven’t used wordpress’ export/import feature yet, though it sure does seem tempting
14. Tadd (89 comments.) says:

    2/26/2008 at 4:52 am

    Perhaps I miss the point, but other than migration – why would you do a fresh install? Does it do any good for your site? I always felt WordPress did a good job at organizing data so that there was no … weirdness … going on in the db. The only thing I do to my database these days is run a weekly optimize to keep things running nice and the size of the db down.

    So .. why?
15. Peter Murray (2 comments.) says:

    2/26/2008 at 5:36 am

    I talked about my own experience on my blog. The real show-stopper for me was the renumbering of posts. That caused all sorts of things to break. I eneded up copying the posts table (and a few other tables) from the old databse to the new database. It is detailed at the bottom of my post at the link above.
16. Bürger-Herold (2 comments.) says:

    2/26/2008 at 6:04 am

    Hi all

    Some days ago I moved my WordPress to a new server. There I made a new installtion with 2.3.3 (table names with xy_… as in the old). The wp-export from the old server with 2.3.2 was no problem. But the wp-import to 2.2.3 was more or less a desaster. So I left the wp-Export/import function and tried a very basic way.

    On the new server then I used the table names wp_… So,then I exported via MySQL admin all tables to a *.sql (table names xy_ as from the old server). Second, I imported via MySQL the *.sql to my new server. After it in my new db I had all xy_..- tables beside the unused wp_… tables.

    Of course, the new system did not work. In wp-config I replaced the basic data with the new one, i.e. table name xy_… Also I had to install all missing plugins as I had on the old server
    Result: WordPress works without any losses.
17. Bürger-Herold (2 comments.) says:

    2/26/2008 at 6:09 am

    @17
    I’ve forgotten something: My old server was equipped with MySQL and php 4.x (both) – the the server runs with V 5.x (both).
18. Otto (215 comments.) says:

    2/26/2008 at 6:18 am

    Re-exporting your data from the old blog was not necessary, the tag bug is in the importer. Fixing the importer and then importing would have gotten your tags.
19. Otto (215 comments.) says:

    2/26/2008 at 6:20 am

    Monika: You can get the Blogroll in an OPML format by going to http://example.com/blog/wp-links-opml.php (use your site info, of course). This can then be imported into the Blogroll on the new WordPress installation.
20. Monika says:

    2/26/2008 at 6:26 am

    oh Otto thanks a lot, I would like to use this for others…

    my 123 linkcats to different post ids .. /big eyes..

    to reconstruct all this … never ever in this life

    kindly regards
    Monika
21. Richard D. LeCour (4 comments.) says:

    2/26/2008 at 7:12 am

    I’ve migrated my blogs several times, from MovableType to WordPress, WordPress to WordPress, and WordPress to WordPress MU — the most recent being a forced upgrade from WordPress 2.1.2 to 2.32.

    I haven’t bothered with doing WP exports, relying solely on SQL dumps and re-imports via phpMyAdmin. The manual process is a huge pain, and you really have to have a good understanding of the database structure, but I feel much more comfortable with quality and reliability doing it myself. ‘Course, I’m also the kind that uses a text editor in which to develop rather than an IDE for the same reason!

    On the plugins front, I totally agree, and I periodically look at my plugins to see if I really need them. Most of the time, however, I do! The biggest problem in my opinion is that many plugins developers have the Microsoft mentality: shove every feature and option possible into the plugin, making it unnecessarily bloated and more processor intensive. Granted, I myself need to take more advantage of caching in my own plugins (such as the Devowelizer), but I think Remove Nofollow is a good example of KISS.

    On the flip side, there are some massive, well-integrated plugins such as Simple Tags that really rock! I have 16 plugins activated (11 written by others), and about another half dozen I’d like to add but won’t until I remove all the unneeded features, rewriting them from scratch.
22. Manoj Sterex (1 comments.) says:

    2/26/2008 at 7:42 am

    Thank you for this wonderful post! And thanks everyone for the comments. It helped me fix my site!
23. Weathervane says:

    2/26/2008 at 8:04 am

    I tried to get around a fresh install by having a local installation mirroring my domain installation. Unfortunately, some plugins only work (or correctly work) at a domain. It’s also not possible to completely duplicate a domain configuration locally, for several reasons. You can’t just take an export from one installation and import it into another, for example, because of pathing. WordPress was written with a path in mind. A “path” meaning you install it at your domain, do some configuration, then blog. It’s designed with the idea of minimal screwing-around: just blog. And so the kind of technical screwings-around that many of us like to do, will cause anxiety, aggravation, and lost blogging time, if not a lost blog. But, hell, it’s all to have fun, il n’est pas?
24. SJ (1 comments.) says:

    2/26/2008 at 8:06 am

    I used WP’s Import/Export feature to transfer two of my blogs from Blogger to WordPress, and later on to another domain. It worked beautifully every time. The only thing that broke was (obviously) the links to images that I also moved. The images I’d uploaded through WP were fine, and I was kicking myself for having done so many manual image uploads. I’m still working my way through them!
25. Ike (13 comments.) says:

    2/26/2008 at 8:07 am

    I am not a code-jockey by any means, but I’ve done phpMyAdmin enough that I’d feel more comfortable manually deleting the unneeded tables.
26. kosir (8 comments.) says:

    2/26/2008 at 8:53 am

    I’d say the same as Ike. I just moved my blog to a different web server a few hours ago. The easiest and most reliable option is to use phpMyAdmin for export/import. You also have an option to only export some tables as well as splitting your exported database to more smaller parts. My db was 60mb and the limit for importing is 8mb. It took a bit of clicking but eventually all data got moved.

    I didn’t have any problems and everything looked exactly the same as on the old server. All posts, pages, tags, … everything was there.
27. Richard D. LeCour says:

    2/26/2008 at 8:58 am

    @Weathervane: I installed WordPress MU locally for testing plugins and themes before deployment by adding “127.0.0.1 whatever.dev” to my Vista HOSTS file and can now access my test blogs by visiting http://whatever.dev/ from any browser (but only on my PC, of course.) As long as wp_blogs, wp_site, and wp_NN_options (I think that’s it) are synced, should have no problems.
28. gamerpk (1 comments.) says:

    2/26/2008 at 9:12 am

    So this means I backup my current dB, apply patch, and restore the dataBase… would that work? I don’t think so
29. ChaosKaizer (62 comments.) says:

    2/26/2008 at 9:44 am

    same thing here. it mess up the tags and userdata.
    long story short, it not safe dont depend on WXR export.
30. Ben (1 comments.) says:

    2/26/2008 at 1:28 pm

    You could always edit your database manually and add 12,000 to whatever your akismet counter is right now.

    In the wp_options table look for an entry called akismet_spam_count under the option_name field.
31. Balaji Dutt (2 comments.) says:

    2/26/2008 at 1:29 pm

    @25: I had the same problem with my migration as well and did a fairly painful search & replace in the WXR file to fix it. Subsequently (and I can’t remember which blog pointed it out) I learnt of a Search & Replace plugin that should make this a lot easier in the future.. de
32. Ben (1 comments.) says:

    2/26/2008 at 1:31 pm

    that last comment had an incorrect URI. If you’d like to, you can edit it to the correct one, which is displayed above.
33. R. Richard Hobbs (2 comments.) says:

    2/26/2008 at 2:50 pm

    I went thru many of the same steps merging two blogs- the tags imported as numbers… btn the wordpress categories to tag tool, leftover data from Simple Tags and UTW, Headspace2’s import capabilities and physically deleting the number tags from the terms tables it all worked out somehow
34. ChrisM (13 comments.) says:

    2/26/2008 at 3:26 pm

    I hit a 2mb limit when I transferred hosts. At the same time I changed themes, upgraded to 2.3.3, trimmed down the plugins, and upon discovering that the posts were all re-numbered, I decided to switch to a name-based fancy permalink setup.
    After trying php.ini file amendments, tech support requests etc., I ended up opening the xml file up, taking the basic structure as a template, and creating 3 new (small enough) XML files. Feel free to read a little more over here – . Wow, just checked it, and I really need to break up my text a little better, apologies. Thanks for the info, next time I’ll try out the MySQL route
35. ChrisM (13 comments.) says:

    2/26/2008 at 3:28 pm

    oops, sorry about the badly formed link there, please do feel free to correct it and delete this comment
36. Christopher Price (1 comments.) says:

    2/26/2008 at 5:22 pm

    Migrating from Joomla to WordPress was incredibly easy for us over at PhoneNews.com. My only regret about the process was that we didn’t do it about six months earlier.
37. Joshua U says:

    2/27/2008 at 7:55 am

    Thanks for letting me know how to remove all the trashy rows, etc. in a wordpress database! I was wondering if it’s possible to do such a thing. I wish plugins didn’t leave your database with unnecessary rows, etc.
38. Christina Warren (4 comments.) says:

    2/27/2008 at 10:31 am

    Yeah, that bug in the tag importer got me too — but I had completely backed up my database, so I just said “screw it” and imported the necessary php tables. No muss, no fuss.
39. Joe (1 comments.) says:

    2/27/2008 at 2:19 pm

    Thanks for this post and for the replies. I recently switched servers (read yesterday) and I have never done the import/export process. Everything seemed to be going fine but my export file was 8.7mb. I had my server administrator set the limit up from the default 2 to 10 and it still would not load.

    Fearing the worst I got really frustrated because it kept giving me an error that there was no info in the file. I finally moved my blog back to my old server which luckily worked and then exported by author. This gave me a slightly smaller file since I had 2 extra authors and I was able to import with no problem.
40. Meraj Chhaya says:

    4/10/2008 at 1:55 pm

    I’m also on AhHosting and the limit is 2MB, while my WXR is 4.2MB. Any ideas on how to split or upload?
    I’m really lost
    Nice article by the way
41. ChrisM (13 comments.) says:

    4/10/2008 at 4:20 pm

    >> Meraj Chhaya
    I’ve given some details on how I split the large file into parts, in the post I mentioned previously ( http://chrismerriman.com/blog-revamp-completed/ ). Take a look, and let me know if you need any further help
42. Rocque (1 comments.) says:

    6/5/2008 at 5:13 pm

    OOPS! I just lost my whole blog maybe. I backed up everything, then deleted my whole database. Then deleted my whole blog because it was not running right, it kept reverting to the Kubrick template.
    Now I did a perfect new install except all my archived content is gone. How do I find? Do I reinstall all the backups? Then see if I can figure out what you are talking about here? Well maybe someone will read this and have some help other than saying “it sucks to be you”.
43. Rocque (3 comments.) says:

    6/5/2008 at 8:01 pm

    Ok I answered my questions and now I have my blog back with my posts. YAY. Thanks to Alex Sysoef for pointing me in your direction. The import/export or export/import worked great after I reinstalled my datatbase and broken blog I was able to export the posts. Phew. Then I imported the file to my new updated blog with the new Data Base, and now it is functioning other than the fine tuning I want to do. It is great to have help around if you know where to find it.
44. secomp (1 comments.) says:

    7/26/2008 at 1:03 am

    i’ll try it, cause i feel my blog look so poor with standar. i hope it can be so nice. thx before…
45. Alex (5 comments.) says:

    4/1/2009 at 7:44 am

    Thank you for posting up this informative post! And thank you to everyone else who posted their help and comments. I wouldnt have a blog if you didnt post!
46. zes (7 comments.) says:

    11/11/2009 at 4:25 pm

    Thanks to ChrisM and all the others who posted. I think I got the solution to my questions on exporting .xml file from wordpress.
    Thanks a lot.
47. Robomaster (3 comments.) says:

    11/28/2009 at 1:58 pm

    Wouldn’t it be possible to do the exact same steps by backing up the blog with Cpanel?

Trackbacks/Pingbacks

1. My Apologies Feed Readers | Jeffro2pt0 says:

   2/26/2008 at 1:51 am

   […] If you’re new here, you may want to subscribe to my RSS feed. Thanks for visiting!For those of you that are subscribed to the Jeffro2pt0.com RSS Feed, you may have noticed that I created 400 new posts the other day. Now, although I wish I could produce content at that rate, the fact of the matter is that, you received all of those new post messages due to me re-importing my WordPress content through the built in WordPress migration tools. Because I performed a redesign of the blog, I decided to reformat WordPress. If you don’t know what I am talking about, please read this article “Reformatting WordPress“. […]
2. TIP: Move Your WordPress Blog, And Leave The Trash Behind | My Technophilic Musings says:

   2/26/2008 at 2:04 pm

   […] For more details, read Jeffro2pt0’s post on weblogstoolcollection.com. […]
3. WordPress Link Love | WordPress Web 2.0 Spot-Er says:

   2/27/2008 at 1:08 am

   […] posted an article on Weblog Tools Collection Reformatting WordPress that can be used as guide to bring your blog up to speed and get rid of all the extra weight. As we […]
4. Wp Wordpress » Blog Archive » WordPress Link Love says:

   2/27/2008 at 1:18 am

   […] posted an article on Weblog Tools Collection Reformatting WordPress that can be used as guide to bring your blog up to speed and get rid of all the extra weight. As we […]
5. WordPress Weekly Episode 8 | Jeffro2pt0 says:

   2/29/2008 at 6:02 am

   […] Reformat your WordPress install We will discuss the guide I created to give your WordPress blog a fresh face. […]
6. WordPress Tip : Extending extended RSS (WXR) 2 Mb limit! | ReviewSaurus - The Techie Dino! says:

   3/10/2008 at 10:29 am

   […] (called extended RSS) and lets you import in any other WordPress installation and all this makes formatting of WordPress pretty […]
7. RogAnty - Blog - Finally Updated! says:

   4/15/2008 at 7:22 pm

   […] Earlier today I finally upgraded my blog to WordPress 2.5. At the same time I took the opportunity to clean out my database, quite literally I reformatted my blog! […]
8. Well Fuck | sqwable says:

   6/6/2008 at 2:21 am

   […] fix the problem. My plan is to back up everything and reformat WP this weekend. According to this article the process shouldn’t be too […]
9. Best Of WLTC Part 1 | Weblog Tools Collection says:

   12/27/2008 at 7:14 pm

   […] Reformatting WordPress […]