I am a CTO with over 5 years of experience in start-up and over 10 years in working at managing position for big companies. I am also a full-stacks developer with over 12 years in system design, product development and technology product deployment. User experience and system security are the things I care about most.
Install Oracle 11g R2 on CentOS
Cài đặt GUI
Đầu tiên cần cài đặt giao diện GUI cho CentOS, làm theo bài hướng dẫn sau: Install Gnome 3 GUI on RHEL, CentOS
Download bộ cài
Download bộ cài Oracle 11g từ trang chủ của Oracle hoặc bằng link Google Drive tại đây:
Backup MySQL database with mysqldump
Option 1: mysqldump an entire mysql instance
Everything written in one file: table structures, indexes, triggers, stored procedures, users, encrypted passwords. Other mysqldump options can also export different styles of INSERT commands, log file and position coordinates from binary logs, database creation options, partial data (–where option), and so forth.
mysqldump -h... -u... -p... --hex-blob --routines --triggers --all-databases | gzip > MySQLData.sql.gz