Managing Files in Projects

This topic explains how to work with files and folders in your projects.

Working with Folders

If you are working with the project that contains many different queries and scripts, you can use folders to organize the related scripts and queries into groups. dbForge Studio for MySQL allows you to create folders and move or add items to them, to create nested folders for complex project organization, delete or rename folders.

To create a folder, right-click the project or folder in Project Explorer and select Add Folder on the shortcut menu.

To delete a folder,right-click it in Project Explorer and select Delete on the shortcut menu. All the file shortcuts and subfolders of this folder will be removed from the project, but physical files will not be deleted.

You can move SQL scripts and queries to and from folders by dragging them from and dropping to the folders.

Note

Project folders are not real Windows folders, information about these folders is stored in the project file (.mydev). When you create or delete folders, corresponding Windows folders are not created or deleted and when you move file shortcuts and folders in Project Explorer from one folder to another, physical files stay at the same locations they were before.

Adding File to Project

To add a new file to the project, right-click the project or its folder node in Project Explorer and select Add New File on the shortcut menu

-or-

select Add New File on the Project menu.

The Add New File window will appear. Choose the desired template of the file to be created. Input the name of the file. Click Add to create the file with code template.

Note

Though the created file is automatically included into the project it is not saved anywhere on the disk. You are to save it by selecting the Save command from the File menu or the Standard toolbar.

To add an existing file to project, right-click the project or its folder node in Project Explorer and select Add Existing File on the shortcut menu.

Removing File from Project

To remove a file from the project, right-click it in Project Explorer, select Delete on the shortcut menu and click Remove in the appeared dialog box. The physical file will not be deleted, these actions only remove the file link from project.

To delete a physical file from disc, right-click it in Project Explorer, select Delete on the shortcut menu and click Delete in the appeared dialog box. The file link in project and the physical file itself will be deleted.

Editing files in Project

You can edit project’s files in a convenient SQL editor, which provides a wide range of options for quick and efficient SQL code editing.