oracle与mysql的导入导出

oracle

  • 创建用户和表空间
    1. -- 有限制大小的
    2. CREATE TABLESPACE fda_code
    3. DATAFILE 'fda_code.dat' SIZE 10M REUSE
    4. AUTOEXTEND ON NEXT 10M MAXSIZE 2G;
    5. -- 创建用户
    6. CREATE USER fda_user IDENTIFIED BY fda_user DEFAULT TABLESPACE fda_code;
    7. GRANT CONNECT, RESOURCE, DBA TO fda_user;
  • 数据导入导出
  1. expdp smps/smps  directory=DATA_PUMP_DIR dumpfile=earth.dmp logfile=earth.log
  3. # 注意表空间之类的
  4. impdp earth/earth@47.107.171.54/orclpdb DIRECTORY=DATA_PUMP_DIR DUMPFILE=earth.dmp  logfile=earth.log   remap_tablespace=smps:earth remap_schema=smps:earth schemas=smps table_exists_action=replace transform=segment_attributes:n

MySQL

MariaDB is an open source relational database management system, backward compatible, binary drop-in replacement of MySQL

MariaDB 用的最为方便

  1. yum install mariadb-server
  2. #start the MariaDB service and enable it to start
  3. systemctl start mariadb
  4. systemctl enable mariadb
  5. #Run the mysql_secure_installation script
  6.  mysql_secure_installation

对外放开权限

  1. GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'  IDENTIFIED BY '123456' WITH GRANT OPTION;

建立数据库

  • 导出数据库
  1. mysqldump -h localhost -u root -p  station > /tmp/station.sql

  • 建立数据库

    1. CREATE DATABASE station CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

  • 导入数据库

    1. mysql -u root -p
    2. mysql -u root -p station < station.sql

    数据库目录 the data directory location is controlled by the datadir variable. Look at your /etc/mysql/my.cnf file to see where your installation of MariaDB is configured to store data. The default is /var/lib/mysql but it is often changed,