How to create and populate a database in your PhpMyAdmin

[dojo]

First you have to get to it: follow the link provided by your host and you'll get to the PhpMyAdmin page. This is a part of it:



If you haven't got a database created you'll have to create one. Please see the image above. After you have created the database it's important to remember the following information: database host (the place it's hosted, usually localhost), database name (the CMS needs to reffer to a database, so it's important to provide the information), database username and database password, provided bt the host or set by the user.

Some Content Management Systems work with an empty database and they write the necessary tables after installing them. Some, Nuke for example, require a database that's already been populated with the necessary tables. The CMS needing this, has in the downloaded package a .sql file that has to be imported in order for the tables and info to be written.

This is how we do it:



Please see the database I call nuke is empty right now. In order to populate it with the nuke.sql information needed for Php-Nuke, please hit sql.



If everything goes well, you'll receive the following page.



If there were errors, hit the structure button, sellect ALL the TABLES and hit DROP. That would clean the database and you can start populating it again by hitting browse and so on.

---
For our Romanian visitors the article has been translated on Invatam.Net: Cum creezi o si populezi o baza de date in phpmyadmin