mysqlimport – can’t get stat of file

So on my server here I have a process that ftps some data from a SQL server and loads it to MySQL. All was well until I got:
Can’t get stat of ‘/home/username/www/data’ (Errcode: 13)

I tried chmod and chown and running the file as root and everything. No success. I then found a post that said – move the file to /tmp. So I tried it and it worked! Here are my scripts.

Please note – you will have to add a user to mysql that has import permissions!

sql

truncate table equipment_in;

LOAD DATA INFILE ‘/tmp/equipment.csv’
REPLACE
INTO TABLE equipment_in
FIELDS TERMINATED BY ‘,’
OPTIONALLY ENCLOSED BY ‘”‘
LINES TERMINATED BY ‘\r\n’;

getdata

cd /tmp
rm *.csv*
wget ftp://username:password@servername/*.csv
mysql –user=username –password=thepassword databasename < /folder/with/the/sql

MySQL
MySQL Documents

SEO and You

So you are thinking you need the services of an SEO (Search Engine Optimization) company. My experience with them so far is less than stellar. They seem to be good at using lots of words and “exciting phrases of the day”. Here are the basics that cover 95% of SEO:

1: Page Titles should be descriptive.
2: Description meta tag should be complete. When you do a google search and see a paragraph under the result, that comes from the description.
3: Keywords meta tag should be complete.
4: Important words in your content should be bold or strong.
5. Use H1, H2 and H3 tags to identify page sections.

Finally, If you are a member of a trade group or organization in your field, link to their pages. Ask if they will link back. If your site has lots of information about “Bees” that is great. If it also links to other pages about “Bees” that is better. If other sites dealing with “Bees” link back to you, that is best.

Todd