[PHP-DB] range_alloc_block_size

2005-12-16 Thread Murat Beyhan
Hello, Im using PHP and MySQL I try to import txt file to mysql Database But file size bigger than 2048KB so I could not import it It is related with range_alloc_block_size Because in mysql this veriable is 2048. If it is possible how can I change this variable. Please If somebody knows this

Re: [PHP-DB] range_alloc_block_size

2005-12-16 Thread Aaron Koning
This could be a number of things. Are you uploading the file in the script? Then the max_upload_size may have been exceeded. If not, then it could be the memory_limit, or the max_execution_time. Check your httpd/php error log (commonly at: /var/log/httpd/error_log) and adjust the referenced

Re: [PHP-DB] range_alloc_block_size

2005-12-16 Thread David Robley
On 12/16/05, Murat Beyhan [EMAIL PROTECTED] wrote: Hello, Im using PHP and MySQL I try to import txt file to mysql Database But file size bigger than 2048KB so I could not import it It is related with range_alloc_block_size Because in mysql this veriable is 2048. If it is possible how

[PHP-DB] SQL Server - do I need PHP to run COMMIT?

2005-12-16 Thread Alex Gemmell
Hello people, My PHP application uses a SQL Server 2000 database. I have previously only ever used MySQL and so my knowledge of SQL Server comes just from experimentation and trial and error experience. My PHP application appears to be working fine but I have just discovered that although

Re: [PHP-DB] SQL Server - do I need PHP to run COMMIT?

2005-12-16 Thread Robert Twitty
Using COMMIT is only required if you issued a BEGIN TRANS before your INSERTs, UPDATEs and / or DELETEs. All transactions are automatically committed if you don't use BEGIN TRANS. Are you backing up the transaction logs regularly? -- bob On Fri, 16 Dec 2005, Alex Gemmell wrote: Hello people,

Re: [PHP-DB] SQL Server - do I need PHP to run COMMIT?

2005-12-16 Thread Alex Gemmell
Yes, the transaction logs are being backed up and shrunk regularly. I am told while they are 400MB most of that is empty space and it's really about 50MB in size. Apparently that is still a bit too big and indicates a possible problem. I'm glad all transactions are auto-commited. I

Re: [PHP-DB] SQL Server - do I need PHP to run COMMIT?

2005-12-16 Thread Robert Twitty
Do you have the truncate log on checkpoint option enabled? Also, if you want to reduce the size of the log file if shrinking doesn't work, try running the following against the database. Of course, you should backup the DB first. SET NOCOUNT ON DECLARE @LogicalFileName sysname,

[PHP-DB] RSS/XML

2005-12-16 Thread Henry Ortega
I want to put a website's RSS feed on my website. For example, http://beccary.com/feed/ I want to put all the titles of that blog page on my website. Is there an easy way to do this?

[PHP-DB] Re: RSS/XML

2005-12-16 Thread El Bekko
Henry Ortega wrote: I want to put a website's RSS feed on my website. For example, http://beccary.com/feed/ I want to put all the titles of that blog page on my website. Is there an easy way to do this? Because they're all in a DB, yes, very easy :) Just build your RSS feed through PHP. --