MySQL Configuration MySQL / General Guides
In this lesson you will read about the configuration of MySQL. The MySQL server configuration normally started during installation process.
Examining MySQL Certification MySQL / General Guides
To overlook MySQL in the world of certification would be a grave injustice. Not only does the topic of the "world's most popular open source database" crop up here and there on miscellaneous Linux/LAMP exams, but there will also be four certifications specific to it...
MySQL System Architecture MySQL / General Guides
In this article, we're going to take a look at MySQL internals. It will be a fun, informative examination of how all the different pieces and parts of the MySQL server operate together.
Select Record MySQL / General Guides
This tutorial will show you how to get records in your table in database to show on your PHP files. This SQL statement has many options.
Using MySQL Programs MySQL / General Guides
This chapter provides a brief overview of the command-line programs provided by MySQL AB and discusses the general syntax for specifying options when you run these programs. Most programs have options that are specific to their own operation, but the option syntax is similar for all of them. Later chapters provide more detailed descriptions of individual programs, including which options they recognize.
Database Maintenance MySQL / General Guides
Use the command line mysqldump utility to dump all database contents to an external file. This utility should ideally be run before regular backups occur so the dumped file will be backed up properly. The command line mysqlhotcopy utility can be used to copy all data from a database (this one is not supported by all database engines). You can also use MySQL to dump all data to an external file using BACKUP TABLE or SELECT INTO OUTFILE. Both statements take the name of a system file to be created, and that file must not already exist or an error will be generated. Data can be restored using RESTORE TABLE.
Working with SQL Server MySQL / General Guides
In this lesson, you'll learn how to connect and log into SQL Server, how to issue SQL Server statements, and how to obtain information about databases and tables.