Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- grant file on *.* to 'webuser@'%';
- mysql> grant file on *.* to 'devuser'@'%';
- ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)
- mysql> select User, File_priv, Grant_priv, Super_priv from mysql.user;
- +----------+-----------+------------+------------+
- | User | File_priv | Grant_priv | Super_priv |
- +----------+-----------+------------+------------+
- | rdsadmin | Y | Y | Y |
- | root | N | Y | N |
- | devuser | N | N | N |
- +----------+-----------+------------+------------+
- --local-infile=1
- mysqldump MYDB | mysql -h rds-amazon-blah.com --user=youruser --pass=thepass
- mysqlimport --local --compress -u <user-name> -p<password> -h <host-address> <database-name> --fields-terminated-by=',' TEST_TABLE.csv
- --Make sure, here the utility will be inserting the data into TEST_TABLE only.
- mysql -u <user-name> -p<password> -h <host-address> <database-name> < TEST_TABLE_INSERT.SQL
- --Here file TEST_TABLE_INSERT.SQL will have bulk import sql statement like below
- --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