Setting up WordPress in your Provider

WordPress is an open source blog tool and publishing platform powered by PHP and MySQL. (see http://en.wikipedia.org/wiki/WordPress). It's often customized into a Content Management System (CMS) wherein one can do their own personal publishing, add their own aesthetics yet still aligned to web standards. It is a free but very essential and priceless blogging software.

If you already have a domain account with PHP and MYSQL support then you should be able to get your WordPress up and running. Follow the following steps below:

PART I "WordPress Package"

1. Download WordPress from http://wordpress.org/download/


2. Unzip the package in one of your temporary directory

PART II "Your MYSQL Database"

1. Access your Administration Panel on your Domain


2. Create a Database and take note of its name


3. Record the username and password

PART III “WordPress Configuration”

1. Go back to the temp folder where you unpacked WordPress


2. Open the file wp-config-sample.php with a notepad or Dreamweaver


3. Edit the following:
   
   define('DB_NAME', ‘NameOfYourDatabase’);
   
   define('DB_USER', 'DatabaseUserName');
   
   define('DB_PASSWORD', 'DatabaseUserNamePassword');
   
   define('DB_HOST', '127.0.0.1');


4. Save the edited file as wp-config.php

PART IV "Uploading WordPress to your Web Server (Externally hosted)

1. Using your favorite FTP program connect to your website.


2. At the html level directory create a blog folder.


3. Example: /var/www/html/blog/


4. upload the WordPress files to that blog folder.

PART V "PHP Configuration"

1. Using your web browser, access http://www.yourdomain.com/blog/wp-admin/install.php to initiate the installation process.


2. Once WordPress comes up click “First Step”


3. Enter the title of your Web Log and enter your email address


4. Click continue to Second Step


5. Note the password generated


6. Click on the login address wp-login.php to access your WordPress Account.

Sponsored by: www.cartizgis.com

MySQL Admin on XAMPP

Introduction

XAMPP is a very cool package that integrates Apache, MYSQL and PHP all at once without you going into the hassle of the individual installation configuration of PHP, Apache and MYSQL. There are some issues though for those who are used to using the MySQL Admin in administering the MYSQL Database. When you install XAMPP the MySQL Admin gui is not included in the installation. Although most of the time you can use the PhpMyAdmin with your database, there are times where in you need more refined administration of the database through MySqlAdmin. In order for the MySqlAdmin to work with the XAMPP configuration you need to do the following.

Procedures:

1. Download the MySql GUI Tools from http://dev.mysql.com/downloads/gui-tools/5.0.html
   Find the appropriate GUI based on your system. With my installation I have the Windows x86. Save and install the program.
2. To install the MySql GUI Tool you need to install using the custom installation. Then place its directory under the directory of XAMPP mysql installation. In my case the XAMPP mysql is in D:\xampp\mysql. So for the installation of the MySql GUI Tools I had to use: D:\xampp\mysql\MySQL Tools for 5.0
   The purpose of this installation is to help MySqlAdmin to locate the MySql Database without you tampering the configuration file.
3. Start your MySqlAdmin from the All Programs Menu and just enter the information needed to start the MySQL Database. User: root. For the password there should be no password if you haven't changed anything in http://localhost/security/index.php

For more information contact jnoel@cartizgis.com

Url: http://www.cartizgis.com

Configurng Apache

http://webhosting.devshed.com/c/a/Web-Hosting-HowTos/Configuring-Apache-2-0-Beginning/

Apache and ASP

1. ASP pages made in PERL: http://www.bluereef.net/support/extensions/development/asp/index.html
2. ASP to PHP conversion: http://asp2php.naken.cc/ - http://asp2php.naken.cc/download.php
3. Apache::ASP 2.57 for Windows 2000/XP : http://www.devside.net/web/server/windows/apache-asp

Running your own web server

well you dont really need an uptight comp to run your own server i mean its so simple i run to instances of apache on on the default port and the other on port 3000 and they all jus take up 40mb ram each so you see its not that hard well heres part two.
to run your own server you are gonna need.
a server software apache preferable
perl. mysql and python (these are optional)
also if you wish to run a web hosting company you gonna need a webhosting control panel.
a mail server
a ftp server
and the most important thing about running your own server is to have it accessible to other people to see it, and this you are gonna need, a dynamic dns client software and a dynaminc dns provider.


you see when you are on a dial up network your ip address changes every time and you need the dynamin dns client to update you ip to the dynamic dns provider every time it changes.

well sorry for all the linux people but this article is jus gonna really focus on poeple running windows coz when it comes to servers everybody knows that windows people have a disadvantage.


so next im gonna show you 5 simple ways you could get your server online and working

1..download the tsw{the saing wamp}thats basically an acronym for windows apache and mysql / perl installer. it will do everything for the configuration of all that crap and save you days of headaches. trust me been there. you could download this from tsw the saint wamp download page
that is there latest version and it features most of the features i mentioned on the first article. and please note that it also features php 5.

2...just make sure that when you are installing it you do not install the services that it the ftp server and the mail server they got there coz they not so user friendly i will tell you which ones to use . for your mails server i stronly recommend that you use.hmail server and you can find that here. hmail server .com and for the ftp server you could possibly go for cerrubus ftp server according to me its the best just use you favourite search engine to find that.

3....configure both the ftp server and the mails server . that should be a walk through. its really easy .

4....dynamic dns...<> first get a uni.cc account. another domain that is and in the domain setup point it out to dns option. then point the external dns servers to ns1.afraid.org
ns2.afraid.org
then go to www.afraid.organd register for a dns account and add your uni.cc domain name . it will probably take some time for the dns servers to change so be patient. then from there you can configure dynamic dns for your domain name. and for the dns client i insist you use dynsite for window. its the best and the easitest to use.

5..everything is done you got your own domain name webserver and everything there is nothing that the server you just setup . cannot run its mega featured lol. take my word for it.for the webhosting control panel for people using windows there is this great one called the zpanel you can grab it at www.thezpanel.com its for people using windows.

well if you have a problem with setting up any of the above esp the dns (trust me that can really be hektic. )just pm or post in this forum ill be sure to help. well there have fun running your own server.....
if you need any other thing jus pm me i'll be glad to help you..

Reference: http://www.trap17.com/index.php/webservers-ever-thought-running-yours_t424.html

FieldType Comparison MS Access, SQL, Paradox, VBA, Delphi

Url Link: http://68.165.245.242/user/clemenzi/technical/Databases/FieldTypes.html

Quick Comparison

SQL is "supposed" to be a standard. However, the reality is that there are many different versions. The following table only shows a "few" possibilities.

	Paradox	MS Access	SQL	Delphi	Visual Basic
Text	A	Text	TEXT, ALPHANUMERIC, CHAR, CHARACTER, STRING, VARCHAR	TStringField, TWideStringField	String
1 Byte Int	ns	Number/Byte	BYTE	TBytesField	Byte
2 Byte Int	S	Number/Integer	SHORT	TSmallIntField, TWordField	Integer
4 Byte int	I	Number/Long Integer	LONG, INT, INTEGER	TIntegerField	Long
8 Byte int	ns	ns	?	TLargeIntField	?
4 Byte Float	N	Number/Single	SINGLE, REAL	?	Single
8 Byte Float	ns	Number/Double	DOUBLE, FLOAT, NUMBER	TFloatField	Double
Autoincrement	+	AutoNumber	COUNTER	TAutoIncField	Long
Date/Time	@	Date/Time	DATETIME, TIMESTAMP	TDateTimeField	Date
Date	D	ns	DATE	TDateField	Date
Time	T	ns	TIME	TTimeField	Date
Memo	M	Memo	LONGTEXT, LONGCHAR, MEMO, NOTE	TMemoField	String
Formatted Memo	F	ns	ns	?	ns
Binary	B	ns	BINARY	TBlobField, TGraphicField, TBytesField, TVarBytesField	ns
Boolean	L	Yes/No	BOOLEAN	TBooleanField	Boolean

ns - Not Supported

MYSQL Error 13 when dropping tables

url link: http://dev.mysql.com/doc/refman/5.0/en/file-permissions.html
http://lists.mysql.com/mysql/83797

PHP Runner

http://www.xlinesoft.com/phprunner/index.htm
PHPRunner builds visually appealing web interface for any local or remote MySQL, MS Access, SQL Server and Oracle databases. Your web site visitors will be able to easily search, add, edit, delete and export data in your database. Advanced security options allow to build password-protected members only Web sites easily. PHPRunner is simple to learn so you can build your first project in just fifteen minutes.

Features:

Easy to use wizard-like interface.
Numerous search modes.
Add, view, edit, copy and delete pages.
Built-in FTP Client to upload PHP pages to the Web server.
Multilingual templates. Ability to choose language while logging in.
Creates password protected PHP pages.
User self-register page, password reminder, change password pages.

Benefits of using PHPRunner are:

Can save you time and money.
Improve functionality of your web site.
Create robust, easy to modify code.
Easy to use, you can generate your first PHP web site in just fifteen minutes.
No programming required.

What PHPRunner can do for me:

Collect user's information.
Phone/address book.
News articles.
Products listing.
Web-based database searching & data entry.
Web-based reporting.
Members only password protected web sites.

Build your own server

Starting Out

Before you begin to install Windows 2000 Professional on the older computer, be sure that there are no data files or other important information still being stored on that old computer. Also, make sure you have your Windows 2000 CD and serial number ready. Be sure that you are prepared to sit and attend a 1-2 hour installation process.

More reading:

url: http://www.hotscripts.com/PHP/Scripts_and_Programs/Database_Tools/more8.html

Installing your own Linux Server

Most people think that you need both money and technical skills to set up a Web server. Well folks, the fact of the matter is you don't need either. That's right, you don't need a dime. And who wants to spend all that time gaining skills? Learning can be such a drag. With nothing more than some charm and a copy of this article, you'll be serving up Web pages from a box outfitted with Linux and the most recent versions of Apache Web server, Perl, and Python in a few hours.

The first thing you're going to need to do is get your hands on some free stuff. Here's a rundown of the tools you'll need and some methods for getting them free - and legally.

• A PC - 486-33 or better, 500 MB hard drive, and 16 MB of RAM. Most charities won't even take these. In fact, you're likely to find one in a garbage can outside a large company. I'll assume for the purposes of these instructions that this box contains some version of Microsoft Windows.
• An Ethernet patch cable. At work, follow your sysadmin around for about 20 minutes; she's going to leave one of these lying around at some point.
• Three floppy disks. You've been saving the AOL mailings, haven't you?
• A domain name. I happen to have the privilege of serving the Webmonkey's own illustrious Mattmarg.com. There are some people out there who have registered dozens of domain names. All you need to do is scribble the name Brent Spiner on a scrap of paper and offer it as an even trade.
• Here's the doozy: Access to a high-speed connection along with the following: IP Address, Netmask, Default Gateway, and Nameserver IP. This is stuff you're going to need to get from a sysadmin. Most businesses with high-speed Internet access have more bandwidth and IP addresses than they can use. It's your task to liberate these resources from their overlords. If you've got good skills, offer some of your time. If you're attractive, try flirting. And if you're ugly and inept, try bribery. Or to keep things really low-cost, offer a bribe, record it, then blackmail the SOB.

It's also worth mentioning that the cost of DSL connections is plummeting. Here in the San Francisco Bay Area, service is offered for about US$40 a month. These are "always on" connections, so if you can buy an additional IP address, you could serve out of your home while still having the resources to browse, email, and all that other good stuff.

Once you finish your tool-gathering, we'll be ready to start. If you have a T1 connection and can proceed without snags, setup will take about two hours. However, to be safe, set aside most of a day.

But before you act, you should know your hardware. Tear open the case and take a look inside. The most important piece of information is your Ethernet card type. Write it down. The model number and manufacturers name should be visible with a flashlight. Linux is not like Windows, where you can shove in any $8 card. There are only a couple of dozen network cards that will work. I did my install with a 3Com 3c509b. I strongly suggest you get yourself a 3Com before you attempt this.

These instructions will not allow for dual booting. When done, this will be a Linux box and nothing else.

Though you don't really need to know Linux to get this working, it definitely wouldn't hurt. Linux rules. When you have this box functioning, take some time and learn it.

More on:
url: http://webmonkey.wired.com/webmonkey/99/08/index3a.html