gemini

Yes, thank you very much!

Thank you very much David! The magic worked! This is cool - I learned something today - thanks a lot, now I have better understanding of it I had to use \n instead of \r\n - thanks to you I know why Thank you, thank you, thank you MySQL doc is quite compicated for a newby like me.

Thank you David. I changed it to \n, but still no difference. I actually have txt tab delimited file as it stated in the LOAD DATA line. I tried using full path in the phpMyAdmin with different options and couldn't import data either - only fom my hdd

Thank you for pointing me into right direction. I still have problems - here is my code: ><?php $dbh=mysql_connect ("localhost", "xxx", "xxx") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("some_db"); $sql1 = "TRUNCATE TABLE sometable"; $sql2 = "LOAD DATA INFILE '/home/my_host/public_html/folder/test.txt' INTO TABLE sometable FIELDS TERMINATED BY '\\t' LINES TERMINATED BY '\\r\\n' IGNORE 1 LINES"; mysql_query($sql1) or die ('I can not empty the 4closures table.'); mysql_query($sql2) or die ('I can not insert data into 4closures table.'); echo "Done"; ?> The syntax seas to be correct and the main problem in the location of the text file. Would you please tell me what path I should use - I tried everything.. may be there is something else.. I tried importing manually through phpMyAdmin and it is successful, also it generated SQL and PHP code that I took for base, the only difference that in the phpMyAdmin I uploaded file form my hard drive and in the script I want it to be off the same site. Thank you for your help.

I was using strandard import tools available in phpMyAdmin

Hello everyone, I have a csv file that being uploaded to my site every morning and I need to import it into existing table - update the data. I'm not a PHP wiz, but I'm sure I could find a script that I can adjust to my needs and make it work, but I would like to ask if there is easier way do that. I know I can import the data manually, so I was wandering if I can use the same tools by setting up cron job and without any additional scripting? Any suggestions? Thank you.

It looks like you entered the time arguments as part of the command line (made obvious by the fact it's trying to run '7' as a command). Assuming you are using cPanel's cron form to enter your crontab info, the actual command should be "/usr/local/bin/php /home/ibsteam/fullbackup.php" and you should use the other form fields available to enter the five scheduling components (i.e., if you used the Advanced cron form, you'll see 5 fields before the command line field. Enter the 5 items in "7 13 * * *" in each of those fields respectively). <{POST_SNAPBACK}> Thank you Mike! That's was the problem. Thank you guys a lot for your great support!

the last one was 7 13 * * * /usr/local/bin/php /home/ibsteam/fullbackup.php the number 30 in the message I figured stands for the minutes in the cron job. The las message was: /bin/sh: line 1: 7: command not found

I'm trying to back stuff up on my local PC and getting the following email from cron: /bin/sh: line 1: 30: command not found what is it? and how do I fix it - any ideas? Thank you!

thanks I figured it I had to delete exe part on the <FilesMatch>

http://www.ibsteam.net/ibs_links/beta5/setup.exe it had permission 755 already I renamed it now I just saw this in my .htaccess # deny most common except .php <FilesMatch "\.(inc|tpl|h|ihtml|sql|ini|conf|class|bin|spd|theme|module|exe)$"> deny from all </FilesMatch> and when I disable it - my *.exe files download just fine - how can I edit this code to add sertain folder with files to be accepted for downloads?

http://www.ibsteam.net/IBS%20Links/beta5/

I uploaded a few *.exe files but can not download them from the webpage by clicking on the link to the files. It says You don't have permission to access the file. I already CHMODed it to 755 still doesn't work P.S. I just saw this in my .htaccess # deny most common except .php <FilesMatch "\.(inc|tpl|h|ihtml|sql|ini|conf|class|bin|spd|theme|module|exe)$"> deny from all </FilesMatch> and when I disable it - my *.exe files download just fine - how can I edit this code to add sertain folder with files to be accepted for downloads?

Hello everybody. This is probably a lame question, but I don't know the answer: I'm using INCLUDE function in my pages and sometimes including pages from subfolders which makes pictures disappear form the header. When I look at the properties I can see that its trying to read the file from the folder where the included page is - of course I always can provide a full path with the domain name for each picture, but I think there is other way to do it right. Is there a way to include pathes somewhere that I just could use something like /images/aaaa.jpg and not entering *****/images/aaaaa.jpg ? Thanks

Sorry I didn't reply right away, thread tracking works kinda strange.. Thank you for suggestions.