Tag Archives: hosting

Restoring The Database via SSH/Telnet

Use SSH/Telnet Client, such as PuTTy.
Note:
If your database backup resides on your home computer, you will first have to upload it via FTP to your website
Open your SSH/Telnet client and log into your website. The command line prompt you will see will vary by OS. For most hosting companies, this will bring you into the FTP root folder.

You can either change directoties to wherever the backup is located and type in the following:

mysql -u dbusername -p databasename < backupname.sql

Or if you do not want to change directories and you know the path to where the backup is located, type in the following:

mysql -u dbusername -p databasename < /path/to/backupname.sql

You will be prompted for the database password. Enter it and the database will backup.

If your hosting company has you on a remote MySQL server, such as mysql.yourhost.com, you will need to add the servername to the command line. The servername will be the same as in your config.php. The command line will be:

mysql -h servername -u dbusername -p databasename < backupname.sql

Or:

mysql -h servername -u dbusername -p databasename < /path/to/backupname.sql

Backing Up The Database via SSH/Telnet

Use SSH/Telnet Client, such as PuTTy.

Open your SSH/Telnet client and log into your website. The command line prompt you will see will vary by OS.
For most hosting companies, this will bring you into the FTP root folder.

Type in the following to create a backup in the current directory:

mysqldump –opt -Q -u dbusername -p databasename > backupname.sql

Or to create a backup in a separate directory (signified by /path/to/) type:

mysqldump –opt -Q -u dbusername -p databasename > /path/to/backupname.sql

You will be prompted for the database password. Enter it and the database will backup.

If your hosting company has you on a remote MySQL server, such as mysql.yourhost.com, you will need to add the servername to the command line. The servername will be the same as in your config.php. The command line will be:

Current directory:

mysqldump –opt -Q -h servername -u dbusername -p databasename > backupname.sql

Separate directory:

mysqldump –opt -Q -h servername -u dbusername -p databasename > /path/to/backupname.sql

You can then, if you wish, download the backup to your home computer.

Welcome to Host4offshore’s blog

International Widespread Services Is an Excellent Offshore Web Hosting Solution

 

Offshore web hosting solutions are a better priced and affordable way to go for online companies. Offshore hosting typically means getting your site hosted in a far off location, owing to various reasons from better pricing, security to more advanced features. Offshore hosting and web design is actually 3-5 times lesser than anywhere else. Other than the price, one factor you always worry about is quality. We are an offshore web host company who will provide you with all of the services you need, and not just some of them. We also have a 24 hour customer service that will help you at all times.A shared web hosting service refers to many websites on one web server connected to the internet. Each site holds a separate position or partition on the server and is distinct from the other websites. This is a very economical manner of offshore hosting as many people essentially share the overall maintenance costs of the server. This and a lot many more options will be available to you with us.