Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- How to execute Mysql command from a shell script?
- `mysql -h "server-name" -u root "password" "database-name" < "filename.sql"`
- `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`
- $ mysql -h "server-name" -u "root" "-pXXXXXXXX" "database-name" < "filename.sql"
- $ mysql -h "server-name" -u "root" -p "XXXXXXXX" "database-name" < "filename.sql"
- Enter password: <you type it in here>
- ERROR 1049 (42000): Unknown database 'XXXXXXXX'
- [client]
- user = root
- password = XXXXXXXX
- $ mysql -h "server-name" "database-name" < "filename.sql"
- $ bash -x myscript.sh
- mysql -h "hostaddress" -u "username" -p "database-name" < "sqlfile.sql"
- mysql -h <host> -u<user> -p<password> database -e
- "SELECT * FROM blah WHERE foo='bar';"
Add Comment
Please, Sign In to add comment