Posts

Showing posts with the label cloudera

Useful HDFS commands

Remove directories recursively hdfs dfs rm -r /loudacre/webpage_files References https://dzone.com/articles/top-10-hadoop-shell-commands

mysql commands for working with the Cloudera VMs

Login mysql -uroot -pcloudera Dump a database to a file mysqldump -u root -p mydatabase > /home/myuser/database-dump.sql Restore mySQL dump file to a mySQL database mysql -u username -p database_name < file.sql mysqldump -u training -p trainingdatabase > /home/training/trainingdatabase-dump.sql mysql -u root -p loudacre < loudacredatabase-dump.sql mySQL commands SHOW DATABASES; CREATE DATABASE loudacre; use loudacre; show tables; mysql -u root -p loudacre -e "describe webpage" mysql -u root -p loudacre -e "select * from webpage limit 5"