1 bit equals to how many bytes?

1 byte = 8 bits = 2³ bits
1 Kilobyte = 1024 bytes = 2¹⁰ bits
1 Megabyte = 1024 kilobytes = 2²⁰ bits
1 Gegabyte = 1024 megabytes = 2³⁰ bits

“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';

Check Network IP location

Check Network IP location
http://network-tools.com

CodeIgniter echo sql statment

CodeIgniter echo sql statment

echo $this->model_name->connectionname->last_query();