XeonBD

Blog

XeonBD's Blog → General

Archive for General

Introduction to SEO

Posted by on May 18, 2013


What is SEO?

SEO is the abbreviation of Search Engine Optimization and it is a process to bring relevant visitors to your site by following the rules and regulations of search engines. The traffic which comes through SEO is unpaid, it is known as natural traffic or organic traffic.

Whenever you enter a question in a search engine and hit ?enter? you get a list of web results that contain that query term. Users normally tend to visit internet sites that are at the top of this kind of list as they understand those to be more relevant to the query. If you?ve ever wondered why many of these websites rank better than the others then you need to know that it is because of a powerful web marketing technique called???Search Engine Optimization (SEO).

SEO is a method which helps search engines locate and rank your website higher than the millions of other sites in response to a search query. Search engine optimization thus helps you acquire traffic from search engines.

This SEO tutorial covers all the necessary information you need to know about Search Engine Optimization ? what is it, how does it work and differences in the ranking criteria of major search engines.

How Search Engines Work

The first basic reality you need to know to learn Search engine optimization is that search engines usually are not humans. While this might be obvious for everybody, the actual differences between how humans and search engines view web pages are not same. Unlike humans, engines like google are text-driven. Although technology advances rapidly, search engines are far from smart creatures that can notice the beauty of a cool design or enjoy the seems and movement in movies. Instead, search engines like google crawl the Web, looking at particular site products (mainly text) to obtain an idea what a website is about. This short explanation is not the many precise because as we will see next, search engines carry out several activities to be able to deliver search results : crawling, indexing, processing, calculating relevancy, as well as retrieving.

First, search engines crawl the Web to see what is there. This task is performed by a piece of software, called a crawler or a spider (or Googlebot, as is the case with Google). Spiders follow links from one page to another and index everything they find on their way. Having in mind the number of pages on the Web (over 20 billion), it is impossible for a spider to visit a site daily just to see if a new page has appeared or if an existing page has been modified, sometimes crawlers may not end up visiting your site for a month or two.

What you can do is to check what a crawler sees from your site. As already mentioned, crawlers are not humans and they do not see images, Flash movies, JavaScript, frames, password-protected pages and directories, so if you have tons of these on your site, you?d better run the Spider Simulator below to see if these goodies are viewable by the spider. If they are not viewable, they will not be spidered, not indexed, not processed, etc. ? in a word they will be non-existent for search engines.

Pin It

Posted in: General, Hosting Service

Leave a Comment (0) →

How to subscribe IMAP email folders in outlook 2010

Posted by on May 13, 2013

Hello, if you use an IMAP connection with Outlook 2010 and you’ve created additional folders outside of Outlook, you may have trouble seeing these new folders. In order to view your new folders in Outlook, you will want to subscribe to those folders. In this tutorial, we’ll walk you through the process of subscribing to an email folder in Outlook 2010.

Please go through the following steps,

  1. Start by opening Outlook 2010 on your computer.
  2. In the navigation pane, right click the email account (e.g. you@yourdomain.com).
  3. In the right click menu, choose IMAP Folders.
  4. In the IMAP Folders pop-up window, click the Query button.
  5. In the list of folders that appears, choose the folder you want to subscribe to and click the Subscribe button. (If you have more than one folder you want to subscribe to; hold down the Ctrl key on your keyboard, click each folder, and then click the Subscribe button).

If you have any trouble viewing all of your IMAP folders, you can update the list in Outlook:

  1. Right click the email account
  2. Choose Update Folder List.
  3. Repeat steps 1-5 in the section above to subscribe to any folders as needed.

Your newly subscribed folders should now be visible under your email account in Outlook 2010.

Pin It

Tags: , ,

Posted in: General, Hosting Service

Leave a Comment (0) →

What does the different extensions mean

Posted by on December 25, 2012

The most common question is “What do the different extensions mean?” The newest web extensions are explained below. . . select a particular domain extension that you would like to learn more about from the list below.

Extensions are categories of Internet domain names. There are several of them to choose from:

.com represents the word “commercial,” and is the most widely used extension in the world. Most businesses prefer a .com domain name because it is a highly recognized symbol for having a business presence on the Internet.

