Search Results

Search found 14956 results on 599 pages for 'mysql dba'.

Page 87/599 | < Previous Page | 83 84 85 86 87 88 89 90 91 92 93 94  | Next Page >

• Using preg_replace in mysql

  - by Roshan

  I have a CMS content in database. The content contains '<img src= .............../>' also. I want to retrieve this content using mysql query and show on frontend but with all '<img src='.........../>' removed from the content. How can it be done using query in mysql?

  Read the article

• Can we use JCR API over MySQL?

  - by n_mysql

  Apache Jackrabbit (or the JCR API) helps you separate the data store from the data management system. This would mean that every data store provider would have to implement the JCR API for his own data store. The question is JCR implemented for MySQL? Can we use the JCR API over MySQL? I want to truly abstract out where i store my content, so that tomorrow if i don't want to use a relational DB i can swap it out with the file system with ease.

  Read the article

• mysql and linq support

  - by darko petreski

  Hi All, I have read in many forums that there is no good linq for mysql (free) but his forums are 2 years old. In the meantime is there any good free linq for mysql ? Hog good is for professional use? Regards

  Read the article

• Configure options MySQL server was compiled with?? [closed]

  - by GetFree

  I have MySQL server 5.0.67 running on a Linux machine. How can I know what configure options were used to compile it?? I'm interested in the option --with-mysqld-ldflags in order to know whether mysql was linked statically or dynamically. Thanks.

  Read the article

• GRANT with database name wildcard in MySQL?

  - by JR Lawhorne

  I want to create a user 'projectA' that has the same permissions to every database named 'projectA_%' I know its possible but MySQL doesn't like my syntax: grant all on 'projectA_%'.* to 'projectA'@'%'; Reference: http://dev.mysql.com/doc/refman/5.1/en/grant.html

  Read the article

• How to deinstall mysql?

  - by Kovu

  Hi, I sit on this problem ~5 hours: I try to install php and mysql on my iis7 machine. After install mysql, I can't connect, PW error (Im sure its not btw). I try to deinstall but after a new install, the database is the same. System is Windows Server Standart SP2 (I don't know hich Windows Server is it, its the only information I get under "system")

  Read the article

• where has sun mysql database manager gone???

  - by opensas

  If I recall correctly, there where at least to desktop programas from sun which were very useful for handling mysql databases... Now, all I can find is some mysql workbench which is only useful for designing data... Both programs I'm talking about allowed you to manage servers, create database, create tables, index, perform querys, edit data, etc... unfortunately I don't even recall there names... Any idea where I can find them? thanks a lot

  Read the article

• MYSQL - datetime to seconds

  - by Mike

  Hello, I wasn't able to find out (googling, reading mysql reference manual) how to get value of DATETIME in seconds in MySQL. I dont mean to extract seconds from datetime, but to convert it into seconds. Thanx

  Read the article

• Log MySQL Query In Kohana 3

  - by Asif

  Hi All, I am using Kohana 3. I want to log the MySQL queries being executed by an application. The reason to determine the query of type INSERT,UPDATE and DELETE which are being executed in a process and store them in another MySQL table with date-time for further reference. Can anybody tell how can I achieve this?

  Read the article

• Tuning MySQL to take advantage of a 4GB VPS

  - by alistair.mp

  Hello, We're running a large site at the moment which has a dedicated VPS for it's database server which is running MySQL and nothing else. At the moment all four CPU cores are running at close to 100% all of the time but the memory usage sticks at around 268MB out of an available 4096MB. I'm wondering what we can do to better utilise the memory and reduce the CPU load by tweaking MySQL's settings? Here is what we currently have in my.cnf: http://pastie.org/private/hxeji9o8n3u9up9mvtinbq Thanks

  Read the article

• php warning mysql_fetch_assoc

  - by death the kid

  I am trying to access some information from mysql, but am getting the warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource for the second line of code below, any help would be much appreciated. $musicfiles=getmusicfiles($records['m_id']); $mus=mysql_fetch_assoc($musicfiles); for($j=0;$j<2;$j++) { if(file_exists($mus['musicpath'])) { echo '<a href="'.$mus['musicpath'].'">'.$mus['musicname'].'</a>'; } else { echo 'Hello world'; } } function getmusicfiles($m_id) { $music="select * from music WHERE itemid=".$s_id; $result=getQuery($music,$l); return $result; }

  Read the article

