MySQL, MyPHPAdmin, CSS Helps Needed
April 28, 2006
Posted by Dan Edelen in : Technical Functions : Trackback,
Print This Post
,
E-Mail This Post
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
There is a CSS viewer that renders the source code really nicely. It’s a firefox extension just check the bug list at the bottom of the page…
http://www.lifehacker.com/soft.....102764.php
Another good extension is here, the web developers extension:
http://www.lifehacker.com/soft.....102764.php
These two bits should make life easier!
Keep me updated!
With so many fanatical users out there, I suspect there’s a good summary of the WP CSS out there. There’s one for Moveable Type, there’s got to be one for WP.
I use the IE based Maxthon and there’s a similar plug in for it. I haven’t used either so I can’t tell you which is better. I also don’t have it installed at work, so I can’t tell you what it is.
CSS takes a bunch to wrap your head around, at least it did for me. I’ve got a better understanding now, mostly by banging my head on it until I got it. One thing that got me is how the classes and id’s (still don’t know the difference) add to and subtract from each other, they don’t completely replace each other. In other words, if you have text in class A that defines the font as Ariel and bold, and then within that class designation add a section of class B that changes the font to Veranda, it will still be bold. That’s because it’s inside both A and B. and the only thing B changes is the font, not the style of the font.
I probably butchered that explanation, but that’s how I understand it.
BTW - I like the new look, but on my wide 1600 x 1200 monitor at work your background image isn’t wide enough.
I thought no one would possibly be using a monitor at that resolution! The background is 1280×960. I tried it at 1600×1200 and it took too long to load. So it was overkill for the people who run at 1024×768 and 1280×960—which I thought was probably 99% of people out there. Oh well.
Unless there is some way to get the background to scale, I don’t know what else to do. I could put the 1600×1200 version in there, but it will show more of the mountains than I want, too.
Any ideas?
Dan
Regarding your post names: Yes, it’s possible. I’d suggest this:
1. run the following SQL: “select ID, post_name from wp_posts” - I’m doing this from memory so I’m not sure I have those columns correct, but you get the idea - we need the post ID and the current name extracted.
2. In phpMySql you can export the results of a query to a CSV file.
3. Load the CSV file in Excel
4. In a third column, type the name you really want (my understanding is you are trying to change the post name, correct? I may not have that right - let me know).
5. Email the spreadsheet to me (my email is on the comment)
6. I’ll email you back a MySql update statement that will replace the original post names with your new post name.
7. Run that MySql statement in phpMyAdmin and you’re in like flynn.
Just an offer. Let me know if you want me to help out and I will
Also - if you’re not sure how to do step 2 I can walk you through that as well. Just email me.
I’ll do that this weekend.
What’s to know about making a MySQL update statement?
Man, there’s times I wish Apple made blogging software!
Unfortunately, that extension crashes Firefox when I attempt to do the one thing I need more than anything else—manage colors.
Thank you, nonetheless. I see its value for other purposes, too.
Thanks Dan - I’ll await the email
Basically, I create a spreadsheet and use a formula to create the SQL. I will send you back the spreadsheet I create, to teach a man to fish rather than giving him one, etc . . .
Dan,
My home laptop is a 1680 x 1050 widescreen. What can I say, I like to get as much on screen as possible. Of course, now more and more blogs are fixed width, so get a lot of empty space on the edges.
I’m not familiar with how to use the ‘background’ function with in the [head] section. Can you center it? That would help. Then, make the background a blue that compliments the sky and you’ll be good, or at least better.
It would be great if you could split the image in two and align the right half to the right and the left half to the left, but I suspect that’s not possible.
salguod (and Dan),
If you wanted to center the background image, you could set the applicable line of CSS to this:
background: url( images/csbgd.jpg ) no-repeat fixed bottom center;It’s just a matter of changing “left” to “center” in there.
Snazzy web site … too bad it takes over 2 minutes to load up for those of us who can’t afford to pay through the nose for a high-speed Internet connection.
I’ve got a 2-way satellite connection which is between DSL and cable in download speed and about five times the speed of dial-up on the upload. Satellite has latency issues, though, which means that I have great download speeds on a solid 50MB file, but if it’s 50MB of 1000 tiny files, it’s not quite as great because the satellite has to relay those calls for more data every single time and going through space isn’t the same as going through a cable.
That said, this site loads up way faster than the Blogger site! Unfortunately, the bottlenecks are identical: calling Joe Carter’s Evangelical Links through Blogrolling, calling Truth Laid Bear’s Ecosystem data (which now works again), and calling the Amazon images for the books.
I got rid of my own Blogrolling link, so that’s a tad faster than before. The “Kingdom Links” are all in the Wordpress MySQL database so the call stays on this domain.
I’ve considered moving some things to another page. I still haven’t filled out my About tab above, but I might add another tab to handle all the stuff that’s slowing down this page. We’ll see.
Don’t know what else to do. I already got a complaint from a couple users who say my 1200×960 backdrop is too small for their 1600×1200 monitors. (I had no idea anyone ran their Web browsers full screen past 1024×768 res. Not sure I understand that, but…oh well!) I had the larger graphic up there, but it was 70k. The smaller one is 41k and even that has a few artifacts. I try to keep my images around 10k as much as possible, but a few break that in GIMP, no matter how much compression I try.
I hear you, but I can’t believe I’m worse than anyone else!
Hey Dan,
I never heard from you, so I’m assuming you got the renames done on your own? Just checking - I hope I didn’t miss an email in there somewhere.
Cool looking site!
Fwiw, I find this semi-transparent content background really hard to read. Making it a solid color would improve readability 110%…