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

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


2d
revised Auto-increment ids with multiple inserts in mysql/mariadb
how many "rows" (not columns) was (afaik) the intended meaning
2d
comment MySQL Code Works in PHPMyAdmin but not in PHP Page
@Justin, welcome to DBA.SE... Stop, and research SQL injection vulnerabilities. You should never concatenate your variables into queries like this. There are massive potential security holes waiting for you. Even if the values come from a safe place now, that's not a good reason to build queries this way. xkcd.com/327
2d
comment Can I use mysql/mariadb databases on different OS?
+1, I agree that dump and reload is always the safest approach, but was primarily curious whether there was a specific or definitive reference we could cite, since the docs are unfortunately vague: "Like MyISAM data files, InnoDB data and log files are binary-compatible on all platforms having the same floating-point number format. If the floating-point formats differ but you have not used FLOAT or DOUBLE data types in your tables, then the procedure is the same: simply copy the relevant files." I've done binary data migrations from Solaris to Linux, but both were 64-bit.
Jul
22
comment Can I use mysql/mariadb databases on different OS?
What is your source for the statement that migrating between 32-bit and 64-bit systems requires a dump and reload?
Jul
22
comment MySQL getting killed by AppArmor
How about /var/log/syslog? (/var/log/messages?) Anything in the mysql error log about "number of processes running now 0"?
Jul
22
comment mysqldump --single-transaction, yet update queries are waiting for the backup
What is your full command line for mysqldump? In particular, are you using --flush-logs or --master-data...? There are potential interactions among the options.
Jul
19
reviewed Close How to manage “up to date” data and data “in use”
Jul
19
reviewed Close Pgpooladmin pcp commands does not work
Jul
19
reviewed Close How to add attachment from email to Sharepoint database
Jul
19
reviewed Leave Open Amazon RDS, RedShift and Data Warehousing
Jul
19
reviewed Close Best way to set up a Master Master Replication when one goes offline (Multi Writer)
Jul
19
reviewed Close Compare between MYSQL cluster and MYSQL server
Jul
19
reviewed Leave Closed “Replicate” Table structures with sp_addscriptexec
Jul
19
reviewed Leave Closed Microsoft SQL Server 2008 error 29
Jul
19
reviewed Close Database Design to administer customer-specific Network Information
Jul
19
reviewed Close Commenting in Greenplum gpload YML script
Jul
19
reviewed Close single table or different tables
Jul
19
reviewed Close about email trigger in mysql server
Jul
19
reviewed Close how to change purchase order from pending status to recieved status in erp
Jul
19
reviewed Close Master data vs reference data + FK?