Survival Kit for MYSQL for Joomla
1. What is a database a. Definition i. A database is an organized collection of data for one or more purposes, usually in digital form. ii. The term database is correctly applied to the data itself, and is different from the DBMS which is a software system that allows storing and changing the data, as well as retrieving information from it. iii. A database is typically organized according to general Data models that have evolved since the late 1960s. One of these types is Relational model which is used in Joomla. b. Discussion i. What do I need to know about database and table structure ii. Will I ever have to create new tables iii. Can I get help if I need it 2. How is a database used in Joomla a. Everything is stored in the database b. Except i. Pictures ii. Files like ftp and doc iii. General rule anything you have to upload is not part of the database 1. The database contains a pointer or a row in a table pointing to the file location for all uploaded items referenced from a page on the web site 3. What do I need to know to maintain the database a. How to access the database i. From Cpanel go to PHP MY Admin under databases b. Example of what changes i. Optimize 1. Why 2. What will Happen a. Before mnp_sobi2_cobj 29 MyISAM utf8_general_ci 474.5 KiB 20.3 KiB b. Command: OPTIMIZE TABLE `mnp_sobi2_cobj` c. After mnp_sobi2_cobj 29 MyISAM utf8_general_ci 454.2 KiB 3. When CopyrightŠ 2011 Times Two Technology LLP & Richard J. Dale Presented Joomla Chicago July 2011
4. 5. 6.
7. 8.
9.
10.
a. Using Cpanel c. Tools to fix or cleanup individual tables i. CHECK TABLE 1. Checks for errors ii. ANALYZE TABLE 1. keep the database working as efficiently as possible 2. Looks at indexes iii. OPTIMIZE TABLE 1. keep the database working as efficiently as possible 2. Combines extents and creates a larger base storage space iv. REPAIR TABLE 1. Can fix some errors found in check table Cpanel backup vs Akeeba Backup Do I need to have a dev site? When should I backup a. How much data are you willing to lose? b. Scheduled backups c. After making changes to Navigation or content d. Before adding any new components or plug-in e. Download files using FTP to not use feature in Akeeba or Cpanel You can backup and restore only the database a. Just because you can do something does not mean you should do it. Performance Tuning a. What is it? b. Should I worry about it? Sites referenced in the preparation of this presentation a. Akeeba Backup i. https://www.akeebabackup.com/ b. What is a database i. http://en.wikipedia.org/wiki/Database c. Repairing a database table i. http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html ii. http://www.techrepublic.com/article/checking-and-repairing-mysqltables/5193721 d. tuning a database i. http://www.webdevstuff.com/123/optimizing-mysql-performance-tuningscript.html Questions and Answers
CopyrightŠ 2011 Times Two Technology LLP & Richard J. Dale Presented Joomla Chicago July 2011