WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] [closed] SQL table structure dump ? (14 posts)

  1. pete_398
    Member
    Posted 3 years ago #

    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

  2. s_ha_dum
    Member
    Posted 3 years ago #

    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.

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

  4. pete_398
    Member
    Posted 3 years ago #

    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.

  5. s_ha_dum
    Member
    Posted 3 years ago #

    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?

  6. s_ha_dum
    Member
    Posted 3 years ago #

    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.

  7. pete_398
    Member
    Posted 3 years ago #

    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.

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

  9. pete_398
    Member
    Posted 3 years ago #

    Okay, thanks. :)

  10. s_ha_dum
    Member
    Posted 3 years ago #

    The database structure, if you are still interested.

    http://pastebin.com/VqDsiLtY

  11. AndyCasey
    Member
    Posted 3 years ago #

    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?

  12. AndyCasey - Make your own topic.

  13. conner061
    Member
    Posted 3 years ago #

    I want to use WP with a shopping cart to set up a new site selling digital products--lots of forms with customizing.

  14. conner061 - Ditto. Make your OWN topic.

Topic Closed

This topic has been closed to new replies.

About this Topic