导出数据表的时候出现如下错误。 急急急!!!
错误信息:
- ( ! ) Fatal error: Cannot 'break' 2 levels in /www/server/phpmyadmin/phpmyadmin_8d806b4299e8f353/export.php on line 864
复制代码
配置文件设置
- [client]
- #password = your_password
- port = 3306
- socket = /tmp/mysql.sock
- [mysqld]
- port = 3306
- socket = /tmp/mysql.sock
- datadir = /www/server/data
- skip-external-locking
- performance_schema_max_table_instances=400
- table_definition_cache=400
- table_open_cache = 512
- key_buffer_size = 128M
- max_allowed_packet = 100G
- table_open_cache = 512
- sort_buffer_size = 2M
- net_buffer_length = 8K
- read_buffer_size = 2M
- read_rnd_buffer_size = 256K
- myisam_sort_buffer_size = 32M
- thread_cache_size = 64
- query_cache_size = 64M
- tmp_table_size = 64M
- explicit_defaults_for_timestamp = true
- #skip-networking
- #skip-name-resolve
- max_connections = 500
- max_connect_errors = 100
- open_files_limit = 65535
- sql-mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
- log-bin=mysql-bin
- binlog_format=mixed
- server-id = 1
- expire_logs_days = 10
- #loose-innodb-trx=0
- #loose-innodb-locks=0
- #loose-innodb-lock-waits=0
- #loose-innodb-cmp=0
- #loose-innodb-cmp-per-index=0
- #loose-innodb-cmp-per-index-reset=0
- #loose-innodb-cmp-reset=0
- #loose-innodb-cmpmem=0
- #loose-innodb-cmpmem-reset=0
- #loose-innodb-buffer-page=0
- #loose-innodb-buffer-page-lru=0
- #loose-innodb-buffer-pool-stats=0
- #loose-innodb-metrics=0
- #loose-innodb-ft-default-stopword=0
- #loose-innodb-ft-inserted=0
- #loose-innodb-ft-deleted=0
- #loose-innodb-ft-being-deleted=0
- #loose-innodb-ft-config=0
- #loose-innodb-ft-index-cache=0
- #loose-innodb-ft-index-table=0
- #loose-innodb-sys-tables=0
- #loose-innodb-sys-tablestats=0
- #loose-innodb-sys-indexes=0
- #loose-innodb-sys-columns=0
- #loose-innodb-sys-fields=0
- #loose-innodb-sys-foreign=0
- #loose-innodb-sys-foreign-cols=0
- default_storage_engine = InnoDB
- innodb_data_home_dir = /www/server/data
- innodb_data_file_path = ibdata1:10M:autoextend
- innodb_log_group_home_dir = /www/server/data
- innodb_buffer_pool_size = 512M
- innodb_log_file_size = 128M
- innodb_log_buffer_size = 8M
- innodb_flush_log_at_trx_commit = 1
- innodb_lock_wait_timeout = 50
- [mysqldump]
- quick
- max_allowed_packet = 16M
- [mysql]
- no-auto-rehash
- [myisamchk]
- key_buffer_size = 128M
- sort_buffer_size = 2M
- read_buffer = 2M
- write_buffer = 2M
- [mysqlhotcopy]
- interactive-timeout
复制代码 数据库版本:MYSQL 5.1
|
|