- Mark as New
- Subscribe
- Mute
- Permalink
- Email to a Friend
- Report Inappropriate Content
May 01, 2013
12:24 AM
Create database
Hello friends,
I have a question,how can we create database using the script?? i tried using "mysql -uroot -proot CREATE DATABASE %abc%" using execute script action,but it fails.Can you please suggest how can i do this??I have mysql installed in my system!
I have a question,how can we create database using the script?? i tried using "mysql -uroot -proot CREATE DATABASE %abc%" using execute script action,but it fails.Can you please suggest how can i do this??I have mysql installed in my system!
2 Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Email to a Friend
- Report Inappropriate Content
May 03, 2013
12:11 AM
Hi Pavan,
Try giving the full path to the 'mysql'.
In Windows eg: C:\\bin\mysql.exe
In Linux eg: /usr/local/mysql/bin/mysql
Or
You can 'cd' to and then run your sql_cmd.
Or
Append the full path of mysql till bin folder in environment variable 'PATH'.
Regards
Utsab Karmakar
Try giving the full path to the 'mysql'.
In Windows eg: C:\
In Linux eg: /usr/local/mysql/bin/mysql
Or
You can 'cd' to
Or
Append the full path of mysql till bin folder in environment variable 'PATH'.
Regards
Utsab Karmakar
- Mark as New
- Subscribe
- Mute
- Permalink
- Email to a Friend
- Report Inappropriate Content
May 03, 2013
02:26 AM
Thanks a lot for your reply 🙂
