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 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