Title: SQL table structure dump ? Last modified: August 20, 2016 --- # SQL table structure dump ? * Resolved [pete_398](https://wordpress.org/support/users/pete_398/) * (@pete_398) * [15 years, 4 months ago](https://wordpress.org/support/topic/sql-table-structure-dump/) * I have been using WP 3.1 ‘within’ XOOPS, and want to drop the whole XOOPS side of things, and just go ‘WP’. * XOOPS handles it all by a module called XPressME, and I don’t know if that has modified the table/s at all. So, in wanting to import all the current WP tables into a new WP database, I need to know the SQL structure of WP 3.1.3 please. * I know there are FAQ describing the structure, but I need version 3.1.3 sql structure only, dumped to a file, so that I can then simply compare the 2 sql files, to see if there are any differences. * Currently the WP posts are of the format [http://example.com/modules/wordpress/?p=18](http://example.com/modules/wordpress/?p=18), and will have to end up like [http://example.com/?p=18](http://example.com/?p=18) * pete Viewing 13 replies - 1 through 13 (of 13 total) * [s_ha_dum](https://wordpress.org/support/users/apljdi/) * (@apljdi) * [15 years, 4 months ago](https://wordpress.org/support/topic/sql-table-structure-dump/#post-2137371) * I don’t know if there is such a document. There might be but I’ve never seen it. I’d just download 3.1.3, install locally, and dump the db structure myself. * But what you are talking about here… * > Currently the WP posts are of the format [http://example.com/modules/wordpress/?p=18](http://example.com/modules/wordpress/?p=18), > and will have to end up like [http://example.com/?p=18](http://example.com/?p=18) * … doesn’t have anything to do with database _structure_. * Also, I’m pretty sure that `?p=` url format has not changed since at least about WP 1.5 so I doubt its changed in 3.1.3. * Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/) * (@ipstenu) * 🏳️‍🌈 Advisor and Activist * [15 years, 4 months ago](https://wordpress.org/support/topic/sql-table-structure-dump/#post-2137386) * `?p=` is till there and works fine. * The trick is that you have WordPress essentially installed in a subfolder. You can KEEP that if you want to, but if you’re switching your whole site from XOOPS to WP, then yeah, the URL locations will change 🙂 * If you move it from /modules/wordpress/?p=18 to just /, then you’d want an .htaccess redirect to send ’em over. * > So, in wanting to import all the current WP tables into a new WP database, > I need to know the SQL structure of WP 3.1.3 please. * Why not export the posts from WP, make your new install, and import them? Or does the module install not have the export feature? * Thread Starter [pete_398](https://wordpress.org/support/users/pete_398/) * (@pete_398) * [15 years, 4 months ago](https://wordpress.org/support/topic/sql-table-structure-dump/#post-2137443) * > I’d just download 3.1.3, install locally, and dump the db structure myself. * Yes, I thought of that, and even though I use a Linux box locally, I’d still have to install php5, MySQL and phpMyAdmin locally, to get the (3.1.3) structure exported. I may end up just adding a subdomain ‘test’ to the website, load 3.1.3 into that, import the rows from XOOPS/XPressMe into a ‘test’ db, and then I have both structures. That way I can play around with the 3.1.3 WP in a seperate sub domain and seperate db. * > .. doesn’t have anything to do with database structure. * Yes, true, I was just thinking out aloud, would have been better to not mention it. * > If you move it from /modules/wordpress/?p=18 to just /, then you’d want an . > htaccess redirect to send ’em over. * Yes, or I can just add php code to my 404 error file, to do the (permanent) redirect. * > Why not export the posts from WP, make your new install, and import them? Or > does the module install not have the export feature? * Will the WP import let me know if there are any columns in the table rows that are different ? (either changed or added,etc). I don’t think the module install has an export feature, but I would just use phpMyAdmin to export the sql first. * [s_ha_dum](https://wordpress.org/support/users/apljdi/) * (@apljdi) * [15 years, 4 months ago](https://wordpress.org/support/topic/sql-table-structure-dump/#post-2137446) * > Yes, I thought of that, and even though I use a Linux box locally, I’d still > have to install php5, MySQL and phpMyAdmin locally, to get the (3.1.3) structure > exported. * You’d only have to install php5 and MySql. You can use mysqldump to dump the structure. I kind-of assumed you already had a local server, I guess. What do you do your development on? * [s_ha_dum](https://wordpress.org/support/users/apljdi/) * (@apljdi) * [15 years, 4 months ago](https://wordpress.org/support/topic/sql-table-structure-dump/#post-2137447) * I’m going to be installing 3.1.3 anyway. I’ll dump the database structure and post it somewhere for you. Remind me if you don’t see it by the end of tomorrow. * Thread Starter [pete_398](https://wordpress.org/support/users/pete_398/) * (@pete_398) * [15 years, 4 months ago](https://wordpress.org/support/topic/sql-table-structure-dump/#post-2137448) * Thanks, that would be good to see the structure. I may just go ahead and wipe the site (after backups), and then install 3.1.3. THat way, I can compare the( new) exported sql with the old. * Seems that /wp-admin/includes/schema.php is the file with the SQL code in it. Ran Beyond Compare on 3.1 <=> 3.1.3 and that file is unchanged, so seems I have nothing to be concerned about. * Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/) * (@ipstenu) * 🏳️‍🌈 Advisor and Activist * [15 years, 4 months ago](https://wordpress.org/support/topic/sql-table-structure-dump/#post-2137481) * > Will the WP import let me know if there are any columns in the table rows that > are different ? (either changed or added,etc). I don’t think the module install > has an export feature, but I would just use phpMyAdmin to export the sql first. * Shouldn’t matter and here’s why. * 1) You install a NEW version of WP where you want your new site to be. * 2) You export the OLD data (note – this is JUST data) * 3) You import the data, and wordpress adds the table rows as needed 🙂 * The rest of the DB structure shouldn’t matter, as the wp_posts and postmeta stuff rarely changes… In fact, I doubt it ever will, and even if it DID, they’d have an upgrade path with an importer. * Thread Starter [pete_398](https://wordpress.org/support/users/pete_398/) * (@pete_398) * [15 years, 4 months ago](https://wordpress.org/support/topic/sql-table-structure-dump/#post-2137482) * Okay, thanks. 🙂 * [s_ha_dum](https://wordpress.org/support/users/apljdi/) * (@apljdi) * [15 years, 4 months ago](https://wordpress.org/support/topic/sql-table-structure-dump/#post-2137491) * The database structure, if you are still interested. * [http://pastebin.com/VqDsiLtY](http://pastebin.com/VqDsiLtY) * [AndyCasey](https://wordpress.org/support/users/andycasey/) * (@andycasey) * [15 years, 4 months ago](https://wordpress.org/support/topic/sql-table-structure-dump/#post-2137517) * I want to use WP with a shopping cart to set up a new site selling digital products– lots of forms with customizing. I know my products but a lot of these comments and questions seem way too technical for me. Do I need outside help to set up a WP site? * Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/) * (@ipstenu) * 🏳️‍🌈 Advisor and Activist * [15 years, 4 months ago](https://wordpress.org/support/topic/sql-table-structure-dump/#post-2137519) * AndyCasey – Make your own topic. * [conner061](https://wordpress.org/support/users/conner061/) * (@conner061) * [15 years, 4 months ago](https://wordpress.org/support/topic/sql-table-structure-dump/#post-2137530) * I want to use WP with a shopping cart to set up a new site selling digital products– lots of forms with customizing. * Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/) * (@ipstenu) * 🏳️‍🌈 Advisor and Activist * [15 years, 4 months ago](https://wordpress.org/support/topic/sql-table-structure-dump/#post-2137531) * conner061 – Ditto. Make your OWN topic. Viewing 13 replies - 1 through 13 (of 13 total) The topic ‘SQL table structure dump ?’ is closed to new replies. ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * [Import](https://wordpress.org/support/topic-tag/import/) * [sql](https://wordpress.org/support/topic-tag/sql/) * [tables](https://wordpress.org/support/topic-tag/tables/) * In: [Everything else WordPress](https://wordpress.org/support/forum/miscellaneous/) * 13 replies * 5 participants * Last reply from: [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/) * Last activity: [15 years, 4 months ago](https://wordpress.org/support/topic/sql-table-structure-dump/#post-2137531) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics