Linux

Posts filed under Linux

How to upload and install huge SQL files through SSH in CentOS?

Filed in LinuxTags: , , , ,

This is a very general problem for the people who maintains the large websites. The problem comes generally when need to move website it to another server . Even I used to do it manually through phpmyadmin page and then import in my early days. But this method has limitations. If you are looking for some other way to do it quickly then this information is for you .

Requirements : You must have SSH access for the new server , must have PV installed on it. If not then ask your hosting provider to install it for you or you can install it yourself if you have root access.

First copy the DB file from OLD server to new using sftp .

First install pv (Pipe Viewer)  run command

IN CentOS/Fedora

install yum pv

In UBUNTU

apt-get install pv

 

Browse to the SQL file and then run the below command (Replace HugeFile with your SQL file name )

 pv HugeFile.mysql.sql.gz | gunzip | mysql -u username -p database

The above command will prompt for DB password . It will start and will show the progress of installation

Leave comments below if y

DB function failed with error number 145

Filed in Joomla, Linux

If you ever faced the below error

 

jtablesession::Store Failed
DB function failed with error number 145
Table ‘./joomla_database/jos_session’ is marked as crashed and should be repaired SQL=INSERT INTO `jos_session` (`session_id`,`time`,`username`,`gid`,`guest`,`client_id`) VALUES (’1ecb458814b53d190db10cafee822dc0′,’1237429551′,”’0′,’1′,’0′);

Error message above usually happens to CMS Joomla. One of Joomla tables jos_session (the table name depends on prefix) is crash. It’s `very easy to overcome this problem. Just truncate the table jos_session. SQL command:

mysql> truncate jos_session;

Or

mysql> repair table jos_session;

You can always check the table ‘health’ by running the command:
check table jos_session

Done !!

 

 

 

How to get rid of “You don’t have permission to access / on this server.”

Filed in Joomla, Linux

If you ever work on Joomla you may hit with this error.

Forbidden
You don’t have permission to access / on this server.

Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request.

This was one of the error which lot lot of my time to fix and yes annoying too !!

So here are the steps which I kfollowed to fix this and atlast what I did to get rid of it.

Method 1:

I googled many articles to fix this issue and found many discussions but they worked for me .I will mention here and you may try your luck .

Method 1: (Didn’t worked for me) 🙁

  1. Check if .htaccess file has 0755 permission.IfAdd the below code in .htaccess file

<IfModule mod_security.c>
SecFilterEngine Off
SecFilterScanPOST Off
</IfModule>

Restart the apache server and check if you have overcome the issue.

Although this trick didnt worked for me.

Method 2: (worked for me) 🙂

I set 0777 permission to all my folder structure .

chmod 777 public_html/ -R

wow it worked.

I know the above trick will work also for you. Its 100% sure. But after that please change the file permissions for your administrator and important folders as you are inviting hackers to hack your site with 777 .

How to open root folder or any file as root user in Linux !!

Filed in Linux

This is very common problem for every new user in Linux to open file system as root user.

Many times its needed to open and run file as root user. In this section I am going to tutorialized two methods to open any folder or right click open as root user in Linux.

Read the rest of this entry »

Post on wall using Facebook command line (FBCMD) in Linux

Filed in Linux, Social

There are many ways to post the messages on facebook wall like mobile, sms , pc .Now you can also post using the FBCMD

There are a few prerequisites for installing the command line Facebook application,FBCMD. PHP 5.x is a requirement, since the application is a single PHP file. You can install php5 via any method you wish but, in my experience, I had to install php5-cli, php5-gd, and php5-mysql to use this application.

Read the rest of this entry »

How to mount\open ISO| IMG|BIN|MDF|NRG files in Linux

Filed in Linux

I have many files I have saved in ISO formats when I was using window OS. When I switched on to the Linux it little difficult.

There are many methods to open and to extract the files from the images.One of the simplest method I will explain you here.

You can install the “Furius ISO mount” software .Its free and very easy to install.

It opens mentioned  formats like ISO, IMG, BIN, MDF and NRG

Check out “Ubuntu Software Center” or download it from the developers site.

After installation it will go

Accessories>> Furious ISO mount

Read the rest of this entry »

wget – Download using the command line

Filed in Linux

There are many ways to download the files from the sources, it can be done by right clicking on the link and choosing to save the given file, but that may take long time and tiring.

If you are on Linux distro then you can use a better approach to use wget command line.

It is usually installed in all Linux distros, but if not we can install it.

wget

Read the rest of this entry »