【待反馈】数据库备份20kb

最初安装的时候是可以备份的，后面做了些什么操作忘记了就不行了
网上搜到过一些处理办法，重置密码啥的，试过好多次。

版本是mysql5.6.46

下面贴出宝塔mysql的配置。有根据网上的一些方法修改过。

请问是怎么回事要怎么解决呢？

现在已经是手动执行dump命令去备份了。23333

1. [client]
   
2. #password        = your_password
   
3. port                = 3306
   
4. socket                = /tmp/mysql.sock
   
5. 
   
6. [mysqld]
   
7. log-slave-updates=true
   
8. enforce-gtid-consistency=true
   
9. gtid-mode=on
   
10.         
    
11. binlog_cache_size = 128K
    
12. thread_stack = 256K
    
13. join_buffer_size = 2048K
    
14. query_cache_type = 1
    
15. max_heap_table_size = 512M
    
16. port                = 3306
    
17. socket                = /tmp/mysql.sock
    
18. datadir = /www/server/data
    
19. default_storage_engine = InnoDB
    
20. performance_schema_max_table_instances = 400
    
21. table_definition_cache = 400
    
22. skip-external-locking
    
23. key_buffer_size = 384M
    
24. max_allowed_packet = 100G
    
25. table_open_cache = 384
    
26. sort_buffer_size = 1024K
    
27. net_buffer_length = 4K
    
28. read_buffer_size = 1024K
    
29. read_rnd_buffer_size = 768K
    
30. myisam_sort_buffer_size = 32M
    
31. thread_cache_size = 128
    
32. query_cache_size = 192M
    
33. tmp_table_size = 512M
    
34. sql-mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
    
35. 
    
36. explicit_defaults_for_timestamp = true
    
37. skip-name-resolve
    
38. max_connections = 300
    
39. max_connect_errors = 100
    
40. open_files_limit = 65535
    
41. 
    
42. log-bin=mysql-bin
    
43. binlog_format=mixed
    
44. server-id = 1
    
45. expire_logs_days = 10
    
46. slow_query_log=1
    
47. slow-query-log-file=/www/server/data/mysql-slow.log
    
48. long_query_time=3
    
49. #log_queries_not_using_indexes=on
    
50. 
    
51. 
    
52. ft_min_word_len=1
    
53. innodb_ft_min_token_size=1
    
54. 
    
55. innodb_data_home_dir = /www/server/data
    
56. innodb_data_file_path = ibdata1:10M:autoextend
    
57. innodb_log_group_home_dir = /www/server/data
    
58. innodb_buffer_pool_size = 512M
    
59. innodb_log_file_size = 256M
    
60. innodb_log_buffer_size = 64M
    
61. innodb_flush_log_at_trx_commit = 1
    
62. innodb_lock_wait_timeout = 50
    
63. innodb_max_dirty_pages_pct = 90
    
64. innodb_read_io_threads = 2
    
65. innodb_write_io_threads = 2
    
66. 
    
67. [mysqldump]
    
68. quick
    
69. max_allowed_packet = 500M
    
70. skip-name-resolve
    
71. 
    
72. [mysql]
    
73. no-auto-rehash
    
74. 
    
75. [myisamchk]
    
76. key_buffer_size = 128M
    
77. sort_buffer_size = 2M
    
78. read_buffer = 2M
    
79. write_buffer = 2M
    

复制代码

phpmyadmin 导出 数据 然后 初始化 从新 导入不就行了

您好，可参考该帖子处理，如需要操作，请备份好数据再操作。
或者服务器做个快照

https://www.bt.cn/bbs/forum.php? ... &highlight=1045