Showing posts with label Web Design. Show all posts
Showing posts with label Web Design. Show all posts

What is a domain name? | Bangla Tech Jagat





A domain name is your website name. A domain name is the address where Internet users can access your website. A domain name is used for finding and identifying computers on the Internet. Computers use IP addresses, which are a series of number. However, it is difficult for humans to remember strings of numbers. Because of this, domain names were developed and used to identify entities on the Internet rather than using IP addresses.


A domain name can be any combination of letters and numbers, and it can be used in combination of the various domain name extensions, such as .com, .net and more.

The domain name must be registered before you can use it. Every domain name is unique. No two websites can have the same domain name. If someone types in www.yourdomain.com, it will go to your website and no one else's.

The price of a domain name typically runs between $15-25 per year.

With Website.com, a professional domain name is included for free with all premium site builder plans. With our current promo, you can own a custom domain name and create your entire website at only $2/month for the first year.

Professional emails at your domain name can also help you boost your credibility and build your brand. Email accounts are included with Website.com Business plans and above, starting at the promo price of just $5/month for the first year.

Why you need a Domain Name

On the Internet, your domain name is your unique identity. Any individual, business or organization planning to have an Internet presence should invest in a domain name. Having your own domain name, website and email addresses will give you and your business a more professional look. Another reason for a business to register a domain name is to protect copyrights and trademarks, build creditability, increase brand awareness, and search engine positioning.

With Website.com's premium plans, as a domain name is one of the most crucial tools to build your reputation, we include your custom domain name in your plan for free.


Free Domain Names


Free Domain Names are sometimes available from certain providers, and are usually in the form of [yourname.webhost.com]. A domain name in this format is also known as a subdomain.

Although a subdomain is free and functional on the Internet, it has its limitations:

  • Your professional image will not be as strong as having a custom domain name.
  • It is not easy for your visitors to find your website, as now they need to remember your website name as well as your host's URL.
  • You will not be able to transfer the subdomain to another web host.
Free site builder plans with Website.com provide you with a free subdomain so you can start building your online presence right away! However, when you are ready to take your online presence to the next step, you will need a professional domain name.

The good news? All Website.com premium plans include professional domain names in your plan - for free.



How to export data from a single table and import into single table using phpMyAdmin? | Bangla Tech Jagat




There may be times when you need to export data from a single table and import it into a single table using an existing database phpMyAdmin.  In this post, we will discuss how to export data from a single table and import into a single table using phpMyAdmin?

Here is a scenario when such an activity may be needed for better understanding. This is from my practical experience.

So, there is this WordPress website we had, and the theme has to be customized. Since we did not want to disrupt the live site, we took a backup and installed a copy on the development system to further customize the site. During the customization process, we ran into some issues. And to isolate the problem, we disabled some plugins to check if the plugins were interfering with the problem.

The problem was, we were using a WordPress plugin called "Post Views Counter" to display views on each post. During the troubleshooting process described above, we also disabled the "Post Views Counter" plugin (or maybe even deleted it from the plugins page in WordPress). Later when we re-installed / re-enabled the plugin, we found the stats have been reset. The post views were all zeros. And we wanted to retain the values.

After the required customization was done, we needed to bring the stats from the "Post Views Counter" to the live site to the development site, before we upload it to the live server. Note: There could have been another way to do this, but we didn't want to take a risk. More on this described at the end of this post.

So here is what we did: export data from a single table and import into a single table using phpMyAdmin.

How to export data from a single table using phpMyAdmin?

To backup only one particular table in phpMyAdmin, click on the particular table and click Export. It will only export the table and not the entire database.

Activities on the live server:
Logged in to phpMyAdmin
Backed up the entire database (just in case needed)
Clicked on the particular table from the left sidebar (ngk_post_views in this case)
Clicked Export
This exported only the table (ngk_post_views in this case) in .sql file


Now that we have the backup of the particular table (ngk_post_views in this case), we need to restore it to the development server.


How to import data from a single table using phpMyAdmin?

To import data from a single table using phpMyAdmin, the process is the same as importing database. BUT, the table you are importing should not exist. Otherwise, phpMyAdmin will throw an error.




Activities on the development server:
Logged in to phpMyAdmin
Backed up the entire database (very important)
Click on the Database
Then select the table we will import, and click drop (table).





The Select T Database Again, Just In Case It Is Not Selected
Click and Import and Select T Backup File of TABLEDownloaded from Live Server



If Every Thing Gets Better, T Import Solda Success (Unless There Are Other Issues, Whitch Bay DD Note Encounter)





We clicked on the table and checked the values and the counts were restored.
View the posts on the site's front end, and we can see the counters restored.
Now that the post view counts have been restored, we have migrated the site to the live server.



By the way, to upload your WordPress website to live server, you can use plugins like "Duplicator". Here is a previous post on -How to use "How to download a website from live server to development local server |   Bangla Tech Jagat



As mentioned above, this could have been achieved in another way.
We could have "dropped" the post views table from the development system of phpMyAdmin and then exported the database. When this is uploaded to the live server, the post views table on the live server database is expected to be as it is. Ensure backups are taken before attempting any of the examples in this post, and at your own risk.


Google Search

The Web Only Soulsbox