::. Hosting Partner .::. Domain Registration, Web Hosting, Reseller Account , Karachi

Knowledge Base - Hosting FnQ

Windows Server - 05

1	Data Base
		Import my data into my database
		Support MSSQL Express
		Connect to SQL Server 2000 using Enterprise Manage
		Backup/Restore your MySQL database

2	E - Mails
		Pop E-mail Account Settings
		SPF record

3	FTP
		Problems with FTP Connection
		Upload Files
		FTP Client

4	General
		Problems 500 Error (Internal Server Error)
		How to change a php.ini value?

1) DataBase:

Import my data into my database, using Plesk?

Solution

Please do the following:

1. Log into Plesk.
2. Click on your domain name.
3. Click on the Databases icon.
4. Click on the database name.
5. Click on the DB WebAdmin icon (Make sure that browser popups are allowed).
6. Click on the SQL tab at the top.
7. Click on the Browse button.
8. Select the SQL file on your hard disk.
9. Click on the Go button.

If you have done enverthing correctly, you will get a response that so many queries has been executed.

Support MSSQL Express

Solution

Yes, we support the MSSQL Express Hosted Edition. If you create .mdf file on your local machine, so you can attach it to our MSSQL Express database.

Connect to SQL Server 2000 using Enterprise Manage

Solution

To connect to your Microsoft SQL Server database using Enterprise Manager to manage your database, you will need to follow the steps listed below:

- Open Enterprise Manager, navigate to SQL Server Group (default group).
- Right Click on SQL Server Group, select "New SQL Server Registration"
- Type the SQL Server Name and comma with port Number(25000) (found in your hosting control panel) in the Available Servers textbox and click Add. Hit Next.
- Select SQL Server Authentication as Authentication Mode. Hit Next.
- Type in the Login and password (can be found in the activation email). Hit Next
- Hit Next and Finish.

Backup/Restore your MySQL database

Solution

If you run a database driven website, it is important to backup your databases very frequently. You can generate a full back up to do this as well but sometimes it may not be unnecessary to backup everything, just to backup your databases.

To backup the databases please do the following:

1. Click Backups.
2. Under Download a MySQL Database Backup, click the name of the database.
3. Click Save As.
4. Select a destination for where you would like the back up to be locally saved.

If you have ever made a boo-boo with a database, you can always restore the database easily and quickly.

To restore a database, please do the following:

1. Click Backups.
2. Click the Browse button next to the option which says Restore a MySQL Database.
3. Select the sql file which you would like restored.
4. Click the open button and click the upload button.

This will now upload the sql file which you can see in the MySQL Databases section in cPanel. You can also make changes to it in PhpMyAdmin.

2) Email:

Pop Email Account

Solution

Incoming (POP3)	mail.your-domain.com
Outgoing (SMTP)	mail.your-domain.com
Outgoing SMTP	Authentication needs to be ENABLED
Outgoing port	default 25 (pop3-110)
Username	Your full email address

SPF record

Solution

SPF provides a way for a domain to tell the world that mail "from" that domain should only arrive from a specific list of mail servers. If the recipient's mail server checks, it can reject mail that arrives "from" a domain that comes from any other mail server.

The default SPF record sytanx :

v=spf1 -all -> it means mydomain.com never sends mail. We may need to do this when a domain is only used for web services and doesn't do email.

v=spf1 mx -all -> If the MX servers used to send mail.

v=spf1 a mx -all -> if the web server and the mx servers used to send mail.

You can enable SPF records by add txt record from your DNS manager, put the SPF record syntax as the txt record value.

3) FTP

Problems with FTP Connection

Solution

Please note that our Windows FTP servers require Passive Mode to be enabled in your FTP client. If you are having problems connecting or listing directory contents, then it is likely that Passive Mode is not enabled in your FTP client. The exact way to enable this will be specific to your chosen software, so you should check the documentation which comes with your software for further details.

If you are using FileZilla 2.x, you can find this option in the Site Manager, by selecting a site and clicking on the Advanced button. In FileZilla 3.x, you can globally select the transfer mode by using the Settings -> Connection menu

Upload Files

Solution

We support FTP (along with FTP compatible software) and Frontpage to upload files

you can also used File Manager for uploading files through control panel

FTP :-

ftp.yourdomianname.com

user name:- user name

pass:

FTP Client

Solution

Basically you can use any ftp client to access our ftp server. But we recommed http://www.smartftp.com/. It's free and reliable.

4) General Issues

500 Error (Internal Server Error)

Solution

This server uses suphp instead of running php as apache module, thats why 500 error occurs a lot from clientside. In most of the cases 3 issues are concerned regarding the 500 error.

1. Using php values and flags in .htaccess
2. Using a php file which has 777 or 666 permission
3. Putting wrong code in .htaccess (Other than php values)

To solve the 1st problem, use a php.ini file to put all the php values and flags. Previously to enable register_globals htaccess was used and it was defined like this under .htaccess:

php_flag register_globals = On

To enable register_globals just put the following code under a php.ini file created in public_html:

register_globals = On

To solve the 2nd problem, make sure you do not have a php file 777 or 666 permission. If you are unsure which file is 777 or 666 moded then just contact our support center to take care of it, they will make all the files under public_html to 755, and this should solve the problem.

To solve the 3rd problem, just make sure what you are writing in .htaccess are correct. In most of the cases, this is included in 3rd party documentation so its always recommended to contact the script owner / writer to solve such cases if you are unsure about the error.

How to change a php.ini value?

Solution

We use suPHP in all of our servers. This is the common reason why php_flag or php_value doesn't work on this servers. To change a value like "register_globals" or other you need to use a custom php.ini file put in the public_html folder.
Suppose, if you want to change the value of register_globals using a custom php.ini file, just put the following inside a php.ini file created on your public_html folder:

register_globals = On

It should set your register_globals value to On, If you want to set the value to Off, use the following:

register_gloabls = Off

Use the same settings for all available php.ini values to be configurable by users.

After you are done with setting up php.ini file, you need to set the suPHP configpath so that all other subdirectories in your public_html takes that php.ini as its default configuration file. To do this put the following line in your .htaccess:

suPHP_ConfigPath /home/username/public_html

You need to change two things to correct values from your account settings. Username set at the above configuration is your cpanel username. You also need to find what home directory you are on, if it is /home, you do not need to do any changes above, but if it is /home2 or /home3 etc, you need to change with correct values. This settings can be found in your file manager or Go to Cpanel and from the left menu find out the path to your "Root Directory" or "WWW Directory" or "Home Directory".

Thats it, you should be all ON

Exclusive Offer

Knowledge Base (FAQ)

Support Form

Designed & Hosted by YounazSoft & HostingPartner
A Project of Y I - Group