Category: MySQL

mysqldump: Got packet bigger than ‘max_allowed_packet’ bytes

Naveen Nayak October 27, 2010 No Comments MySQL

If you get this error then you need to change the max_allowed_packet size in my.cnf  in the [mysqldump] section [mysqldump] max_allowed_packet = 500M The maximum size as of Mysql 5.1 is 1024 MB http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_max_allowed_packet This works fine if you are on the localhost and are using mysqldump from the local host However, if you are trying […]

Installing phpMyAdmin on Ubuntu

Naveen Nayak May 4, 2010 No Comments MySQL

Ubuntu version: 10.4 This is on a localhost 1. Open a terminal and type the command (supply the root password) sudo apt-get install phpmyadmin 2. Open a web browser and use the below address to access phpmyAdmin http://localhost/phpmyadmin If you have a dedicated server where you MySQL database has been set up then in the […]

Logging in MySQL

Naveen Nayak December 21, 2009 No Comments MySQL

References : – MySQL Reference Manual Logging in MySql Latest version of MysQL allows logging into both files and tables. Though Table logging is more advanced and desirable(we can use queries to select a particular client or timestamps to see what happened via SQL statements) , it has heavy performance requirements when compared to file […]

Page 2 of 2