MySQL, MyPHPAdmin, CSS Helps Needed
April 28, 2006
Posted by Dan Edelen in : Technical Feedback : 15 comments
I promise I’m in my last week of messing around with the blog before I start posting real content.
If any of you have experience with any of the items in the title, I could use your help:
- 1. MySQL & MyPHPAdmin - Because Blogger truncates and removes articles from post name URLs, my migration has not been without a few issues. I have 400 hundred posts that came over in my import and I hardcoded the permalink structure to mimic Blogger. This keeps old links from breaking. However, the truncation and article issue whacks link anyway; 300 links must be fixed by hand.Ugh.
I know nothing about MySQL, but enough to have it return all the post names in the post_name field through MyPHPAdmin. But when I try to edit that field, the edit function in MyPHPAdmin pulls up all the rest of the fields associated with a post when I click on the edit button. Sure, I can edit the post_name, but saving saves all the information from every field and that is taking me a ton of time per post.
What I’d like to is have it return nothing but the post names, then when I click on edit, it opens only the post names, not the rest of the post fields. Then I can save changes only to the post_name and not have to save the post_name along with all the other post data.
The way I’m doing this now is taking almost a minute to two minutes to save the edited post. I have a relatively fast connection to the Internet, but it’s not a T1, so I’d like to edit JUST the post_name and save it alone and not have to resave the fields I’m not modifying.
Any ideas of this is done? I’ve got to believe it’s possible. Doing hand work is bad enough, but waiting so long to save each correction is a nightmare.
Does this question make sense?
2. The Joys (not) of CSS - I have no ability to read other people’s CSS, especially when it sprawls across pages and pages. I’m trying to make general color and font-size changes to the original Wordpress theme, but I can’t line up the CSS I’m seeing in text on a page with what I’m seeing displayed when the site loads up. Does anyone know of a free CSS editor that allows me to look at specific page elements and make changes to them (even when they are objects that posses multiple states, such as a rollover button)?
Technorati Tags: MySQL, MyPHPAdmin, CSS
No tag for this post.
Posts
Comments
