8:00 – 4:00 SR

• Normal backups
• I tried making a full backup of the system using the following arguments:
  • mysqldump – u root -pxxxx –all-databases –max_allowed_packet=512M –routines > fullbackup.sql
• That appeared to work fine, creating a file 148,338KB big
• I tried to ingest the file in the new instance on the integration machine using:
  • mysql -u root -pxxxx < fullbackup.sql
• That gave the following error:
  • ERROR 2006 (HY000) at line 4729: MySQL server has gone away
• Line 4729 turns out to be “INSERT INTO `query_logs` VALUES(…), which is *huge*. Not sure what to do about that. I did check to see that the line isn’t truncated, so that’s not the problem. Just to make sure, I ran it again with the same message at the same line
• This post at stackOverflow suggests that it’s a max_packet_size problem. Going to try that. Changed from 1M to 12M as per the suggestion.
• Same error, but new line (6367). Going to try 24M
• Same error, but new line (6373). Going to try 512M, same as the mysqldump command..?
• Yay! That did it.
• Finished generating C/C++ and Flex svn statisitics. Interestingly, in the “lines committed” charts, you can see the difference between mature development and ongoing development:
• 

  Mature profile of server codebase

   

• 

  Ongoing rapid development of GUI

   

• Ok, back to unit tests.