O'Reilly Answers

Topics: mysql

mysql Feed    mysql Open Questions Feed    mysql Email    Open Questions via Email

Please sign in or register to post.

Please sign in or register to post.

• MySQL Replication Troubleshooting Best Practices

  

  By Chuck Bell : Yesterday, 04:54 PM

  MySQL replication is a very stable feature but like any computing solution things can go wrong. Sometimes the problems are not manifested with descriptive error messages (are they ever?) and sometimes...

  Tags:

  • mysql
  • replication
  • best practices
  • troubleshooting

  0Votes

  0Comments

  ---

• How to insert my storage engine into mysql of 5.5.2-m2 ?

  Asked by lieyia : 28 May 2010 - 12:17 AM

  Tags:

  • mysql

  0Answers

  0Comments

  ---

• Why MySQL is Finnish

  

  By filmbilly : 22 April 2010 - 05:03 PM

  O'Reilly editor Andy Oram and I interviewed a number of MySQL attendees last week at the O'Reilly MySQL Conference in Santa Clara, California. After our fourth or fifth interview I was struck by the f...

  Tags:

  • Oracle
  • Sun Microsystems
  • MySQL
  • MariaDB
  • Monty Program Ab
  • open database alliance
  • Michael Widenius
  • Cloud Computing

  1Vote

  0Comments

  ---

• Getting the most out of MySQL in the Amazon Cloud

  

  By Chuck Bell : 13 April 2010 - 04:29 PM

  Best Practices for Using MySQL in EC2 Using MySQL in the Amazon cloud is only slightly different from using MySQL on your own hardware. If you use an AMI with MySQL installed and configured, you can ...

  Tags:

  • MySQL Users Conference
  • Cloud
  • Amazon
  • MySQL
  • High Availability

  1Vote

  0Comments

  ---

• How to Write Accurate SQL Code: A video sample of Chris Date's new course

  

  By filmbilly : 12 April 2010 - 05:36 PM

  I was honored to work with Chris Date to bring his legendary relational theory class to video and the web. During the making of this video Date shared a number of stories about his collaborations wit...

  Tags:

  • tuples
  • relvars
  • database design
  • relational model
  • oracle
  • mysql
  • sql
  • base tables
  • nulls

  3Votes

  0Comments

  ---

• Begining mySQL for every day work and linking in and out of MS Excel

  Asked by komMWM : 11 March 2010 - 07:40 AM

  

  Answered by KBenson : Mar 17 2010 11:30 AM
  (Skip to the bottom if you are ONLY interesting in the MySQL portion of the question) There's a few basic questions that need to be answered before you can really decide where to start. These ar... full answer >

  Tags:

  • mysql
  • excel
  • web

  1Answer

  0Comments

  ---

• Help to use out parameter of store procedure of mysql in hibernate

  Asked by harrymash : 27 February 2010 - 05:22 AM

  Tags:

  • hibernate
  • mysql

  0Answers

  0Comments

  ---

• login system using roles from a MYSQL database error

  Asked by seaturtleftw : 22 January 2010 - 02:20 AM

  

  Answered by odewahn1 : Jan 25 2010 04:41 AM
  Without seeing the code in detail, it's hard to say anything in particular. But, this looks straightforward enough that it's probably some small mismatch somewhere or the other. Have you con... full answer >

  Tags:

  • login system
  • roles
  • mysql

  1Answer

  2Comments

  ---

• How do I write a CRON job to backup a mySQL Database?

  Asked by todisht : 18 January 2010 - 07:17 AM

  

  Answered by todisht : Jan 19 2010 06:45 PM
  I figured it out: mysqldump -u [your_username] -p[your_password] [your_database] | gzip > [your_path/filename].gz If you want to make the filename unique you can add the date to it like this: my... full answer >

  Tags:

  • web
  • mysql
  • cron
  • php

  1Answer

  0Comments

  ---

• MySQL Server Error 1045

  Asked by SQLBoy : 28 December 2009 - 08:05 PM

  

  Answered by Chuck Bell : Feb 26 2010 06:50 AM
  Hello, The message is typical of a situation where a user attempts to login without a password when a password has been set by the administrator. If you had a previous installation and assigned a pa... full answer >

  Tags:

  • mysql

  1Answer

  0Comments

  ---