SQL table structure dump ?

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

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

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.

https://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?

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.

conner061 – Ditto. Make your OWN topic.