Does anyone know of any interface to administer beanstalkd? What I'm looking for vaguely is something like PhpMyAdmin for MySQL.
Doesn't have to be PHP or web-based, could be any interface, GUI ..etc
We are using PHP,MySQL,SVN, and Apache. I want to know if I assume the local subnet trusted, and allow all ports on our subnet using iptables, then allow only port 80 as open to "anyone". If it is "good security" taking that the subnet is trusted as a premise. This is also assuming good PHP code etc, and that apache is configured correctly.
This is using CentOS 5.
I'm looking for a way to do something analogous to the MySql dump from SQL Server. I need to be able to pick the tables and export the schema and the data (or I can export the schema via SQL Server Management Studio and export the data separately somehow).
I need this data to be able to turn around and go back into SQL Server so it needs to maintain GUIDs/uniqueidentifiers and other column types.
Does anyone know of a good tool for this?
Hi everyone,
I'd read this article recently and are very interested on how to make a practical approach to Concurrency control on a web server.
The server will run CentOS + PHP + mySQL with Memcached. How would you set it up to work?
http://saasinterrupted.com/2010/02/05/high-availability-principle-concurrency-control/
Thanks!
Hi all,
I need your suggestion for this.
I need to add data tomysql database through the admin interface, at initial i need to add data in bulk, so i thought of using csv upload but how to add images with csv i.e. when doing single add i insert name , description and a image via a form, but how to do the same for bulk.
Thanks in advance.
I remember when I was working with PHP several years back I could blow up my application by naming a MySQL column 'desc' or any other term that was used as an operator.
So, in general are there names I should avoid giving my table columns?
update answers a1
set a1.FilingDate=(
select date_sub( a2.FilingDate
,Interval 1000 Year) as FilingDate
from answers a2
where Year(a2.FilingDate)>=3000
)
where Year(a1.FilingDate)>=3000
but it gives me the following error:
You have an error in your SQL syntax;
check the manual that corresponds to
your MySQL server version for the
right syntax to use near 'update
answers a1 set a1.FilingDate=( select
date_sub(a2.FilingDate,Interval 10' at
line 1
Can anyone tell me about the issue and its solution?
I am designing a php/mysql website that will have a members are and a separate "forum" section.
Should I just use the forum software as my "login/registration"? If this is the case should I go with VBulletin, Invision, phpBB3 or something different?
Or should I roll my own single sign on hack? Or something completely different?
I have read that relational databases are a terrible way to do multicast messages like twitter.
So twitter saves every tweet only one times and then retrieve its in every stream ? or saves every tweet in every users's stream ?
I want to know why relational database ( like mysql or postgresql ) doesn't good for twitter-like application.
Hello
i am currently trying to run a web crawler through the terminal. it compiles fine and the debug does not find any errors, however i get the following error which i do not understand.
any ideas on how to get rid of this error would be much appreciated
Unhandled Exception: System.ArgumentOutOfRangeException: startIndex + length > this.length
Parameter name: length
at System.String.Substring (Int32 startIndex, Int32 length) [0x00000]
at OpenWebSpiderCS.mysql.executeSQLQuery (System.String SQL) [0x00000]
at OpenWebSpiderCS.db.startIndexThisSite (OpenWebSpiderCS.page p) [0x00000]
at OpenWebSpiderCS.ows.startCrawling () [0x00000]
at OpenWebSpiderCS.mainClass.Main (System.String[] args) [0x00000]
thank you
I have a mysql table with three columns: username, location, timestamp. This is basically a log of user activity of what location they are in and the time that they were there.
What I want to do is select a distinct username+location where only the most recent item (by timestamp) is provided.
So say the table consists of:
tom roomone 2011-3-25 10:45:00
tom roomtwo 2011-3-25 09:00:00
tom roomtwo 2011-3-25 08:30:00
pam roomone 3011-3-25 07:20:23
I would want only these to be selected:
tom roomone 2011-3-25 10:45:00
tom roomtwo 2011-3-25 09:00:00
Currently my MySQL data stored like below
product | total
------------------------------------------
puma,adidas | 100.00,125.00
puma | 80.00
reebok,adidas,puma | 70.00,100.00,125.00
adidas,umbro | 125.00,56.00
How to combine, explode, merge and total it like this in php?
puma 485.00
adidas 350.00
reebook 70.00
umbro 56.00
I am using php, mysql with smarty and I places where users can put comments and etc. I've already escaped characters before inserting into database for SQL Injection. What else do I need to do?
Hello, I am starting with spring-roo, so I downloaded it and now I'm trying to export the variable.
To get it, I tryed:
PATH=$PATH:/Users/myUsr/spring-roo/bin
export PATH
PATH variable
my-Name-3:~ myUsr$ echo $PATH
/sw/bin:/sw/sbin:/usr/local/mysql/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin:/usr/X11R6/bin:/Users/myUsr/spring-roo/bin
In this path (/Users/myUsr/spring-roo/bin), there is roo.sh
But then, I can not run the command roo as it is suposed to be.
Any idea??
Thanks in advance
Hi,
i just finish some MYSQLto excel script with xlwt and I need to colour every second row for easy reading.
I have tried this:
row = easyxf('pattern: pattern solid, fore_colour blue')
for i in range(0,10,2):
ws0.row(i).set_style(row)
Alone this colouring is fine, but when when I write my data rows are again white.
Can some please show me some example 'cuz I m lost in coding :/
Best Regards.
Our application needs to use two different kinds of databases.One is oracle, the other is mysql and we want to use maven plugin hbm2ddl to generate the ddl file, and want to output the two ddl files at the same time, I don't know how to set the configuration in pom.xml. I tried to use this plugin twice, but it always generated one ddl file. Any one encountered such case before ? could u please give some advice.
Hi,
I'm making a RSS 2.0 feed powered by PHP & MySQL. I would like to know how to make simple formatting in the contents like Line Breaks, Bold, Italics, Links, Images.
When I try to insert a <br> in the database for a newline, the feed reader is displaying it as Invalid Feed.
Please help
Thanks
Is there anyway to find the date difference in php? I have the input of from date 2003-10-17 and todate 2004-03-24. I need the results how many days is there within these two days. Say if 224 days, i need the output in days only.
I find the solution through mysql but i need in php. Anyone help me, Thanks in advance.
Hi,
Let's say you have a big web app with large visits, but you don't want your app to crash & you don't want people to see the php or mysql errors that happens during replacing files using FTP, How to avoid that? How to just execute the old version of file until the replacing is done?
Thanks
How do I correct the following error that is listed below. I'm using PHP & MySQL.
I get the following error.
Not Found
The requested URL /fckeditor/editor/fckeditor.html was not found on this server.
I followed the directions on http://docs.cksource.com/FCKeditor_2.x/Developers_Guide/Integration/PHP
Are there any good database schema comparison tools out there that support Sybase SQL Anywhere version 10? I've seen a litany of them for SQL Server, a few for MySQL and Oracle, but nothing that supports SQL Anywhere correctly.
I tried using DB Solo, but it turned all my non-unique indexes into unique ones, and I didn't see any options to change that.
Hey, I'm just wondering if it's possible to have a form in html do two things on submit, have the action go to a url like normal (for a search) but also run a mysql command.
Thanks!
I have a bash script that runs on our shared web host. It does a dump of our mysql database and zips up the output file. Sometimes the mysqldump process gets killed, which leaves an incomplete sql file that still gets zipped. How do I get my script to 'notice' the killing and then delete the output file if the killing occurred?