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.
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.
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.phpto 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.