Database MySQL Tips and Tutorials, Resources

MySQL tutorials

Optimize MySQL tables for speed  By 999tutorials Rate It  | Review 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:649    Rate:  1.0(out of 5)    Vote:1   Submit Date :2006-03-19   Rate It   |  Error   |  Review

Build Your Own Database Driven Website Using PHP & MySQL: Pa  By databasejournal Rate It  | 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:583    Rate:  0.0(out of 5)    Vote:0   Submit Date :2006-03-20   Rate It   |  Error   |  Review

Backup MySQL With Cron Jobs  By pbkill Rate It  | 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:562    Rate:  0.0(out of 5)    Vote:0   Submit Date :2006-03-19   Rate It   |  Error   |  Review

How To Set Up Database Replication In MySQL  By howtoforge Rate It  | 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:528    Rate:  0.0(out of 5)    Vote:0   Submit Date :2006-03-19   Rate It   |  Error   |  Review

Optimizing MySQL Queries and Indexes  By databasejournal Rate It  | 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:515    Rate:  0.0(out of 5)    Vote:0   Submit Date :2006-03-19   Rate It   |  Error   |  Review

Using SELECT to retrieve data  By geekpedia Rate It  | 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:429    Rate:  0.0(out of 5)    Vote:0   Submit Date :2006-03-20   Rate It   |  Error   |  Review

MySQL Crash Tutorial  By brainbell Rate It  | 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:399    Rate:  4.0(out of 5)    Vote:1   Submit Date :2006-03-19   Rate It   |  Error   |  Review

Backing Up And Restoring Your MySQL Database  By codebeach Rate It  | 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:370    Rate:  0.0(out of 5)    Vote:0   Submit Date :2006-03-19   Rate It   |  Error   |  Review

Optimizing MySQL, Hardware and the Mysqld Variables  By databasejournal Rate It  | 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:366    Rate:  0.0(out of 5)    Vote:0   Submit Date :2006-03-20   Rate It   |  Error   |  Review

MySQL: An Introduction  By whedimer Rate It  | 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:353    Rate:  0.0(out of 5)    Vote:0   Submit Date :2006-03-20   Rate It   |  Error   |  Review