Tagged: best cloud server linux hosting

Linux Cloud Server Hosting with ASPHostPortal.com :: How To Import and Export Databases and Reset a Root Password in MySQL

How to Import and Export Databases

Export

To Export a database, open up terminal, making sure that you are not logged into MySQL and type,

mysqldump -u [username] -p [database name] > [database name].sql

The database that you selected in the command will now be exported to your panel.

Read more »

Cloud Server Linux Hosting – ASPHostPortal.com :: How To Install and Secure phpMyAdmin on Debian 7

phpMyAdmin

phpMyAdmin is a free web software to work with MySQL on the web. It provides a convenient visual front end to the MySQL capabilities.

Setup

Before working with phpMyAdmin, you need to have LAMP installed on your server. If you don’t have the Linux, Apache, MySQL, PHP stack on your server, you can find the tutorial for setting it up here.
Once you have the user and required software, you can start installing phpMyAdmin on your VPS!

Read more »

Linux Cloud Hosting with ASPHostPortal.com :: How To Install Rails, Apache, and MySQL on Ubuntu with Passenger

Intro


Installing Ruby on Rails and MySQL on an apache virtual private server is the first step toward getting Ruby applications live and online. Three useful installers make the task of building this server easier than ever before.

Setup

This tutorial requires you to have a  server up and running. Additionally, the rails ready script needs to be performed by a user with sudo privileges. If you don’t have a user like that on your server, you can check out how to do that in steps 3 and 4 of this tutorial.

Step One—Install Rails Ready


Once you are logged in on your virtual server with your user with root privileges, type in the command to install Rails Ready:

wget --no-check-certificate https://raw.github.com/joshfng/railsready/master/railsready.sh && bash railsready.sh

Rails Ready can be installed either from the source or with RVM, the Ruby Version Manager. I would recommend using RVM—it’s an easy installation and will later let you to switch between multiple versions of Ruby if needed.

Read more »

Linux Cloud Hosting – ASPHostPortal.com :: How To Setup a Rails 4 App With Apache and Passenger on CentOS 6

1

When the user creates a droplet from a vanilla image (in our case: CentOS 6.4 x64), additional system administration work is needed before a Ruby on Rails application can be run and become available online. This tutorial provides the necessary steps to make that happen.

In order to go through this tutorial, a virtual server with at least 1 GB of RAM is a minimum requirement, because Passenger commands in step #3 are memory intensive.

Also, the tutorial assumes that the user has root access to the VPS (either as a user with root privileges or as the system root).

This tutorial is not intended for production node setup. It involves development library installation and ad hoc compilation on the machine, which is not a good practice when you’re setting up a production environment.”

Step One – Apache Setup

It all starts with the web server and the simplest way to install Apache is to pull it from the yum repository:

yum install httpd

After the installation is done, the system should be configured to automatically run Apache on system boot:

chkconfig httpd on

Without this setting, the httpd service needs to be started manually each time the droplet is rebooted.

The next step is to configure Apache to expect incoming requests by editing its configuration file:

nano /etc/httpd/conf/httpd.conf

In the editor, near the bottom, locate and uncomment the line containing: NameVirtualHost *:80

Save and exit the editor. Apache is ready to be started now:

service httpd start

Voilà! Accessing droplet’s IP address in a web browser will show Apache’s welcome page.

 Step Two – Ruby 2.0 and Rails 4.0 Setup

Setting up Apache was an easy stroll. It’s even simpler to setup Ruby, followed by Rails.

The quickest way is to use Ruby Version Manager (RVM) to maintain multiple Ruby environments on the machine. The latest stable version of RVM is downloaded and installed like this:

curl -L get.rvm.io | bash -s stable

If RVM is supposed to be used by all users, there is a shell script available for the job:

source /etc/profile.d/rvm.sh Read more »