• Books for experienced .NET developer learning PHP/MySQL

  - by webworm

  Hi All, I am an experienced .NET developer (C#/ASP.NET) looking to broaden my skills to the PHP/MySQL arena. I would like get recommendations on books for learning PHP/MySQL that are geared towards someone who is already familiar with object oriented programming and web development. I do realize that there are lots of online material out there but I am looking for an actual print book I can read. Thanks a bunch.

  Read the article

• mysql query query

  - by nightcoder1

  basically i need to write a query for mysql, but i have no experience in this and i cant find good tutorials on the old tinternet. i have a table called rels with columns "hosd_id" "linkedhost_id" "text link" and a table called hostlist with columns "id" "hostname" all i am trying to achieve is a query which outputs the "hostname" and "linked_id" when "host_id" is equal to "id" any help or pointers on syntax or code would be helpfull, or even a good mysql query guide

  Read the article

• MySQL InnoDB insertion is very slow

  - by dharmapurikar

  We use MySQL server 5.1.43 64-bit edition. InnoDB is used as engine. We have a sql script which we execute every time we build the application. On ubuntu machine with MySQL server and InnoDB engine it takes about 55 seconds to complete the execution. If I run the same script on OSX, it takes close to 3 minutes! Any ideas why OSX is so slow while executing this script?

  Read the article

• Upgrading mysql from 4.1.22 to 5.0

  - by Arsenal

  Hi, I'm trying to upgrade our company's 4.1.22 version of MySQL to 5. I'm using sudo yum --enablerepo=centosplus upgrade mysql* but keep getting an error of conflicted files with the 4.1 version. Does that mean there really isn't any other way than uninstalling 4.1 and installing 5.0? I have read that using the yum upgrade command should work however... Thanks in advance!

  Read the article

• Is there any performance difference between Debug and Release?

  - by Lazlo

  I'm using MySql Connector .NET to load an account and transfer it to the client. This operation is rather intensive, considering the child elements of the account to load. In Debug mode, it takes, at most, 1 second to load the account. The average would be 500ms. In Release mode, it takes from 1 to 4 seconds to load the account. The average would be 1500ms. Since there is no #if DEBUG directive or the like in my code, I'm wondering where the difference is coming from. Is there a project build option I could change? Or does it have to do with MySql Connector .NET that would have different behaviors depending on the build mode?

  Read the article

• MySQL index building performance

  - by Christian

  I tried to build an index over a two columns of a 30,000,000 entry database. I canceled the process after ~60hr as it didn't seem to work. For some reason MySQL takes only 22 mb ram instead of using the RAM fully. Is index building an operation that needs no Ram or is there some way to tell MySQL to use more RAM to be faster?

  Read the article

• Mysql ninja tricks

  - by alexn

  Hi, what are your mysql ninja tricks? What features are extra special? I'm starting with ORDER BY FIELD which enables you to sort in a particular order, like this: SELECT url FROM customer ORDER BY FIELD(customer.priority, 1, 2, 3, 0) Features like this is hard to find in the mysql documentation. Bring it!

  Read the article

• Convert MSSQL Varbinary field to MYSQL, keeping data intact

  - by Mike Sheridan

  I was given the daunting task of converting a ASP website to PHP and MSSQL to MySQL, and I ran into an issue that hopefully somebody can help I have a user table which has a password field with datatype Varbinary(128), are using pwdencrypt to encrypt the password. Is there a way to transfer that over to MySQL, and somehow i need to be able to keep the password intact... how can i go about that? any pointers would be greatly appreciated!

  Read the article

• mysql full text search ampersand (&) Problem

  - by Jason

  How can I serach word with "&" using mysql full text search ? There are words string, like "Marks & Spencer", "at&t" in my tables , serach "at&t", but can't find it on the database using mysql full text search Any ways to serach word with "&"?

  Read the article

• SQL Query about blob length

  - by Christian

  Is there a way to query a MySQL database that gives me all blobs that are bigger than 1kb?

  Read the article

• Locating current mysql my.cnf

  - by Aglystas

  Hi All, I'm trying to determine which my.cnf mysql is using. Is there a command or something for mysql or mysqladmin that shows which one is being loaded?

  Read the article

• MySQL query to view vertical data

  - by wenkhairu

  I have MySQL data that looks like this: +----------------------------------------+ |Name | kode | jum | +----------------------------------------+ | aman |kode1 | 2 | | aman |kode2 | 1 | | jhon |kode1 | 4 | | amir |kode2 | 4 | +--------------------+-----------+-------+ How can I make the table look like this one, using a MySQL query? kode1 kode2 count aman 2 1 3 jhon 0 4 4 amir 0 4 4

  Read the article

• PHP Web Service vs mySQL Connector on Windows Application

  - by Derek

  I have a Windows Application in C#. This application interacts with a remote mySQL database. Should I create a PHP web service to do these (insert/add/delete/update) or use mySQL connector for c#? I'm not sure which way is better. Thanks!

  Read the article

• MySQL stored procedure debugging

  - by NumberFour

  Hello, do you have any tips for some GUI applications (free) that are capable of debugging MySQL stored procedures? I tried devArt dbForge MySQL Studio which worked just fine, but it's not free. Thanks for any tips.

  Read the article

< Previous Page | 83 84 85 86 87 88 89 90 91 92 93 94  | Next Page >