Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [mysql-5.0]

MySQL version 5.0 - please also tag with mysql for search purposes.

MySQL 5.0 was the first major release of MySQL 5.0 with the following features

  • Stored Procedures
  • Triggers
  • Views
  • INFORMATION_SCHEMA database
46 questions
285
votes
18 answers

How can I monitor the progress of an import of a large .sql file?

I am importing a 7 GB foobar.sql to restore a table in a local database. $ mysql -h localhost -u root 'my_data' < foobar.sql $ mysql --version /usr/local/mysql/bin/mysql Ver 14.12 Distrib 5.0.96, for apple-darwin9.8.0 (i386) using readline…
qazwsx
  • 3,327
  • 9
  • 21
  • 21
23
votes
6 answers

DELETE command not completing on 30,000,000 row table

I have inherited a database and am looking to clean and speed it up. I have a table that contains 30,000,000 rows, many of which are junk data inserted due to an error on behalf of our programmer. Before I add any new, more optimized indexes, I…
bafromca
  • 541
  • 1
  • 3
  • 9
18
votes
2 answers

What can we do in MySQL 5.0 Replication to address bandwidth concerns?

I am developing an application to run on the client PC (Win) which is configured with a MySQL server 5.1 instance that will act as read-only slave to the remote master. The remote master has dozens of schemas, but I only need one per client so I…
Abram
  • 283
  • 2
  • 6
13
votes
5 answers

How to find dependencies on a table in mysql 5.0?

I am trying to drop a table in MySQL but its complaining about "Cannot delete or update a parent row: a foreign key constraint fails"... Questions Is there a way to find out all the table dependencies and objects dependent on it? For Sybase,…
user325643
  • 131
  • 1
  • 2
  • 4
6
votes
2 answers

Query runs a long time in some newer MySQL versions

I have created a database on MySQL 5.0.15. I have a query and when I run this query on this MySQL version, I get 0.9 s run time. When I import this database to another MySQL server with same hardware and run the same query I get over 120s and…
user3731
  • 205
  • 2
  • 5
6
votes
1 answer

MySQL upgrade 5.0.88 to the latest version

I have some questions regarding upgrading from 5.0.88 to the latest version. Why should I upgrade? If so, which version should I consider? What are all the known risks? Is upgrading step by step suggested? Or is binary replacement suggested?
Devi Govindasamy
  • 61
  • 1
  • 2
6
votes
1 answer

Replicate MySQL 5.0 Master to 5.5 Slave?

We're planning out a series of server/software upgrades and were curious. We have a RHEL5 install running MySQL 5.0 that we'd like to replicate to a new (virtualized) server running CentOS 6 and MySQL 5.5. Then, in the future, we would bump the…
xref
  • 739
  • 2
  • 8
  • 16
5
votes
1 answer

"TRUNCATE doesn't run ON DELETE trigger" true or false

I was searching on the topic of why TRUNCATE is placed in DDL instead of DML for which I found following answer here Why is truncate DDL? I this answer I found a sentence as given below "The fact that TRUNCATE doesn't run ON DELETE triggers also…
geeksal
  • 151
  • 1
  • 9
4
votes
1 answer

Allocating 8GB memory to MySQL on a 64bit system

Specs - MySQL 5.0.x , Redhat 5.9 , Physical memory - 16GB I am trying to set innodb buffer pool size to 8GB (innodb_buffer_pool_size=8G). When i do, and start mysql, i get following error - InnoDB: Error: cannot allocate 8589950976 bytes…
Quest Monger
  • 171
  • 1
  • 7
4
votes
2 answers

Replication from MySQL 5.0 to MariaDB 10.2.8 - Unknown system variable 'binlog_checksum', Internal MariaDB error code: 1193

We are finally upgrading our MySQL 5.0.90 environment to MariaDB, and we would like to enable replication from MySQL 5.0 to MariaDB 10.2.8 and then cutover thus providing minimal downtime. I tried this originally with MariaDB 10.1.18 and it worked…
MIke Tutor
  • 81
  • 1
  • 4
3
votes
2 answers

How do I fix the definer problem The user specified as a definer ('fred'@'192.168.0.%') does not exist

I dumped an existing database from my web site into a new MySQL setup on my laptop. Everything works except pages that use a view, when the error message above appears. There is only one view on the system. I assumed that this was caused because the…
user20200
  • 39
  • 1
  • 1
  • 3
3
votes
2 answers

MySQL - Unix timestamp from columns with hour, day, month

I have MySQL table with columns (day, month, hour). Is it possible to build unix timestamp from this within the query itself? I am looking for something like this: SELECT unix(2016, a.month, a.day, a.hour, 00, 00) as d FROM a WHERE d > 456456 AND d…
Martin Perry
  • 231
  • 4
  • 11
2
votes
1 answer

Moving MySQL Cold Backup to Another DB Server

I am new to MySQL and want to know the info whether taking a cold backup from source and copying it onto new server with same version require any additional configurations settings to be changed. As I have gone through few of the tutorials, none of…
Nandan
  • 21
  • 1
  • 2
2
votes
1 answer

Load different date formats in mysql

I have a date field in my datafile which I am trying to load in MySQL, but the date field is in dd-mon-yy format and MySQL only understands YYYY-MM-DD. Is there a way by which I can load DD-MON-YY data into YYYY-MM-DD format using MySQL LOAD or any…
Hitesh Chouhan
  • 497
  • 5
  • 12
  • 22
2
votes
1 answer

Can't create/write to file MySQL

Server Configuration: MySQL 5.051a-community-nt-log Community Edition installed on Windows Server 2003 Standard Edition SP1. This MySQL Server is part of a client's WAMP installation Problem: MySQL was originally using the C:\WINDOWS\TEMP directory…
Craig Efrein
  • 9,560
  • 12
  • 54
  • 94
1
2 3 4