I have a MySQL database full of information and I want to start moving it into my MySQL database that runs Wordpress. Of course the field names, etc. are completely different but I was hoping there was a script out there that could make life easier for me. Maybe something where I can tell it the database, password and location of the first bit of information and where that information needs to go into the new database. And enter that for each bit of information. Then run it. Does anyone know of a program or script that will do this?
By the sound of it, your database at the moment is completely proprietary. So there won't be a script out there to port it to a wordpress schema. You could hire a PHP coder to make a script that could do this, it wouldn't be hard - less than an hours coding.
I think I might have to do that. In another thread, I was told that there's a program called Navicat that can do it. I think it might be rather complex considering the information is going to be broken up into different tables for wordpress and will need to accommodate wordpress's user id numbering system. I'll let you know if I need your help Deacalion.
Yeah, there are quite a few programs out there designed for this sort of thing. They take longer to configure and use than it would take to do it manually though. That's why I didn't recommend any.
Yes you'll need a custom script to do that. There's basically two ways: If you just want to import the contents of your database into WordPress, but don't plan to update your proprietary database in the future, you can use a standalone script to do the import once. If you'll still update your database and you just want to use WordPress as an additional way to publish its content, it might be better to have a WordPress plugin developed that does the import on a regular basis.