.net represents the word “network,” and is most commonly used by Internet service providers, Web-hosting companies or other businesses that are directly involved in the infrastructure of the Internet. Additionally, some businesses choose domain names with a .net extension for their intranet Websites.

.org represents the word “organization,” and is primarily used by non-profits groups or trade associations.

.biz is used for small business Web sites.

.info is for credible resource Web sites and signifies a “resource” web site. It’s the most popular extension beyond .com, .net and .org.

.mobi (short for “mobile”) is reserved for Web sites built for easy viewing on mobile devices.

.us is for American Web sites and is the newest extension. It has the largest amount of available names in inventory.

.cc was originally the country code for Coco’s Keeling Islands. It is unrestricted and may be registered by anyone, from any country.

.bz was originally designated as the country code for Belize, but is now commonly used by small business who can’t get the name they want using the .biz extension. It is unrestricted and may be registered by anyone, from any country.

.tv is for rich content/multimedia Web sites, commonly used within the entertainment or media industry.

.vg is the country code for the British Virgin Islands. It is unrestricted and may be registered by anyone, from any country.

.ws was originally designated as the country code for Western Samoa, but is now commonly used as an acronym for “Web sites.” It is unrestricted and may be registered by anyone, from any country.

.name is the only domain extension specifically designed for personal use. It is commonly used for easy to remember e-mail addresses and personal web sites that display photos or personal information about an individual.

.co.uk is the country code for United Kingdom. The .co portion of the extension indicates the domain name is for commercial purposes (similar to a standard .com extension). It is unrestricted and may be registered by anyone, from any country.

.org.uk is the country code for United Kingdom. The .org portion of the extension indicates the domain name is for an organization. It is unrestricted and may be registered by anyone, from any country.

.me.uk is the country code for United Kingdom. The .me portion of the extension indicates the domain name is for an individual. It is unrestricted and may be registered by anyone, from any country.

.de is the country code for Germany. It is unrestricted and may be registered by anyone, from any country. If you are not a resident and citizen of Germany, the Administrative Contact for this domain name registration will automatically be assigned Network Solutions’ German proxy contact information.

.eu is the country code for the European Union. Registration of .eu domain names requires registrants to meet one of the three eligibility requirements: have a registered office, central administration or principal place of business within the European Community; have an organization established within the European Community without prejudice to the application of national law; or be a natural person resident within the European Community. Alternatively, you can secure the use of a .eu domain name by using Network Solutions .EU Registration Service. Network Solutions Europe, LLC is the registrar for all .eu domain names. Click here for more information.

.be is the country code for Belgium. It is unrestricted and may be registered by anyone, from any country.

.cn is the country code for China. It may be registered by businesses, organizations and sole proprietorships from any country.

.com.cn is the country code for China. The .com portion of the extension indicates the domain is for commercial purposes (similar to a standard .com extension). It may be registered by businesses, organizations and sole proprietorships from any country.

.net.cn is the country code for China. The .net portion of the extension represents the word “network”, and is generally used by internet infrastructure providers. It may be registered by businesses, organizations and sole proprietorships from any country.

.org.cn is the country code for China. The .org portion of the extension indicates the domain is for an organization. It may be registered by businesses, organizations and sole proprietorships from any country.

.cn Regional names. There are 34 regional .cn extensions available, for example, .bj.cn. The .bj portion of the extension represents Beijing and the .cn represents China. These extensions may be registered by businesses, organizations and sole proprietorship from any country.

.tw is the country code for Taiwan. It may be registered by businesses, organizations and sole proprietorships from any country.

.com.tw is the country code for Taiwan. The .com portion of the extension indicates the domain is for commercial purposes (similar to a standard .com extension). It may be registered by businesses, organizations and sole proprietorships from any country.

.org.tw is the country code for Taiwan. The .org portion of the extension indicates the domain is for an organization. It may be registered by businesses, organizations and sole proprietorships from any country.

.at is the country code for Austria. It is unrestricted and may be registered by anyone, from any country.

.com.mx is the country code for Mexico. The .com portion of the extension indicates the domain name is for commercial purposes (similar to a standard .com extension). It is unrestricted and may be registered by anyone, from any country.

.co.nz is the country code for New Zealand. The .co portion of the extension indicates the domain name is for commercial purposes (similar to a standard .com extension). It is unrestricted and may be registered by anyone, from any country.

