Stack Overflow
Stack Overflow

Questions tagged [mysql-5.1]

MySQL version 5.1 is a version of the popular database system MySQL and included an event scheduler, partitioning, plugin API, row-based replication and server log tables

MySQL 5.1 was released at the end of November 2008, and included an event scheduler, partitioning, plugin API, row-based replication and server log tables.

While the generic tag should be used with all MySQL related questions, this tag should be used if a question is about a problem seen while running version 5.1 or if it is about features specific to this version.

111 questions
16
votes
8 answers

How to select rows from partition in MySQL

I made partition my 300MB table and trying to make select query from p0 partition with this command SELECT * FROM employees PARTITION (p0); But I am getting following error ERROR 1064 (42000): You have an error in your SQL syntax; check the manual…
Kad
  • 542
  • 1
  • 5
  • 18
15
votes
9 answers

Connection for controluser as defined in your configuration failed

I've already looked into this but since I am running on Ubuntu 10.04 instead of XAMPP and have already created the phpmyadmin database and I can log in through terminal with both the root and phpmyadmin users. How I installed: sudo apt-get install…
Spitfire19
  • 260
  • 1
  • 2
  • 11
13
votes
3 answers

How can I cast an int to a bit in MySQL 5.1?

I am transitioning from SQL Server to MySQL 5.1 and seem to be tripped up trying to create a table using a select statement so that the column is a bit. Ideally the following would work: CREATE TABLE myNewTable AS SELECT cast(myIntThatIsZeroOrOne as…
Aaron Silverman
  • 22,070
  • 21
  • 83
  • 103
9
votes
1 answer

Why is signal keyword not working in mySQL 5.1.48?

I'm using mysql v5.1.48 and red http://dev.mysql.com/doc/refman/5.5/en/signal.html. But the code DELIMITER $$ CREATE PROCEDURE `CoreRaiseError`() BEGIN SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'An error occurred', MYSQL_ERRNO =…
MUY Belgium
  • 2,330
  • 4
  • 30
  • 46
8
votes
5 answers

Extremely Slow Select Query on MySQL

I’m trying to understand why a select query runs extremely fast on my laptop while extremely slow on the server. The query takes 1.388 seconds to run on the laptop while 49.670 seconds on the server. Both schemas are identical as I have exported the…
AlGallaf
  • 627
  • 6
  • 15
  • 28
6
votes
1 answer

MySQL partitioning by week automatically

I created a table to log the activity of my application. This table will log more than 2 millions record per month. So I want to use partitioning by month or week CREATE TABLE IF NOT EXISTS `UL`.`Log` ( `LogID` INT(20) NOT NULL AUTO_INCREMENT, …
user5209569
5
votes
2 answers

How to Import database, update products that have changed, delete products that have been removed

I'm "ok" at basic MySQL, but this is "WAY OVER MY HEAD"! Objectives: Import database update products that have changed delete products that have been removed Quickly and efficiently The database table(s) are HUGE, speed is an issue. Does not…
Brad
  • 2,237
  • 5
  • 41
  • 69
5
votes
2 answers

Upgrading Amazon RDS instance from MySQL 5.5 to MySQL 5.6

With a large data set and a real time system, halting that applications using RDS for a mysqldump from a 5.5 instance and loading that data with the mysql command is impractical. In the Amazon blog http://aws.typepad.com/aws/amazon-rds/page/2/ on…
snappy
  • 51
  • 3
5
votes
2 answers

INSERT INTO table VALUES.. vs INSERT INTO table SET Error

I'm trying to run the following query: "insert into visits set source = 'http://google.com' and country = 'en' and ref = '1234567890';" The query looks good to me and it prints a warning: 1 row(s) affected, 2 warning(s): 1364 Field 'country'…
jribeiro
  • 3,387
  • 8
  • 43
  • 70
4
votes
2 answers

GROUP BY and custom order

I've read through the answers on MySQL order by before group by but applying it to my query ends up with a subquery in a subquery for a rather simple case so I'm wondering if this can be simplified: Schema with sample data For brevity I've omitted…
rink.attendant.6
  • 44,500
  • 61
  • 101
  • 156
4
votes
3 answers

ERROR: Error installing mysql: ERROR: Failed to build gem native extension

I followed the "http://blog.mmediasys.com/2011/07/07/installing-mysql-on-windows-7-x64-and-using-ruby-with-it/" for setting the connection between Ruby on rails app and mysql server 5.1 So when I install the mysql gem with the following command: gem…
sunil
  • 1,040
  • 9
  • 20
4
votes
2 answers

Undefined method 'accept' for nil:NilClass after upgrading to Rails 3

I just upgraded my Rails application from Rails 2.3.8 to Rails 3.2.7 and I've run across a problem with Activerecord. If I try to access my database with Activerecord at all(Ex: Employee.last), I get the following error: NoMethodError: undefined…
Breathtender
  • 490
  • 5
  • 15
3
votes
1 answer

Unable to delete a MySQL InnoDB table

I am using MySQL 5.1.56 I have a DB with about 70 tables and I have an issue with a particular corrupted table e.g. Table_X When I try to access the table mysql> select * from Table_x; ERROR 1105 (HY000): Failed to read from the .par file I am…
Supriya
  • 41
  • 6
3
votes
2 answers

MySQL LIKE Query changes in 5.1 to 5.6 to full table scan

For some reason MySQL 5.6 does a full table scan, while MySQL 5.1 doesn't. Why is this happening? EDIT: Both tables have the same exact indices On MySQL 5.1 mysql> explain SELECT `kv`.`key`, `kv`.`value` FROM `kv` WHERE `kv`.`key` LIKE BINARY…
JiminyCricket
  • 7,050
  • 7
  • 42
  • 59
3
votes
2 answers

Where mysql stores the password of users

When we setup a MySQL database system, system automatically create a MySQL databse in which there are multiple tables like db,event,func,host,servers,slow_log,user_info etc. In user_info table I can get the list of users and their details by…
ursitesion
  • 988
  • 2
  • 15
  • 26
1
2 3 4 5 6 7 8