andrewmoir

HI All, just a quick question - please note I'm fairly new to MySQL. I am using MySQL Administrator to backup my database (I also backup via .csv export as a backup backup) I have watched the backup files from MySQL Admin grow in size in 6 months from 20 to 30 megabytes. However using PHPmyadmin to look at the database I note that my main table is only 11 megabytes (it has only grown by 4 megabytes in 6 months). Note all other tables are in KB sizes and no tables are linked. Is there a reason for the difference in size?? regards Andy

Dear all, I trust you can point me in the right direction. My laboratory collects our data into a simple flat file database (MySQL). Reports are generated from the database. I wish to replicate the data onto our hosted (ISP's) web server so that customers can also view reports. so local network MYSQL -> ISP (hosted) MYSQL. No data has to travel the other way. Note the database file size is 30 mb. Is there an automatic way that any changes to the local database can be transferred to the hosted database? One way I thought about was to flag any row that has any sort of change made to it with a value (e.g. 1) and then build a little vb app to transfer all data from the database that has been flagged with a 1 (then set all transferred rows to 0). regards Andy Unfortunately our clients cannot come down our ADSL to view data.

Great, thank you very much to Nogray for his help. This topic may be marked closed  /  Solved .  Can't find FYI - If you want the popup to always get the focus: add  - win.focus(); <a href="#" onclick="selectLink(this); win = window.open('quickview.php?numrows=10&sample=<?php echo $samplenumber; ?>&b=b', 'popup', '');  win.focus(); return false;">b</a> regards

Nogray:  Thanks very much that worked great. ;D small problem 1) - I have a long page of links, once one of the links on the bottom of the page is selected, it highlights perfectly, but it also refreshes the page and so the page returns to the top, the link remains highlighted but offscreen at the bottom of the page. ???Solution???Somehow using the anchor tag and the Name attribute?? 2)- putting the window.open before the selectLink gives no popups??e.g. <a href="#" window.open('test1.html', '', ''); onclick="selectLink(this);">Link 1</a><br /> <a href="#" onclick="selectLink(this); window.open('test1.html', '', '');">Link 2</a><br /> 1st link does not work, 2nd does. Fenway:  I apologise, my HTML and PHP is great but when it comes to Javascript I am a copy and paste monkey - thus the reason I did not use your suggestion - I did attempt to google it though. Thanks for you help so far..

Hi all, I initially put this in Javascript section, however its more appropriate here. I have page with links (generated by PHP).  Each link opens a popup window. When clicking on a link I need that link to be highlighted (marked) so that when finished with the popup I can tell which link I was last on. I need the link to lose its highlights once I select another link, and for that new link to get the highlight. Highlight can be a change of colour, or a pointer. Note that a standard text link is highlighted when selected, but when the window loses focus the highlight disappears. Have googled this topic to death and so far have come up with nothing. Thank you for your help Andy

Hi all, Put this in Javascript since I assume this is the best way to do it. I have page with links (generated by PHP).  Each link opens a popup window.  I need the currently selected link to be highlighted, so that when finished with the popup page I can see which link I was currently on. I need the link to lose its highlights once I select another link, and for that new link to get the highlight. Highlight can be a change of colour, or a pointer. Have googled this topic to death and so far have come up with nothing  :P Thank you for your help Andy

Hi there - 2 questions 1) Have a simple laboratory setup, 5 machines pushing data once every couple of minutes into the database, and maximum of 20 users reading and updating data.  The database is a pure table with no dependencies or  foreign key restraints. I realise that Innodb can roll back incomplete updates/transactions but if info from a machine does not push through correctly it is absolutely no train smash at all.  So what do you think  Is Innodb worth the extra overhead?  Should I stick with my first choice Isam? 2) Phpmyadmin lists my  MySQL charset: as  UTF-8 Unicode (utf8)  I did a fresh install, then messed around with the    MySQL connection collation setting. Its now set to UTF_unicode_ci  because I think that is what it was set to??? Is that the default setting?  I don't have any difficult data, nor need use of special characters other than % and °.  Would I speed things up by using Latin1_bin??  (since UTF has to translate the characters)  Would using Latin1 clash with my Charset UTF-8 Unicode? P.s. 3) Using Windows Xp/apache , is simply putting an index.html in all sub folders in my htdocs folder enough to stop people getting their mitts on any of my phpmyadmin settings php files (apologies for the non Mysql question). kind regards and thanks for your answers Andrew

Hello there, You may have seen it before: when in PhpMyAdmin, when editing a row in your database, a page is displayed with all the database fields and the all the current values for each field. If you change one of the values in a row (e.g. 'status' field) and press the 'GO' (submit) button, the submit page is displayed with the following SQL statement: e.g. UPDATE `sample` SET `status` = '2' WHERE `sampno` = '153' LIMIT 1 ; However there were lots of other fields which I did not change, these were not included in the submit query. How does the script know which fields were changed (i.e. status field) , how does it manage to generate a SQL statement tailored to include only those fields which have changed? (-I know how to construct basic php submit forms-if its too much effort to type giving me a basic idea will suffice.) Please ask me to clarify if something is not clear. regards Andrew