.net.nz is the country code for New Zealand. The .net portion of the extension represents the word “network”, and is generally used by internet infrastructure providers. It is unrestricted and may be registered by anyone, from any country.

.org.nz is the country code for New Zealand. The .org portion of the extension indicates the domain name is for an organization. It is unrestricted and may be registered by anyone, from any country.

.gs is the country code for the South Georgia & South Sandwich Islands. It is unrestricted and may be registered by anyone, from any country.

.tc is the country code for the Turks & Caicos Islands. It is unrestricted and may be registered by anyone, from any country.

.ms is the country code for Montserrat. It is unrestricted and may be registered by anyone, from any country.

.fm is the country code for Federated States of Micronesia, but is commonly used for FM radio.

.am is the country code for Armenia, but commonly used for AM radio.

.la is the country extension for Laos, but also used for Los Angeles, Louisiana or Latin America.

.us.com is an alternate domain for the United States

.uk.com is an alternate domain for the United Kingdom

.eu.com is an alternate domain for the European Union

.de.com is an alternate domain for Germany

Pin It

Tags: ,

Posted in: Domain Registration, General

Leave a Comment (0) →

Useful WordPress Plugins

Posted by on March 19, 2012

There are several thousands of WordPress plugins in the WordPress community and new plugins are coming out each and every day. However, not all plugins are useful, in fact some are very bad written that will mess up your site or harm your WordPress installation. So how do you know which plugins are right for you? Well, here is a list of plugins those are found useful. Hopefully you will find something useful here.

WP Cache

To save your SQL server resources, WP Cache works by caching Worpress pages and storing them in a static file for serving future requests directly from the file rather than loading and compiling the whole PHP code and then building the page from the database. It is a very useful plugin if you have a high traffic site or low performance server.

WP eCommerce

Want to sell stuffs on your blog? You must check out this WP eCommerce plugin byInstinct. It is an Ajax powered shopping cart, very easy to use. You can setup your shop in minutes through the Admin panels.
Intouch Ajax contact form
I’ve been using this contact form for over a year. It works very good and filters all the spams. Seriously, NO SPAM at all. It also allows you to customize the email subject, thank you messages, and adds addition form fields.
Secure and Accessible Contact Form
Another contact form by Mike Cherim and Mike Jolley. Although, I have never used this contact form before, but I’ve been hearing good rating on them. So, give it a shoot.

Sideblog

One of the popular WordPress plugins, Sideblog is the best way to post short notes on the sidebar. I use it for Best Web Gallery. It gives you options to define the sideblog category, how many entries to display, and whether to exclude from RSS feeds.

WP PageNavi

WP PageNavi adds a better paging navigation to your WordPress site. It is nice if you have a lot of posts because it allows your visitors to skip from page to page. I use it onN.Design Studio and Best Web Gallery.

Sociable

Sociable appends a list of the social bookmarking sites (ie. Digg, Del.icio.us, Reddit) at the end of your posts and allows your visitors to bookmark. I used this plugin before and it worked very well.

Ajax Post Rating

WP Post Ratings adds a 5-star Ajax rating system to your posts/pages. It works like a charm. Hint: most CSS gallery sites use this plugin.

Ajax Comment

A very simple yet effect Ajax comment plugin, it checks if all fields filled correctly (so your visitors will never see the default error messages), and also makes sure to avoid comment duplication, and has flood protection capabilities as well.

Ajax Inline Comment

This plugin gives your visitors an Ajax live comment preview. It is great if they need to enter HTML tags in your comments. So, no more syntax errors in your comments.

Ajax Polls

As seen on Web Designer Wall, it adds a Ajax poll system to your site. It is very flexible with a lot of features. Layout is completely customizable via Admin panels. It also allows you to archive the polls. Highly recommended!

Gravatar 2 Plugin

It basically display a Gravatar (globally recognized avatar) of your commenters. In case you don’t know yet, Automattic (WordPress creator) just acquired Gravatar and the future Gravatar services will run faster and bigger sizes (up to 128px).

Digg This

