Search Results

Search found 14016 results on 561 pages for 'mysql 5 5'.

Page 51/561 | < Previous Page | 47 48 49 50 51 52 53 54 55 56 57 58  | Next Page >

• 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 now?

  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 this very specific hardware…

  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 /home/**/PEAR/MDB2.php on line 1937.…

  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 have to install Code: …

  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, its the only…

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

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

  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). I tried…

  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 -pass 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

• 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

• 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

• master-slave-slave replication: master will become bottleneck for writes

  - by JMW

  hi, the mysql database has arround 2TB of data. i have a master-slave-slave replication running. the application that uses the database does read (SELECT) queries just on one of the 2 slaves and write (DELETE/INSERT/UPDATE) queries on the master. the application does way more reads, than writes. if we…

  Read the article

• Is an NTBackup of a MySQL data directory reliable

  - by Justin Dearing

  This question was asked on the MySQL forums in 2004 with no answers. I'm installing MySQL 5.0.x on a Windows 2003 Server for use with Drupal. I began to configure the backup with mysqldump when it occurred to me that an ntbackup taken using shadow copying should be reliable enough for backing up the…

  Read the article

• Can the mysql slow query log show milliseconds?

  - by Chase Seibert

  The mysql slow query log shows query time in whole integers. # Query_time: 0 Lock_time: 0 Rows_sent: 177 Rows_examined: 177 SELECT ... # Query_time: 1 Lock_time: 0 Rows_sent: 56 Rows_examined: 208 SELECT ... There was a microsecond patch to allow mysql to be configured to log queries that…

  Read the article

• MySQL: how to quote or escape field names?

  - by DrStalker

  Recently I was given a MySQL DB that included a field named time-taken, which caused errors when used in a select because of the minus sign. In this case I was able to rename the field, but for future reference how can field names be quoted or escaped in a MySQL query?

  Read the article

• Partial sync of Mysql databases on two remote computers

  - by Beck

  Does mysql replication supports delayed sync if remote slave server is OFF? For example I want to make my developing server have a fresh copy of databases each morning. It should be partial sync, not full copy of databases each morning. And synchronization should be only ONE way, not duplex, to…

  Read the article

• Set character_set_results UTF8 in MySQL my.cnf

  - by Marc

  Hi Folks, how can i set the Variable character_set_results from latin1 to uft8? I thought it would be enough if I would add the following variable in the my.cnf: default-character-set=utf8 But it not seem so: mysql SHOW VARIABLES LIKE 'character_set_%';…

  Read the article

• Centos mysql version is 5.5 however PHPmyadmin still says version 5.1

  - by Marc Rasmussen

  When i run the following in my console: [root@****~]# mysql -u root -p -e 'SELECT VERSION();' Enter password: +-----------+ | VERSION() | +-----------+ | 5.5.39 | +-----------+ Which should be the correct version. However when i enter my PHPMYADMIN on…

  Read the article

• what does the number represents in MYSQL connection error

  - by jack

  Hi I'd just like to know what the number '64' represents in mysql connection error message: Can't connect to MySQL server on '127.0.0.1' (64) in /var/www/test.php Thank you.

  Read the article

• MySQL database Int overflow and can't login in.

  - by Ryan SMith

  I have a MySQL database on my server and I"m pretty sure it's an int over flow on one table with an auto_increment field that's crashing it. I can delete the table, it's not very important, but I can't get into the server. Is there anyway to delete that…

  Read the article

< Previous Page | 47 48 49 50 51 52 53 54 55 56 57 58  | Next Page >