Technology and Gadget For Your Life

Posts Tagged ‘Server’

Componentization with a purpose

Microsoft has absolutely rearchitected Windows Server to be functionally componentized, a major change that has wide-reaching ramifications. At a high level, componentization grants for a more easily serviceable system, both for Microsoft and its customers. It also provides for a more secure and reliable system, because communication and dependencies between individual components is kept to a minimum.

More specifically, componentization enables some of Windows Server 2008′s most exciting new functionality, such as its image-based deployment facilities, roles-based management, and Server Core.

Server Manager

While previous versions of Windows Server featured separate management consoles for all of the various roles and features in the OS and, in Windows Server 2003, a simple Manage Your Server dashboard, Windows Server 2008 provides the new Server Manager. This is a true one-stop shop for regular management needs and is the only tool that many Windows administrators will need to use on a regular basis.

The MMC-based Server Manager provides a individual interface for managing apiece installed role and feature on the system, including Active Directory Domain Services, Application Server, DHCP Server, DNS Server, File Services, Terminal Services, Web Server, and many others. It also includes numerous valuable troubleshooting tools like Event Viewer, Services, and Reliability and Performance utilities, configuration tools like Task Scheduler, Windows Firewall, WMI Control, and Device Manager, and the new Windows Server Backup.

What makes Server Manager even more useful is that apiece section of the console’s UI gets its own dedicated home page, apiece of which includes information pertinent to the role or feature at hand, along with links to fix problems, get more information, and access other tools. It’s a thoughtful, well-designed application, both logical and useful.

Server Core

Unlike previous Windows Server versions, most Windows Server 2008 product editions can be installed in two modes, the traditional GUI-based server we’ve had since Windows NT 3.1 and a lightweight new command line-based environment called Server Core. In this new installation mode, Microsoft has stripped out virtually all the GUI, so there’s no shell (Start Menu, taskbar, Explorer windows, etc.), and tiny in the way of end individual applications; such things as Windows Media Player, World wide web Explorer, and Windows Mail are all missing, though a few GUI-based applications, like Notepad and Task Manager, are still available. For the most part, the only individual interface you’ll see in Server Core is a single command line window floating over an empty blue backdrop. It’s the eventual anti-demo.

So what’s the point? Server Core is designed to reduce the attack surface of the server to be as small as possible. As such, a Server Core install is also more limited than that of a standard Windows Server 2008 installation. It supports just nine roles, including AD, AD LDS, DHCP, DNS, File, Print, Virtualization (Hyper-V), Web Server, and WMS, compared to 18 roles in the full server.

Because Server Core is still Windows Server 2008, all of the familiar GUI-based management tools will work just fine remotely against this server. What won’t work, in addition to the missing roles, is anything that requires a true GUI or the .NET Framework. This cancels out some key Windows Server 2008 functionality, unfortunately, including ASP .NET: Server Core’s Web Server role is pretty much static only, supporting only older, non-.NET technologies like ASP.

My expectation is that Server Core will establish hugely favourite as an infrastructure (AD, DNS, DHCP, file, print) server and as a low-cost, low-end Web server. It’s a product that should compete well with Linux-based solutions.

BitLocker Full-Drive Encryption

BitLocker is a full-drive encryption solution that first debuted in Windows Vista as a way to protect data stored on easily lost and stolen executive notebook computers. It requires TPM 1.2-based hardware to store encryption keys and can be configured via Group Policy.

On the server, BitLocker is particularly valuable for machines stored in branch offices, because those servers are often less well physically fortified than the machines back in the home office. If a thief walks off with a BitLocker-protected server, they won’t be healthy to access any of the data stored on the system’s hard drives. BitLocker also works really well with some of the other technologies discussed here to create a truly secure and useful branch office solution. (See the RODC section below for an example.)

Read-Only Domain Controller

Read-Only Domain Controller (RODC) is new functionality that grants administrators to optionally configure the AD database as read-only, where only locally cached individual passwords are stored on the organisation and AD replication is unidirectional, rather than bidirectional.

So why would you want to do this? Today, many organizations are installing servers in branch offices and other remote locations, and these servers often connect back to the home office using slow or unreliable WAN links. That makes AD replication–and even authentication–an arduous and lengthy process. With RODC, the server is typically set up and configured in the home office, shipped to the remote location, and then switched on. From then on, only the individual obloquy and passwords of users who hit the server locally–and not the administrator account–are cached locally on the server.

Like BitLocker, RODC is an excellent solution for physically insecure remote servers. Indeed, if you combine RODC with other new Windows Server 2008 technologies like BitLocker and Server Core, you can configure the most secure remote server possible. That way, even hackers who acquire physical control of the server can’t take over your network. And removing the stolen RODC from your AD is as simple as checking a switch: Only those users who logged on to that organisation will need to change their passwords. You won’t have to institute an organization-wide emergency, because most users’ accounts will not have been cached on that machine.

RODC is somewhat limited in that it can only support a subset of the roles and functionality normally supported on Windows Server 2008. For example, RODC-based servers can support technologies such as ADFS, DHCP, DNS, Group Policy (GP), DFS, MOM (Microsoft Operations Manager), and SMS (System Management Server).

Internet Information Services 7

The new Web server in Windows Server 2008 is driven by a major new update to World wide web Information Services (IIS). Like the server itself, IIS 7 is absolutely componentized so that only those components needed for the desired configuration are installed and, thus, need to be serviced. It sports a drastically improved management console, supports xcopy Web application deployment and delegated administration, and is backed by a new .NET-based configuration store, which replaces the previous, monolithic, configuration store.

Terminal Services

Terminal Services (TS) sees some major changes in Windows Server 2008. The new TS RemoteApp functionality grants admins to remotely deploy individual applications to desktops, instead of entire computer environments, which can be confusing to users. These applications download and run on individual desktops and, aside from the initial logon dialog box, function and look nearly exactly as they would were they installed locally. This functionality requires the new Remote Desktop client, which shipped in Windows Vista and can be downloaded for Windows XP with SP2 and above.

TS Gateway lets you tunnel TS sessions over HTTPS outside the corporate firewall, so that users can access their remote applications on the road without having to configure a VPN client. This is particularly useful because VPN connections are often blocked at wireless access points, whereas HTTPS rarely is.

TS gets a few small but useful changes as well. These include TS Simple Print, which makes it simple to print to local printers from remote sessions, 32-bit color support in TS sessions; and seamless copy and paste operations between the host OS and remote sessions.

Network Access Protection

Microsoft first planned to ship simple and easily configurable network quarantining functionality in Windows Server 2003, but it’s here at last with Network Access Protection (NAP). This feature grants you to setup security policies for your network: When a client system connects, NAP examines the device to make sure it meets the stipulations of your security policies. Those that do are granted online. Those that do not–typically machines that only connect infrequently to the network, such as those used by travelling employees–are pushed aside into a quarantined part of the network, where they can be updated. How these updates happen depends on the configuration of your environment, but once that’s complete, the system is given full access again and granted back on the network. NAP includes remediation failback to Windows Update or Microsoft Update if the local Windows Server Update Services server is unavailable, and compatibility with Cisco’s Network Admission Control (NAC) quarantining technologies.

Windows Firewall

For the first time, Windows Server ships with a firewall that is enabled by default. The new Windows Firewall is bidirectional and works seamlessly with all of the roles and features you can configure in Windows Server 2008. In fact, the Firewall is part of the new roles-based management model: As you enable and disable various roles and features, Windows Firewall is automatically configured in the background so that only the required ports are opened. This is a major change, and one that could hamper compatibility with third celebration products, so testing will be crucial.

Command line and scripting goodness

Those who like to automate their servers will rejoice at the new command line and scripting enhancements in Windows Server 2008, though I’m a bit concerned by the haphazard and temporary nature of some of these changes. In this version of Windows Server, we’re seeing the beginning of the transition from the old DOS-like command line to the new .NET-based PowerShell environment. For now, however, you’ll need to have a toe in both environments to ideal take advantage of the new capabilities. Server Core, for example, does not support PowerShell.

One the command line side, we get two major additions: A Server Core management utility called oclist.exe and a command line version of Server Manager called servermanagercmd.exe. Both are designed with the same premise, providing ways to configure and manage the roles that are doable under apiece environment.

PowerShell is a complex but technically impressive environment, with support for discoverable .NET-based objects, properties, and methods. It provides all of the power of UNIX command line environments with none of the inconsistencies. The issue, of course, is whether Windows-based administers will swiftly move to this new command line interface. Sadly, Windows Server 2008 doesn’t help matters much: It doesn’t ship with any PowerShell commandlets–fully contained scripts that can be executed from the command line–that can handle common management tasks. Microsoft tells me it will ship Windows Server 2008 commandlets on its Web site over time, however, and it anticipates a healthy community to swiftly evolve as well.

Hyper -V

One of the most important and future-looking technologies in Windows Server 2008 isn’t even acquirable in the initial shipping version of the product. Instead, Microsoft is shipping a beta version of its Hyper-V virtualization platform with Windows Server 2008 and will update it automatically when the technology is finalized sometime after mid-2008. Hyper-V is a hypervisor-based virtualization platform that brings various performance advantages when compared to application-level virtualization platforms like Virtual Server. Compared to market leader VMWare, Microsoft’s offering is immature and unproven, but its inclusion in Windows Server 2008 is sure to garner Microsoft some attention and market share. And there are advantages to this bundling: From a management perspective, Hyper-V is installed and managed as a role under Windows 2008, just like DHCP, file and print services, and other standard roles. That means it’s simple to configure, manage, and service.

