MySQL Query Logging to Syslog-ng server.
Is it possible to log queries to a central syslog-ng server? Need to have mysql query logs present in an existing centralized log server. ...
mysql
Slow query stops apache from getting answer
I have a problem where I can not query my mysql db until other queries are done. This happens when I run a heavy sql-query (30s) from apache, or when I ran a series of sql-querys from within the same apache-request. Since my queries are only selects (no updates or modifications and no transactions) I think it should be possible to run s...
Sql Un-Wizardry: Compare values from one list in another
I have a comparison I'd like to make more efficient in SQL. The input field (fldInputField) is a comma separated list of "1,3,4,5" The database has a field (fldRoleList) which contains "1,2,3,4,5,6,7,8" So, for the first occurrence of fldInputField within fldRoleList, tell us which value it was. Is there a way to achieve the followin...
How do I add two count(*) results together?
I have two tables: Toys and Games. +--------------------+------------------+ | Field | Type | +--------------------+------------------+ | toy_id | int(10) unsigned | | little_kid_id | int(10) unsigned | +--------------------+------------------+ +--------------------+------------------+ | Field ...
Help with search coding please.
I am doing a project where I want a person to enter the name of any artist/band into a text box where it will seach my mysql database for the event information and display the results/content on another page. The code below is within my index.php where it should get the information from search.php (below also). I've looked all over and I...
PHP/SQL Database querying good practice and security.
So I'm a slightly seasoned php developer and have been 'doin the damn thing' since 2007; however, I am still relatively n00bish when it comes to securing my applications. In the way that I don't really know everything I know I could and should. I have picked up Securing PHP Web Applications and am reading my way through it testing thing...
What mysql settings affect the speed of LOAD DATA INFILE?
Let me set up the situation. We are trying to insert a modestly high number of rows (roughly 10-20M a day) into a MyISAM table that is modestly wide: +--------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+-------...
a JOIN query edited so that a field that has unique values
I have a JOIN query that pulls the last 6 "topic" records (the records with the highest topic_ids that are have a topic_status of 0, i.e. it's not spam): SELECT topic_title, topic_slug, meta_value, topic_poster FROM `folio_topics` as Topics INNER JOIN `folio_topicmeta` as Topicmeta ON Topics.topic_id = Topicmeta.topic_id WHERE `topic_st...
PHP Script that inserts URL variables into a mysql db?
Hi All I'm looking for a simple and secure script to insert rows into a mysql table from a php script. by calling http://www.myserver.com/addtosometable.php?1=asdf&2=asdf.... I'm not asking how specifically, rather I thought this might be a good platform to build a example script and keep it up to date with best practices... Chee...
Mysql Query : Where clause if Exists
Dear All I have a MySQL db and inside it a table called ProductMaster with 6 fields "Product_Id,Product_Name,Model,Opening_date,Closing_Date,Status". Opening_Date and Closing Date Can accept null values.So some records has values for this field I have the below query to display records from this table. "select Product_Id,Product_Name,...
temporary tables within stored procedures on slave servers with readonly set
Hi, We have set up a replication scheme master/slave and we've had problems lately because some users wrote directly on the slave instead of the master, making the whole setup inconsistent. To prevent these problems from happening again, we've decided to remove the insert, delete, update, etc... rights from the users accessing the slave...
rails windows problem
Hello, I just installed ruby on rails on windows. install mysql and created a new project. Then I changed database.yml to use my own mysql server as follow development: adapter: mysql database: mytools username: test password: test when I try to access story controller(http://localhost:3000/stories), error shows "SQLite3::SQLExcepti...
problems with mysql for ruby on rails
Hello, ah...it is not easy to get started ruby on rails to me.. I am trying to use mysql for ruby on rails development. When I execute "gem install mysql", I get following error. error: while generating documentation for mysql-2.8.3-x86-mswin32...message: unhandled special: special: type=17...bla bla... how do I install mysql for ru...
CakePHP problem bake views (EasyPHP, MySQL)
I CakePHP (cake_1.2.2.8120) and EasyPHP (3.0) installed on Windows Vista Ultimate. I followed the "baking" tutorials online, successfully set the database connection with the "cake bake" command from the CLI. I baked the controller for my "Users" table using the "php cake.php bake controller Users" command - worked fine. However, when I...
How to migrate from my WAMP environment to using MSSQL?
I have on my local PC installed WAMP environment (using WampServer OS). Now I would need to change one script from working with MySQL to MSSQL. I have no idea at all how to proceed, where to download MSSQL, how to install it and how to connect with PHP? Thank you very much ...
Difference between MySQL .zip and .msi download
Sorry I know this is not really a programming question. But when for example on the MySQL website you are given the option to download a .zip or .msi file. Is the result exactly the same application, or do the two work slightly different. I.e. the .zip option being more self contained, with everything under the MySQL folder and nothing ...
MySql schema generation with NHibernate
I've used following code to generate database creation script Configuration configuration = new Configuration(); configuration.Configure(); SchemaExport schemaExport = new SchemaExport(configuration); using(TextWriter stringWriter = new StreamWriter("create.sql")) { schemaExport.Execute(false, false, false, true, null, stringWriter);...
best way to generate reports on table
the question is : i have a table that contains details, this table is used by users when they registered or update there profile or participate in different exams. The report I need will have some calculation like aggregate scores . I would to as if it is better to create new table witch includes the report i need or it's better to work...
MySQL change type of foreign key
I am using MySQL and I have a table with an index that is used as a foreign key in many other tables. I want to change the data type of the index (from signed to unsigned integer) , what is the best way to do this? I tried altering the data type on the index field, but that fails because it is being used as a foreign key for other table...
Oracle XE or MySQL , which one I should choice?
I am going to develop a SNS website. Now I need to make a decision between Oracle XE and MySQL. I know you are a group of experts. Can you share some comments on this? Best wishes Ariso ...