Bummer Posted August 31, 2008 #26 Posted August 31, 2008 Since I'm on the topic, are there any members here that are MySQL guru's??I can't claim anything close to guruhood, but I have a huge book and have used it to make a few databases. I've used it as a command line tool and with a front end called Rekall.
Bummer Posted August 31, 2008 #27 Posted August 31, 2008 Bummer... I just created a website using one of the FrontPage 2003 templates. The first line in the index.htm document is... Dunno much beyond that and since it's on local machine, I can't run the W3C validator against it. I'll keep playing with this for a while (seeing as it's Saturday morning and I got nuthin better to do for an hour or so lol)Sounds like it's a case of folks just not using the page startup template. Does it have a character encoding statement in one of the header lines? If so it should be good enough to get folks started. Keep in mind that the online validator can fail in odd ways over coding errors. e.g. If one writes javascript without properly declaring text/type it can misparse the rest. Not always, but sometimes. None the less, it can be a hugely useful tool. Have you tried the Opera browser? You can run the W3C validator against anything you can load into Opera by right clicking the page and selecting validate. I test my pages on my local machine before publishing all the time. Comes in pretty handy, though Opera is standards compliant and does not always render IE specific code properly. A lot of sites have text that does not display properly because of an old bug in IE that has been there so long everyone codes to it without knowing it.
Bummer Posted August 31, 2008 #28 Posted August 31, 2008 Wow! never knew there were so many bilingual folks on here. What the heck are you guys talk'n about???? And where does it go on the motorcycle?Don't worry Gary, we're speaking Nerdish. It usually goes on the loose nut holding the handlebars.
Bummer Posted August 31, 2008 #29 Posted August 31, 2008 I merely wish to change some text on our main page of our shop's website . A buddy of mine built our site , but failed to instruct me on how to make text changes . Our web hosting guy was going to show me how , but he passed away last month . I now have a new guy I speak too to make these changes and he makes them for me without having to charge me $65.00 minimum , but I feel like I asking to much of him . He has given me my FrontPage username and password and a quick tutorial over the phone . Other than the main page , the rest of our site is E-Commerce and I can manage that without any issues . It just the main page is what I'm going to screw up on ! I was just merely asking towards if there was an easier way by using another program . BEER30 That SHOULD be pretty easy in FrontPage, particularly since the site is already set up using it. You SHOULD be able to just load up FrontPage, click on the text you want to change, delete it, type in what you want, then save it. OO would work that way too, but you'd still have to put it online. That would make it a step more complicated. It's not hard, but that should be built into FrontPage. Either way there'll be a learning curve since you've never worked with either. Could you have the guy who's doing it for you now stand behind you and tell you what to do step by step? That's how I teach people how to do stuff on the computer. I find that if their hands are actually doing the work they learn much more quickly.
SilvrT Posted August 31, 2008 #30 Posted August 31, 2008 I can't claim anything close to guruhood, but I have a huge book and have used it to make a few databases. I've used it as a command line tool and with a front end called Rekall. I'm in the beginng stages of converting my company's MS Access database system so that it will use MySQL as the backend. We'll stay with Access for the frontend for simplicity of migration and minimal user impact. There is a need to have localized data (tables stored on the client workstations) so I spent some time setting up and testing replication. Seems to work fine except it took me 2.5 days to get it to work...that was mostly because all the documentation I could find on the web failed to state that certain commands placed into the my.ini file (in Windows) required quotes around them (whereas in Linux they apparently don't in the my.cnf file). I'm using a Linux server and WindowsXP workstations. Have you had any experience with replication? I'm wondering about such things as band width, limitations on # of client machines specific to replication, how to replicate more than one database. Anyone else? friesman1??... any experience in this area?
Bummer Posted August 31, 2008 #31 Posted August 31, 2008 Have you had any experience with replication?A little, but not at the level you're working with. Nothing I've done has been live. Sorry. Sounds interesting though. From a Nerdish perspective.
BuddyRich Posted August 31, 2008 #32 Posted August 31, 2008 Have you had any experience with replication? YES :rotf: Got 2 kids and 3 grandkids....:rotf:
BEER30 Posted August 31, 2008 #33 Posted August 31, 2008 Could you have the guy who's doing it for you now stand behind you and tell you what to do step by step? That's how I teach people how to do stuff on the computer. I find that if their hands are actually doing the work they learn much more quickly. Our website hosting in located 1.5 hours away . I wished I had thought of what you just mentioned when I went to see my Congressman office last week as he was in the same town . But even though , I had a tight schedule . From what he explained to me was to make a backup of that page , and rename that file for just in case . Then open up FrontPage with my username and password , open the page I need to make changes , make changes and then save . He told me I would be making change "Live" . If I screw up , replace it with the backup file . BEER30
SilvrT Posted September 1, 2008 #34 Posted September 1, 2008 Our website hosting in located 1.5 hours away . I wished I had thought of what you just mentioned when I went to see my Congressman office last week as he was in the same town . But even though , I had a tight schedule . From what he explained to me was to make a backup of that page , and rename that file for just in case . Then open up FrontPage with my username and password , open the page I need to make changes , make changes and then save . He told me I would be making change "Live" . If I screw up , replace it with the backup file . BEER30 That's correct! Exactly as I have done it. There is another method which is commonly used and that is to store the entire website on your local PC. You open that, make the changes and then Publish the changes to the actual web which is seen on the Internet. The thing about this is you can view your changes locally and make any adjustments necessary BEFORE you publish it to the live site.
SilvrT Posted September 1, 2008 #35 Posted September 1, 2008 A little, but not at the level you're working with. Nothing I've done has been live. Sorry. Sounds interesting though. From a Nerdish perspective. I found the answer to the "multiple database" Q ... Basically you must list all databases in my.cnf on the master and slave. Master: Code: binlog-do-db=db1 binlog-do-db=db2 binlog-do-db=db3 binlog-do-db=db4 binlog-do-db=db5 binlog-do-db=db6 binlog-do-db=db7... Slave: Code: replicate-do-db=db1 replicate-do-db=db2 replicate-do-db=db3 replicate-do-db=db4 replicate-do-db=db5 replicate-do-db=db6 replicate-do-db=db7 ... __________________ ...More "Nerdish" but maybe useful to someone here...
Bummer Posted September 1, 2008 #36 Posted September 1, 2008 There is another method which is commonly used and that is to store the entire website on your local PC. You open that, make the changes and then Publish the changes to the actual web which is seen on the Internet. The thing about this is you can view your changes locally and make any adjustments necessary BEFORE you publish it to the live site.That's how I do it. But then I'm using an editor and an FTP program so there is no "Live" editing. Naturally, if it's important (whatever it may be) I make a backup before playing.
Bummer Posted September 1, 2008 #37 Posted September 1, 2008 I found the answer to the "multiple database" Q ... Basically you must list all databases in my.cnf on the master and slave. ====8 ...More "Nerdish" but maybe useful to someone here...I don't know if I'll ever need it but it's filed in the back of the head. Thanks for posting it.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now