8,051 reputation
1822
bio website
location Cincinnati, OH
age 43
visits member for 1 year, 7 months
seen 21 hours ago

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


Mar
14
reviewed Close SQL statement slower on as400 console than from remote odbc
Mar
14
reviewed Close SQL Server 2008 R2: cannot attach database
Mar
14
reviewed Close DMV queries for capturing most frequently used queries and worst performing queries
Mar
14
reviewed Close Want to show last month highest scorer details grouped by week
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 Transactional Replication-Creating New Publication (for 800GB SQL Server 2008 DB) taking too long
Mar
12
reviewed Close Clever repeatable benchmarking and bottleneck detection test bench - PostgreSQL
Mar
12
reviewed Close Unable to connect to pgbouncer admin console
Mar
12
reviewed Close Should I consolidate my SQL instances?
Mar
12
reviewed Close Concatenating multiple rows in one query
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 Sync MySQL database to central server