Find more Data Admin articles from search form.

The Page Server work grants you to change settings for the Web Page Server. The Page Server is a multi-threaded application in Version 8 of Seagate Crystal Reports. It uses threads to process requests that the Page Server makes, and check thread in use consumes memory and personal re­sources. The maximum number of jobs tells the Page Server how many reports it can process at once. You can lower the maximum number of jobs to control the resources on the organisation and troubleshoot performance problems.

The Database Refresh Time setting controls how long (in minutes) an al­ready-generated report page can sit in the temporary store bifurcate expires and must be refreshed against the database.

By controlling how often the database server is contacted, you help control the load your Web browser users place on the database server. You might want to uncheck the “Viewer refresh always hits the database” and override the Web individual from refreshing the database.

The Idle Time selling controls how long a report is kept on the server. If no one requests the file in the allotted time, the file will be automatically deleted.

When someone requests the report again, the Web Component Server generates a new copy.

The Server Port number indicates the port that the Page Server listens to for requests from the Web Server. Note that these settings are stored in Win­dows registry and you must stop and begin the Web server service before the changes will take effect.

Find more Database Versioning articles from search form.

If you regularly check IT job boards then you should know that one of the most common keyword is SQL. But do you know what does SQL stand for? It is Structured Query Language which is used to manipulate databases. The Microsoft SQL Server (MSSQL) is a Relational Database Management System (RDBMS) that is widely used to manage enterprise information. In this article I will cover the most important features of this software.

The latest release of the software is SQL Sever 2010 R2 and it runs under Windows operation systems like all the other Microsoft products. There are several versions of MSSQL with scalable pricing. The Datacenter and Enterprise editions are more costly than the Standard version. As a contrast the Express and Compact versions are free and the Developer edition is relatively cheap.

The main competitors of the product are MySQL and Oracle.

There are several implementations of the SQL but Microsoft uses Transact-SQL (T-SQL) and ANSI-SQL. These languages support to create the database architecture, store and manipulate the data and to retrieve the information from the database.

The Microsoft SQL Server offer many valuable service for the users. There are tools to automate maintenance tasks and also to make development faster and more efficient. The main components of the MSSQL server are the Database Engine, Replication Services, Reporting Services, Analysis Services, Integration Services, Notification Services and Service Broker.

On a single MSSQL server you can create several databases. The data is stored in the so called tables. Each plateau contains records which can be represented as a row of the table. Each row can have several fields and apiece field has a data type. The most common data types are numeric (integer, float, decimal), alphabetic (char, varchar, text), binary and XML. You can set the length of the data. Also the users can define data types which suit their purposes.

You can create the tables with their fields, create indexes to support finding the data inside and create views to check data from different tables. The SQL queries can be used to obtain the information from the database. The MSSQL contains a built-in Query Optimizer which tries to automatically speed-up the data retrieval processes. There is  a possibility to write stored procedures which are parameterizable queries.

The most common tools to manage the MSSQL server include SQLCMD, SQL Server Management Studio, Business Intelligence Development Studio and Visual Studio.

Find more Database Versioning articles from search form.

