Database MySQL Tips and Tutorials, Resources |
|
|
|
|
MySQL tutorials
|
|---|
 Optimize MySQL tables for speed
Just like you need to defrag and check your file system, it's important to do the same thing with MySQL tables. If you don't, you might end up with slow and corrupted database tables. Follow this easy tutorial to set up an automatic optimization for your db.
| | Hits:474 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-19
Rate It | Error | Review |
|
| | | |
|---|
| Backup MySQL With Cron Jobs
In this tutorial you will learn how to make and use a Cron Tab from within Cron Jobs installed on Cpanel. If your version of Cpanel does not contain Cron Jobs or your web host does not provide it there are other ways of using Cron Tabs but those shell methods will not be discussed in this tutorial.
| | Hits:464 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-19
Rate It | Error | Review |
|
| | | |
|---|
| Build Your Own Database Driven Website Using PHP & MySQL: Part 4
This final installment covers publishing MySQL data on the Web, connecting to MySQL with PHP, sending SQL queries with PHP, inserting data into the database, and even has a "homework" assignment. This book covers everything from installing PHP & MySQL under Windows or Linux, through to building a live Web-based content management system.
| | Hits:431 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-20
Rate It | Error | Review |
|
| | | |
|---|
| Optimizing MySQL Queries and Indexes
Building a database-driven site is one thing. But all too often your masterpiece starts performing like a donkey when it becomes popular. Learn how to optimize your queries and indexes in MySQL, and potentially speed up your application many times over.
| | Hits:382 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-19
Rate It | Error | Review |
|
| | | |
|---|
| Optimize MySQL tables for speed
How To Set Up Database Replication In MySQL
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.
| | Hits:372 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-19
Rate It | Error | Review |
|
| | | |
|---|
| Using SELECT to retrieve data
This tutorial deeply covers the SELECT statement of the T-SQL/SQL language. Starts from the basics - how to retrieve the values inside a column to ordering data, selecting multiple columns and then tables, joining them...
| | Hits:356 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-20
Rate It | Error | Review |
|
| | | |
|---|
| Creating and Using a Database
Now that you know how to enter commands, it's time to access a database.
| | Hits:301 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-20
Rate It | Error | Review |
|
| | | |
|---|
| MySQL: An Introduction
MySQL: An Introduction
A short introduction to MySQL that will get you started using php with it. It assumes a small amount of php knowledge.
| | Hits:298 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-20
Rate It | Error | Review |
|
| | | |
|---|
| Optimizing MySQL, Hardware and the Mysqld Variables
You've fine-tuned your indexes, and have optimized those queries to the bone. But still your MySQL database is crawling. It's time to look at tweaking the mysqld variables, what hardware improvements you can make, and how you can compile MySQL to run just that little bit faster.
| | Hits:291 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-20
Rate It | Error | Review |
|
| | | |
|---|
| Backing Up And Restoring Your MySQL Database
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.
| | Hits:288 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-19
Rate It | Error | Review |
|
| | | |
|
|---|
| Build Your Own Database Driven Website Using PHP & MySQL: Part 4
This final installment covers publishing MySQL data on the Web, connecting to MySQL with PHP, sending SQL queries with PHP, inserting data into the database, and even has a "homework" assignment. This book covers everything from installing PHP & MySQL under Windows or Linux, through to building a live Web-based content management system.
| | Hits:431 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-20
Rate It | Error | Review |
|
|
|---|
| Optimizing MySQL, Hardware and the Mysqld Variables
You've fine-tuned your indexes, and have optimized those queries to the bone. But still your MySQL database is crawling. It's time to look at tweaking the mysqld variables, what hardware improvements you can make, and how you can compile MySQL to run just that little bit faster.
| | Hits:291 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-20
Rate It | Error | Review |
|
|
|---|
| Using SELECT to retrieve data
This tutorial deeply covers the SELECT statement of the T-SQL/SQL language. Starts from the basics - how to retrieve the values inside a column to ordering data, selecting multiple columns and then tables, joining them...
| | Hits:356 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-20
Rate It | Error | Review |
|
|
|---|
| MySQL: An Introduction
MySQL: An Introduction
A short introduction to MySQL that will get you started using php with it. It assumes a small amount of php knowledge.
| | Hits:298 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-20
Rate It | Error | Review |
|
|
|---|
| Installing MySQL
Learn how to obtain and install MySQL.
| | Hits:251 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-20
Rate It | Error | Review |
|
|
|---|
| Introduction to MySQL
This chapter provides a tutorial introduction to MySQL by showing how to use the mysql client program to create and use a simple database.
| | Hits:252 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-20
Rate It | Error | Review |
|
|
|---|
| Connecting to and Disconnecting from the Server
Before you can start running your queries you need to get your client talking with your server.
| | Hits:191 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-20
Rate It | Error | Review |
|
|
|---|
| This section describes the basic principles of entering commands, using several queries you can try out to familiarise yourself with how mysql works.
| | Hits:164 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-20
Rate It | Error | Review |
|
|
|---|
| Creating and Using a Database
Now that you know how to enter commands, it's time to access a database.
| | Hits:301 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-20
Rate It | Error | Review |
|
|
|---|
| Creating and Using a Database
Now that you know how to enter commands, it's time to access a database.
| | Hits:112 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-20
Rate It | Error | Review |
|
|
WebmastersHome.com
Discussion about programming, SEO, WebHosting and more! |
|
Pages : 1 2 3 |
|
