Skip to content

Instantly share code, notes, and snippets.

@realfirst
Last active December 13, 2017 06:20
Show Gist options
  • Save realfirst/2a225af266920daa6d1a17e2b9d67a88 to your computer and use it in GitHub Desktop.
Save realfirst/2a225af266920daa6d1a17e2b9d67a88 to your computer and use it in GitHub Desktop.
SELECT User,Host FROM mysql.user;
DROP USER 'testuser'@'localhost';
* MySql export schema without data
mysqldump -u root -p --no-data dbname > schema.sql
mysqldump -u root -p --no-data azkaban > azkaban-schema.sql
* how-to-import-an-sql-file-using-the-command-line-in-mysql
mysql -u username -p database_name < file.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment