Ethical Internet Marketer – Make More Money Online… Ethically!

SUBSCRIBER QUESTIONS PART 2
———————————-

Question: How do you set up a database in mysql?

Tony

——————————————

ANSWER:

In order to create a database in MySQL, you need to login into your CPanel. Usually, this is the URL of your domain and then a :2082. So the full URL to your CPanel would be www.yourdomain.com:2082/ and then you need to enter the access details for your CPanel. In most cases, these are the same details you would be using to access your domain via FTP.

Step1:

After logging in, you are on the overview page where you find can links to dozens of items. You just need to locate the one which says “MySQL Databases”. Click on the link. You will now see an overview about the databases which already have been created. In your case, there will be nothing, yet.

In order to create your first database, you give your new database a name. This name should be related to the script you want to install. e.g. if you want to install AdSpyPro on your server and you want to create the database for it, call the database e.g. adspypro. So you enter this where it says “New database” and then you click the “Create database” button. Voila, your first database has been created…

Step2:

But in order to make it work for most scripts, you also need to add a username and give this user a password. This is done, where it says: “Current users” and then you can see the fields “username” and “password”. Just enter the details which you want to use there and click on “create user”.

Step 3:

Add the user to the database. In the section “Add users to database”, you choose the username which you”ve just created from the dropdown menu. The same goes for the database which has a dropdown menu next to the username. You need to make sure that the checkbox “All privileges” is checked and then you just need to click on the button “Add user to database”. That”s it.

When entering the details into some kind of config file for the script you want to install, it wants to have the username and database usually in a different form. It will add the ftp username in front of it. So this becomes yourdomai_username and yourdomai_database when entering the details into the file which connects to the database (usually a file called install.php, config.php or something similar). You will find this in the installation instructions for the software you want to install.

SUBSCRIBER QUESTIONS PART 1
———————————-

Dear Detlev ,

I have made an e-book but do not know how to get it onto a download page or how to put a paypal button on my sales page, and where in cpanel do I upload them too. Plus if I want to buy another domain name how and where do I put it in my cpanel it says I have unlimited addons and sub domain space but I don’t understand the information page they supply its all geeky to me.

I have also read that everyone should have a list but what do I write to them all the info on this subject is for marketing but I have a self hosted wordpress blog on craft, www.findacraft.com

Thank you for caring enough to ask what we your subscribers need and yes you may use my name and question if you would like.

Sandra

ANSWERS:
———-

Hi Sandra,

Thanks for submitting your questions. I will answer them one by one so it is easier to follow.

Question 1.) I have made an e-book but how to get it onto a download page?

If your ebook is ready to be sold, all you have to do is upload it to your server. So if the filename is something like funwithcrafts.pdf, you should upload the pdf file using a FTP software. If you don”t know how to use such a FTP software, you can have a look at my video which I have done for members of my Nichecontentwebsites.com. Just sign up for free at www.nichecontentwebsites.com/ and go to the download page. There you will find it.

Files are not uploaded to a CPanel but to your server. A CPanel just helps you to organize and create some things like email addresses, stats, databases or execute some scripts using Fantastico which is nothing more than a collection of different scripts under one roof so to speak. There also is a section called “web upload” or “web FTP” in your CPanel but you should always do it with an FTP software as it is much easier to handle. Most of these FTP programs like CoreFTP or WS_FTP are completely free to use. Just do a search for these program names on Download.com.

You should try to make the download location or filename very hard to guess so people cannot get the file for free. In other words, don”t just upload the file with the same name as your domain name and then put it into the root folder. You need to protect it. Give either the file name itself a weird name like 4746funwithcrafts.pdf or upload it to a folder which is hard to guess.

Something like /public_html/4747thanks88/ on your main server.

With regards to the download page: After you are done uploading, you need to create the download page itself from where people can access the ebook which they”ve purchased. This means, on your download page, you need to create a link which leads to your exact download location. Taking the example from above, you would be writing something like:

“Thank you for your purchase. Please find below the download link for Fun with crafts”:

Fun with crafts – Click here to download

which would be linked to:

www.yourdomain.com/4747thanks88/funwithcrafts.pdf

The whole download page with the above link should be saved as index.htm and uploaded to your download location /public_html/4747thanks88/ and this also is the return URL for customers who have paid for your product (e.g. in Clickbank it is the so called “thankyou page” – in this case www.yourdomain.com/4747thanks88/index.htm).

The download page should always come second, though. It is much more important that you have a good salesletter which convinces people to buy…

Question 2: how to put a paypal button on my sales page?