Digg this is a WordPress plugin that detects incoming links from Digg.com to your wordpress post and automatically display a link back to the digg post, for people to digg your story. When a digg is first recognized, it will send an email to the site’s admin.
Subscribe to comment
Subscribe to Comments 2.1 is a plugin that allows commenters on your blog to check a box before commenting and get e-mail notification of further comments. You probably seen it already, it adds a checkbox “Notify me of followup comments via e-mail” in the comment form.

Admin Drop Down Menu

I’ve been this plugin since my first WordPress site, it is a must have for every WordPress site. It saves me so much time and clicks. It basically makes your secondary menu activate on mouseover. For example, instead of click Write, then click Page; you can mouseover Write and click Page (this will save one click and one pageload). Big time saver!

Adsense Deluxe

Adsense Deluxe is probably the best Adsense plugin available on the web. Very easy to use: first you define your ad code through the Admin options, then insert a HTML snippet (“”) into anywhere of your post content, and it will automatically repace it with your ad code.

Search Everything

Default WordPress search engine doesn’t search metadatas, static Pages, etc. This plugin allows you to search everything in the database. Of course, it comes with options, so you can set what to search.

Ajax Calendar

If you use calendar in your sidebar, consider this Ajax Calendar. Your visitor can browse through the calendar without refreshing the page.
Breadcrumb Navigation XT
Although not many sites use breadcrumb navigation now, but if you want, here is one:Breadcrumb Navigation XT. It basically lets you add a breabcrumb navigation to your site.

Google Sitemap Generator

If you need to generate a XML compliant sitemap for search engines, Google Sitemap Generator is the best choice (supported by most popular search engines: Google, Yahoo, Ask.com, and MSN).

Simple Recent Comments

Another must have plugin. In fact, it is in all my WordPress sites. It outputs a list of recent comment excerpt. You can install as WordPress plugin or simply include in your theme folder (no activation required). Simple!

Simple Tags

As of version 2.3, WordPress has a built-in tagging system, however with very limited features. Simple Tags gives you more features: type-ahead / auto suggestion tags, manage tags (rename, delete, add..), edit mass tags, dynamic tag cloud colors, and more!

WP Mailing List

Not sure if anyone would still signup newsletter since we have RSS now. But newsletter is the best way to inform your subscribers with new products and updates. I find this plugin will be useful if you run a WP eCommerce shop. It is not free (cost $14.99), but totally worth it (check out their features).

Category Tag Cloud

If you want to fake your categories into a tag cloud like what I did at Best Web Gallery, here is the plugin Category Tag Cloud. It is very easy to install and customize.

Paged Comments

This plugin is useful if you get a lot of comments on your blog. It breaks your comments into a number of pages. Imagine if your blog gets over a thousand of comments? You definitely need this plugin.

flickrRSS

This plugin allows you to easily display Flickr photos on your weblog. It supports user, public and group photostreams. The plugin is relatively easy to setup and configure via an options panel. It also has support for an image cache located on your server.

Theme Switcher

Theme Switcher allows your readers to switch among installed themes. This plugin is useful if you offer WordPress theme and you want to let your users to preview the themes. I use it to showcase my free WordPress themes.

Pin It

Tags:

Posted in: General, Open Page, Wordpress

Leave a Comment (0) →

How to inject javascript, iframe and malicious code in to index page and it’s solution!

Posted by on April 29, 2011

Hello,

I hope the following information will be helpful for you.

Normally, The virus attacks following files on your server:

1.  index.php
2.  index.html
3.  main.php
4.  header.php
5.  footer.php

At the start or end of these files it will insert the  <IFRAME>,  javascript php or malicious encoded code:

What it does?
—————-
I can only guess. The code is calling a script on online-channels.info site. It can be sending traffic information. Maybe it is a first case of Internet marketing espionage? Or it can be trying to run some malicious code.

What it does?
———————–
He save your FTP password, acces you account, and instal in your index files, (Index from all directory) an <IFRAME> code that will open a virus page in your index of the forum.

How it’s done ?
——————-
This is a sophisticated operation, and the infection cycle is involved, but basically, the hacker(s) are setting up innocent looking sites (or using previously hacked sites where the owner is usually unaware of being compromised) and loading them with expensive hacking tools like Mpack. When someone visits that site, their browser is detected and attacked (browsers affected are IE, firefox and opera). The visitor is unaware that they may have a keylogger that sends the persons passwords ect to the hacker(s) and moves on. If the innocent visitor has an ftp or root password for any internet sites, the hackers use a program that goes to the persons site(s) and instantly adds the hidden iframe to every index type page. This is why there seems to be no indication that the site has been compromised, as the hackers already have the ftp or root passwords to login. And since they have at least your account ftp pass, whatever permissions your folders and files are set to make no difference.

