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.
Integration with MySQL command line client
Moderators: AmigoJack, bbadmin, helios, Bob Hansen, MudGuard
Integration with MySQL command line client
TextPad redneck since 1999.
NinjaLabs is now CSWD Limited!
NinjaLabs is now CSWD Limited!
You could set up a tool (Configure | Preferences | Tools | Add | Program) with the following parameters:
1. Check the path to cmd.exe and mysql.exe
2. Change <database> accordingly, or just put "USE <databasename> in your sql file.
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
2. Change <database> accordingly, or just put "USE <databasename> in your sql file.