Guest User

Untitled

a guest
Aug 15th, 2018
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.82 KB | None | 0 0
  1. How to execute Mysql command from a shell script?
  2. `mysql -h "server-name" -u root "password" "database-name" < "filename.sql"`
  3.  
  4. `perl fb_apps_frm_fb.pl` `perl fb_new_spider.pl ds_fbids.txt ds_fbids.sql` `mysql -h dbservername -u username -ppassword dbname < ds_fbids.sql`
  5.  
  6. $ mysql -h "server-name" -u "root" "-pXXXXXXXX" "database-name" < "filename.sql"
  7.  
  8. $ mysql -h "server-name" -u "root" -p "XXXXXXXX" "database-name" < "filename.sql"
  9. Enter password: <you type it in here>
  10. ERROR 1049 (42000): Unknown database 'XXXXXXXX'
  11.  
  12. [client]
  13. user = root
  14. password = XXXXXXXX
  15.  
  16. $ mysql -h "server-name" "database-name" < "filename.sql"
  17.  
  18. $ bash -x myscript.sh
  19.  
  20. mysql -h "hostaddress" -u "username" -p "database-name" < "sqlfile.sql"
  21.  
  22. mysql -h <host> -u<user> -p<password> database -e
  23. "SELECT * FROM blah WHERE foo='bar';"
Add Comment
Please, Sign In to add comment