A data sheet was accidentally introduced to the MySQL database today, but the file was found to be 2.9M and the import failed.
Take a look at the returned error because the file exceeds the size limit of 2M, depressed.
Find a "Jailbreak" method, need to modify the configuration of php.ini and phpMyAdmin, retrace, the results found that Linux can not find
The configuration file described in the article, angry AH.
Suddenly think of this limitation may be caused by phpmyadmin, not MySQL is not allowed to upload or import ah. Open the terminal command line directly:
[Email protected] ~/Desktop $ mysql-h localhost-u root-p
Enter Password:
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 228
Server version:5.5.34-0ubuntu0.12.10.1 (Ubuntu)
Copyright (c) and/or, Oracle, its affiliates. All rights reserved.
Successfully logged in.
mysql> use isuzu_database;
Reading table information for completion of table and column names
Can turn off this feature to get a quicker startup with-a
Database changed
mysql> source ~/Download/t_product_store.sql;
...
Query OK, 279 rows Affected (0.00 sec)
records:279 duplicates:0 warnings:0
Query OK, 188 rows Affected (0.01 sec)
records:188 duplicates:0 warnings:0
Query OK, 0 rows Affected (0.00 sec)
Query OK, 0 rows Affected (0.00 sec)
Query OK, 0 rows Affected (0.00 sec)
Success!
Sometimes there's an unexpected surprise in a different angle,:P
phpMyAdmin Upload File size limit