Mysql: Difference between revisions

From Server STB
Jump to navigation Jump to search
No edit summary
No edit summary
Line 3: Line 3:
  mysql -u username -p database_name < file.sql
  mysql -u username -p database_name < file.sql


<h3>Error</h3>
<h3>Mengatasi Error</h3>
Mengatasi Error hostname blocked too many error flush-host
Mengatasi Error hostname blocked too many error flush-host
  SET GLOBAL max_connect_errors = 10000000000;
  SET GLOBAL max_connect_errors = 10000000000;
atau
atau
  mysqladmin -p flush-hosts
  mysqladmin -p flush-hosts

Revision as of 05:29, 4 March 2024

Import

mysql -u username -p database_name < file.sql

Mengatasi Error

Mengatasi Error hostname blocked too many error flush-host

SET GLOBAL max_connect_errors = 10000000000;

atau

mysqladmin -p flush-hosts