Support » Everything else WordPress » SQL table structure dump ?

  • Resolved pete_398

    (@pete_398)


    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 , and will have to end up like http://example.com/?p=18

    pete

Viewing 13 replies - 1 through 13 (of 13 total)
  • 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 , and will have to end up like 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)

    (@ipstenu)

    🏳️‍🌈 Halfelf Rogue & Plugin Review Team Rep

    ?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?

    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.

    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?

    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.

    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)

    (@ipstenu)

    🏳️‍🌈 Halfelf Rogue & Plugin Review Team Rep

    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.

    Okay, thanks. 🙂

    The database structure, if you are still interested.

    http://pastebin.com/VqDsiLtY

    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)

    (@ipstenu)

    🏳️‍🌈 Halfelf Rogue & Plugin Review Team Rep

    AndyCasey – Make your own topic.

    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)

    (@ipstenu)

    🏳️‍🌈 Halfelf Rogue & Plugin Review Team Rep

    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.