This used to a be a question which was quite easy to answer. But with the recent changes Paypal has made to their interface, it”s hard to locate the section where you are supposed to create the payment buttons. They are almost completely hidden somewhere in the “Merchant tools” area and that”s why I am not creating the buttons in their own interface anymore. In the German Paypal version, you cannot even locate the section anymore where the buttons can be created. You click from one link to the next only to be led into a circle of descriptions about the process but no link to the actual creation page.

To make a long story short: I am using a software for creating my buttons. It”s called “Paylock Generator”. You can get this for around $1 on Ebay if you don”t have it yet. This software also allows you to encrypt the code which is used for processing the sale. In order to protect your download location, it is important to activate the encryption or people can just view the source code and see the URL where you have placed your file into.

Paypal also needs to know what the “thankyou page” (download page) is in order to redirect the customer to this page after the payment has been processed. This is usually the page which is linked to the button “Return to merchant” when having completed the payment. Often, people forget to click that button, though. Then they”ll be asking you for the download location via email. In this case, you need to send them the link to your thankyou page manually after having checked that they really have made a payment.

Question 3: where in cpanel do I upload the Paypal button to?

The button will not be uploaded to your CPanel. As I”ve explained above, you use a software to create the HTML code for your Paypal payment button. This code, which is produced by the software, needs to be pasted into the HTML code for the page you want to use as your salesletter. In other words, instead of just being in “normal view” within your HTML editor (like Frontpage), you switch to “HTML code view”. There, you need to locate the section which should contain your payment button.

This is done by comparing the visible “normal view” part from your HTML page with the HTML code. e.g. you have a sentence like “Click the Paypal button below to make your payment” on your page. Then you do a search for this sentence in your HTML code and paste the code from Paylock Generator directly below this sentence. Then, you save the page. When viewing the page in “normal view” again, the Paypal button should come up. Last but not least, you simply upload the whole salesletter (e.g. index.htm to the root folder /public_html/) of your server and then the whole process is completed.

Question 4: Plus if I want to buy another domain name how and where do I put it in my cpanel?

The way addon domains work is like this: You have an existing main domain which uses 1 IP address (a domain name written in digits like 202.757.28.123). Addon domains are added to the same IP address and use the same FTP details like the main domain. You would have to add the domain name within your CPanel where it says “Addon Domains” and in the field “New Domain Name:”, you add the name of the domain you want to add. Usually, it is without the www. part. It will then take the first letters of that domain name and create your username from this. This username will also be the addon directory name on your server for your main domain. In order to make your subdomain work, you will have to upload your files exactly into this directory.

e.g. your addon domain is: bizbuilder.com. You would enter this as addon domain in your CPanel. At the same time, a directory called “bizbuilder” will be created on your server. You can access this folder by using your FTP software again. In order to have content show up when pointing your browser to your www.bizbuilder.com/ domain, you need to upload all the pages for this domain to the folder “bizbuilder” on the server of the main domain. This is the case for all addon domains you are adding. They will all be using the FTP details from your main domain and you upload their contents into the folders which have been automatically created when adding a new addon domain.

It is important, though, that you also add the DNS or nameservers from your hosting provider into the DNS fields at your domain registrar for the new domains you are adding. You will get these DNS server details from your hosting provider when you sign up with them. The DNS servers are usually something like ns1.slhost.com and ns2.slhost.com so you have to add 2 servers. In Namecheap.com, you have to select the domain name by checking it and then clicking on the “Edit selected” button at the bottom. On the next screen, under “General”, you will find a link which says “Domain Name Server Setup”. Enter your 2 nameservers there and click on “Save changes”. That”s it. Your domain name should be resolved worldwide within 24 hours.

Question 5: what do I write to them?

First of all, after having viewed your blog, I would suggest you take one of the better ready made WordPress templates for this. I don”t want to hurt your feelings but the blog simply doesn”t look professional enough. An extensive list of WordPress themes can be found here (it”s the biggest list of WordPress themes that I know of):

Emily Robbins” list of 980+ WordPress themes

Moreover, you should get rid of the unrelated links. Why are you mentioning something about SEO there? Do you really think someone interested in crafts would click on these links? Remove them! The same goes for the link to the free ebook about Google Adsense…

If you want to give away a free ebook then use one which is on topic or create a free report yourself which you can give away to your visitors. Use it as an incentive for getting an opt-in. Also get rid of the SEO link at the bottom. This is completely distracting from your main purpose which is to attract people interested in crafts. Your site should always keep its” focus and not be a supermarket where everything under the sun should be available.

Back to your question. What to write about…? You have chosen the topic of “crafts” so people visiting your site will be interested in what you have to say about the topic of crafts, of course. Not SEO, not Adsense but crafts. If you have always loved crafts like you are saying on your blog then tell them why you love it so much.

