Mysql Export/Import

Bir tabloyu export ve import etmek icin.

export

[root@localhost ertugrula]# mysqldump logdb logs -u logger -p > log.txt

import

[root@localhost ertugrula]# mysql -u logger -p  logdb < log.txt

#HY000Host 'XXX' is not allowed to connect to this MySQL server

mysql> grant all privileges on *.* to logger@192.168.10.14 identified by 'logger';

Mysql create user

mysql> CREATE USER 'username'@'localhost' IDENTIFIED BY 'pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost'
    ->     WITH GRANT OPTION;