
gemini
Members-
Content Count
44 -
Joined
-
Last visited
Community Reputation
0 NeutralAbout gemini
-
Rank
Family Friend
Contact Methods
-
Website URL
http://www.ibsteam.net
-
ICQ
0
Profile Information
-
Location
Myrtle Beach, SC
-
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.'); e
-
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!
-
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.jp
-
Sorry I didn't reply right away, thread tracking works kinda strange.. Thank you for suggestions.