recentpopularlog in

therobyouknow : sql   62

A Drupal 7 SQL cheat sheet (examples) | Drupal 7 SQL function examples |
looks good

my book at amazon
android (45)
best practices (63)
career (50)
cvs (27)
design (33)
drupal (91)
eclipse (6)
funny (3)
gadgets (108)
git (15)
intellij (4)
java (429)
jdbc (26)
swing (74)
jsp (9)
latex (26)
linux/unix (289)
mac os x (315)
mysql (54)
ooa/ood (11)
perl (156)
php (97)
postgresql (17)
ruby (56)
scala (336)
sencha (23)
servlets (10)
svn (6)
technology (84)
testing (13)
uml (24)
drupal7  sql  database  computing  dev  cms  drupal  db_query  db_select  cheatsheet  example 
november 2015 by therobyouknow
Designing Effective Database Systems: Rebecca M. Riordan: Books
Paperback: 384 pagesPublisher: Addison Wesley; 1 edition (10 Jan 2005)Language EnglishISBN-10: 0321290933ISBN-13: 978-0321290939
book  isad  syan  systemanalysis  analysis  system  database  db  design  normalisation  normalization  relational  computing  howto  university  portsmouthuniversity  portsmouth  degree  course  1styear  year1  firstyear  first  year  study  sql 
april 2011 by therobyouknow
how to change Mysql packet size? - Server Fault
On linux, well CentOS at least, you would edit /etc/my.cnf and add the same text as randy melder says.

You would then need to restart the MySQL server (mysqld) as otherwise it won't know about your change since it only reads it when it starts up.

To restart mysqld: /etc/init.d/mysqld restart

Why would you want to increase your packet size? If you want to import a large file: mysql -u username -p -h localhost databasename < data.sql

With that default setting you might not be able to do the import and you would therefore be presented with the error message: "ERROR 1153 (08S01) at line 53: Got a packet bigger than 'max_allowed_packet' bytes".

So setting max_allowed_packet as described in the answer above can cure that problem, provided your setting is larger than the file you want to import.
mysql  packet  size  change  import  mysqldump  enable  large  error  solution  my.cnf  mysqld  restart  re-read  howto  max_allowed_packet  computing  setting  configuration  dos  denial  service  file  sql  plaintext  export 
july 2010 by therobyouknow
Yet another blog: How to install MySql in CentOS 5.3 from shell or webmin
Cure for error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'. This works for setting up mysql properly on CentOS
linux  mysql  php  centos  solution  error  connect  server  sock  socket  problem  solved  howto  computing  database  sql  setup  configuration  command  tip  install  re-install  remove  upgrade  update  computer 
july 2010 by therobyouknow
MYSQL Server has gone away query |
Disable Update Status Module advice here worked for me.
drupal  fix  mysql  query  sql  troubleshooting 
march 2010 by therobyouknow

Copy this bookmark:

to read