Integration with MySQL command line client

[ninjalabs]

Has anyone done this successfully before I attempt to have a go?

I've been using mysql-administrator but it's buggy as anything and is less productive than textpad generally.

[bveldkamp]

You could set up a tool (Configure | Preferences | Tools | Add | Program) with the following parameters:

Code: Select all

Command: C:\Winnt\System32\cmd.exe
Parameters: /c C:\Path\to\mysql.exe -u$Prompt(Enter username) -p$Password(Enter password) <database> < $File

1. Check the path to cmd.exe and mysql.exe
2. Change <database> accordingly, or just put "USE <databasename> in your sql file.

[ninjalabs]

Thanks for the tips - i will try this tonight.