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?
Navicat can do it. They have a free version for non-commercial and a free 30 day trial. Make sure to download the mysql version unless you need oracle, postgre, etc. http://www.navicat.com/en/download/download.html
Is there a Mac version of this? Is it fairly easy to use? What are the limitations with the 30 day trial?
Download HeidiSQL. It's free and very powerful. You can connect two mysql databases together and transfer data live.
Yes. Windows, Mac and Linux versions. 30 day trial is for a completely unrestricted version. If you are not using for commercial, there is a lite version as well. The only thing the light version can't do is backups.