flews blog

htaccess file to help prevent sql injection attempts

2010-03-30T12:03:00.003+13:00

I use the text below in a .htaccess file to help prevent sql injection attacks that seem to crop up from time to time.

This will look for common attack methods and redirect them to a page called hack.cfm which I will commonly just leave as a blank page while recording the type of attack.

RewriteEngine On

Options +FollowSymLinks
ServerSignature Off

RewriteCond %{REQUEST_METHOD} ^(HEAD|TRACE|DELETE|TRACK) [NC,OR]
RewriteCond %{THE_REQUEST} ^.*(\\r|\\n|%0A|%0D).* [NC,OR]

RewriteCond %{HTTP_REFERER} ^(.*)(<|>|'|%0A|%0D|%27|%3C|%3E|).* [NC,OR]
RewriteCond %{HTTP_COOKIE} ^.*(<|>|'|%0A|%0D|%27|%3C|%3E|).* [NC,OR]
RewriteCond %{REQUEST_URI} ^/(,|;|:|<|>|">|"<|/|\\\.\.\\).{0,9999}.* [NC,OR]

RewriteCond %{HTTP_USER_AGENT} ^$ [OR]
RewriteCond %{HTTP_USER_AGENT} ^(java|curl|wget).* [NC,OR]
RewriteCond %{HTTP_USER_AGENT} ^.*(winhttp|HTTrack|clshttp|archiver|loader|email|harvest|extract|grab|miner).* [NC,OR]
RewriteCond %{HTTP_USER_AGENT} ^.*(libwww-perl|curl|wget|python|nikto|scan).* [NC,OR]
RewriteCond %{HTTP_USER_AGENT} ^.*(<|>|'|%0A|%0D|%27|%3C|%3E|).* [NC,OR]

RewriteCond %{QUERY_STRING} ^.*(;|<|>|'|"|\)|%0A|%0D|%22|%27|%3C|%3E|).*(/\*|union|select|insert|cast|set|declare|drop|update|md5|benchmark).* [NC,OR]
RewriteCond %{QUERY_STRING} ^.*(localhost|loopback|127\.0\.0\.1).* [NC,OR]
#RewriteCond %{QUERY_STRING} ^.*\.[A-Za-z0-9].* [NC,OR]
RewriteCond %{QUERY_STRING} ^.*(<|>|'|%0A|%0D|%27|%3C|%3E|).* [NC]

RewriteRule ^(.*)$ hack.cfm

Backup FTP/SFTP settings in Aptana/Coldfusion Builder

2009-07-29T08:26:00.003+12:00

I have had a problem with Aptana in the past and also with Coldfusion Builder now (it appears to use Aptana used under the hood). The problem is if Eclipse/Computer freezes up and you have to restart the computer with Eclipse still open. This process seems to corrupt the workspace and you tend to lose all your settings (incl FTP/SFTP settings). So here is how you back them up.

1. Goto 'File' then 'Export'
2. Select 'Coldfusion' then select 'Syncing Settings'
3. Name the file and save somewhere

these can be imported in the same way. Hope this saves some time for people.

Changing the user of Coldfusion on Linux

2009-04-08T20:47:00.004+12:00

I made the mistake of setting up Coldfusion 8 on a linux system (centOS) with the user set as 'nobody'. This proved to be a big mistake when it came to using tags like cffile to write to the filesystem. I had a hunt around for some info on how to do this with Adobe suggesting a reinstall of coldfusion

To change the user running coldfusion to the same as the owner of the web directory I completed the following steps.

1. vi /etc/init.d/coldfusion_8 then change the runtime user to the same as the user of your web folder
2. vi /etc/init.d/cfsearch8 then change the runtime user to the same as the user of your web folder
3. vi /opt/coldfusion8/bin/coldfusion then change the runtime user to the same as the user of your web folder
4. chown -R /opt/coldfusion8 name_of_new_runtimeuser

This allowed me to then use cffile to copy files to my server, however I was still running into a minor problem with the image functions of Coldfusion. Thanks to Ben Nadal who has a note on installing a hot fix to solve this problem.

Forbidden 403 Error after installing phpMyAdmin

2009-03-13T12:25:00.003+13:00

After I had installed phpMyAdmin (in my case centos, using YUM) I received a 403 forbidden error. By default phpmyadmin installed path is /usr/share/phpmyadmin and the apache configuration file is located in /etc/httpd/conf.d/phpmyadmin.conf.

To fix:

vi /etc/httpd/conf.d/phpmyadmin.conf

Remove or comment these lines

#Order Allow,Deny
#Deny from all
Allow from 127.0.0.1

Restart the apache server.

/etc/init.d/httpd restart

You should be able to see phpmyadmin working by going to http://ipaddress/phpmyadmin

Resizing a Amazon EBS Volume

2009-03-10T09:40:00.004+13:00

I struggled to find the answer to resizing an existing Amazon Elastic Block Store Volume.

Here is how I resolved this

1. Created a snapshot of the existing volume (log into Amazons Console for this https://console.aws.amazon.com)

2. Create a new volume based on the snapshot

3. Attach this new volume to my Amazon Instance (after detaching the other volume)

4. SSH into my Amazon Instance

5. Enter the following, this checks the integrity of the disk 'e2fsck -f /dev/sdf'

6. Enter the following 'resize2fs /dev/sdf'

7. Mount the volume 'mount /dev/sdf /mnt/data-store'

Arrow and delete keys not working in VMWare on Ubuntu

2009-02-20T12:00:00.002+13:00

Browse to the hidden directory inside your home directory

.vmware

then create the following file

config

and copy the following info into the file

xkeymap.keycode.108 = 0x138 # Alt_R
xkeymap.keycode.106 = 0x135 # KP_Divide
xkeymap.keycode.104 = 0x11c # KP_Enter
xkeymap.keycode.111 = 0x148 # Up
xkeymap.keycode.116 = 0x150 # Down
xkeymap.keycode.113 = 0x14b # Left
xkeymap.keycode.114 = 0x14d # Right
xkeymap.keycode.105 = 0x11d # Control_R
xkeymap.keycode.118 = 0x152 # Insert
xkeymap.keycode.119 = 0x153 # Delete
xkeymap.keycode.110 = 0x147 # Home
xkeymap.keycode.115 = 0x14f # End
xkeymap.keycode.112 = 0x149 # Prior
xkeymap.keycode.117 = 0x151 # Next
xkeymap.keycode.78 = 0x46 # Scroll_Lock
xkeymap.keycode.127 = 0x100 # Pause
xkeymap.keycode.133 = 0x15b # Meta_L
xkeymap.keycode.134 = 0x15c # Meta_R
xkeymap.keycode.135 = 0x15d # Menu

Subclipse and Eclipse on Ubuntu

2009-02-20T09:37:00.001+13:00

Install libsvn-java

The package libsvn-java contains JavaHL.

Install libsvn-java by typing the following into a command line:

sudo apt-get install libsvn-java

then make sure you add the following to your Eclipse launcher parameters (ie add it to the end of the shortcut to eclipse):

-vmargs -Djava.library.path=/usr/lib/jni

Restart Eclipse.

Adding a Column to JSON using Coldfusion8

2008-04-16T12:49:00.006+12:00

I use Spry to output a lot of queries that I use in my projects.

So I call my coldfusion function from Spry

var ts = new Date();
var spry_ContactList = new
Spry.Data.JSONDataSet("module_contacts.cfc?method=qry_ContactsList &returnFormat=json& queryFormat=column&TS=" + ts.toString(),{path:"DATA", pathIsObjectOfArrays:true});

There are a couple of things to note here, first of I am using Coldfusion 8's new returnFormat=json to return the query that resides in my function, as well as this I am also using queryFormat=column. Finally I have added on a date string to prevent browsers such as IE6 from caching the request.

So based on the above I can return my query as JSON, however I found that any dates were being returned in a fairly ugly way eg. March 21, 2008 00:00:00. I wanted to remove the dates and on consulting with a couple of people I came to the conclusion that doing this in Javascript would not be the best solution so I added the following after the query in my function.

<cfset tempArr = arrayNew(1) />
<cfloop query="qry_ContactsList">
<cfset arrayAppend(tempArr, "#DateFormat(qry_ContactsList.visitdate,'dd-mm-yyyy')#")/>
</cfloop>
<cfset qry_ContactsList.addColumn("PRETTYDATE", tempArr) />

This created an additional column in the JSON that was returned, and I could now display the date as I wanted to.

Change the Date and Timezone in Centos

2008-04-15T09:49:00.002+12:00

Log into your server then retrieve the current date and timezone by typing in

date

all timezone information is stored at /usr/share/zoneinfo you can browse to this by typing

cd /usr/share/zoneinfo

you should see a list of all the available timezones including folders for countries which have multiple time zones eg. America

so to change the time zone just enter the following

ln -sf /usr/share/zoneinfo/Europe/London /etc/localtime

If you then want to manually set the time to 30/03/2008 09:57, the format to enter the date is 'mmddhhmmyyyy'

033009572008

The following command will update your hardware clock

hwclock --systohc

And now when you type in 'date' you should see an up to date clock

Setting up VSFTPD

2008-03-29T18:43:00.010+13:00

The virtual machine I used was a centos 5 linux distribution, I then installed VSFTP

1. Install VSFTPD

[root@localhost]# yum install vsftpd

2. Make sure vsftpd starts on bootup

[root@localhost]# chkconfig vsftpd on

3. Switch of anonymous ftp access

[root@localhost]# vi /etc/vsftpd/vsftpd.conf

then change the line to

anonymous_enable=no

4. You can change the greeting you see when you connect to the ftp server by changing the line

tpd_banner= New Banner Here

5. Create a user group and shared directory. In this case, use /var/www/vhosts and a user group name of ftp-users for the remote users

[root@localhost]# groupadd ftp-users
[root@localhost]# mkdir /var/www/vhosts

6. Make the directory accessible to the ftp-users group.

[root@localhost]# chmod 775 /var/www/vhosts
[root@localhost]# chmod 775 /var/www

7. Add users, and make their default directory /var/www/vhosts

[root@localhost]# useradd -g ftp-users -d /var/www/vhosts user1

8. Change the permissions of the files in the /var/www/vhosts directory for read/write only access by the group

[root@localhost]# chown root:ftp-users /var/www/vhosts*

9. Restart the VSFTPD service using

[root@localhost]# service vsftpd restart

10. Make sure you are not blocking ftp ports to the server (ftp requires port 21 to be open)

system-config-securitylevel

11. After configuring the vsftpd server on an Amazon ec2 server , I was not able to connect to vsftpd in one server from my ftp client. It throws the error:

500 OOPS: vsf_sysutil_recv_peek

The solution for this problem is to load capability module:

# modprobe capability

12. If you are having trouble connecting with an FTP client (such as FileZilla) and receiving an error like below

Error: Could not read from socket: ECONNRESET - Connection reset by peer
Error: Disconnected from server
Error: Failed to retrieve directory listing

Then make sure you change the connection settings in the client to 'active' rather than 'default'

Import a CSV file into MySql

2008-02-29T09:46:00.003+13:00

I recently received a CSV file that I needed to import into MySQL, I tried to use Navicat on a Windows machine but the file was large enough to cause it to hang. So I went to the command line on the server and created it as follows

mysqlimport --fields-terminated-by="," --fields-optionally-enclosed-by="\"" --lines-terminated-by="\n" databasename /pathtocsvfile/csv.csv -u mysqlusername -p

note that the name of the file I was importing was csv.csv, in order for this to work you must have created a table that will accept this data wit the same name as the file you are importing (minus the extension)

Install Flex 2 Alpha for Linux on Ubuntu

2008-02-28T08:53:00.002+13:00

Make sure you have a copy of Eclipse 3.3 Classic (Europa Installed)

Download this from http://www.eclipse.org/downloads/

Create a directory in your home file called eclipse3.3

Extract eclipse into this directory

Make sure you have the latest version of Java Installed (ie. Version 1.6)

and make sure it is set as the default Java sudo update-java-alternatives

Download Flex for Linux http://labs.adobe.com/technologies/flex/flexbuilder_linux/

chmod +x flex* (to allow you to execute the download file)

follow the installation process and select the eclipse installation that you have created above when prompted by the flex installer

CSS and Transparent PNG's

2008-01-18T15:28:00.000+13:00

I use the simple solution for Transparent PNG's

<div id="newsletter_subscribe">
<form action="" method="post">
<input type="text" name="email" id="subscribeemail" />
<input type="submit" name="submit" />
<a href="">This is a link</a>
</form>
</div>

Non-IE6

div#newsletter_subscribe
{
position:absolute;
top:150px;
right:15px;
background-image:url(../images/site/subscribe_home.png);
background-repeat:no-repeat;
width:150px;
height:139px;
z-index:80;
}

Conditional Statement for IE6

div#newsletter_subscribe
{
background-image: none; filter:progid:DXImageTransform.Microsoft.AlphaImageLoader(src=../images/site/subscribe_home.png,sizingMethod='scale');
}

This works well, except I was finding that links and text boxes within this particular div had been disabled altogether. It is a known glitch that in IE6 any child link tag within a AlphaImageLoader filtered tag will be rendered useless. So my work around was to do the following.

<div id="newsletter_subscribe"></div>
<div id="newsletter_subscribe_container">
<form action="" method="post">
<input type="text" name="email" id="subscribeemail" />
<input type="submit" name="submit" />
<a href="">This is a link</a>
</form>
</div>

I then altered my CSS as follow

non-IE6

div#newsletter_subscribe
{
position:absolute;
top:150px;
right:15px;
background-image:url(../images/site/subscribe_home.png);
background-repeat:no-repeat;
width:150px;
height:139px;
z-index:80;
}
div#newsletter_subscribe_container
{
position:absolute;
top:150px;
right:15px;
width:150px;
height:139px;
z-index:80;
}

Conditional Statement for IE6

div#newsletter_subscribe
{
background-image: none; filter:progid:DXImageTransform.Microsoft.AlphaImageLoader(src=../images/site/subscribe_home.png,sizingMethod='scale');
}

This then rendered a seperate div with no child elements and just positioned the Links and Input boxes in another div over the top of my transparent PNG.

Bug Tracking using Mylyn and Trac

2007-12-19T10:19:00.000+13:00

You will need to be using the Eclipse IDE in order to use the Mylyn Plugin.

The mylyn plugin can be found at http://www.eclipse.org/mylyn/.

Follow the installation instructions that are appropriate for your version of Eclipse.

I use 'FastViews' a lot when developing in Eclipse, so after installation of the mylyn plugin I add a new fastview for both 'Task Repositories' and 'Task Lists'.

For those who don't know what a fastview is it is a button on a toolbar normally on the side or bottom of the eclipse window which enables a pop up to be displayed.

Once you have your fast views working then open the 'Task Repository' fastview and right click and create a new repository. You will then need to paste the url of your Trac Installation. In my case this looks something like https://www.***.com/trac/***/nameofproject. Then enter your username and password should your Trac Installation require this. Then click validate settings.

To Create a Task
So how do you get your tasks to appear in the task list? You should now be able to now go to your fastview called 'Task List' just type an asterisk into the 'find' text box in the task list and hit enter.

To Add a Task
You should now be able to now go to your fastview called 'Task List' and right click and create a new task and select the repository you want your task stored in.

NOTE:If you find that your task opens up in a Trac webpage it is likely your Trac Installation does not have the XML-RPC plugin which is required for the Mylyn to use its internal Bug Frontend. You should be able to install the plugin to your Trac Installation easy enough and once you have done this, go back to the fastview titled 'Task Repositories' select you repository and under additional settings select XML-RPC as the access type. When you add a Task now you should be using the Mylyn bug Reporting Tools rather than the webpage.

Happy Bug Tracking.

Amazon S3 useful commands with S3Sync

2007-12-19T09:45:00.000+13:00

If you are using Amazon's S3 service for Simple Storage (offsite backups) in conjunction with the S3Sync Project then there are some simple commands that may be of benefit to you

From the command line browse to the directory that hold the file s3cmd.rb

To list all available buckets type

./s3cmd.rb listbuckets

To create a bucket

./s3cmd.rb createbucket BucketName

To list all files within a bucket

./s3cmd.rb list BucketName

To list all files within a key

./s3cmd.rb list BucketName:Key

To drill down into folders in a bucket

./s3cmd.rb list BucketName:Key/folder1/folder2

To copy a directory from a bucket to your local computer

./s3sync.rb -r BucketName:Key/folder/subfolder /somedirectory

SQLite Browser

2007-11-08T10:23:00.000+13:00

I have been looking for a good SQLite Browser and came across this firefox plugin. Makes creating and viewing your SQLite databases straightforward enough

https://addons.mozilla.org/en-US/firefox/addon/5817

Create a Virtual Server with Apache, VMWare and Blue Dragon

2007-10-06T10:10:00.000+13:00

This is a brief guide to creating a VMWare Server that runs Centos Linux, PHP, MySQL, BlueDragon on Apache. It also briefly shows how you can run this so that the files being served in apache are running from a windows machine, which makes it perfect for a testing environment.

To begin

Download Centos5 from ThoughtPolice (www.thoughtpolice.co.uk) and unzip the VMWare image file

Load the file in VMWare Player

Once loaded log in username:root password:thoughtpolice
enter 'yum install apache2' (installs apache)
enter 'yum install mysql-server' (installs mysql server)
enter 'yum install php-mysql' (installs the plug ins for php and mysql'
enter 'system-config-securitylevel' (open port for apache www)

Create and share a windows directory called www and create a user on the windows machine called 'linux' with a password of 'linux'

On the virtual server enter 'mkdir /mnt/www' (creates a directory which you will mount the windows share on)

Then enter 'vi /etc/fstab' and add the line at the bottom of the file by pressing '*' then 'a' and adding //192.168.79.1/www /mnt/www rw,user=linux,password=linux 0 0 (the ip address at the front of this line is the ipaddress of the windows computer)

after this enter 'mount /mnt/www' this should mount successfully, if not you may want to check any firewall settings on the windows machine to make sure it will allow access from the ip address of the vmware server. You can check the ip address on a linux computer by entering (ifconfig)

Download the BlueDragon Script from www.newatlanta.com

Copy in the BlueDragon script to install into the windows shared directory you created
browse to the directory you created earlier on the linux machine 'cd /mnt/www' then copy the Blue Dragon script onto the Linux Machine 'cp bluedragonscript /home' make sure the blue dragon script has execute rights 'chmod +x bluedragonscriptname'

Browse to the home directory 'cd /home' and run the script 'sh bluedragonscript'

Accept all the defaults and make sure you select Apache as the option of webserver

Automatic Startup of BlueDragon 'ln -s /etc/rc.d/init.d/BlueDragon_Server /etc/rc.d/rc3.d/K95bluedragon' and 'ln -s /etc/rc.d/init.d/BlueDragon_Server /etc/rc.d/rc3.d/S95bluedragon'

Create a directory for apache conf files 'mkdir /mnt/www/conf' this is where we will hold .conf files for virtual hosting

Give apache access to your folder 'chgrp -R apache /mnt/www'

Start mysql /etc/init.d/mysqld restart

Set a password for mysql '/usr/bin/mysqladmin -u root password 'password'

Make sure mysql starts on bootup 'chkconfig mysqld on'

Make sure apache starts on bootup 'chkconfig httpd on'

Make sure you download the mysql jar odbc connector file from the mysql website. This needs to be copied into the bluedragon lib directory (/usr/local/NewAtlanata/BlueDragon_Server_70/lib) (make sure the correct permissions exist for this file), you can download it into the windows directory and copy it across from the virtual server.

Download phpMyAdmin from http://www.phpmyadmin.net/home_page/downloads.php copy it across into the directory /var/www/html on the virtual server. Then rename the folder to phpMyAdmin.

Should then be able to browse to this at http://ipaddressofvmaware/phpMyAdmin

The username should be root and the password as password as we set above.

Guide : Mount a linux directory from windows

2007-08-28T17:26:00.000+12:00

From windows right click on the folder you want to share with your VMWare Web Server and share this as 'www' you will want to create a user and password within windows, I normally run with the username as 'linux' and password as 'linux'

NOTE: NTFS drives are only read only when mounted from Linux, alternatively create a FAT partition and use this so that you can write files to your windows machine from Linux.

Open up your fstab file in linux

'vi /etc/fstab'

then press '*' then 'a' to start editing

add a line at the bottom as follows

share a directory including a username and password for the user

//192.168.79.1/www /mnt/www cifs rw,user=linux,password=linux 0 0

Guide : Change hosts file in windows

2007-08-28T17:23:00.001+12:00

Browse to

c:/windows/system32/drivers/etc

open in notepad/wordpad

hosts

add under 127.0.0.1 localhost

ipaddressofvmwareserver webserver(or name of development domain)

reboot windows for changes to take affect

T3G Sierra 580 Wireless Card connecting with Ubuntu 7.04

2007-08-21T08:53:00.000+12:00

This guide is for users of Ubuntu Feisty Fawn 7.04 on the Telecom New Zealand network

first plug in your Sierra Wireless 580 T3G Data Card
then install kppp

sudo apt-get install kppp

then start kppp

kppp

click on configure and add a new account call it 'telecom', add the phone number as '#777' and the authentication as 'PAP'.

Then add a new modem call it 'telecom' and select '/dev/tty/USB0'.
You are now ready to connect the username is 'mobile@jamamobile' (same for all users) and the password is 'telecom'(same for all users) and click on connect

Connect to a remote NFS Server

2007-08-18T00:07:00.000+12:00

Enter the following commands on the server you want to share

sudo gedit /etc/exports

Then enter the following replacing the ipaddress I have below with your own, you can remove the last digits of your ipadress an replace with a 0 for anyone to access from that ip range

/pathtoshare 172.16.197.0/255.255.255.0(ro,sync)

Reload the Exports File

sudo exportfs -r

On the client machine set up a directory up to mount to

sudo mkdir /mnt/www

Then edit your fstab file

sudo gedit /etc/fstab

and add

172.16.197.1:/pathtoshareremote /pathtosharelocal nfs rsize=8192,wsize=8192,timeo=14,intr

Guide : Installing Skype on Ubuntu Feisty

2007-08-17T18:45:00.000+12:00

sudo gedit /etc/apt/sources.list

add the following line

deb http://download.skype.com/linux/repos/debian/ stable non-free

sudo apt-get update

sudo apt-get install skype

Guide : Install VMWare Server on Ubuntu Feisty

2007-08-17T18:39:00.000+12:00

sudo gedit /etc/apt/sources.list

add the line

deb http://archive.canonical.com/ubuntu feisty-commercial main

sudo apt-get update

sudo apt-get install vmware-server vmware-tools-kernel-modules

Guide : Ubuntu and Backing up to Amazon S3

2007-08-08T13:43:00.000+12:00

I have been looking for a good method to back up to Amazon's S3 service. I have used the 'S3 Firefox Organizer' although this seems a bit cumbersome at times and does not give much feedback.

I have since installed s3sync

you need to have ruby installed as well as openssl-ruby, so using aptget I installed these

sudo apt-get install ruby

sudo apt-get install libopenssl-ruby

Extract s3sync somewhere on your computer and then create a file in this directory called s3config.yml and put your key and secret key that you have obtained from Amazon in this file, there is an example file in the directory to help out here.

You will need to create a bucket (somewhere to save your files) on your AmazonS3 Service so browse to the newly extracted folder and run the commands below to list the buckets in your account and also create a bucket

s3cmd.rb listbuckets

s3cmd.rb createbucket BucketName

You can then backup to AmazonS3 service with a command such as

s3sync.rb -r directory bucketname:nameofbackup

There are some other useful commands which can be obtained in the readme files.

Guide : Starting Eclipse using a different Java Version

2007-08-01T09:01:00.000+12:00

The following shortcuts are on Ubuntu Feisty

Create a shortcut with the path as follows

/usr/bin/eclipse -vm /usr/lib/jvm/java-6-sun-1.6.0.00/jre/bin/java

or in the eclipse.ini file add the following

-vm
/usr/lib/jvm/java-6-sun-1.6.0.00/jre/bin/java

Guide : VMWare Share Folders with Windows from Ubuntu

2007-07-28T09:58:00.001+12:00

Make sure Samba is installed on Ubuntu

sudo apt-get install samba

Create a new Samba User

sudo smbpasswd -a USERNAME

Then edit the samba configuration file

sudo gedit /etc/samba/smb.conf

Then add the following to the bottom of the file

security = user
[NAMEOFSHARE]
path = DIRECTORYPATH
valid users =USERNAMEAS ABOVE
read only = No
create mask = 0777
directory mask = 0777

Then restart Samba

sudo /etc/init.d/samba restart

Then you need to configure the network connection of the VMWare instance, so edit the settings of the VMWare instance, I had the Ethernet Connection set as NAT.

It is then just a matter of starting windows, open 'My Network' and then the 'Entire Network' and you should see the share available for use.

Guide : MySQL Importing and Exporting

2007-07-25T10:30:00.000+12:00

Importing a SQL File from the command line

mysql -u USER -p DBNAME < FILENAME.sql

Exporting a SQL File from the command line

mysql -u USER -p DBNAME > FILENAME.sql