Once you have taken the dump of the database then you can restore using the dump.sql files(learn here to take the dump/back-up from database).
In phpMyAdmin simply click on the SQL tab and then from there you can browse the dump.sql file that you have stored after taking the dump. If the structure is not there [...]

It is very important to take the back-up of your data as well as the application to keep things moving and to be on the safer side. It is wiser to take the back-up of data and structure both. There are several ways to take the back-up.
If you are using phpMyAdmin then you it very [...]

To display the new module that you have created to show in the ACL Roles you have to run one SQL query against the Sugar database. This query will insert module details in the “acl_actions” table. I would suggest to take the dump of the existing “acl_actions table” using phpMyAdmin or from the MySQL command: [...]