After they put the iframe code into that person’s pages, anyone visiting that site will be redirected to the hackers infection site, where the person’s computer will be injected and infected. The hackers are depending on site owners not knowing their sites have been hacked so that the number of hacked sites will grow (as they have starting in Italy) into the tens of thousands… Please don’t think you can depend solely on your antivirus software to protect your computer. It more than likely won’t help you. For $1000 dollars, the russian hacking bulletin boards are offering Mpack with 1 year support and a GUARANTEE that virus programs will not catch the keyloggers. SO, keep your virus program updated, but don’t depend on it completely!

This way this hack is spreading fastly from one computer to another broadcasting the passwords to hackers.During my research in this, I even found some of the password files collected by the hack on some of the hacked server, where they pass this password file to thier tool to add the code. In some cases Google bots picks this files and you can even find the login details of FTP accounts and Server root login details in google.

How Do I got attacked  ??
—————————
1. Your computer or a computer you use to administrate your website gets infected with a virus or trojan.

2. That virus or trojan runs a process on the computer searching FTP applications and their databases for username and password combinations or just looking for username and passwords in files on the computer.

3. When a username and password is found, that information is e-mailed, or somehow sent to an individual or a group of individuals.

4. That individual or group of individuals then have access to your account login information. They proceed to connect to your account via FTP using the hostname, username, and password that the trojan/virus provided for them.

5. Once connected to FTP on your account, they download your index page, edit that index page, place a malicious piece of javascript code or iframe code into the index page, then reupload it to your account.

6. Your website is now infected with malicious javascript or iframe code, which can then be used to infect or track other visitors of your website.

Your computer being infected with a virus is not a direct result of your website being infected with a virus, or vice-versa. It is because of the type of virus or trojan that is installed on your computer, that your login information was compromised. This compromised data is what led to your website being infected.

How you got infected (Step 1) is completely up in the air. Perhaps you downloaded a program that was infected. Perhaps you received an e-mail that caused the infection. Perhaps you visited a website that caused the infection. There’s really no way to be absolutely certain of how this infection initially took place. The best thing you can do is preventive measures. Keep your anti-virus software up-to-date. Make sure the memory resident of the virus scanner stays running. Do routine virus scans on your computer just to be sure. Use anti-spyware software to keep tabs on possible trojans or key loggers that might be installed on your computer. Practice overall safe web-browsing. I recommend using only Firefox for your web browser and installing the NoScript Firefox addon to help prevent any malicious javascript from running in your browser.

All of this assumes that your account credentials were compromised due to a local virus or trojan. That may not be the case. I would bet that your credentials have been compromised in some way, but even that is not a given. Other ways for your credentials to be compromised is if you leave your username and password written down near your desk at work or at a coffee shop, if you leave it in plain view, someone else may be able to read that information and then your information is compromised. There’s really no way to know exactly how the information was compromised.

It’s also possible that there was no credential compromise at all. You may have an outdated script installed on your account or on your web server that allowed malicious users to gain access to your account and inject material into your website. You should always make sure that you are running the latest version of any scripts or applications you have on your website to prevent something like this from happening.

===============================================
What is solution now ?
===============================================

If you are facing this problem and your administrator says its only your account, just change the FTP password and it will stop

You must have removed the code as soon as it attack and change the file permission to READ ONLY or CHMODE 444 to make sure it never got attack again. Please Change the FTP Password immediately. Just changing password is not complete solution but is the first step.

Whats next, your password is leaked that means your computer is sending out the passwords, so I would suggest you to do a clean format first and then install any antivirus of spyware which you think could block it. But the best solution is to clean format the computer.

Just do the three things:

1) Change the FTP or root password of server.
2) Clean format the PC.
3)  Forum cleaning.
You can download file_check.php . Put it in your root of the forum and run it from the adress http://yourforumadress.com/file_check.php .
It usually add that IFRAME code after the “?>” of the PHP code. You`ll get some pages that you need to delete the IFRAME.
Now go to the index.template.php from Themes/your theme directory. Search where the <body> code start, and there you`ll find another IFRAME. Delete it (WARNING! Without ‘; from after the </IFRAME>.).
Now the forum is “clean”.

