Mysql on windows and wamp backup and restore

03/09/2013 [D_A] Varia, 0

This will create your database “mydb” and restore db_backup.sql from folder: C:\wamp\bin\mysql\mysql5.5.24\bin\

C:\wamp\bin\mysql\mysql5.5.24\bin> mysql -u root -p --default-character-set=utf8

mysql> create database mydb;
mysql> use mydb;
mysql> source db_backup.sql;

grep ja logid IP block from MySQL via iptables