LiveZilla Live Help
LiveZilla Live Help
indian flag    Email : support@thepinnaclegroup.in
   Call : +91(0141)-4113929
What is MySQL ?
Gopal at Sat Aug 2018 12:41:19

What is MySQL ?

MySQL is a very flexible, open source relation database management system. Its support a very large number of applications.

Features:
>>   MySQL is a opensource database server.
>>   Freely available to use.
>>    Supports a large number of platforms.
>>    Default port uses 3306.
>>    Uses Stored procedures and Triggers for high productivity.


...

Read More

How to Backup and Restore a MySQL Database
Gopal at Sat Sep 2018 15:57:53

How to Backup and Restore a MySQL Database
MySQL is a database server for storing data permanently.If you are using MySQL server for an production use, then it’s necessary to create database backup for recovering from any crash. MySQL provides an utility mysqldump for taking backups. In this article you will learn, to taken databases backup in .sql format for archive format. Also we will explain various options for it.

Options for Creating MySQL Databases Backup
You have many options for creating databases backups. read few options below. For this example we have using databse name “mydb”.

1. Full Database Backup in Plain .sql File
# mysqldump -u root -p mydb > mydb.sql
2. Full Database Backup in Archive .sql.gz File
# mysqldump -u root -p mydb | gzip > mydb.sql.gz
3. Backup Single Table Only
# mysqldump -u root -p mydb tbl_student > tbl_student.sql
4. Backup Multiple Databases
# mysqldump -u root -p --datab...

Read More

Linux Server Security Tips
Gopal at Sat Sep 2018 15:16:05

Security of data and server from hackers is a main task of system administration services. Below is few basic security tips for your linux server.

1: Strong Password Policy

Making strong passwords is first stage of securing your server. Do not use common names as your password like yourname, date of birth, mobile number etc. Passwords should be alphanumeric with upper and lower case letters.
You can use password aging policy on your linux machine to enforce users to change there password on regular interval.

Read More


Things Consider Before Selecting Dedicated Server
Ajay at Sat Apr 2018 18:00:19

Things Consider Before Selecting Dedicated Server

I'll just start it with a practical question. Just think you want to make an app like Facebook. There are many people who have this ambition. Here the question number one which occurs is which server you need.

I always suggest to consider below points before selecting any dedicated server/VM/Cloud:

What is the impact of server downtime on your business?

One of the first things to consider when selecting a dedicated server is how to deal with potential downtime. If you are also looking for VM and Cloud this fact plays vital role. So choose the service provider wisely with least downtime.

Scalability of your application

Scalability is also an important factor while selecting a dedicated server. How well does your application scale? Is it easy to add more servers and will that increase the amount of end users you can service? If it is easy for you to scale, it doesn’t matter whether you use a dedicate...

Read More

Special Offers March 2018
Ajay at Mon Jun 2018 16:33:03

Now We have come up with the March 2018 Exclusive offer on Windows SSD Cloud Linux VPS Server-Dedicated Server : INDIA Location. Please go through the promo and share your inputs, so that we can take it ahead accordingly.

Terms & Conditions:

MSP panel, MY SQL & MS SQL express edition will be free.

 Existing server cannot be replaced with the offersserver

Basic management and setup price is included with offer price

Prices are applicable on Half-Yearly purchase. Monthly price also available

Do write us ajay.singh@thepinnaclegroup.in if you'd wish to get the most from this unmatched offer.
Thanks.

...

Read More

WHAT DEDICATED SERVER DO I NEED IN 2018?
Ajay at Tue Feb 2018 14:05:40

Dedicated server is like a computer. Dedicated server give you dedicated resources for your online requirements here you own all the resources of this dedicated server. You'll not have to share it's resources like bandwidth, speed, performance and uptime with anyone. When your server has good CPU speed with required resources client gets good performance which takes it to higher level..

When we come to the point of payment; how much it requires for dedicated server? obviously it's charges are more than regular hosting package or virtual private server but it actually will pay you back for each rupee which you pay. When we analyse the plus and minus points of buying dedicated server we'll see a number of benefits why do i choose dedicated server but i closely depends on your website resources requirement and your expectations about it. Here we'll discuss about the different kind of dedicated servers which are availabe in ...

Read More