Stuart McLachlan
stuart at lexacorp.com.pg
Tue Jan 1 12:53:26 CST 2013
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 >