Creation of database on server is very necessary. SQL database can be created by using some easy steps.
First, log into your Control Panel. You will see a list of icons on the main screen. Scroll down and search for the group labelled 'Databases' and click the icon named MySQL Server'.
On the resulting screen, before the entry of database, you should create a database user. Create paper icon (or up arrow), just next to 'Add new MS SQL login' label and then follow the next instructions. After its completion, you should turn back to the same screen.
Next step is to create database. Click the 'Add database' label, to start creating your database. You need to define the database name and assign the user to database & then click submit. The data locations can be changed as soon as the database is created.
Once the database is created, you have to get back on 'database screen'. You'll notice that database has a paper/hammer icon. This icon depicts that there are more details available for this topic. Click that icon. On the resulting screen, you can view the current allocations of your database. Click the paper icon on this screen to change the allocations, if required by you. You can change the total amount of space allocated to the resource and the ratio between the log file and the database file. Most of situations, find a ratio of 70% appropriate.
|
SITE MAP
ABOUT US
SUPPORT
FAQ
HOME