Discover and enjoy a wide range of IT solutions designed to make your digital experience smoother, faster, and more efficient. From software tips to troubleshooting guides, find everything you need in a place. Stay updated, stay secure, and enhance your tech skills with reliable, user-friendly information and resources.
Sunday, November 4, 2012
Friday, October 26, 2012
1 bit equals to how many bytes?
1 byte = 8 bits = 23 bits
1 Kilobyte = 1024 bytes = 210 bits
1 Megabyte = 1024 kilobytes = 220 bits
1 Gegabyte = 1024 megabytes = 230 bits
1 Kilobyte = 1024 bytes = 210 bits
1 Megabyte = 1024 kilobytes = 220 bits
1 Gegabyte = 1024 megabytes = 230 bits
Friday, October 5, 2012
“Got a packet bigger than ‘max_allowed_packet’ bytes” MySQL error
Also, change the my.cnf or my.ini file under the mysqld section and set max_allowed_packet=100M or you could run these commands in a MySQL console connected to that same server:
# mysql -u admin -p
mysql> set global net_buffer_length=1000000;
Query OK, 0 rows affected (0.00 sec)
mysql> set global max_allowed_packet=1000000000;
Query OK, 0 rows affected (0.00 sec)MSQL Restoring a Table table script
MSQL Restoring a Table table script
To restore your table, you’d run:
$ mysql -u user -ppassword mydb < /tmp/extracted_table.sql
Voila! – you’re back in business.MYSQL GRANT ALL PRIVILEGES
MYSQL GRANT ALL PRIVILEGES
GRANT ALL PRIVILEGES ON dbname.* TO 'user'@'localhost' IDENTIFIED BY 'password';
Wednesday, October 3, 2012
Tuesday, October 2, 2012
CodeIgniter echo sql statment
CodeIgniter echo sql statment
echo $this->model_name->connectionname->last_query();
echo $this->model_name->connectionname->last_query();
Subscribe to:
Posts (Atom)