Tina Norris Fields
tinanfields at torchlake.com
Tue Jan 1 14:28:18 CST 2013
Thank you, Stuart. For my own curiosity and understanding,I have to check that out. But, I really appreciate the feedback that I can do the necessary with phpMyAdmin. I hope this new year a joyous and prosperous one for you and your family. Best, T Tina Norris Fields tinanfields at torchlake.com 231-322-2787 On 1/1/2013 1:53 PM, Stuart McLachlan wrote: > Don't bother with the CLI - I never do. You can do everything you want/need with > phpMyAdmin. > > If you really want to check it out, go to your mySQL installation's binary directory and type > "mysql -h". (Not sure what it will be with UwAMP, but my WAMP was installed on my D > drive and the MySQL directory is: D:\wamp\bin\mysql\mysql5.5.20\bin). There's a tutorial on > using mySQL.exe here: http://dev.mysql.com/doc/refman/5.5/en/mysql.html > > How the data is stored depends on which storage engine is used (msot likely InnoDB or > myISAM for early versions). To quote the manual: > > <quote>For new tables, MySQL always creates an .frm file to hold the table and column > definitions. The table's index and data may be stored in one or more other files, depending > on the storage engine. The server creates the .frm file above the storage engine level. > Individual storage engines create any additional files required for the tables that they > manage</quote>. . > > > > On 1 Jan 2013 at 9:43, Tina Norris Fields wrote: > >> I've been playing with MySQL, using UwAMP and phpMyAdmin to run some >> tutorials. I've also downloaded a huge MySQL reference manual and have >> begun studying it. Using the phpMyAdmin I have a WYSIWYG interface for >> connecting to the localhost/mysql server to play around. The reference >> manual speaks of what looks like a command line connection for invoking >> MySQL. This one I don't follow. How do I invoke MySQL from the DOS >> window? Where do I have to be? How do I make the connection that the >> phpMyAdmin seems to make so easily? Or, should I just wait until that >> part makes sense to me and stick with the WYSIWYG interface for now? >> >> The database structure for MySQL seems to be that the database is a >> folder and the database objects are separate files within that folder. >> Do I have that right? That's the way the old dBase structure was, if I >> recall correctly. >> >> I do appreciate the hand-holding, my friends. There's so much to learn >> in a short time! >> >> T >> >> Tina Norris Fields >> tinanfields at torchlake.com >> 231-322-2787 >> >> On 12/29/2012 6:22 PM, Tina Norris Fields wrote: >>> Hi Guys, >>> >>> I've got two fairly straight-forward database projects coming up, that >>> need to be available on the Web. >>> >>> One is of scanned images of soil erosion permit applications. People >>> must apply for a soil erosion permit in Michigan if they are planning >>> to do any tree cutting or earth modification within 100 feet of the >>> state waters. Lake associations realize the importance of monitoring >>> such applications. In order to make the records easily available, the >>> county soil erosion officer wants to scan the permit applications and >>> put the images online for the public to search. >>> >>> The second one is of data pertinent to streams that we monitor - >>> macroinvertebrate inventory data, p H, temperature, clarity, etc., >>> plus the GPS coordinates of the sites. >>> >>> I have never put a database online, and I could use some tutoring on >>> how best to go about it. The databases themselves don't look >>> complicated, but putting stuff on the Web for search is new to me. >>> >>> Thanks for all the good advice you will be giving me! >>> >>> T >>> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> >