In some case, this “virus” make some modification in your database system. Make sure you checked you database and removed any suspicious code and take care in future, you dont visit any of the virus links made by this hack.

 

Hope it will work for you and if won’t please let us know where you found difficulty or failure. Thank you…

Pin It

Tags: , , , , ,

Posted in: General

Leave a Comment (0) →

XeonBD Web Media Server

Posted by on March 22, 2011

XeonBD’s Video Distribution Service is available with our shared Linux, VPS, Managed and Dedicated server product lines to offer customers a complete solution to upload, manage and broadcast high quality web video and audio to their account/customers. XeonBD’s video distribution service is a complete server solution that is capable of recording, converting and streaming audio and video content in virtually any file format.

Below is a list of its supported file formats which currently supported by our shared Linux server:

  • MPEG audio
  • MPEG-1 systems (muxed audio and video)
  • MPEG-2 PS (also known as VOB file )
  • MPEG-2 TS (also known as DVB Transport Stream )
  • ASF
  • AVI
  • WAV
  • Macromedia Flash (Only embedded audio is decoded.)
  • FLV (Macromedia Flash video files )
  • Real Audio and Video
  • Raw AC3
  • Raw MJPEG
  • Raw MPEG video
  • Raw PCM8/16 bits, mulaw/Alaw
  • Raw CRI ADX audio
  • Raw Shorten audio
  • SUN AU format
  • NUT (NUT Open Container Format)
  • QuickTime
  • MPEG-4 (MPEG-4 is a variant of QuickTime. )
  • Raw MPEG4 video
  • DV
  • 4xm (4X Technologies format, used in some games. )
  • Playstation STR
  • Id RoQ (Used in Quake III, Jedi Knight 2, other computer games. )
  • Interplay MVE (Format used in various Interplay computer games. )
  • WC3 Movie (Multimedia format used in Origin’s Wing Commander III computer game. )
  • Sega FILM/CPK (Used in many Sega Saturn console games. )
  • Westwood Studios VQA/AUD (Multimedia formats used in Westwood Studios games. )
  • Id Cinematic (.cin) (Used in Quake II. )
  • FLIC format (.fli/.flc files )
  • Sierra VMD (Used in Sierra CD-ROM games. )
  • Sierra Online (.sol files used in Sierra Online games. )
  • Matroska
  • Electronic Arts Multimedia (Used in various EA games; files have extensions like WVE and UV2)
  • Nullsoft Video (NSV) format
  • ADTS AAC audio
  • Creative VOC (Created for the Sound Blaster Pro.)
  • American Laser Games MM (Multimedia format used in games like Mad Dog McCree )
  • AVS (Multimedia format used by the Creature Shock game. )
  • Smacker (Multimedia format used by many games. )
  • GXF (General eXchange Format SMPTE 360M, used by Thomson Grass Valley playout servers.)
  • CIN (Multimedia format used by Delphine Software games. )
  • MXF (Material eXchange Format SMPTE 377M, used by D-Cinema, broadcast industry. )
  • SEQ ( Tiertex .seq files used in the DOS CDROM version of the game Flashback. )

If you ever run into a problem you know that someone is standing by 24×7 at our support desk to give you a hand.

Pin It

Posted in: General

Leave a Comment (0) →

XeonBD PCI Compliance Certification

Posted by on March 22, 2011

XeonBD PCI Certification is a fully managed scanning service that verifies your compliance with the Payment Card Industry Data Security Standard. PCI Compliance is a single security standard which is required to accept credit card transactions from the five major credit card companies. PCI Compliance certifies that your organization takes all necessary steps to protect sensitive customer data and provides a set of standards for your infrastructure and server setup.

With XeonBD PCI Certification our Heroic Support experts in networking and security will help design and customize your infrastructure to comply with all applicable security standards. This will ensure that your customers’ sensitive data is always protected and that you will not be at risk of fines or permanent expulsion from card acceptance programs. XeonBD’s security team will use a comprehensive set of tools to scan your setup at regular intervals to ensure your ongoing compliance with these evolving security standards and perform all necessary corrections.