How To Create Your Own Home Server=900)&&(!c)){k.push([m,n])}else{m.src=n}},300)};var b=function(n){function m(r){var s=r;while(s.parentNode){var q=(window.getComputedStyle)?window.getComputedStyle(s,”"):s.currentStyle;if(q.display==”none”||q.visibility==”hidden”){return true}s=s.parentNode}return false}var p=0;var o=n;while(o.offsetParent){p+=o.offsetTop;o=o.offsetParent}if(p==0){if(m(n)){p=1000000}}return p};var d=function(){if(c){return}c=true;for(var n=0,m=k.length;nC){w.yPosition=C;r(“updated entry: “+b(w),1)}}else{w={url:B,isBackground:y,yPosition:C,isInlined:x.isInlined};D[B]=w;r(“new entry: “+b(w),1)}}function v(z){if(z.tagName){if(z.src){if(z.tagName==”IFRAME”){t(o.list_iframes,z,z.src,false)}else{if(z.tagName==”IMG”||z.tagName==”INPUT”||z.tagName==”TABLE”){t(o.list_images,z,z.src,false)}}}var y=u(z);if(y){t(o.list_images,z,y,true)}var A;if(n){A=z.children}else{A=z.childNodes}for(var x=0;x






Share your Knowledge




Hi, please
Log In or
Log in via
or
Join now









Publish Content
Featured Content
Get Help





Categories
Art & Entertainment
Business & Finance
Culture & Society
Events & Holidays
Fashion & Beauty
Health & Nutrition


More
Automotive
Education
Family
Food & Drinks
Hobbies & Crafts
Home & Garden
Internet
Pets
Relationships
Religion & Spirituality
Reviews
Science & Technology
Self Improvement
Sports & Fitness
Travel




You are in:
Home » Personal » How To Create Your Own Home Server







How To Create Your Own Home Server

In this tutorial you will learn how to step up your own server. This server will be comprised of Apache 1.3.5, PHP 4.2.0, and MySQL 3.23.49. This tutorial will address the basic setup of a server on your own computer. This means the removal of hassles of dealing with the company that is running a remote web server. It will be simple to modify. You can add any thing you want to it, be it CGI/Perl, Zope, Roxen, etc, all by your self. You will have unlimited disk space, well at least as huge as your hard drive is =) Now that you know the advantages, it is time that I tell you what i used, and what you will need.

What Is Needed

* Windows 2000 – NOTE that if you are using 2k you WILL NEED Administrative Privileges. If you don’t then get them somehow =) If you are on NT, XP,
* Apache 1.3.6 – I tried to use 2.0 but I could not get it work. I also feel that 1.3.6 is tried and true, so why mess with greatness.
* Mysql 3.23.49 – The newest version of MySQL when I set up my server. MySQL also the is the ideal PHP supported Database, and well love PHP don’t we.
* PHP 4.2.1 – The latest and greatest PHP release. -nt

* Apache 2 – Link: h**p://www.apache.org/dist/
* Mysql 3.23.49 – Link: h**p://www.mysql.com/downloads/mysql-3.23.html
* PHP 4.2.0 – Link: h**p://www.php.net/downloads.php
* Windows – This tutorial is ONLY written for new versions of Windows.

Once you have downloaded all the programs you are ready to continue.

Instructions




1

Installing Apache

The first step is to download Apache for Windows. Before you install it make sure that any other server software is removed. Remove it all via the control panel. Once you have clicked on the executable, a screen should com up that looks like this. Go ahead and click on next individual posted image Of course you plan to stay be the license agreement, so click on I accept…. and click on next.

You really don’t need to read this, but if you want you can. Read it if you want feel informed. When you are ready click on next.

Here is where the actual setup of Apache begins. For Network Domain place in localhost as for Server Name You want these both to be localhost because the server is running locally, on your computer. It doesn’t matter what is in email field, just place in yours. No one will no it because it’s just you.

For the intoxicant of this tutorial it is superior to just leave it as it is because, later in the tutorial I will show you how to begin the server with one click of the mouse, and for the intoxicant of ease, it will be easier for you to follow along. You can change it if you want, but you will have to realize where to alternative it. For me the root drive is E: but for you will probably be C: Once you have all the talking set up, it is time to install the server. If you are on w2k or XP be sure that you have Administrative permissions or you will get an error about half way through the install saving can't access msvrt32.dll or something. If you get that error run it again when you have admin privileges. Once you are ready click on install. If all went well you just see a screen similar to this. Now it is time to test the install of apache. Click on Begin > Program Files > Apache HTTP Server and look for begin Begin Apache in Console. Click it. Once it states Apache XXXXX running, press Windows Key + R and type -http://localhost/. If the install works you should see a page saying that it works. If all is set and done, continue to the next step.

HP EX490 1TB Mediasmart Home Server (Black)

Amazon Price:0.00
List Price: 3.99

HP EX495 1.5 TB MediaSmart Home Server (Black)

Amazon Price:2.00
List Price: 1.99

2

Installing PHP

Once you have clicked on the executable, a screen should come up that looks like this. Go ahead and click on next. Of course you plan to stay be the license agreement, so click on I accept…. and click on next. For this information, we will want the simple standard install. Chances are you if you are reading this tutorial, you will probably not even want to speak about advanced =) This is the mail setup, just enter localhost, and me@localhost.com. These are not important, because you, the admin, are the only mortal that will use the server, and you will be the one handling errors. We are going to want this install to work is Apache, so click on Apache, and move on. Once you have all the talking set up, it is time to install the server. If you are on w2k or XP be sure that you have Administrative permission or you will get an error about half way through the install saving can't access msvrt32.dll or something. If you get that error run it again when you have admin privileges. Once you are ready click on install.  After the install is done you should get something that states you will have to manually configure apache to use php. Assuming you have a working Apache server installed, make sure that it is not running. Navigate to C:\Program Files\Apache Group\Apache\conf\ open the httpd.conf file. Note that you can also get to the http.conf from the begin menu. Begin > Program File > Apache HTTP Server > Configure Apache Server > Edit the Apache httpd.conf Configuration File and the window will open up in notepad. Now hit Ctrl + End if you see something like what follows, you can skip this step. If you do not see that code, copy it. This code will only work if you used the default install folder when you installed php. If you did, copy that code and paste it into the end of the file. Choose the code to right, and hit crtl + c , then go into the httpd.conf file and hit ctrl + v and save the file.

ScriptAlias /php/ “c:/php/”
AddType application/x-httpd-php .php .phtml
Action application/x-httpd-php “/php/php.exe”

Now that we have php installed, it is time to test it. Open up notepad and type the code to the right. Save it as phpinfo.php. Remember to set it as all files in the drop down menu, or the file will be a text file. Save in the Directory: C:\Program Files\Apache Group\Apache\htdocs. htdocs is the directory where all the files go. You can create endless dir’s and browse them. For Example E:\Program Files\Apache Group\Apache\htdocs\mydir\myfile.php could be accessed as http://localhost/mydir/myfile.php. Once you have that file saved. You will need to begin the Server. Click: Begin > Program File > Apache HTTP Server >; and look for something like Begin Apache in Console. After you have found it, launch it. You should get a window saying that Apache is running. Now go to Begin > Run > and type in -http://localhost/phpinfo.php. If you don’t see anything, php is not installed correctly. If php is installed correctly, you will see a few massive tables, displaying php’s configuration. Now Your are 1/2 done!

Act By Sage 2010

Amazon Price:.49
List Price: 9.99

3

Installing MySQL

Once you have clicked on the executable, a screen should com up that looks like this. Go ahead and click on next.  Of course you plan to stay be the license agreement, so click on I accept…. and click on next.  Just like before you should leave the default dir alone, so you will be healthy to follow along with me when I show you how to begin and stop all the aspects of the server.

Stay with the typical installation. Just like before, if you don’t have admin privileges, the install will be faulty. After you click next, the install will begin. After the install has finished, move on to the next step.

Now you have to set up the root account. The root statement is the absolute admin of the system, the highest possible. Click on Begin > Run and type cmd to open up the command prompt. You are going to have to navigate to where MySQL is installed. Type C: > Enter > cd mysql > Enter > cd bin > Enter. Now you have to tell setup the root settings. Type mysqladmin -uroot password InsertYourPasswordHere then hit enter.

To see an image of the screen, -h**p://www.webmasterstop.com/tutorials/images/doscreen1.gif

What is the point of having a database if you can’t easily administer it! That is where phpMyAdmin comes into play. phpMyAdmin is a free piece of software written in php that makes the administration of a mysql or many other types of databases easy. You will want to download (h**p://prdownloads.sourceforge.net/phpmyadmin/phpMyAdmin-2.2.6-php.zip?downloadrelease_id=85832)the latest version. Save it in the htdocs folder. Once it is done downloading it, right click on it and choose Extract > To Here. When it is done you should end up with a directory in the htdocs folder called phpMyAdmin-2.2.6 To make it easier to access, rename it to phpMyAdmin. After you have renamed it, click on it and look for a file called config.inc Open it. This is where you set the configuration of phpMyAdmin. When you open it up, it should look similar to the image to your side. On yours there should be a few things missing. The $ cfgPmaAbsoulteUrl and $ cfgservers[$ i]['password']. You will need to fill those in between the quotes. for the $ cfgPmaAbsoulteUrl enter -http://localhost/phpMyAdmin/ if you followed my instructions to the letter. If you did not rename it or extracted to a different directory, place that in there. For the $ cfgservers[$ i]['password'] enter the password you entered when you were setting MySQL in the set above. You can refer to the image for help. After you have place the right things in save the file.

To see an image of the screen, -h**p://www.webmasterstop.com/tutorials/images/phpmyadminscreen1.gif

Now we want to test the install of mysql, php, phpmyadmin, and apache all at once. Begin apache in console like we did before. Now, you are going to need to begin mysql. For myself I prefabricated a file that would begin mysql for me. Open notepad and type: begin c:\mysql\bin\mysqld-nt.exe –standalone and save that as Begin MySQL.bat. Once you have saved it, click it. A window should open and then close. Mysql is now running on your computer. After mysql and apache are started go to run again and type -http://localhost/phpMyAdmin/index.php and if everything is installed correctly phpmyadmin should so up. You are nearly done! Now we have the simple part =)

Microsoft Office 2010 Home & Student (Disc Version)

Amazon Price:Too low to display
List Price: 9.99

Mac OS X version 10.6.3 Snow Leopard

Amazon Price:.47
List Price: .00

QuickBooks Pro 2011 [Download]

Amazon Price:8.23
List Price: 9.95

4

Content

Add new comment



* You must be logged in order to leave comments, please
Sign in
or join us.




Comments


Be the first to comment on this topic.

“How To Create Your Own Home Server” is managed by muhsmmad

Report


Share








Got a how-to to share? Create One

Videos

ASUS TS Mini Windows Home Server Home Personal Backup Setup &…
3:48 minutes

My Home Server Rack/Computer Room
4:02 minutes

Windows Server 2008: add an Active Directory Computer
3:22 minutes

Joining a Windows Vista personal to a Windows Server 2008 domain …
7:54 minutes

XAMPP – Make your Personal a Webserver: Apache, PHP, MySQL
11:52 minutes

Show more
Powered by

Tags


·
comuter ·
server ·
sql ·
http ·
personal ·
begin mysql ·
begin apache ·
PHP ·
mysql ·
way install saving can't ·
w2k xp sure administrative ·
half way install saving ·
get error half way install ·
apache server ·
begin apache console ·
plan stay license agreement ·
course plan stay license ·
apache ·




Related Content



Advanatges of Windows 2008 server


Login Failed For User in Sql Server Error


Sql Authority


How to Find the Right Paint Color for Your Home

Publish Content
Featured Content
Get Help

All CategoriesArt & EntertainmentAutomotiveBusiness & FinanceCulture & SocietyEducationEvents & HolidaysFamilyFashion & BeautyFood & DrinksHealth & NutritionHobbies & CraftsHome & GardenInternetPetsRelationshipsReligion & SpiritualityReviewsScience & TechnologySelf ImprovementSports & FitnessTravel

Bukisa
Blog
About Us
Contact Us
RSS Feed

Site Links
Join
Login
Recently Added
Advanced Search

Help & Tools
Community Support
Bukisa 101
Widgets
Search Plugin

Sitemaps
How To Articles
Twitter Users
Topics Sitemaps
General Sitemap

Follow Us
On Facebook
On Twitter
Bukisa Newsletter

Please read our Terms of Use and Privacy Policy | User published content is licensed under a Creative Commons License except where otherwise noted.
© Copyright 2008 – 2011 Webika Ltd. All Rights Reserved.
v. 3.0.1 / 20110131 (w1)
Hebrew |
Portuguese

0){for(var u=0;u0){var B=h.shift();w.parentNode.appendChild(B)}for(var z=0;z

Find more Database Versioning articles from search form.

Manual installation instructions: Demo Machine Setup
To set up the hardware

* Set up the hardware according to the manufacturer’s instructions. (Refer to the Minimum Hardware Stipulations section in this document.)

Create a basic install of Windows 2000 Advanced Server or XP

* Choose to create or convert to a NTFS partition during setup.
* Reboot the computer once installation is completed

To configure FrontPage 2000 Server Extensions

1. Open Control Panel.
2. Click Add/Remove Windows Components.
3. Double-click on World wide web Information Services (IIS).
4. Choose FrontPage 2000 Server Extensions.
5. Click OK.
6. Click Next.
7. Click Finish.
8. Click Close.

Install SQL Server 2000 Enterprise Edition

* Walk through the SQL setup accepting all defaults EXCEPT for the Authentication Mode page, which should be changed to Blended Mode. Use a blank password for the sa login.

Install VS.NET

* Launch setup.exe from the VS.NET installation CD.
* Choose Windows Component Update.
* Click Browse and choose VS.NET\WCU subdirectory.
* Click OK twice.
* From here, proceed with default installation options (the organisation will reboot a number of times).
* When Windows Component Update installation is completed, proceed with installation of Visual Studio.NET and continue with default installation options.

Configure ASP.NET Permissions

1. Navigate to C:\[Windows]\Microsoft.NET\Framework\[Version]\Config.
2. Open machine.config in a text editor.
3. Find the tag.
4. Change the userName attribute to SYSTEM.
5. Save machine.config.
6. Navigate to Begin | Run.
7. Enter IISReset, and click Ok.

To install and configure the demo files

1. Install DEVT1-25.MSI.

Setup demos

1. Navigate to C:\FieldContent\DEVT1-25\Demos\Demo setup.

2. Right-click on Setup.vbs, and choose Open with Command Prompt.

3. Wait for the setup to complete.

Find more Sql Editor articles from search form.

hello Guys This guide its about how to make your Own MuOnline Server [COLOR=Red]Season 1 / 2 /3 / 4 /5[/COLOR]
So Lets start.

First of All You Need Microsoft SQL Server 2000 or 2005 ( i advocate 2000 )
Download from Here : [URL="http://seeitworks.com/index.php?dir=SQL Servers/SQL 2000/"]SQL Server 2000 [/URL]or [URL="http://download.microsoft.com/download/SQLSVR2000/Trial/2000/NT45/EN-US/SQLEVAL.exe"]Here  [/URL]or [URL="http://www.filebox.com/xu2tj0ge9mpw"]Here[/URL]
2. You Need The Server Files for It.
[URL="http://rapidshare.com/files/70999312/CzF_Season_I_NO_Personal_ID_2kDB.rar"]Season 1 Server Files[/URL]
[URL="http://www.megaupload.com/?d=8ZFS9KVZ"]Season 2 Server Files[/URL]
[URL="http://rapidshare.com/files/280076921/MuServer_Beta_21.rar"]Season 3 Server Files[/URL][URL="http://www.megaupload.com/?d=VDHGW684"]   Mirror[/URL]
[URL="http://www.megaupload.com/?d=L268BJ1J"]Season 4 Server Files[/URL][URL="http://www.mediafire.com/download.php?ymd1ykyyjqi"] Mirror [/URL]
[URL="http://rapidshare.com/files/280125398/Season_5_MuServer.rar"]Season 5 Server Files   [/URL][URL="http://www.filefront.com/14534537/Season 5 MuServer.rar"]Mirror[/URL]

3. You Need The Client.
[URL="http://www.megaupload.com/?d=7T4K1M8E"]Season 1 Client[/URL] & ( [URL="http://rapidshare.com/files/71282028/LostCastle_Patch_For_CzF_By_zEsko.rar"]Patch[/URL] )
[URL="http://www.bigdownload.com/games/global-mu-online/pc/global-mu-online-installer"]Season 2 Client[/URL]
[URL="http://dox.abv.bg/files/dw?a=bb73ec2d50"]Season 3 Client[/URL]
[URL="http://www.megaupload.com/?d=0EIUJLV7"]Season 4 Client[/URL][/SIZE]
[URL="http://www.megaupload.com/?d=VW68JDSZ"][SIZE=1]Season 5 Client[/SIZE][/URL] [SIZE=1] & ( [URL="http://www.hastlegames.com/foro/redirector.php?url=ftp://muonline.nefficient.co.kr/pub/muonline/MU1_06D+_Patch.zip"]Patch[/URL] )

[COLOR=Gray]4. You Need to Install SQL Server 2000[/COLOR]
[/SIZE]
[SIZE=1]
[/SIZE][COLOR=Blue][COLOR=Green]1.[/COLOR] Go to C:\SQLEVAL,
the folder u unpacked the downloaded package to.

[COLOR=Green]2[/COLOR]. Begin Autorun.exe

[COLOR=Green]3[/COLOR]. Choose SQL 2000 Server Components

[COLOR=Green]4.[/COLOR] Click Install Database Server

[COLOR=Green]5[/COLOR]. Click 8 Times Next Next . . .

[COLOR=Green]6[/COLOR]. Choose ” [COLOR=Red]Use[/COLOR] [COLOR=Red]Local System Account[/COLOR] “[/COLOR][SIZE=1][COLOR=Blue] Then Next.

[COLOR=Green]7[/COLOR]. [SIZE=2]Choose Blended Mod “[COLOR=Red]And Add your SQL Account Password[/COLOR]” Press Next 2 Times … Wait still its been Succesfully Installed.

[COLOR=Green]8[/COLOR]. Go to Start>Programm Files> Microsoft SQL Server > Service Manager > Put your computer Name ex: [COLOR=Red]MY-PC[/COLOR] , Then just begin the Service Manager.

Now you have Succesfully installed Your SQL Server  Working.

[COLOR=Silver]————————————————————[/COLOR]

[SIZE=1][COLOR=Gray]5. Now You Have to Restore Databases.

[/COLOR][/SIZE][/SIZE][/COLOR][/SIZE]
[SIZE=1][COLOR=Blue][SIZE=2][SIZE=1][COLOR=Gray]
[SIZE=2][COLOR=Blue][COLOR=Green]1.[/COLOR] Go to Start> Programm Files>Microsoft SQL Server> Enterprise Manager[/COLOR][/SIZE] [SIZE=2][COLOR=Blue]and Open it.

[COLOR=Green]2.[/COLOR] Click Microsoft SQL Servers> SQL Server Group> (local) (Windows NT)

[COLOR=Green]3.[/COLOR] Open Databases > Right Click on Databases > New Database >
Now you have to make Databases ,
For Season 1 You Must Open only “[COLOR=Red]MuOnline & Ranking[/COLOR]“
For Season 2 You Must Open “[COLOR=Red]MuOnline , MuOnline_Event , MuOnline_Ranking[/COLOR]“
For Season 3 You Must Open only “[COLOR=Red]MuLog & MuOnline[/COLOR]“
For Season 4 You Must Open “[COLOR=Red]MuOnline , Ranking , Event,SCFMuTeam[/COLOR]“
For Season 5 You Must Open “[/COLOR][/SIZE][/COLOR][/SIZE][/SIZE][/COLOR][/SIZE][SIZE=1][COLOR=Blue][SIZE=2][SIZE=1][COLOR=Gray][SIZE=2][COLOR=Blue][COLOR=Red]MuOnline , MuOnline_Event , MuOnline_Ranking , MuLog , MuConnectLog”[/COLOR][/COLOR][/SIZE][/COLOR][/SIZE][/SIZE][/COLOR][/SIZE]

[COLOR=Blue][COLOR=Green]4.[/COLOR] Then Make the Databases

[COLOR=Green]5. [/COLOR]Now Right Copy your Server Files to C:\ or D:\

[COLOR=Green]6.[/COLOR] Right Click On your Database you Made example: “[COLOR=Red]MuOnline[/COLOR]” > All Tasks> Restore Database> From Device > Choose Device > Add > Then find on C:\ Or D:\ You Server Files and Open the File “dbbaks or DBBAKS”
Take [COLOR=Red]MuOnline[/COLOR] or [COLOR=Red]Whatever[/COLOR] Database your Restoring > Click OK 2 Times > Go to Options > Now u will See This

[URL="http://img524.imageshack.us/i/thg.gif/"][IMG]http://img524.imageshack.us/img524/7842/thg.gif[/IMG][/URL]

[SIZE=2]C:\[COLOR=Red]Here Put The Place Which U Want To Restore Your Database[/COLOR]\MuOnline_Data.MDF

So if Your Files are on C:\
and study of your Files is “MuServer” Then place this on the line
[COLOR=Red]C:\MuServer\DBBAKS or dbbaks\MuOnline_Data.MDF
and under of the Line place This
C:\MuServer\DBBAKS or dbbaks\MuOnline_Log.LDF
[/COLOR]
Then Just Tick the “[COLOR=Red]Force Restore over existing database[/COLOR]” and Press OK.
Then ur Done with MuOnline Database or Whatever u Restored

Now Do the Same Thing on Other Databases “[COLOR=Red]MuLog,Event,SCFMuTeam or Whatever you have to Restore[/COLOR]“

Now your Done with Restoring your Database .

Do the Same with the other Database you have to restore “[COLOR=Red]Event,Ranking,SCFMuTeam,MuLog or Whatever[/COLOR]“

Lets state u have Done [COLOR=Red]succesfuly[/COLOR] Installed & Restored Databases .

[/SIZE][/COLOR][SIZE=1][COLOR=Blue][SIZE=2][COLOR=Silver]————————————————————[/COLOR][/SIZE][/COLOR][/SIZE]
[COLOR=Blue][SIZE=2]
[/SIZE][/COLOR][COLOR=Blue][SIZE=2]
[SIZE=1][COLOR=Gray]6.[/COLOR][/SIZE] [SIZE=1][COLOR=Gray]Its time to Work with Your Server Files[/COLOR][/SIZE][COLOR=Gray] .

[COLOR=Blue][COLOR=Green]1.[/COLOR] Go to Your Server Files

[COLOR=Green]2.[/COLOR] We must Edit  ” [COLOR=Red]IP’s & SQL Server Account Password [/COLOR]“

[SIZE=1][COLOR=Gray]
7. We Begin with Season 1 Files

[SIZE=2][COLOR=Blue][COLOR=Green]1.[/COLOR] Open Your MuServer> Open StartUp.ini > Edit all ips to “[COLOR=Red]127.0.0.1[/COLOR]“
[/COLOR][/SIZE][/COLOR][/SIZE]Close Startup.in
[COLOR=Green]2.[/COLOR] Open Folder “CS” > ListServer > Edit your Ip to ” (your ip here) “
Your [COLOR=Red][URL="http://www.murious.com/forums/www.whatismyip.org"]Global IP or NO IP ,Close Listerver.ini[/URL]
[COLOR=Blue][COLOR=Green]3.[/COLOR] Open Data>lang>Kor>commonloc.ini Edit IP: To “[COLOR=Red]127.0.0.1[/COLOR]” Close commonloc and save.
[COLOR=Green]4[/COLOR].Open Data>IpList.ini > Edit your Ip to “[COLOR=Red]127.0.0.1[/COLOR]” Close and Save.
[COLOR=Green]5.[/COLOR]Open Data>Mapserverinfo.dat And edit your ip “[URL="http://www.murious.com/forums/www.whatismyip.org"]Your Global IP[/URL] Only or no-ip “no-ip “if ur no -ip its with “-” u cant . u need with “dots” Close and Save.
[COLOR=Green]6.[/COLOR]Open EventServer>DATA>svconfig.ini > Put Your SQL ID “[COLOR=Red]sa[/COLOR]” and Password ” that you added when u installed the SQL Server” Close and Save.
[COLOR=Green]7.[/COLOR]Open GameServer_CS>DATA>lang>commonloc>Edit the ip “[COLOR=Red]127.0.0.1[/COLOR]“
Open Iplist.dat and Put “[COLOR=Red]127.0.0.1[/COLOR]” Then open MapServerInfo.dat
and edit your IP “[URL="http://www.murious.com/forums/www.whatismyip.org"]Your Global IP[/URL] Only or no.ip without “-”. Close and Save.
[COLOR=Green]8.[/COLOR]Open ODBC>Double Click ODBC.reg [/COLOR][/COLOR][/COLOR][/COLOR][/SIZE][/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]“register it” .[/COLOR][/COLOR][/SIZE][/COLOR]
[COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue][COLOR=Red][COLOR=Blue] [COLOR=Green]9.[/COLOR]Open RankingServer>svconfig.ini>Edit your  ” SQL ID “[COLOR=Red]sa[/COLOR]“  & [COLOR=Red]Password[/COLOR] “
Close and Save.
[COLOR=Green]10.[/COLOR] Download the Season 1 Client [URL="http://www.megaupload.com/?d=7T4K1M8E"]HERE[/URL] & Patch [URL="http://rs289.rapidshare.com/files/71282028/LostCastle_Patch_For_CzF_By_zEsko.rar"]HERE[/URL]
[COLOR=Green]11.[/COLOR] Open the Patch Paste it on Your Server Files “Extract / and Replace all” Then > Open Data> Mapserverinfo.dat and Edit your IP again “[URL="http://www.murious.com/forums/www.whatismyip.org"][COLOR=Red]Global IP[/COLOR][/URL]”
[COLOR=Green]12.[/COLOR]Open Client ,Extract It Somewhere , “Download HexEditor [URL="http://advanced-hex-editor.softonic.de/download#pathbar"]HERE[/URL]” Open Main.exe with HexEditor > Find Text > “connect”
go abit Down and u will see an “IP” Replace it with Yours”
Then Save.
[COLOR=Green]13.[/COLOR] Go to your ServerFiles > And Run MuServerStartup . “[COLOR=Red]If u have vista or Windows 7 Run it As Administrator[/COLOR]“
Then [/COLOR][/COLOR][/COLOR][/COLOR][/SIZE][/COLOR][SIZE=1][COLOR=Blue][SIZE=2][SIZE=1][COLOR=Gray][SIZE=2][COLOR=Blue]Connect with the Main.exe[/COLOR][/SIZE][/COLOR][/SIZE][/SIZE][/COLOR][/SIZE][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue][COLOR=Red][COLOR=Blue] to your Client !
To Create Account Use ” MuMaker Download from [URL="http://seeitworks.com/index.php?dir=Editors/MuMaker 1.04 - By TMT - MuEditor - MultiLang!!/"]HERE[/URL]“

[COLOR=Green]You have SuccesFully Installed your MuOnline Server Season 1 .[/COLOR]

[SIZE=1][COLOR=Gray]8.How to Config Season 2 Files Now.[/COLOR][/SIZE]

[COLOR=Green]1.[/COLOR]Download Files from [URL="http://www.megaupload.com/?d=8ZFS9KVZ"]HERE [/URL]
[COLOR=Green]2.[/COLOR]Extract Files to C:\ or D:\  
[COLOR=Green]3.[/COLOR]Restore Databases ” Read [/COLOR][/COLOR][/COLOR][/COLOR][/SIZE][COLOR=Red][U][B](6.)[/B][/U][/COLOR][/COLOR]
[COLOR=Green]4.[/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue][SIZE=1][COLOR=Gray][SIZE=2][COLOR=Blue]Open Your MuServer> Open StartUp.ini > Edit all ips to “[COLOR=Red]127.0.0.1[/COLOR]“
[/COLOR][/SIZE][/COLOR][/SIZE]Close Startup.ini
[COLOR=Green]5.[/COLOR]Open bin>Ranking.cfg >Edit your “SQL ID “[COLOR=Red]sa[/COLOR]” and Pass” Close and Save > Open exdb.cfg [/COLOR][/COLOR][/SIZE][/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]Edit your “SQL ID “[COLOR=Red]sa[/COLOR]” and Pass” Close and Save>
Open event.cfg [/COLOR][/COLOR][/SIZE][/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]Edit your “SQL ID “[COLOR=Red]sa[/COLOR]” and Pass”Close and Save>
Open Data>ServerList.dat Put your [URL="http://WHATISMyip.org"]Global IP[/URL] on “WANIP” or your no.ip.
Close and Save>Open JoinServer Non-Md5 > Copy everything Go back to “bin” and paste and replace.
[COLOR=Green]6.[/COLOR]Open Data>MapServerInfo.dat and Put your [URL="http://WHATISMyip.org"]GLOBALIP or no -ip without “-” Close and Save .[/URL]
[COLOR=Green]7.[/COLOR]Open DBBAKS>And run ODBC.Reg [/COLOR][/COLOR][/SIZE][/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]“register it”[/COLOR][/COLOR][/SIZE][/COLOR]
[COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue] [COLOR=Green]8.[/COLOR]Download Client from [URL="http://www.bigdownload.com/games/global-mu-online/pc/global-mu-online-installer"]HERE [/URL]& Patch from [URL="http://rapidshare.com/files/213208980/Main.rar"]HERE [/URL]
Install the Client whereever you want , Downlaod patch and copy it to the Client  and Replace .
[COLOR=Green]9.[/COLOR]Open [URL="http://advanced-hex-editor.softonic.de/download#pathbar"]HexEditor  [/URL]
Open main.exe from your Client  find text “connect or 192.168.0.1″
and Edit the “192.168.0.1 with your[URL="http://whatismyip.org"] GLOBALIP[/URL] or NO.IP” Close and Save.
[COLOR=Green]10.[/COLOR] Go to server Files and Run MuServerStartUp “if u have vista or windows 7 run it as Administrator”
Then just [/COLOR][/COLOR][/SIZE][/COLOR][SIZE=1][COLOR=Blue][SIZE=2][SIZE=1][COLOR=Gray][SIZE=2][COLOR=Blue]Connect with the Main.exe[/COLOR][/SIZE][/COLOR][/SIZE][/SIZE][/COLOR][/SIZE][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue] to yout Client .
[/COLOR][/COLOR][/SIZE][/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue][COLOR=Red][COLOR=Blue]To Create Account Use ” MuMaker Download from [URL="http://seeitworks.com/index.php?dir=Editors/MuMaker 1.04 - By TMT - MuEditor - MultiLang!!/"]HERE[/URL]“[/COLOR][/COLOR][/COLOR][/COLOR][/SIZE][/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]

[COLOR=Green]
You Have Succesfully Installed your MuServer Season 2

[SIZE=1][COLOR=Gray]
9.How to Config Season 3 Files Now .

[/COLOR][/SIZE][/COLOR][/COLOR][/COLOR][/SIZE][/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue][COLOR=Red][COLOR=Blue][COLOR=Green]1.[/COLOR]Download Files from [URL="http://www.megaupload.com/?d=8ZFS9KVZ"]HERE [/URL]
[COLOR=Green]2.[/COLOR]Extract Files to C:\ or D:\  
[COLOR=Green]3.[/COLOR]Restore Databases ” Read [/COLOR][/COLOR][/COLOR][/COLOR][/SIZE][COLOR=Red][U][B](6.)[/B][/U][/COLOR][/COLOR]
[COLOR=Green]4.[/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]Open CashShopServer>CashShopOption.cfg Edit ur ” [COLOR=Red]SQL ID “sa”  AND PASS[/COLOR] ” Close and Save.
[COLOR=Green]5.[/COLOR]Open ConnectServer >Data> ServerList.dat And edit the “[COLOR=Red]127.0.0.1″ with ur [URL="http://whatismyip.org"]GlobalIP[/URL][/COLOR]” Close and Save
[/COLOR][/COLOR][/SIZE][/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue][COLOR=Green]6.[/COLOR]Open Data>MapServerInfo.dat and Put your [URL="http://whatismyip.org/"]GLOBALIP or no -ip without “-” Close and Save .[/URL][/COLOR][/COLOR][/SIZE][/COLOR]
[COLOR=Blue][COLOR=Green]7.[/COLOR]Open EventServer>[/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]DATA>svconfig.ini > Edit your [/COLOR][/COLOR][/SIZE][/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]” [COLOR=Red]SQL PASS[/COLOR] ” Close
and Save.[/COLOR][/COLOR][/SIZE][/COLOR]
[COLOR=Blue][COLOR=Green]8.[/COLOR]Open ExDB>ExDB.ini>Edit the “[COLOR=Red]SQL PASSWORD[/COLOR]” With your SQL PASSWORD”[/COLOR] [COLOR=Blue]Close and Save.
[COLOR=Green]9.[/COLOR]Open RankingServer>svconfig.ini > [/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]Edit your [/COLOR][/COLOR][/SIZE][/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]” [COLOR=Red]SQL PASS[/COLOR] ” Close
and Save.
[COLOR=Green]10.[/COLOR]Run ODBC.reg “register it”
[/COLOR][/COLOR][/SIZE][/COLOR][COLOR=Blue][SIZE=2][COLOR=Green]11.[/COLOR]Download Client [URL="http://dox.abv.bg/files/dw?a=bb73ec2d50"]HERE [/URL]
Then extract it whereever u want, Open HexEditor > Find text > [/SIZE]“mu.*********.net” the ip  & replace it with ur [URL="http://whatismyip.org"]Global IP[/URL] or no-ip[/COLOR]
[SIZE=1][COLOR=Blue][SIZE=2][SIZE=1][COLOR=Gray][SIZE=2][COLOR=Blue] [COLOR=Green]12.[/COLOR]Go to your Server Files > Run “[COLOR=Red]MuServerStartUp[/COLOR]” if u have Windows vista or windows 7 run it as Administrator.
[COLOR=Green]13. [/COLOR]Go to your Client and Connect with the Main.exe
[/COLOR][/SIZE][/COLOR][/SIZE][/SIZE][/COLOR][/SIZE][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue][COLOR=Red][COLOR=Blue]To Create Account Use ” MuMaker Download from [URL="http://seeitworks.com/index.php?dir=Editors/MuMaker 1.04 - By TMT - MuEditor - MultiLang!!/"]HERE[/URL]“

[/COLOR][/COLOR][/COLOR][/COLOR][/SIZE][/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue][COLOR=Green]You Have Succesfully Installed your MuServer Season 3 [/COLOR][/COLOR][/COLOR][/SIZE][/COLOR]
[SIZE=1]

[/SIZE][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue][COLOR=Green][SIZE=1][COLOR=Gray]10.How to Config Season 4 Files Now .[/COLOR][/SIZE][/COLOR][/COLOR][/COLOR][/SIZE][/COLOR]

[COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue][COLOR=Red][COLOR=Blue][COLOR=Green]1.[/COLOR]Download Files from [URL="http://www.megaupload.com/?d=L268BJ1J"]HERE[/URL]
[COLOR=Green]2.[/COLOR]Extract Files to C:\ or D:\  
[COLOR=Green]3[/COLOR].Restore Databases ” Read [/COLOR][/COLOR][/COLOR][/COLOR][/SIZE][COLOR=Red][U][B](6.)[/B][/U][/COLOR][/COLOR]
[COLOR=Blue][COLOR=Green]4.[/COLOR]Open CS>DATA>ServerList[BoR].dat Replace the IP”84.57.38.96″
with ur [URL="http://www.whatismyip.org"]Global IP[/URL][/COLOR] [COLOR=Blue]or no,ip Close and Save
[COLOR=Green]5.[/COLOR]Open Data> MapServerInfo.dat Replace the ip “[/COLOR][COLOR=Blue]84.57.38.96″” With your [URL="http://www.murious.com/forums/www.whatismyip.org"]Global IP[/URL] or no,ip Close and Save [/COLOR], [COLOR=Blue]Open[/COLOR] [COLOR=Blue]MapServerInfo_Cs.dat[/COLOR] [COLOR=Blue]Replace the ip “[/COLOR][COLOR=Blue]84.57.38.96″” With your [URL="http://www.murious.com/forums/www.whatismyip.org"]Global IP[/URL] or no,ip Close and Save[/COLOR]
[COLOR=Blue][COLOR=Green]6.[/COLOR]Open eDataServer>eDataServer.ini Go Down[/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue] Edit your [/COLOR][/COLOR][/SIZE][/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]” [COLOR=Red]SQL PASS[/COLOR] ” If u have restored Database for Event “Event” then Edit the [/COLOR][/COLOR][/SIZE][/COLOR][COLOR=Blue]
[/COLOR][SIZE=1] [COLOR=Blue][SIZE=2]“EventDNS = MU2003_EVENT_DATA” to “[/SIZE][SIZE=2][COLOR=Red]Event[/COLOR][/SIZE][SIZE=2]” Close and Save.
[COLOR=Green]7.[/COLOR]Open GameServer>SCF_Connect.ini> [/SIZE][/COLOR][/SIZE][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]Edit your [/COLOR][/COLOR][/SIZE][/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]” [COLOR=Red]SQL PASS[/COLOR] ” on line “SCFPassword = XXXX” close and Save.
[COLOR=Green]8.[/COLOR]Open GameServerCS>[/COLOR][/COLOR][/SIZE][/COLOR][SIZE=1][COLOR=Blue][SIZE=2]SCF_Connect.ini> [/SIZE][/COLOR][/SIZE][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]Edit your [/COLOR][/COLOR][/SIZE][/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]” [COLOR=Red]SQL PASS[/COLOR] ” on line “SCFPassword = XXXX” close and Save.
[COLOR=Green]9.[/COLOR]Open Programy>SCFDB>SCFdb3.ini > [/COLOR][/COLOR][/SIZE][/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]Edit your [/COLOR][/COLOR][/SIZE][/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]” [COLOR=Red]SQL PASS[/COLOR] ” on line “SCFPassword = XXXX” close and Save.[/COLOR][/COLOR][/SIZE][/COLOR]
[COLOR=Blue][COLOR=Green]10[/COLOR].If you Want SubServer Open SUBServer> [/COLOR][SIZE=1][COLOR=Blue][SIZE=2]Open GameServer>SCF_Connect.ini> [/SIZE][/COLOR][/SIZE][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]Edit your [/COLOR][/COLOR][/SIZE][/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]” [COLOR=Red]SQL PASS[/COLOR] ” on line “SCFPassword = XXXX” close and Save.[/COLOR][/COLOR][/SIZE][/COLOR] [COLOR=Blue]Then Open Data> MapServerInfo.dat Put On  “[/COLOR][COLOR=Blue]WANIP” ” With your [URL="http://www.murious.com/forums/www.whatismyip.org"]Global IP[/URL] or no,ip Close and Save [/COLOR], [COLOR=Blue]Open[/COLOR] [COLOR=Blue]MapServerInfo_Cs.dat[/COLOR] [COLOR=Blue]Put On  “[/COLOR][COLOR=Blue]WANIP” [/COLOR][COLOR=Blue]” With your [URL="http://www.murious.com/forums/www.whatismyip.org"]Global IP[/URL] or no,ip Close and Save[/COLOR]
[COLOR=Blue][COLOR=Green]11.[/COLOR]Right Click on RunServer_GS>ShortCut> On Line “[COLOR=Red]Target[/COLOR]“: place exactly where is ur MuServer Files Located for ex:
“C:\muserver\GameServerCS\CrackCS.exe 127.0.0.1 55970 127.0.0.1 55962 55919″
[/COLOR][SIZE=1][COLOR=Blue][SIZE=2]Do Same on Line “Start In ex: c:\MuServer\GameServerCS. Apply and OK.[/SIZE][/COLOR][/SIZE][COLOR=Blue] Do the same with RunServer_CS/GS/SUB.lnk too [/COLOR]
[SIZE=1][COLOR=Blue][SIZE=2] [COLOR=Green]12.[/COLOR]Download Client From [URL="http://www.megaupload.com/?d=0EIUJLV7"]HERE [/URL]
Extract it to your Desktop or whereever you want .
Open MainCracker.exe
Find main.exe
Edit your IP Your ”[URL="http://www.whatismyip.org"]GlobalIP[/URL]” or no,ip
Save and close.
[COLOR=Green]13.[/COLOR]Go to your Server Files &[/SIZE][/COLOR][/SIZE] [SIZE=1][COLOR=Blue][SIZE=2][SIZE=1][COLOR=Gray][SIZE=2][COLOR=Blue]Run “[COLOR=Red]MuServerStartUp[/COLOR]” if u have Windows vista or windows 7 run it as Administrator. then run eDataserver from eDatserver folder
then run scfdb3.exe from Programy>SCDFB folder then run ur GS OR CS OR SUB !
[COLOR=Green]14.[/COLOR]Go to your Client and Connect your Client with main.exe
[/COLOR][/SIZE][/COLOR][/SIZE][/SIZE][/COLOR][/SIZE][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue][COLOR=Red][COLOR=Blue]To Create Account Use ” MuMaker Download from [URL="http://seeitworks.com/index.php?dir=Editors/MuMaker 1.04 - By TMT - MuEditor - MultiLang!!/"]HERE[/URL]“[/COLOR][/COLOR][/COLOR][/COLOR][/SIZE][/COLOR]
[SIZE=1][COLOR=Blue][SIZE=2][SIZE=1][COLOR=Gray][SIZE=2][COLOR=Blue]

[/COLOR][/SIZE][/COLOR][/SIZE][/SIZE][/COLOR][/SIZE][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue][COLOR=Green]You Have Succesfully Installed your MuServer Season 4:)[/COLOR][/COLOR][/COLOR][/SIZE][/COLOR]
[SIZE=1][COLOR=Blue]
[COLOR=Silver][COLOR=Gray]
11.How to config Season 5 Files Now [/COLOR]

[/COLOR][/COLOR][/SIZE][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue][COLOR=Red][COLOR=Blue][COLOR=Green]1.[/COLOR]Download Files from [URL="http://www.sendspace.com/file/bwqdnu"]HERE[/URL]
[COLOR=Green]2.[/COLOR]Extract Files to C:\ or D:\  
[COLOR=Green]3.[/COLOR]Restore Databases ” Read [/COLOR][/COLOR][/COLOR][/COLOR][/SIZE][COLOR=Red][U][B](6.)[/B][/U][/COLOR][/COLOR]
[COLOR=Blue][COLOR=Green]4.[/COLOR]OpenCashShopServer> CashShopOption.ini > And [/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]Edit your[/COLOR][/COLOR][/SIZE][/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue] “[COLOR=Red]SQL PASS[/COLOR]“[/COLOR][/COLOR][/SIZE][/COLOR]
[COLOR=Blue]Close and Save.
[COLOR=Green]5.[/COLOR]Open ConnectServer>Data>ServerList.dat [/COLOR][COLOR=Blue]Replace the IP”84.57.23.10″
with ur [URL="http://www.whatismyip.org/"]Global IP[/URL][/COLOR] [COLOR=Blue]or no,ip Close and Save[/COLOR]
[COLOR=Green]6.[/COLOR][COLOR=Blue]Open Data> MapServerInfo.dat Replace the ip “[/COLOR][COLOR=Blue]84.57.38.96″” With your [URL="http://www.murious.com/forums/www.whatismyip.org"]Global IP[/URL] or no,ip Close and Save [/COLOR]
[COLOR=Green]7.[/COLOR][COLOR=Blue]Open EventServer>[/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]DATA>svconfig.ini > Edit your [/COLOR][/COLOR][/SIZE][/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]” [COLOR=Red]SQL PASS[/COLOR] ” Close
and Save.
[COLOR=Green]8.[/COLOR][/COLOR][/COLOR][/SIZE][/COLOR][COLOR=Blue]Open ExDB>ExDB.ini>Edit the “[COLOR=Red]SQL PASSWORD[/COLOR]” With your SQL PASSWORD”[/COLOR] [COLOR=Blue]Close and Save.
[COLOR=Green]9.[/COLOR]Open RankingServer>svconfig.ini > [/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]Edit your [/COLOR][/COLOR][/SIZE][/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue]” [COLOR=Red]SQL PASS[/COLOR] ” Close
and Save.[/COLOR][/COLOR][/SIZE][/COLOR]
[COLOR=Blue][COLOR=Green]10.[/COLOR]Open GameServer>Data> Open MapServerInfo.dat Replace the ip “84.57.23.10″ with your [URL="http://whatismyip.org"]GlobalIP[/URL] or no,ip
[COLOR=Green]11.[/COLOR][/COLOR][COLOR=Blue]Open GameServerCS>Data> Open MapServerInfo.dat Replace the ip “84.57.23.10″ with your [URL="http://whatismyip.org/"]GlobalIP[/URL] or no,ip[/COLOR][COLOR=Blue]
[COLOR=Green]12.[/COLOR][/COLOR][COLOR=Blue]Right Click on GS-01.lnk >ShortCut> On Line “[COLOR=Red]Target[/COLOR]“: place exactly where is ur MuServer Files Located for ex:
“C:\muserver\GameServer\CrackCS.exe 127.0.0.1 55970 127.0.0.1 55962 55919″
[/COLOR][SIZE=1][COLOR=Blue][SIZE=2]Do Same on Line “Start In ex: c:\MuServer\GameServer. Apply and OK.[/SIZE][/COLOR][/SIZE]
[COLOR=Blue]do the same with GS-CS.lnk too
[COLOR=Green]13.[/COLOR]Open Configs.ini go down and edit the ip “84.57.xx.xx” with “[COLOR=Red]127.0.0.1[/COLOR]” Close and Save.
[COLOR=Green]14.[/COLOR]Download the Client from [/COLOR][SIZE=2][URL="http://www.megaupload.com/?d=VW68JDSZ"]HERE[/URL][/SIZE] [COLOR=Blue]& Patch from [/COLOR][SIZE=2][COLOR=Blue][URL="http://www.hastlegames.com/foro/redirector.php?url=ftp://muonline.nefficient.co.kr/pub/muonline/MU1_06D+_Patch.zip"]HERE[/URL][/COLOR][/SIZE] [COLOR=Blue]Extract the Client wherever u want then take the patch and place it on the Client Replace it ,then Open main.cracker.exe and edit IP With your [URL="http://whatismyip.org/"]GlobalIP[/URL] and Serial : [COLOR=Red]8gksYM30JnvgqpcP[/COLOR][/COLOR][COLOR=Blue] Save and exit.
[/COLOR][SIZE=1][COLOR=Blue][SIZE=2][SIZE=1][COLOR=Gray][SIZE=2][COLOR=Blue][COLOR=Green]15.[/COLOR]Go to your Client and Connect your Client with main.exe
[/COLOR][/SIZE][/COLOR][/SIZE][/SIZE][/COLOR][/SIZE][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue][COLOR=Red][COLOR=Blue]To Create Account Use ” MuMaker Download from [URL="http://seeitworks.com/index.php?dir=Editors/MuMaker 1.04 - By TMT - MuEditor - MultiLang!!/"]HERE[/URL]“[/COLOR][/COLOR][/COLOR][/COLOR][/SIZE][/COLOR]
[COLOR=Blue]

[/COLOR][COLOR=Blue][SIZE=2][COLOR=Gray][COLOR=Blue][COLOR=Green]You Have Succesfully Installed your MuServer Season 5:)[/COLOR][/COLOR][/COLOR][/SIZE][/COLOR]

————————————————————-

Congrad’s now u officialy have your server up and runing !

————————————————————-

[COLOR=SeaGreen]Credits For Files[/COLOR] :
[COLOR=Red]- WebZen
- SCF Team
- Tomatoes
- Plasma32
- Oski
- ECTTeam
- Dark Team
- CzF Team
- MMT Group

[COLOR=Green]Credits For Guide:[/COLOR]
KarLi’n'babaygaz
[COLOR=Silver]
—————————————————————[/COLOR]
[COLOR=Silver]Have Fun & Good Luck To Everyone  ![/COLOR][/COLOR][COLOR=Blue][COLOR=Red][COLOR=Silver]
With your Server

QUESTIONS or PROBLEMS plz contact me babaygaz@gmail.com

Thank you .

[COLOR=DeepSkyBlue]KarLi[/COLOR][/COLOR][COLOR=Teal]
[/COLOR][/COLOR]

[/COLOR][SIZE=1][COLOR=Blue]
[/COLOR]
[/SIZE]

Find more Sql Editor articles from search form.

Proxy servers are commonly used by people, especially students and people in workplace, to bypass censors or firewalls set by the system administrators. So, even if the system admin blocks websites such as MySpace, Orkut or Facebook, you can sort of unblock the censor settings by using a web proxy.

The most important use of agent services, however, is the security it provides to the common user. Sometimes it is suggested to browse using web proxies because they don’t leak any information about your IP, bank accounts to third celebrations or hacking tools. Interesting it might sound that the same technology that is used by hackers to steal info is held against them with a web proxy.

Most web proxies are accessible for free, even though some others charge the users a fee. However, while using one, make sure that it is not known to the censor who configures the firewalls.

ProxyBoxOnline is a bad free online web agent server from the United States. Its server is put in the U.S. It uses Glype agent script, and the default page encoding is UTF-8. For non-UTF-8 pages, its support is poor, and there is garbled showed on these pages. To resolve this problem, you need to change its settings by yourselves. It also does not support SSL, which means you can't visit https sites such as Gmail. When I try to access to Gmail, the sentences showed as below that “the site you are attempting to browse is on a secure connection. This agent is not on a secure connection. The target site might send sensitive data, which might be intercepted when the agent sends it back to you.” And the other disadvantage of this site is too much full screen ads which will affect you when you surf the internet.

You can try to use it follow the steps. Enter the page you want to visit in the address bar, and then click “Go!” button. If the page you visit appears garbled, right-click the web pages, select “code” in the pop-up menu, and then select “Simplified Chinese (GB2312)” to solve this problem.

For the good stable online web agent server, check my other articles here.

Find more Data Admin articles from search form.

Windows Server 2008 R2 is the server version of Windows 7. It is built on the same Windows NT version (6.1) as Windows 7 is. Even though it is designed to be as secure as doable and focus on background processes, it can be configured to function like a desktop operating system.

The first thing you’d probably want to do is enable wireless LAN:

Open Server Manager
Select Features from the tree-view on the left
Click Add Features
Check Wireless LAN

At this stage you can also install the Desktop Experience feature but make sure you have downloaded and installed the your graphics card driver beforehand.

Check Desktop Experience (along with .NET Framework 3.5.1)
Click Next
Wait for features to be installed and configured and personal to restart

Now that you have your video card driver and desktop experience installed, you can enable the aero theme by doing the followning:

Open Services
Click on Themes and the service
Set it to Automatic and click Apply.
Right-click on the desktop and choose Personalize
Choose the Windows 7 theme

You can also download more Windows 7 themes and backgrounds from here and use one of them if you desire. Now, you might be wondering why you can’t hear any sounds. To fix this:

Open Services
Click on Windows Audio and begin the service

Set it to Automatic and click Apply.
Click on Windows Audio Endpoint Builder and begin the service
Set it to Automatic and click Apply.
Right-click on the desktop and select Personalize

Click on Sounds (along the bottom)
Change Sound Scheme to Windows Default

By default, a Windows Server operating system tells the processor to give priority to the background services since 90% of the time there is no individual using the organisation to open any applications. But to ensure your applications get all the processor power they need, follow these steps:

Open Advanced System Settings (in personal properties)
Go to the Advanced tab
Click Settings in the Performance group-box
Go to the Advanced tab
Select Programs under Processor Scheduling
Click Apply

You might have noticed that World wide web Explorer blocks many websites, this is because Internet Explorer Enchanced Security (IE ESC) is enabled. To disable it:

Open Server Manager
Go to the root of the tree-view
Scroll down to Securtiy Infomation
Click Configure IE ESC
Select Off for your desired individual group(s)
Click Apply

Server operating systems rely very much on logs so that the server administrator knows what problems have occurred and possibly why. This is why it asks you for a reason that the server’s being shutdown. If you’d rather not have this then:

Open Run (from the Start menu)
Type gpedit.msc and click OK
Expand Administrative Templates (under Computer Configuration)
Select the System folder below
In the right pane, locate then open Display Shutdown Event Tracker
Choose Disable
Click Apply

If you are fussed about having to press CTRL+ALT+DEL before you enter your password for login then do this:

Open Local Security Policy (under Administrative Tools)
Expand Local Policies
Select Security Options
In the right pane, locate Interactive logon: Do not require CTRL+ALT+DEL
Open it and choose Enabled
Click Apply

That concludes this article, I hope this has been of great help to you. If you have any problems or queries then please comment.

Until next time,

Kind Regards,

Rob Nox

Find more Query Builder articles from search form.

Initially when I was trying to save Urdu Language in SQL Server database I was thinking it would be very difficult task. But it wasn’t and as simple as saving English characterset. SQL Server is Unicode enabled database server and wage extensive for support multilanguage characterset. Urdu is also one of the Language which is supported by SQL Server. Instead of getting into any technical detail I am describing the steps directly which are necessary to save Urdu in SQL Server database. Following steps are also true for multilanguage support in your software except that you have to select your suitable Collation.

Choose Collation while creating database

Choose Column Type for Urdu and Multilanguage Characterset

SQL Statements to support Urdu and Multilanguage

Selection of Correct Collation for SQL Server Database

For Urdu characters I have used SQL_Latin1_General_CP1_CI_AS collation which is also an SQL Server default collation. This collation fully support Urdu Language including sorting and searching. Therefore you don’t need to define any collation while creating Database. SQL Server will automatically select correct collation for Urdu Language. For any other language kindly check Microsoft documentation to select correct collation. Be careful while selecting collation because wrong selection will convert your data into garbage. Collation can be selected only at the time of creation of database and can not be changed later on. But you can also specify column level collation. For the list of collation you can check this link : http://msdn.microsoft.com/en-us/library/ms144250(SQL.90).aspx

Selection of Column Type for Urdu / Multilanguage Support

For Urdu and other Multilanguages support SQL Server wage few specific column types. These column type are nchar, nvarchar and ntext. These three column types fully support unicode characterset and hence Urdu and multilanguage. nchar is multilanguage version of char, nvarchar for varchar and ntext for text datatype. For columns which are required to hold Urdu or multilanguage characters please define either one of the three datatypes which is ideal suitable according to the data length.

SQL Statements to support Urdu and Multilanguage

There is not any huge difference while writing SQL statement to retrieve or save multilanguage characters into database. For apiece type of statement (Select, Insert and Update) only character “N” is incremented before multilanguage data. Which tells SQL Sever that subsequent data after “N” is multilanguage characters. I try to explain each statement with an example.

Think about plateau structure with study tblTraslation:

EnglishName          varchar(20)

UrduName             nvarchar(20)

Column UrduName will contian Urdu language characters.

INSERT

In below statements I have marked changes with Red color which are required to insert Urdu and Multilanguage characters in database.

INSERT INTO tblTranslation (EnglishName, UrduName) Values (‘Asif’, N‘آصف’)

INSERT INTO tblTranslation (EnglishName, UrduName) Values (‘Sohail’, N‘سہیل’)

INSERT INTO tblTranslation (EnglishName, UrduName) Values (‘Kamran’, N‘کامران’)

SELEC

In below statements I have marked changes with Red color which are required to retrieve Urdu and Multilanguage characters from database.

SELECT EnglishName, UrduName from tblTranslation

SELECT EnglishName, UrduName from tblTranslation Where EnglishName = ‘Asif’

SELECT EnglishName, UrduName from tblTranslation Where EnglishName Like ‘As%’

SELECT EnglishName, UrduName from tblTranslation Where UrduName = N‘کامران’

SELECT EnglishName, UrduName from tblTranslation Where UrduName Like N‘کا%’

UPDATE

In below statements I have marked changes with Red color which are required to update Urdu and Multilanguage characters in database.

UPDATE tblTranslation SET EnglishName = ‘Faraz’ Where EnglishName = ‘Kamran’

UPDATE tblTranslation SET UrduName = N’فراز’ Where EnglishName = ‘Faraz’

UPDATE tblTranslation SET EnglishName = ‘Kamran’ Where UrduName = N’فراز’

UPDATE tblTranslation SET UrduName = N’کامران’ Where EnglishName = ‘Kamran’

See how simple it is to insert and retrieve Urdu and other Language characters into SQL Server database. Hopefully it will make you clear how to use SQL Server for Urdu and other languages.

Find more Database Versioning articles from search form.

MySQL can be a rock solid, lighting swiftly database server which has been designed for two factors pace and efficiency. It could be the Ferrari of databases: Light weight, swiftly and Built for the higher pace tracks! I nonetheless hear an awful lot of stories from owners whose databases are running two slow. In my experience, the three principal places to seem for issues are:
1. Faulty Database Design
2. Lousy Queries
3. Server factors

Faulty Database Design
Correct database design might be the single most essential bourgeois for the ensuring efficiency and maintainability with the database. Right here is what you have to answer when designing a desk: Can I decrease the size of knowledge that each row will have? Right here is what you are healthy to do:
1. Use unsigned numeric values when the application is not going to save negative numbers. Like the quantity ordered of an item in an ecommerce application is never going to become -5.

2. Use Variable length values as an substitute to fixed length worth i.e. utilised varchar in place of char.

3. Tend not to use unnecessarily huge field sizes. For most ecommerce application unsigned smallint is extra than adequate to retailer inventory count. A field described as unsigned smallint can keep a max benefit of 65535.

4. Dont ignore normalization; its helps prevent unnecessary repetition of info. The part B of that is, dont overuse normalization. If the desk is not going to grow in size substantially, there’s no point in normalization. For instance, if the individual desk has just 20 rows (i.e. 20 employees in a organization), all attempts of normalization are wasted.

5. Use Keys. Dont decide keys by The customer id has to become indexed from the order desk. If the order desk is becoming searched 90% of your times by order date, it makes much more sense to index order date.

Remember, how a desk will probably be employed must determine how it truly is designed. Spending time right here will save years of frustration.

Lousy Queries
It sounds too excellent to become true but you wont believe the number of developers out there who completely suck at writing queries. You will discover two kinds of undesirable queries:
a) Unnecessary Queries: These are the queries that shouldnt have been prefabricated inside initial place. The only method to refrain it can be asking, Do I actually need to have this info?
b) Inefficient Queries: These are the queries that usually do not use the underlying desk structure or MySQL functions inside correct way.

