Editing mysql databases

From Novara Support Knowledgebase

Editing MySQL databases using PHPMyAdmin

You can edit the content of your databases using the phpMyAdmin utility that comes with your control panel. To run phpMyAdmin, do the following:

1. Select MySQL DBs in the Databases menu.

2. In the form that appears, click the name of the existing MySQL Database you want to edit or the Edit icon on its right:

3. In the form that appears, click Built in phpMyAdmin control panel to start editing your database.

4. To edit the database enter the database username and password in the relevant fields as shown above.

5. Follow the instructions of the phpMyAdmin control panel to edit your MySQL DB.

Note: Regarding backup of database there is no automated process in place to backup the database you can backup database manually in phpmyAdmin using the Export option - see link: http://php.about.com/od/learnmysql/ss/mysql_backup_3.htm You can export to a .sql file and if you need to restore database you can do so to an existing database or a new one using Import option in phpMYadmin. If you get any errors about command not allowed its most likely down to the permission set under you user name eg: update,insert, delete, drop etc.