Pin It

Posted in: General

Leave a Comment (0) →

Upload large MySql file to phpMyAdmin

Posted by on September 21, 2010

Hello friends,
Today I am going to give you an useful tutorial on uploading big database to phpmyadmin. Many times you have seen this error message at the time of loading database, “Got a packet bigger than ‘max_allowed_packet’ bytes”. It means you are not allowed to upload big database pack to phpmyadmin.

As a website owner or blogger you may want to import your MySQL dump from one server to another server database, but what you do if it exceeds the limit offered by phpMyAdmin. By default phpMyAdmin provides the upload limit specified in the php.ini file. You can increase this upload limit size by editing the php.ini file if you have access to it, generally if you are in a shared hosting you won’t be able to edit this file because it will affect all the accounts on that server and XeonBD won’t allow this. If you have shell access to your account you can import easily, see below for how to import using SSH.

Using BigDump.php (Recommended):
BigDump is a script written by Alexey Ozerov for importing large mysql dumps. It’s a staggered MySQL dump importer, meaning the script executes only small part of the huge dump and restarts itself, the next session starts where the last was stopped. This process continues until it imports the whole database dump.

Download BigDump from here, http://www.ozerov.de/bigdump.zip

Steps:

1.Adjust the database configuration in this file
2. Drop the old tables on the target database if your dump doesn’t contain “DROP TABLE”
3. Create the working directory (e.g. dump) on your web-server
4. Upload bigdump.php and your dump files (.sql, .gz) via FTP to the working directory
5. Run the bigdump.php from your browser via URL like http://www.yourdomain.com/dump/bigdump.php
6. BigDump can start the next import session automatically if you enable the JavaScript
7. Wait for the script to finish, do not close the browser window
8. IMPORTANT: Remove bigdump.php and your dump files from the web-server

If you have completed the steps successfully you are done.

Using SSH:
Shared hosting account does not have shell access. If you have shell access you can use the following commands to dump your mysql database.
mysql -u [user] -p [password] -h [hostname] [databasename] <[file.sql]

Pin It

Tags: , , , , ,

Posted in: Featured, General, Hosting Service

Leave a Comment (2) →

Give less and Get more

Posted by on August 24, 2010

It is our pleasure to have some talented customers/partners with us in these days of hardship and scarcity.

We all know a proverb that Survival of the fittest, yes in these days those will survive who are fit and able to keep their existence on earth with full dignity and boldness as well as on internet world same words echo.

We are happy to invite our customers/partners in our first client participation program called Give less and Get more which is actually an idea sharing program in our official blog. It is very much easy that you just register yourself in our blog, post article in a continuous flow through three months and you will win many attractive prizes. The terms are very simple that we are mentioning in the following:

  • Your article should be relevant to our services (Domain, Hosting, Server, IP, SSL, E-Commerce, Web Design) and some other relevant categories article you can submit are related to Technology, Programming Language, Latest Software or IT services.
  • Do not spam and do not post warez link otherwise you will be banned.
  • Do not copy and paste from other article that may violate the copyright laws and result you banned forever.
  • We will track all users? articles posting and verify it by human. Three (3) selected article writer will be rewarded by exclusive prizes.
  • After 3 months all the blog post will analyzed and winners name (1st, 2nd, 3rd) will announced. Judgment will made upon quality of post, usability of the post, most read post, useful comment on the post, search engine impression upon the post etc. For making the judgement process transparent we’ll invite some of our experts client/partners to take this responsibility.

Some tips that may help you:

  • Do not stumble upon the flow of your article posting and keep a rhythm.
  • Use wiki reference and research on internet before posting article.
  • Make SEO friendly article that will help you to be in the top position on the program.
  • Search our blog before posting an article because duplicate article may cause harm.
  • More you’ll post more opportunity you’ll get to become a winner.

That is all for this moment from us. If you have any question related to this program than feel free to comment on this blog post. We will fulfill your thirst.

Hope this program for you will be able to give you a extra excitement and also help you to enrich your knowledge as well as our every blog readers.

Pin It

Posted in: Announcement, Featured, General, Open Page

Leave a Comment (2) →
Page 1 of 6 12345...»

Visit Our Website

To get back to our main website

Click here