MySQL Import data method and error resolution

Mysql-u root-p DatabaseName < Db.sql

When the database imports data, MySQL receives the following exception: ERROR 1153 (08s01): Got a packet bigger than ' Max_allowed_packet ' bytes.

This is because the default configuration of MySQL is not adjusted, the default maximum processing only 16M files, and I want to import the forged data has a 50M of SQL.

Then adjust the configuration file:/etc/my.cnf

Modify the maximum allowable packet size for MySQL
Add a sentence in the [Mysqld] section (not in this section):
max_allowed_packet=50m
Restarting the MySQL service is possible.

The restart command is as follows:

First, the starting mode
1. Start with service: Service mysqld start
2. Start with mysqld script:/etc/inint.d/mysqld start
3. Use Safe_mysqld to start:safe_mysqld&
Second, stop
1. Start with service: Service mysqld stop
2. Start with mysqld script:/etc/inint.d/mysqld stop
3, mysqladmin shutdown
Third, restart
1. Start with service: Service mysqld restart
2. Start with mysqld script:/etc/inint.d/mysqld restart

MySQL Import data method and error resolution