Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 16
Impact
~16k people reached

  • 0 posts edited
  • 0 helpful flags
  • 23 votes cast
Apr
13
awarded  Popular Question
Feb
22
awarded  Popular Question
Feb
2
accepted Change webserver with minimal downtime
Feb
2
comment Change webserver with minimal downtime
Thanks Michael, After asking about replication, I did a little research and found it. Very nice answer!
Feb
2
comment Change webserver with minimal downtime
Zero downtime is good! I've never done database replication. Is this available with MySQL community edition (EDIT. Looks like it is: dev.mysql.com/doc/refman/5.0/en/replication.html)? Could you give me some key words to google regarding the /etc/hosts trick? Thank you
Feb
2
asked Change webserver with minimal downtime
Jan
10
comment Configure MySQL so it doesn't automatically change values in NOT NULL columns
Hello downvoter. I am not asking how to perform a query, but asking how to configure a MySQL server so it enforces these constraints. Why the downvote?
Jan
10
comment Configure MySQL so it doesn't automatically change values in NOT NULL columns
I had STRICT_TRANS_TABLES, not STRICT_ALL_TABLES in my.cnf. And no, I don't believe I am starting as mysqld_safe, but need to read up on it.
Jan
10
accepted Configure MySQL so it doesn't automatically change values in NOT NULL columns
Jan
10
answered Configure MySQL so it doesn't automatically change values in NOT NULL columns
Jan
10
comment Configure MySQL so it doesn't automatically change values in NOT NULL columns
Thanks Mike. Yes, I recently came across dev.mysql.com/doc/refman/5.6/en/…, and found that I need to use STRICT_ALL_TABLES if I wish to throw an error.
Jan
10
revised Configure MySQL so it doesn't automatically change values in NOT NULL columns
edited title
Jan
10
asked Configure MySQL so it doesn't automatically change values in NOT NULL columns
Dec
23
accepted Cause of error: Invalid (old?) table or database name 'lost+found'
Dec
23
asked Cause of error: Invalid (old?) table or database name 'lost+found'
Dec
16
accepted Automatic archiving of log files
Dec
16
comment Automatic archiving of log files
@JennyD. Thank you. I think this is exactly what I was looking for.
Dec
16
asked Automatic archiving of log files
Dec
13
awarded  Popular Question
Jul
30
awarded  Popular Question