I can't use PHPMyAdmin to export/import my blogs from one server to an other because I'm using Wordpress Network.

Export/import works pretty well for Posts, custom posts types and their media, but not for the Blog settings themselves

How could I export my blog settings?

Some examples:

  • sizes for Thumbnails, medium, large images
  • Pictures cropping
  • Date format
  • show excerpts
  • how many articles per pages
  • ...

my main goal being to apply all my beta website settings to the main website when fully tested and approved.

  • why cant you export that from the database? Jul 5, 2012 at 18:48
  • maybe I could export wp_63_options (if my blog is the 63rd one) and identify which lines are for the settings. Maybe it will end with a homemade plugin to select only the right options if nothing exists
    – Christian
    Jul 5, 2012 at 20:34
  • What do you mean by "one server to another"? And I mean: is it going to be a transfer from Multisite to Multisite? Or to Single site? At first, it doesn't really matters if it's the same or another server...
    – brasofilo
    Jul 7, 2012 at 18:55
  • from a multisite (beta) to an other multisite. On 2 different LAMP.
    – Christian
    Jul 7, 2012 at 19:18
  • Sorry, but, in a second reading, I think this needs clarification as well: how does it comes you "can't use PHpMyAdmin"¿?
    – brasofilo
    Jul 9, 2012 at 0:08

2 Answers 2


Export the options table that is specific to the multisite blog in question (just the option names and values), import them into the new options table on the new site.

This will work for every option that doesn't use a prefixed option name, which is only user-specific stuff like capabilities and roles.

  • if there's such a table, it's exactly what I'm looking for. But I need you to be a bit more precise because I can see only get_option($name). Do you mean that I should create my own plugin to do get_option() and set_option() ?
    – Christian
    Jul 7, 2012 at 19:22
  • I thought you were looking directly at the database. In a multisite install, each site gets its own set of tables. So there will be wp_3_options and wp_4_options and so on. These options are those that are specific to that particular site. Just export all of them, minus the ID's, and put them in the new site's options table. You'd use phpMyAdmin or similar to do this.
    – Otto
    Jul 7, 2012 at 19:31
  • sorry, now I understand. I also should exclude siteurl home upload_path fileupload_url. I only need data from the submenus settings available in /wp-admin/, it's weird that there's no way to separate them... all the /wp-admin/options-*.php
    – Christian
    Jul 7, 2012 at 19:43
  • On a multisite setup, things like those generally don't matter so much. The multisite code handles them, and it has its own sitewide options table.
    – Otto
    Jul 7, 2012 at 19:44
  • It doesn't seem to me the safest way to deal with a website working that I need to update with my latest theme version without accidental interruption. 'generally don't matter you said... I will try your solution today, but it seems a good way to get side effects one day without noticing in time
    – Christian
    Jul 9, 2012 at 6:57

I was thinking about this last night and don't want to 'self promote' too much here

If you can't access PHPMyAdmin, my database backup plugin dbc backup 2 will create the SQL export for you of all tables in your WordPress install.

You can then open the export in a SQL editor like SQLYog and you'll be able to see all the tables in your database.

But from experience you don't save time editing in SQL, many of the things you are looking for like setting post per page, and excerpt length are quicker to change from within WP-Admin then reading through all the rows in the WP_options table.

Remember you can always go to /wp-admin/options.php to see all the options for that site.

Take care - some options in the database have a checkvalue (length) as well
example username admin may have a value of (5) next to it.

  • thank you, I fully agree with you. When I need the create a copy for Beta tests I will more likely be happy to know your plugin.
    – Christian
    Jul 14, 2012 at 9:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.