Learning MySQL

Whether you're running a business, keeping track of members andmeetings for a club, or just trying to organize a large and diversecollection of information, you'll find the MySQL database engineuseful for answering questions such as: Which are my top ten fastest-selling products?How freq...

Descripción completa

Detalles Bibliográficos
Autor principal: Tahaghoghi, Seyed M. M. (-)
Otros Autores: Williams, Hugh E.
Formato: Libro electrónico
Idioma:Inglés
Publicado: Beijing : O'Reilly 2007.
Edición:First edition
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627202006719
Tabla de Contenidos:
  • Table of Contents; Preface; Who This Book Is for; What's in the Book; Introduction; Using MySQL; Advanced Topics; Web Database Applications with PHP; Interacting with MySQL Using Perl; Appendix; Conventions Used in This Book; Resources; Using Code Examples; Safari® Enabled; How to Contact Us; Acknowledgments; Saied Tahaghoghi; Hugh Williams; Part I. Introduction; Chapter 1. Introduction; Why Is MySQL so Popular?; Elements of MySQL and Its Environment; The LAMP Platform; Structured Query Language; MySQL Software Covered in This Book; The Book's Web Site; Chapter 2. Installing MySQL
  • Installation Choices and PlatformsLinux; Live CDs; Windows; Mac OS X; So, What Should I Do?; Using the Command-Line Interface; The Linux and Mac OS X Shell; Command completion and history; Performing restricted operations; Restricting access to files and directories; The Windows Command Prompt; Command completion and history; Using a Text Editor; Following the Instructions in This Book; Downloading and Verifying Files from the MySQL AB Web Site; Downloading MySQL from the MySQL AB Web Site; Verifying Package Integrity with MD5; Installing Under Linux
  • Installing MySQL on Linux Using RPM Packages from MySQL ABInstalling MySQL on Linux Using a gzipped Tar Archive from MySQL AB; Installing MySQL on Linux by Compiling the Source Code from MySQL AB; Installing MySQL, Apache, PHP, and Perl on Linux Using Distribution Packages; Installation on Red Hat and Fedora Core; Installation on Mandriva; Installing under Debian-based systems; Uninstalling MySQL; Installing MySQL, Apache, PHP, and Perl on Linux Using the XAMPP Integrated Package; Configuring a Newly Installed Server; Configuring a server installed using RPM or Debian packages
  • Configuring a system-wide server installed from tarball or sourceConfiguring a local server; Configuring MySQL for automatic start; Installing Under Windows; Installing Only MySQL Using Packages from MySQL AB; Windows installation using the installer; Starting and stopping MySQL as a service; Starting and stopping MySQL from the command line; Installation with the "no-install" .zip Archive; Installing MySQL, Apache, PHP, and Perl on Windows Using the XAMPP Integrated Package; Installing Under Mac OS X; Installing only MySQL Using the Installer from MySQL AB; Configuring the installed server
  • Installing Only MySQL Using the no-installer Package from MySQL ABInstalling MySQL, Apache, PHP, and Perl on Mac OS X Using the XAMPP Integrated Package; Using a MySQL Installation Provided by an ISP; Upgrading an Existing MySQL Server; Should I Upgrade to MySQL 5.1?; How to Upgrade; Steps to Upgrade an Existing MySQL Server; Configuring Access to the MySQL Server; What If Things Don't Work?; Can't Download Files from Behind a Proxy; Error Message About MySQL Executable Programs Not Being Found or Recognized; Error Message Running mysql_install_db; Server Doesn't Start
  • Client Programs Can't Connect to the Server