Search Results

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

Page 54/599 | < Previous Page | 50 51 52 53 54 55 56 57 58 59 60 61  | Next Page >

• You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version

  - by user1810442

  Hi I keep getting SQL syntax error when i'm running my code in php, however when i remove the variables and do it manually in MYSQL, not a problem. I've tried 2 different versions of query one with (') and other with (") and nothing. Could you please help? Thank you. $produpdateid = $_GET ['id']; $varcat = $_POST['category']; …

  Read the article

• What Counts For a DBA: Imagination

  - by drsql

  "Imagination…One little spark, of inspiration… is at the heart, of all creation." – From the song "One Little Spark", by the Sherman Brothers I have a confession to make. Despite my great enthusiasm for databases and programming, it occurs to me that every database system I've ever worked on has been, in terms of its inputs and outputs, downright…

  Read the article

• What Counts for a DBA: Skill

  - by drsql

  “Practice makes perfect:” right? Well, not exactly. The reality of it all is that this saying is an untrustworthy aphorism. I discovered this in my “younger” days when I was a passionate tennis player, practicing and playing 20+ hours a week. No matter what my passion level was, without some serious coaching (and perhaps a change in dietary…

  Read the article

• MySQL query, 2 similar servers, 2 minute difference in execution times

  - by mr12086

  I had a similar question on stack overflow, but it seems to be more server/mysql setup related than coding. The queries below all execute instantly on our development server where as they can take upto 2 minutes 20 seconds. The query execution time seems to be affected by home ambiguous the LIKE string's are. If they closely match a…

  Read the article

• Postfix (SASL) / MySQL: Use MD5 Encryption?

  - by Lorren Biffin

  Is it possible to use MD5 password encryption to encrypt passwords when using Postfix / SASL and MySQL? Currently, my setup is using the MySQL CRYPT() function, which for various reasons isn't ideal.

  Read the article

• Backup a Linked MySQL DB through SQL Server Management Studio

  - by saturdayplace

  I have a MySQL database that I'm able to query as a Linked Server through SQL Server Mgt Studio. I'm wondering if it's possible to create a backup task in Studio that will backup the MySQL DB, so that I could schedule automated backups. Is this possible?

  Read the article

• Monitoring MySQL SELECT/WRITE/UPDATE/SLOW queries in Nagios

  - by imaginative

  There's ways to get performance graphs with several monitoring software packages out there such as ZenOSS. There's a plugin available that will graph MySQL based SELECT/WRITE/SLOW queries in a nice rrd style graph. I'm curious if there is a way to also get similar graphs available in Nagios 3.0? I know Nagios has tools like pnp and…

  Read the article

• Need help making an ODBC MySQL Connection

  - by Andy Moore

  Short Version: How do I connect from PowerShell to an ODBC 5.1 MySQL Driver? I can't seem to find any connection strings that accurately have a "Provider" field for this particular instance. (See bottom of this question for examples/errors) ===== Long Version: I'm not a server guy, and I've been handed the task of setting up…

  Read the article

• PHP & MySQL on Mac OS X: Access denied for GUI user

  - by Eirik Lillebo

  Hey! This question was first posted to Stack Overflow, but as it is perhaps just as much a server issue I though it might be just as well to post it here also. I have just installed and configured Apache, MySQL, PHP and phpMyAdmin on my Macbook in order to have a local development environment. But after I moved one of my…

  Read the article

• Change collation of a MySQL table to utf8_general_cs

  - by jack

  I tried to change collation MySQL table to utf8_general_cs but got following error: mysql> ALTER TABLE table_name CONVERT TO CHARACTER SET utf8 COLLATE 'utf8_general_cs'; ERROR 1273 (HY000): Unknown collation: 'utf8_general_cs' I run "SHOW COLLATE" command and "utf8_general_cs" is not in the results. What can I do…

  Read the article

• I/O intensive MySql server on Amazon AWS

  - by rhossi

  We recently moved from a traditional Data Center to cloud computing on AWS. We are developing a product in partnership with another company, and we need to create a database server for the product we'll release. I have been using Amazon Web Services for the past 3 years, but this is the first time I received a spec with…

  Read the article

• MDB2, Pear, Mysql error

  - by Kyle Hudson

  ORIGINALLY POSTED ON http://stackoverflow.com/questions/2682332/mdb2-pear-mysql-error however as its a server issue thought i may have more luck here. Hi Guys, I have PEAR, MDB2 and Mysql Driver installed however I keep getting: Fatal error: Call to undefined function: MDB2_Driver_mysql::_isNewLinkSet(). in…

  Read the article

• ubuntu mysql install error with php

  - by Mirage

  When i try ton install php5-mysql it gives this error The following packages have unmet dependencies: php5-mysql: Depends: php5-common (= 5.2.6.dfsg.1-3ubuntu4) but 5.2.6.dfsg.1-3ubuntu4.4 is to be installed E: Broken packages I tried installing php5-common but it says php5-common is new version I think i…

  Read the article

• MySQL Stored Procedure

  - by xdevel2000

  I must convert some stored procedures from MS Sql Server to MySQL and in Sql Server I have these two variables: @@ERROR for a server error and @@IDENTITY for the last insert id are there MySql similar global variables?

  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,…

  Read the article

• mysql with DRBD on rackspace

  - by Richard Castle

  I am trying to set up a failover secondary MySQL server that is a mirror of my primary MySQL server using DRBD. The problem is that I am on a rackspace cloud server and I need a second partition on both the primary and secondary servers that I will replicate with DRBD. Rackspace does not allow me to create a…

  Read the article

• mysqldump triggering repair of MySQL tables

  - by Rhodri

  I have an automated backup of a 6 Gigabyte MySQL database running very two hours. I also have a script which checks every minute for the need to repair MySQL tables. Increasingly I'm getting tables having to be repaired during the backup process with the message returned of: Auto-increment value: 0 is…

  Read the article

• Plesh admin password for MySQL

  - by David

  Does anyone know how Plesk stores MySQL admin password? I accidentally changed the admin password in MySQL's user table which was set by Plesk and now Plesk is broken.

  Read the article

• How to install MySQL on Windows 7

  - by akash gupta

  Please help me how to install MySQL on Windows 7. When I tried to install, I am getting errors as: The security settings could not be applied to the database because the connection has failed of the following errors ERROR NR:1045 Access denied for user 'root@'localhost(using password yes). …

  Read the article

• MySQL deny login via terminal and phpmyadmin

  - by dave

  Hello, I am trying to login to mysql via terminal and phpmyadmin it says cannot access localhost. Below is the return message when trying to login via the terminal ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) root@x27:/var/lib/phpmyadmin# mysql --user=root…

  Read the article

• MySql client for Linux

  - by Hannes de Jager

  What MySql client are you using for Linux. I currently use PhpMyAdmin and the Mysql Query Browser but I would like something similar to Toad or HeidiSql that I use on windows. One with SQL code completion.

  Read the article

• Restart MySQL on Solaris

  - by Vincent

  All, I am trying to setup remote access for MySQL on a solaris machine. I copied my-small.cnf to /etc/my.cnf. How do I restart MySQL in Solaris? Thanks

  Read the article

• Why does MySql have 'utf8' for collation on its information_schema but latin1_swedish on all other d

  - by PoppySeeds

  Using the latest version of MySql. I created a database, it defaulted to Latin1_Swedish, and just noticed that the 'mysql' database also has Latin1_Swedish. Only the information_schema has a collation of utf8_general_ci. Should I be changing my database to utf8? And if so, how?

  Read the article

• Configure options MySQL server was compiled with??

  - 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

• Plesk admin password for MySQL

  - by David

  Does anyone know how Plesk stores MySQL admin password? I accidentally changed the admin password in MySQL's user table which was set by Plesk and now Plesk is broken.

  Read the article

< Previous Page | 50 51 52 53 54 55 56 57 58 59 60 61  | Next Page >