Webmaster2020.com

MYSQL needs not only read access on the file, but also execution rights on directory. It reads using the rights of the mysqld process (user: mysql) You probably don't want your home-dir accessible by everyone. So a quick solution it to copy the file to the /tmp -dir and load it from there. LOAD DATA...

You can login in mysql:

Code: Select all

mysql -u You -p database

and the you can use the LOAD DATA INFILE command

Code: Select all

LOAD DATA INFILE 'data.csv' INTO TABLE table

You can get the complete explanation here:
http://dev.mysql.com/doc/refman/5.0/en/load-data.html

When you move files from windows to (l)unix, you always have problems with white characters. Thats because windows and linux handle with spaces differently. Sed can be found on most linux/unix distributions. sed s/\r// hello.txt > goodhello.txt you can also do the same with perl: perl -pie 's/\r//g'...

Hi,

you can do this with awk

For example:

Code: Select all

awk '{ print $2 }' list.txt

This gets the second column from the file list.txt
Standard the separation is space (" ")
With -F you can change this

Code: Select all

awk -F ";" '{ print $2 }' list.txt

You can also use gawk as an alternative.

You can find a complete explanation here: http://blog.famillecollet.com/pages/Config-en In short: You have to install EPEL: wget http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-3.noarch.rpm rpm -Uvh epel-release-5*.rpm Then set the Remi repository: cd /etc/yum.repos.d wget http://rp...

Hi,

mktime() works fine for me:

Code: Select all

$yesterday=date('Y-m-d', mktime(0, 0, 0, date("m") , date("d") - 1, date("Y")));

But you can also use the following code:

Code: Select all

$yesterday=date("Y-m-d", time()-86400);

The result should be the same.

With PHP it is easily done. You create the body of your message in html. Don't forget <html><body></body></html> and in the headers you tell it is a HTML-mail with the following line: Content-type: text/html\r\n So the complete code looks something like this: $email='someone@somewhere.com'; $subject...

are yo sure svscan is running?

On my gentoo machine I can check this with:

Code: Select all

/etc/init.d/svscan status

If the status is stopped
You can start it with

Code: Select all

/etc/init.d/svscan start

then run

Code: Select all

svc -u /service/bincimap/

and it should work.

Regards

You can do this with the function number_format()

Code: Select all

$float = 55.3333333333;
$new_num = number_format($float, 2);

echo $new_num; //55.33

You probably want something like virtual alias domains . Add/edit the following in /etc/postfix/main.cf : virtual_alias_domains = example.com, example.net, example2.com virtual_alias_maps = regexp:/etc/postfix/virtual_alias The create the file /etc/postfix/virtual_alias with the aliases you need: po...

Webmaster2020.com

Search found 199 matches

Re: How do I load a csv file in MYSQL

Re: How do I load a csv file in MYSQL

Re: Remove the ^M Character

Re: How do i get columns out of text in shell

Re: update php on CentOS

Re: PHP yesterday date

Re: How to send a HTML mail

Re: bincimap not starting

Re: print of double/float

Re: How do I create non-local aliases in postfix