WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
why cant you export that from the database? – Pontus Abrahamsson Jul 5 '12 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 '12 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 '12 at 18:55
from a multisite (beta) to an other multisite. On 2 different LAMP. – Christian Jul 7 '12 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 '12 at 0:08

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.

share|improve this answer
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 '12 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 '12 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 '12 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 '12 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 '12 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.

share|improve this answer
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 '12 at 9:37

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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