Monthly Archive: May 2013

How to mount a remote directory in Linux using sshfs 0

How to mount a remote directory in Linux using sshfs

Step1: Installing Package

On Ubuntu/Debain

apt-get install build-essential libcurl4-openssl-dev libxml2-dev libfuse-dev comerr-dev libfuse2 libidn11-dev libkadm55 libkrb5-dev libldap2-dev libselinux1-dev libsepol1-dev pkg-config fuse-utils sshfs

If you get any errors just remove the package that gave the error. In my case I had to remove  libkadm55.

Step2: Once the packages are installed we have to create a mount point and mount our  server data using sshfs command, for which we require  username/password. Here are my details for this task. (more…)

How to upload sql files from shell/bash 0

How to upload sql files from shell/bash

Importing the SQL file another way

If you have a Unix/Linux server and have SSH access to it then you can use the `mysql’ command line program to import the file like so:

mysql -u myuser -p mydatabase < myfile.sql

This will prompt you for the password for `myuser’ and then import the SQL from myfile.sql. Obviously you will need to have uploaded myfile.sql through FTP or similar. Ideally you would compress myfile.sql, upload it, uncompress it and then import using the command above.

via Overcoming file size limits when uploading SQL files to phpMyAdmin – Interspire Knowledge Base.