Setting Default Database and Folder for Execute Script

aamir777 · Post by **aamir777** » Thu 03 Mar 2011 07:14

I have few files and have written hundreds of stored procedures for my different MySQL databases which I have to deploy them again and again on our testing server.

I am using dbForge for MySQL v4.50.335. Can someone tell me how to set Default Database and Folder for Database -> Execute Script menu option.

Thanks

.jp · Post by **.jp** » Thu 03 Mar 2011 08:58

You can create a main file that contains SOURCE commands.

Code: Select all

SOURCE 'filename1.sql';
SOURCE 'filename2.sql';
SOURCE 'filename3.sql';
...
SOURCE 'filenameN.sql';

Then open Execute Large Script Wizard, choose appropriate Connection and Database, and execute this main file.

Note: filename1.sql, filename2.sql ... filenameN.sql cannot contain USE statements.