Tell them how they can make their own crafts – in all possible details (take pictures of you doing crafts, create a video showing them how to create crafts etc.). Tell them where they can buy ready made crafts. Give them all the info on crafts they could be interested in. If you were coming to a site about crafts yourself, what would you like to see on such a site…?

Put yourself in your visitor”s shoes and then write about the things that could be interesting for them from your personal perspective. Inject your personality and write to them as if you”re explaining something to a friend. If you don”t know what to write about, have a look at other people”s crafts websites by doing a search on Google.

Visit craft forums to find out what people want to hear about. And if you absolutely have no idea, go to Ezinearticles.com and read some articles about crafts and then write your own or use the best ones which you can find there and put them on your blog. I recommend writing your own content, though. You will have more success in the search engines and your visitors also will appreciate it, if your content is original and cannot be read on hundreds of other websites. Then they would have no reason to stay on YOUR site!

P.S.: You can still submit your own questions here:

www.ethicalinternetmarketer.com/helpdesk/

Starting this summer (when I will be back in Germany), I will be doing more content writing for this blog as I realize that I was probably not doing enough in this regard. Sorry about that. I was quite busy with some other projects and also the coaching thing here on Mauritius.

Rather than deciding on all of the topics for this blog myself, I want you to take part in the process. That”s why I am asking you to submit any burning marketing questions you have or anything that you want to hear more about. Please submit the questions and topics at my helpdesk. What are you problems and stumbling blocks when building your Internet business? What is holding you back? What technical things are you afraid of? You can also have a look at my blog”s categories to find the areas that I can help you with.

Several of these questions will be answered directly as I will pick a few of them and answer them here on my blog. The questions should be directly related to making money online and Internet marketing. Of course, I probably won”t be able to answer them all but the best ones will also be answered in my upcoming Internet marketing ebook (I have completed about 42 pages and I still have a long way to go to get everything into it…).

Last but not least, please also mention if I can use your name together with the post or if you”d like me to keep your details anonymous. Depending on the number of questions I am getting, it can take some time to go through them and answer them. Please be patient.

You will certainly know the problem if you ever wanted to bring your new and professionally designed web pages online: Which hosting company should you choose? After all, there are hundreds or even thousands of them. What are the key aspects you, as an Internet marketer, have to watch out for?

01. Service/Support

It is very important that you always have someone to talk to if you have made a deal with a hosting company. If your web site is down for several hours it might cost you hundreds or for some of us even thousands of dollars in sales. Fast action is necessary then, so it’s vital to your business that you can reach them 24 hours a day, 365 days a year. Another thing to watch out for is professional assistance for installing and uploading scripts or complete web sites if you’re not familiar with it.

02. Reliability

The uptime of a server should be at least 99%. The best thing is if the company can provide mirror servers which will be accessible if the hardware server has to be maintained or the like. Look out for testimonials or awards on their site. If they don’t have them, ask if they can provide you with some email addresses of satisfied customers which you can ask about it or about reviews of their service.

03. Cost Effectiveness

It would not make sense to choose a hosting company that offers all important features but costs you a small fortune each month. No hosting with the here mentioned basics should cost you more than $20 per month. Anything above that would be a waste of your dollars. This is meant for home based businesses, though. Professional high budget companies might have to meet different criteria.

04. Modern Hardware

You need to make sure that the hosting company uses the best, fastest and most reliable servers you can get for your money. If the speed of the servers can not keep up with the demand of web pages for your domain, your web site will slow down and might take ages to load. Again, look out for testimonials.

05. Easy to use CPanels

There are several different administrations panels available for your web hosting but certainly one of the best is the Cpanel. It offers all the great features under one roof and especially their Fantastico script collection where you can install most scripts by adding a few details and clicking your mouse button.

06. Enough POP-email Accounts

It is important that you have some mechanism in place to sort out your emails automatically into different folders. If you have enough email addresses to use, you can file them into these folders by sorting them according to the receiver email address. e.g. all article submissions for your ezine go into folder from the email address articles@domain.com .

You want to make sure that your email addresses reflect your domain name if you’re an online marketer. POP-email account means that you can use any email client to automatically receive your incoming emails. You don’t need to login on a web site and check your emails there. This can be a very tedious and time consuming task. A Hotmail or Zwallet account is not advisable for any professional business emails!

07. Free CGIs

There are a lot of cgi programs available which will enhance the functions of your web site. These options include using scripts for automatic capturing of email addresses with little pop-up boxes like Opt-in Lightning. Then you must upload that script to your /cgi-bin directory to make it work. Just uploading to your web space will not do the job. Other possibilities for these scripts are tracking features for your ads so you can directly see how successful your advertising campaigns have been.

