.: MySQL Top Related Articles
1). Tutorial - Enabling IIS 5.1 on Windows XP Pro
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 tags: php, mysql, tutorial, iis, web, server, windows, xp, pro
2). PHPBB: You Can Simplify the Set Up Process!
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 tags: phpbb, phpbb2, php, mysql, web host, vbulletin, invision boards, ezboard, forums, message boards
3). Cpanel downgrade MYSQL 4.1.X to MySQL 4.0.xx
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 tags: cpanel, linux, mysql
4). Taking advantage of Open Source PHP MySQL applications
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 tags: opensource, open, source, php, mysql, gpl, free, web, application, applications, howto, install, evaluate
5). Using XSAS to develop multiple XOOPS sites locally
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 tags: xoops, xsas, localhost, phpmyadmin, mysql, cms, standalone server, web development, mywebresource
6). Way's To Sky-Rocket Your Profits
Way's To Sky-Rocket Your Profits
Article tags: hosting, host, web host, web hosting, domain, domain name, bandwidth, email, pop3 email, web space, control panel, cpanel, mysql, php, frontpage, web site builder, ssl
7). Read This Before You Redesign Your Database!
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 tags: mysql, database redesign
8). PHPBB2: A Tapestry of World Languages
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 tags: phpbb, mysql, vbulletin, ezboard, invision board, ikonboard, message boards, forums, online chatrooms
9). Small Business Web Hosting: 11 Points Checklist
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 tags: web hosting, hosting, small business, internet, programming, website, domains, linux, php, mysql
10). ASP vs. PHP
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 tags: asp, php, mysql, windows server, building a web site, c++, visual basic, microsoft, ms-sql
11). Improve the performance of your MySQL Server
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 tags: mysql, performance optimization, tuning, query.
12). How To Block Sites Access Manually
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 tags: install, apache, mysql, php, phpmyadmin, zend optimizer, windows xp