This site has Unicode encoded Bengali texts. If you cannot see the Bangla texts, then you would need to setup your computer for Unicode. Here is how to setup. You may also need to install a good Bangla Unicode font. We have modified the  publicly available Ekushey Lohit font for better screen reading. The new font, called AponaLohit looks almost like an Unicode compatible version of popular Boishakhi font. Download from here. You may wish to view the Bangla version of this site too.

Developing PHP/MySQL website on PC E-mail
Article Index
Developing PHP/MySQL website on PC
Downloading and Installing
Starting, stopping and restarting
Creating, editing MySQL database
Importing and exporting
Database users and passwords
Page 4 of 6

Creating, deleting, modifying MySQL database

As you already know, to do anything with MySQL you need to go to phpMyAdmin page. In the phpMyAdmin panel, if you come up with Fig 5, then that means the MySQL server is not running. Run the MySQL server on the Uniform Server page (top left corner). If you have the MySQL running then you can expect the Fig 6.

phpMyAdmin

To create a new database (for a new website) type in the name of the database and a collation. The collation is very important for UTF-8 or Unicode based websites. For Bangla websites, you need to set this to utf8_bin. Once you have pressed the Create button, the database is created and ready for use.

To delete a database, or modify/delete table(s) under it, select the database from the database list on the left. Then you would see the list of tables within that database. The right hand screen has more then a handful of commands that I can describe. Fig 7 shows a section of tables from a typical Joomla database.

 Database creation

 
 
[ Back ]
 

© 2008 Copyright joomla-bd. All rights reserved. All articles and pictures are properties of respective author. Using them anywhere is prohibited.

Valid XHTML 1.0 Transitional Valid CSS!

Template by Joomlashack