Right here is actually a starting point to start looking at issue areas:
1. Unnecessary utilization of Choose * statements when the entire processing is becoming carried out on a single column. The far more info is fetched from the server the extra work MySQL has to do and much more bandwidth it takes.

2. Employing sub-query as an substitute to a join. On a correctly designed database, joins are incredibly rapidly. Making use of sub-queries just shows a demand of knowledge.

3. Improper use of Keys. It can be specially valid for range checks. Remember to use the Explain statement to check the utilization of keys and then use the use crucial statement in your where clauses to force critical utilization.

Server Factors
Each thing carried out correctly, there nonetheless might well be some server factors that might possibly be causing the technique to become slow. These are:
1. Hardware associated

2. Server configuration associated

Right here is what you are healthy to do about the hardware:
1. The extra RAM is on the method the much superior it can be. MySQL often fetches info from the RAM and a lot more the RAM is on the technique, the much superior it can be.

2. Buy the fastest achievable RAM! A slower RAM is just irony.

3. As soon as you will be settled with the RAM size and velocity, seem for processing velocity. MySQL can use multiple processors.

As soon as you might be satisfied with the hardware, you will find a set of variables in my.cnf that you should seem at:
a) key_buffer_size: This describes the memory accessible to save the index keys. The default is 8 MB but you might set it to 25% with the RAM.
b) query_cache_size: This worth is by default ..! if you might have a great deal of repeating queries like in reporting applications and so on, make certain you set this benefit large.
c) table_open_cache: This determines the number of desk descriptors that MySQL will maintain inside cache. The default worth is 64. But, if you’ve 100 users accessing a desk concurrently then this worth require to atleast be 100. You also need to take into considerations joins and so on. Thus, this worth will need to also be kept large. Read more Software Guide and Review

Find more Database Designer articles from search form.