8,530 reputation
1923
bio website
location Cincinnati, OH
age 43
visits member for 1 year, 10 months
seen 14 hours ago

If you question or otherwise fail to recognize the superiority of the relational model... you're doing it wrong.


Mar
14
reviewed Leave Open CentOS and Ubuntu differences with information_schema
Mar
14
comment CentOS and Ubuntu differences with information_schema
Yes, if you declare them in a way that the documentation specifically says will not work, then, strangely enough, it's not going to work: MySQL does not recognize or support “inline REFERENCES specifications” (as defined in the SQL standard) where the references are defined as part of the column specification. MySQL accepts REFERENCES clauses only when specified as part of a separate FOREIGN KEY specification. dev.mysql.com/doc/refman/5.6/en/create-table.html
Mar
14
comment MySQL backup breakes a table every time
That's a good catch. No matter where this script is run, it is dangerous and wrong and something will be deleted unexpectedly... but it seems like the /var/backup/mysql directory is still there, and that command, as shown, should remove it, no? Still, +1... at any rate, a backup simply would not remove a MyISAM tablespace in any circumstance I can think of, and I'd also note that the exit status of mysqldump is not being checked as it should be.
Mar
12
comment CentOS and Ubuntu differences with information_schema
SHOW CREATE TABLE will give you more useful information than DESCRIBE TABLE. I think @a_horse_with_no_name is onto something, there... It sounds a bit like one table might show ENGINE=InnoDB and the other ENGINE=MyISAM... If SELECT @@default_storage_engine; returns different values on the two machines, and the setup scripts aren't explicit in their table declarations, that could be the explanation.
Mar
12
comment Implementing older version of mySQL on RH9
@ypercube on reflection, I think you are probably right. I may have misread "built" as "build" as though it were advice on what not do to, rather than what he hasn't personally tried.
Mar
12
reviewed Close Bloating effect in Postgresql
Mar
12
reviewed Close SQL string field lengths in a db having about 6 different types of addresses, with about 20 markets and environments
Mar
12
reviewed Leave Open whats the fastest way to copy data from table to new one?
Mar
12
reviewed Close Clever repeatable benchmarking and bottleneck detection test bench - PostgreSQL
Mar
12
reviewed Close Should I consolidate my SQL instances?
Mar
12
reviewed Close How to Recover truncate table in mysql
Mar
11
reviewed Close Fetching Recently added rows from table
Mar
11
reviewed Leave Open select all rows with a minimum value
Mar
11
reviewed Approve suggested edit on How do I best measure the query performance?
Mar
11
comment Install/bootstrap mysql without name-based users
What value does /usr/local/mysql/bin/resolveip `hostname` | awk '/ /{print $6}' return when run on your system?
Mar
11
comment What tool do I use to administer MySql?
I voted down because the question was "Which tool provided by MySQL," which I interpreted as "Which tool provided by Oracle," and this answer does not answer that question. If the question had, instead, been "What is a good tool for administering MySQL" then we would need to close the question as off-topic, primarily opinion based, or off-topic, shopping list question. MySQL Server is great ( MariaDB and Percona Server, too) but I personally think MySQL Workbench is a horrible, unstable, ill-conceived piece of dreadful ugly bloatware that Oracle should be ashamed of and nobody should use.
Mar
11
reviewed Leave Open Ms Access SQL problem
Mar
11
reviewed Leave Open ORACLE Shifting from from one version to another
Mar
11
comment MySQL 5.5 to 5.6 Upgrade. Will data remain the same?
True, except for the system tables, where there are structural changes, but there should be no data loss. Also, read the upgrade guide and all of the release notes for every release of MySQL 5.6 to verify that there are no incompatible changes that may cause issues if your application is relying on some behaviors of older versions that could have changed.
Mar
11
answered What tool do I use to administer MySql?