08. Enough Web Space Included

In the beginning, you will be tempted to go with the lowest amount of web space included because you might be on a tight budget. After all, those web pages just have a size of just a few kb , so most will not even reach 100 kb per web page. But you have to think in the future, too. Do you want to offer a lot of free downloads like software demos, free ebooks and similar items? Then you must be prepared that it will take a lot of your space.

Also, if you update your web site frequently (which should be a matter of course), you will need much of that space. I have experienced this at first hand with my own web site. I started with just 10 MB web space and after 4 months it was too small already. If you have reached your web space limit, you are not able to upload any new content and files to your web site and you might have to wait a week or so before you have upgraded your web space…! This could mean a delay in your marketing activities and you don’t want to risk that.

09. Enough Bandwidth Included

Most of us will start small if we bring a new web site online, so the need for bandwidth will not be urgent at that time. But what if your company grows and with it the traffic that comes to your web site? Will you have to pay additional fees because you just have 1 GB transfer volume included? I’ve seen several sites already which were switched off by their hosting company because they used too much bandwidth.

But you want to have large amounts of traffic, do you ? So make sure that you don’t have to pay for this additional traffic or you wil not be able to relish your prospering business… In most cases, 10 GB bandwidth will be enough even for high traffic sites. If you’re offering a lot of downloads, you might need more than that, though.

10. Extensive statistics

This is one of the most important features a web hosting company should offer. You will have to analyze where your traffic comes from and how successful certain advertising campaigns are. You can even set redirect pages which can be viewed in your statistics so you don’t have to use a tracking service. You must be able to view the referrers, your daily unique visitors and which pages have been accessed.

If you also can see which keywords at the search engines have lead your visitors to your site, it can be worth its’ weight in gold. You will be constantly working with this information for improving traffic and performance of your web site, so you should take this point very seriously. A last tip from me: Make sure that the company you’re working with is at least two years in business already. You don’t want to consign your web site to an unreliable company which will be going bancrupt because they could not handle their business correctly…

===========================

==> The hosting company which fulfills all of these requirements and the one I’m mentioning if I’m asked about which hosting provider I recommend, the answer is Hostmonster.com. They offer 300 GB of web space and 3000! GB of bandwidth. Moreover, you can host unlimited domains with them.

If you’re looking or trying hard to build backlinks for your sites, this is a no brainer. With a membership to a new site called “Backlink Solutions”, you can land hundreds of high quality backlinks to any site you wish.

And I think, I don’t have to tell you anymore how important backlinks are for your search engine rankings…

For starters, you can link from over 100 plus sites across over 60 plus unique IP’s… and more sites and IP’s being added each month:

tinyurl.com/2sqncf

The sites are pure white hat and you can only link to pure white hat sites. This way, you can be assured
that your links will last.

How does it work? Backlink Solution offers a centralized access to a network of blogs to which you can post real unique articles with a link back to your site. Once you’ve signed up with them, you can login into any of their blogs and make a post – no spamming allowed!

Here is just a taste of what Backlink Solutions offers:

– Exclusive access to hundreds of websites with PR from 1-4 (and later maybe even higher PR sites)

– Mature – minimum of 1 year old

– Link from popular sites that are spidered daily from the big 3 search engines

– All sites are sitting on a large number of different C-class IP’s (meaning they will count as individual
backlinks)

– Grab unlimited backlinks from all sites relevant to your niches

– Use your keyword anchor text contained within relevant content

– Link from niche related sites, all containing several sub niches

– Gain hundreds of backlinks for all your sites and all the sites you’ll ever have

– No limits to how many sites you can receive links for

– Deep link your sites for as many pages as you want (meaning you don’t just have to link back to the
homepage of your site – this is pure gold!)

– Your links will be permanent as long as you’re a member in good standing

– You only pay a flat monthly rate regardless of how many links you grab

The only thing is… the price goes up after just 50 members, and people are moving FAST on this one.

tinyurl.com/2sqncf

I saw a similar site some weeks ago but that other site charged $147 a month for it which I found quite steep. And now you can become a member of a similar site for less than $100. I signed up already and I love the way the site is structured.

This will become my secret weapon in getting all of my sites ranked highly in the search engines quickly – not to speak of the advantages of very quick indexing. The quicker your sites get indexed, the more money you can make.

Well?

I know one thing… I wouldn’t be sitting here pondering “what if” questions anymore if I just found out all of
these benefits! I would be securing my extremely low price right now – after all, there are only 50 memberships at that price and this email is going out to close to 7000 people.

Here’s that link again:

tinyurl.com/2sqncf

To Your Success,

Detlev Reimer

=========================

P.S.: (This message has been sent to my list as well)