syncing local site with mysqldump, ignoring configuration settings

Hello, I’ve been fighting with joomla for a long time and have finally given in and switched over to wordpress, and for the most part I’m very, very happy. However, joomla puts all server configuration settings in a single php file, so I had a wonderful script set up that automatically dumped the database via mysqldump, then imported it to my local xampp installation, then rsynced all the file changes across. It worked the other way too, so I could edit offline, then upload with a single terminal command.

I have the bash script set up for the wordpress site, however, on wordpress some of the settings are stored in the wp_options table in the database – specifically, “home” and “siteurl”. I can’t just use the mysqldump –ignore command, as other elements in the table (such as themes) are changed. So….what I’m looking for is a way to ignore those specific elements of a table that will cause a problem between servers, and if possible could someone give me a list of all the options that are likely to cause a problem.

I have looked through the mysqldump helpfile, but can’t seem to find how to ignore specific elements of a table, so I think it will have to be done on the import.

Any help would be greatly appreciated

Thanks