Advertisement
Guest User

Untitled

a guest
Sep 29th, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.21 KB | None | 0 0
  1. grant file on *.* to 'webuser@'%';
  2.  
  3. mysql> grant file on *.* to 'devuser'@'%';
  4. ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)
  5.  
  6.  
  7. mysql> select User, File_priv, Grant_priv, Super_priv from mysql.user;
  8. +----------+-----------+------------+------------+
  9. | User | File_priv | Grant_priv | Super_priv |
  10. +----------+-----------+------------+------------+
  11. | rdsadmin | Y | Y | Y |
  12. | root | N | Y | N |
  13. | devuser | N | N | N |
  14. +----------+-----------+------------+------------+
  15.  
  16. --local-infile=1
  17.  
  18. mysqldump MYDB | mysql -h rds-amazon-blah.com --user=youruser --pass=thepass
  19.  
  20. mysqlimport --local --compress -u <user-name> -p<password> -h <host-address> <database-name> --fields-terminated-by=',' TEST_TABLE.csv
  21. --Make sure, here the utility will be inserting the data into TEST_TABLE only.
  22.  
  23. mysql -u <user-name> -p<password> -h <host-address> <database-name> < TEST_TABLE_INSERT.SQL
  24. --Here file TEST_TABLE_INSERT.SQL will have bulk import sql statement like below
  25. --insert into TEST_TABLE values('1','test1','2017-09-08'),('2','test2','2017-09-08'),('3','test3','2017-09-08'),('3','test3','2017-09-08');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement