Difference between revisions of "My db-class.org notes"

From Got Opinion Wiki
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
== Useful links ==
== Class setup ==


[http://dev.mysql.com/doc/refman/5.6/en/index.html MySQL Reference Manual]
[[Software setup for db-class]]


[http://www.if-not-true-then-false.com/2010/install-mysql-on-fedora-centos-red-hat-rhel/ Install MySQL on Fedora]
== XML ==


== Installing required software on Fedora Core 15 ==
=== Useful resources ===


=== xmllint ===
W3Schools online introductions


My Fedora Core 15 had xmllint installed. To confirm you have the software installed:
[http://www.w3schools.com/xml/xml_whatis.asp Introduction to XML]
<pre>[ptay@robot logs]$ xmllint --version
xmllint: using libxml version 20707
  compiled with: Threads Tree Output Push Reader Patterns Writer SAXv1 FTP HTTP DTDValid HTML Legacy
  C14N Catalog XPath XPointer XInclude Iconv ISO8859X Unicode Regexps Automata Expr Schemas Schematron
  Modules Debug Zlib
[ptay@robot logs]$</pre>


=== Kernow ===
[http://www.w3schools.com/dtd/dtd_intro.asp Introduction to DTD]


'''Download Kernow'''
[http://www.w3schools.com/Schema/schema_intro.asp Introduction to XML Schema]
<pre>[ptay@robot Kernow]$ wget http://sourceforge.net/projects/kernowforsaxon/files/Kernow/Kernow%201.7.2/Kernow%201.7.2.zip/download?use_mirror=iweb</pre>


'''Unzip Kernow file'''
[http://www.zvon.org Zvon.org] online course
<pre>[ptay@robot Downloads]$ unzip "Kernow 1.7.2.zip"
Archive: Kernow 1.7.2.zip
  creating: Kernow 1.7.2


  //////////////omitting text/////////////////////
[http://www.zvon.org/comp/r/tut-XML.html XML Tutorial]


  inflating: Kernow 1.7.2/readme.txt</pre>
[http://www.zvon.org/comp/r/tut-DTD.html DTD Tutorial]


Optional, remove .zip file by using <code>rm -f "Kernow 1.7.2.zip"</code> command.
W3C XML & XML Schema specifications


Launch Kernow
[http://www.w3.org/TR/xml/ XML]


Navigate to directory where Kernow is located (or create symbolic link and use symbolic link). This command will launch a Kernow java window.
[http://www.w3.org/TR/xmlschema-0/ XML Schemas]
<pre>[ptay@robot Downloads]$ cd Kernow1.7.2/
[ptay@robot Kernow1.7.2]$ ls
ant    extensions  Kernow.exe  Kernow.sh  readme.txt
cache  Kernow.bat  kernow.jar  lib
[ptay@robot Kernow1.7.2]$ java -jar kernow.jar &
[1] 3370
[ptay@robot Kernow1.7.2]$</pre>


=== MySQL ===
== Relational Algebra ==


Ubuntu commands:
[http://en.wikipedia.org/wiki/Relational_algebra Relational algebra] on Wikipedia
<pre>$ sudo apt-get install mysql-server mysql-common mysql-client</pre>


Fedora Core 15 commands:
A commercially failed relational algebra database called [http://en.wikipedia.org/wiki/Business_System_12 Business System 12] on Wikipedia
<pre>[ptay@robot logs]$ sudo yum groupinstall "MySQL Database"
[sudo] password for ptay:


//////////////omitting text/////////////////////
[http://en.wikipedia.org/wiki/Rel_%28DBMS%29 Rel] an open source relational database management system primarily used in teaching.


Installed:
[http://db.grussell.org/section010.html Relational Algebra] portion of a [http://db.grussell.org/index.html database eLearning site].
  MySQL-python.x86_64 0:1.2.3-1.fc14                                           
  libdbi-dbd-mysql.x86_64 0:0.8.3-6.fc14                                       
  mysql.x86_64 0:5.1.58-1.fc14                                                 
  mysql-connector-odbc.x86_64 0:5.1.5r1144-7.fc13                             
  mysql-server.x86_64 0:5.1.58-1.fc14                                         
  perl-DBD-MySQL.x86_64 0:4.017-1.fc14                                         
  unixODBC.x86_64 0:2.2.14-12.fc14                                             


Dependency Installed:
== Other Useful links ==
  libdbi.x86_64 0:0.8.3-4.fc14        libdbi-drivers.x86_64 0:0.8.3-6.fc14   
  perl-DBI.x86_64 0:1.613-1.fc14   


Complete!</pre>
[http://dev.mysql.com/doc/refman/5.6/en/index.html MySQL Reference Manual]


'''Enable MySQL at specific run levels'''
[http://www.if-not-true-then-false.com/2010/install-mysql-on-fedora-centos-red-hat-rhel/ Install MySQL on Fedora]
 
Note: I did 3 & 5
<pre>[ptay@robot logs]$ sudo chkconfig --level 35 mysqld on
[ptay@robot logs]$ chkconfig --list | grep -i mysqld
mysqld          0:off  1:off  2:off  3:on    4:off  5:on    6:off</pre>
 
'''Start MySQL daemon (mysqld)'''
 
As root
<pre>
[root@robot ~]# service mysqld restart
Stopping mysqld:  [ OK  ]
Initializing MySQL database:  Installing MySQL system tables...
OK
 
//////////////omitting text/////////////////////
 
Starting mysqld: [  OK  ]</pre>
 
'''Run MySQL secure installation script'''
 
As root
<pre>[root@robot ~]# /usr/bin/mysql_secure_installation
 
//////////////omitting text/////////////////////
 
Set root password? [Y/n] y
Remove anonymous users? [Y/n] y
Disallow root login remotely? [Y/n] y
Remove test database and access to it? [Y/n] y
Reload privilege tables now? [Y/n] y
Cleaning up...
 
All done!  If you've completed all of the above steps, your MySQL
installation should now be secure.
 
Thanks for using MySQL!</pre>
 
'''Test MySQL'''
 
As any user
<pre>[root@robot ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 5.1.58 Source distribution
 
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
mysql> show databases;
+--------------------+
| Database          |
+--------------------+
| information_schema |
| mysql             |
+--------------------+
2 rows in set (0.00 sec)
 
mysql> create database test;
Query OK, 1 row affected (0.01 sec)
mysql> use test
Database changed
mysql> use test;
Database changed
mysql> drop table if exists T;
Query OK, 0 rows affected, 1 warning (0.00 sec)
 
mysql> create table T (A text, B text);
insert into T values ('Hello,', 'world!');
select * from T;Query OK, 0 rows affected (0.06 sec)
 
mysql> insert into T values ('Hello,', 'world!');
Query OK, 1 row affected (0.00 sec)
 
mysql> select * from T;
+--------+--------+
| A      | B      |
+--------+--------+
| Hello, | world! |
+--------+--------+
1 row in set (0.00 sec)
 
mysql> \q
Bye</pre>


<center>[[Education|To Education]]</center>
<center>[[Education|To Education]]</center>

Latest revision as of 08:40, 23 October 2011

Class setup

Software setup for db-class

XML

Useful resources

W3Schools online introductions

Introduction to XML

Introduction to DTD

Introduction to XML Schema

Zvon.org online course

XML Tutorial

DTD Tutorial

W3C XML & XML Schema specifications

XML

XML Schemas

Relational Algebra

Relational algebra on Wikipedia

A commercially failed relational algebra database called Business System 12 on Wikipedia

Rel an open source relational database management system primarily used in teaching.

Relational Algebra portion of a database eLearning site.

Other Useful links

MySQL Reference Manual

Install MySQL on Fedora

To Education
Retrieved from "https://wiki.gotopinion.info/wiki/index.php?title=My_db-class.org_notes&oldid=1315"