변군이글루

mysqlshow 명령어 - display database, table, and column information $ mysqlshow [options] [db_name [tbl_name [col_name]]] database 출력 $ mysqlshow -u root -p Enter password: +--------------------+ | Databases | +--------------------+ | information_schema | | mysql | | performance_schema | | racktables_db | | sys | | zabbix_db | +--------------------+ mysql(database)의 table 출력 $ mysqlshow -u root -p m..

mysql(mariadb) 백업 및 복원 mysql(mariadb) 백업 mysqldump -u user -p[user_password] [database_name] > dump.sql mysqldump -hmyinstance1.123456789012.us-east-1.rds.amazonaws.com -udbadmin -p'Gc6Jdj39n9GUnsCdLFvo==' test_db > dump.sql mysql(mariadb) 복원 mysql -u user -p[user_password] [database_name]

MariaDB 소스 설치 필수 라이브러리 yum install -y ncurses-devel cmake libevent tar xvfz mariadb-10.0.20.tar.gz cd mariadb-10.0.20 groupadd -g 27 mysql useradd -m -c "MariaDB Server" -d /app/mariadb -s /bin/false -u 27 -g 27 mysql cmake \ -DCMAKE_INSTALL_PREFIX=/app/mariadb \ -DMYSQL_DATADIR=/app/mariadb/data \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_ARCHIVE_STORAGE_ENGINE=1 \ -DWITH_BLACKHOLE_STORAGE_ENGI..

MariaDB YUM Repository # vi /etc/yum.repos.d/MariaDB.repo [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.0/centos6-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1 # yum clean all # yum install MariaDB-client MariaDB-server 원본 URL : https://mariadb.com/kb/en/mariadb/yum/