mysql
LearnoMate Technologies > mysql
Import all tables from MySql database to HDFS
06
Jun
In this blog, I will show you the way to import all tables from MySql database. STEP 1. First connect to MySQL database and check the no of tables. cloudera@cloudera-vm:~$ mysql -uroot -ptiger Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 64 Server version: 5.1.61-0ubuntu0.10.10.1 (Ubuntu) Copyright […]
Exclude parameter in SQOOP to exclude import tables
05
Jun
STEP 1. Check the no of tables in mysql database. mysql> show tables; +—————-+ | Tables_in_test | +—————-+ | company | | student | | transactions | +—————-+ 3 rows in set (0.00 sec) 3 rows in set (0.00 sec) STEP 2. Use import-all-tables command to import all tables from test database excluding company table. […]