Creating and Selecting a Database MySQL / General Guides
Before you can start creating tables you need to have a database.creates your database for you when setting up your permissions, you can begin using it. Otherwise, you need to create it yourself:
Build Your Own Database Driven Website Using PHP & MySQL: Part 4 MySQL / General Guides
you'll learn how to take information stored in a database and display it on a Web page for all to see. So far you have installed and learned the basics of MySQL, a relational database engine, and PHP, a server-side scripting language. Now you'll see how to use these two new tools together to create a true database-driven Web site!.
How To Set Up Database Replication In MySQL MySQL / Replication and Backup
This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync.
What is MySQL? MySQL / General Guides
MySQL is a freely available open source Relational Database Management System [RDBMS], a database engine of sorts that uses Structured Query Language (SQL). SQL is the most popular language for adding, accessing, and processing data in a database, and is most noted for its rapid processing, proven reliability, and ease and flexibility of use.
Backing Up And Restoring Your MySQL Database MySQL / Replication and Backup
If you've been using MySQL database to store your important data, it is imperative that you make a backup of your data to prevent any loss of data. This article shows you how to backup and restore data in your MySQL database. This process can also be used if you have to move your data to a new server.
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.
What is MySQL MySQL / General Guides
MySQL is a open source Relational Database Management System. MySQL is very fast reliable and flexible Database Management System. It provides a very high performance and it is multi threaded and multi user Relational Database management system.
What is SQL? MySQL / General Guides
What is SQL? SQL stands for Structured Query Language and is the lingua franca in the database world. SQL is a standard that is used by all database vendors and programmers to define, extract and access the information that is stored in databases.
Creating Users and Setting Permissions in MySQL MySQL / General Guides
MySQL is an extremely powerful database, but in order to properly maximize its potential you may need to learn how to set up users and their respective permissions. In this article take a look at using the MySQL console application to create users and grant permissions to them. We also shows us how to grant permissions from remote hosts, how to reduce user privledges and more. MySQL is an extremely powerful database, but in order to properly maximize its potential, you may need to learn how to set up users and their respective permissions.
Database Development MySQL / General Guides
Free to view, step by step, short tutorial on database development with MySQL. The tutorials have many flash illustrations, screen shots to get you started on MySQL the fastest and the easiest way.