[root@cent65 percona-56]# service mysql start
Starting MySQL (Percona Server).[ OK ]
[root@cent65 percona-56]# netstat -an|grep :3306
tcp 0 0 :::3306 :::* LISTEN
2、导入用户权限表
[root@cent65 percona-56]# mysql -u root -p </home/mysql/grants.sql
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@cent65 percona-56]# mysqladmin -u root password "oracle"
Warning: Using a password on the command line interface can be insecure.
[root@cent65 percona-56]# mysql -u root -p </home/mysql/grants.sql
Enter password:
3、导入备份数据
[root@cent65 percona-56]# mysql -uroot -p -e "SET GLOBAL max_allowed_packet=1024*1024*1024"
Enter password:
[root@cent65 percona-56]# mysql -uroot -p --max-allowed-packet=1G < /home/mysql/full-data-dump.sql
Enter password:
[root@cent65 percona-56]#