This topic explains how to work with files and folders in your projects.
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 Fusion 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 Solution Explorer and select Add Folder on the shortcut menu.
To delete a folder, right-click it in Solution 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 Solution Explorer from one folder to another, physical files stay at the same locations they were before.
To add a new file to the project, right-click the project or its folder node in Solution Explorer and select Add New File on the shortcut menu
-or-
select Add New Item on the Project menu.
The Add New Item window will appear. Choose the desired template of the file to create. 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 on the File menu or Standard toolbar.
To add an existing file to project, right-click the project or its folder node in Solution Explorer and select Add Existing File on the shortcut menu
-or-
select Add Existing Item on the Project menu.
To remove a file from the project, right-click it in Solution 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 Solution 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.
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.