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:633 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:566 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-20
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:552 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:504 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-19
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:492 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:421 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-20
Rate It | Error | Review |
|
| | | |
|---|
| MySQL Crash Tutorial
One of the most-used SQL tutorials in the world, with an emphasis on teaching what you really need to knowmethodically, systematically, and simply.
| | Hits:382 Rate: 4.0(out of 5) Vote:1 Submit Date :2006-03-19
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:351 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:351 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-19
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:340 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-03-20
Rate It | Error | Review |
|
| | | |
| |
Pages : 1 2 3 |
|
