Mysql Articles

1). PHPBB: You Can Simplify the Set Up Process! By : Matthew C. Keegan
In several previous articles I mentioned my having downloaded and installed the fantastic PHPBB open source forum. I shared with readers the lengthy and tedious process of selecting the right mirror, downloading the files to my computer, and following all the long, drawn out, and complicated set up steps. Fortunately, what was once a procedure that took the better part of a day can now take 30 minutes or less to complete! Let’s take a look how you can shorten the entire set up process and start benefiting from this free, popular program.
Article Related to: phpbb, phpbb2, php, mysql, web host, vbulletin, invision boards, ezboard, forums, message boards

2). Tutorial - Enabling IIS 5.1 on Windows XP Pro By : C Alexander
Windows XP Home Edition does not support IIS 1. You may need to put your Windows XP Pro CD into the PC. 2. Go to Control Panel, ‘Add Remove Programs’, then ‘Add/Remove Windows Components’. In the Windows Components window, place a check mark beside ‘Internet Information Services (IIS)’, then click next, then click finish. 3. During installation, Windows creates a directory at C:inetpubwwwroot and places a few files there.
Article Related to: php, mysql, tutorial, iis, web, server, windows, xp, pro

3). Cpanel downgrade MYSQL 4.1.X to MySQL 4.0.xx By : webhosting-live.com
I have ordered a new server Centos 4.3 with Cpanel WHM 10.8.0 cPanel 10.8.2-R119. When I have transfered old server all accounts to this new server, Some sites mysql database had a few problems. I found the new server is MySQL 4.1.xx and my old server is MySQL 4.0.xx. So i decide to downgrade MYSQL 4.1.X to MySQL 4.0.xx. cPanel Tweak Settings only have MYSQL 4.
Article Related to: cpanel, linux, mysql

4). Taking advantage of Open Source PHP MySQL applications By : tcwicks
One obvious solution is to approach a software development company and obtain a custom built product. However to take this approach one needs to first know what features and functionality is desired. Then on the other hand in some instances the need does not warrant the cost of commissioning a custom application. A plethora of free open source web applications exist today.
Article Related to: opensource, open, source, php, mysql, gpl, free, web, application, applications, howto, install, evaluate

5). PHPBB2: A Tapestry of World Languages By : Matthew C. Keegan
Several of my related articles about PHPBB2, the open source program that helps webmasters create and maintain internet forums, touched on many of the technical aspects of the program. What you may not know is that PHPBB2 has a worldwide audience with the potential to reach more than half of the world’s population in their native language. Chalk it up to a combination of expert programmers and wonderful translators who have made this feat a reality.
Article Related to: phpbb, mysql, vbulletin, ezboard, invision board, ikonboard, message boards, forums, online chatrooms

6). How To Block Sites Access Manually By : Monx Digital Library
If you're using Windows Operating System and didn't use Proxy to connect to the internet, then search for the 'hosts' file or if you use Windows XP and use Windows XP standard installation, you can find the file at C:WINDOWSsystem32driversetchosts These file used as a mapping site URL to your localhost IP. You can use this trick to block sites access and also blocking ads sites, so you can surf the internet faster.
Article Related to: install, apache, mysql, php, phpmyadmin, zend optimizer, windows xp

7). ASP vs. PHP By : Halstatt Pires
When building web sites, ASP and PHP are very popular languages. Here’s my opinion on whether ASP or PHP is best ASP v. PHP Both ASP and PHP are languages used to build Dynamic Web sites that can interact with Databases and exchange information. ASP (Active Server Pages) is from Microsoft and is used with IIS (Internet Information Server) that runs on Microsoft Servers.
Article Related to: asp, php, mysql, windows server, building a web site, c++, visual basic, microsoft, ms-sql

8). Using XSAS to develop multiple XOOPS sites locally By : JMorris
This tutorial provides step-by-step instructions for how to develop multiple XOOPS websites locally using XSAS (XOOPS Stand Alone Server). I use this information pretty much on a daily basis, and I hope you find it helpful, too. As always, I welcome any feedback or suggestions you may have. (It is assumed that the reader has a basic knowledge of folder structures, permission settings, how to perform basic operations in phpMyAdmin, and of course, how to install XOOPS.
Article Related to: xoops, xsas, localhost, phpmyadmin, mysql, cms, standalone server, web development, mywebresource

9). Small Business Web Hosting: 11 Points Checklist By : Sergio Roth
There is a lot of information about web hosting. Thousands of different companies and plans. It is often hard to decide on what will fit you best, especially when you do not understand all the hosting related terminology. So what should you do then? Close your eyes and pick a company? Pick the cheapest one? The average one? I will try to help you make your decision in this article, by providing a checklist of the items you should consider when choosing a hosting company for your small business website.
Article Related to: web hosting, hosting, small business, internet, programming, website, domains, linux, php, mysql

11). Read This Before You Redesign Your Database! By : Mukul Gupta
As business evolves, the information that they store and process also changes and that means the underlying database structures that have been holding well for many years needs to be changed as well. This are even more complicated when you have redesign an “in use” system. Here is a step by step guide on what needs to be done: Step 1: Draw the structure of the new database on Paper Based on the new business requirements, you need to draw the structure of the new database on paper.
Article Related to: mysql, database redesign

12). Improve the performance of your MySQL Server By : Mukul Gupta
MySQL is a rock solid, lighting fast database server which has been designed for two factors speed and performance. It is the Ferrari of databases: Light weight, fast and Built for the high speed tracks! I still hear an awful lot of stories from owners whose databases are running two slow. In my experience, the three main places to look for problems are: 1.
Article Related to: mysql, performance optimization, tuning, query.