Web Hosting Vodahost    

Home Take The Royal Tour! Order Now Features Prices
Go Back   Web Hosting > VodaHost Web Hosting Support > mySQL & PHP

Notices

mySQL & PHP Discussions, information and help with mySQL and PHP.

Reply
 
LinkBack Thread Tools
  #1  
Old 04-06-2007, 05:49 PM
aconstas1's Avatar
Lieutenant Colonel
 
Join Date: Mar 2007
Posts: 597
Default phpMyAdmin problem

Im installing a web calendar that is php based and requires MySQL database.

During the installation instructions it says to create the database through phpMyAdmin. Here is the instruction:

"On the initial phpMyAdmin page, under the "MySQL" heading, the first option should be "Create new database." Enter the name you have chosen for the database and press the "Create" button. (The default database name used by WebCalendar is "intranet".) After pressing the "Create" button, it should say: "Database <your database name here> has been created.""

When I go into phpMyAdmin there is no create button. I see the following: Create new database:
No Privileges

but this is not a link or button.
I created the database through the MySQL Account maintenance instead and added a user there.

The next step is creating tables for the calendar database in phpMyAdmin here are the instructions:
  1. Click on the "Databases" tab at the top of the page.
  2. From the list of databases on the page, click on the name of the database that you created.
  3. Click on the "SQL" tab at the top of the page.
  4. At the bottom of the page, there is an area to upload a SQL file. Click on the "Browse" button and select the tables-mysql.sql file in the WebCalendar toplevel directory. Then, press the "Go" button.
  5. The top of the page should say "Your SQL-query has been executed successfully."
  6. You have now finished creating the WebCalendar database tables.
After I create the database and add the user, phpMyAdmin does list the database. I select it and click the SQL tab at the top however, the page it takes me to has a Run SQL query/queries on database box with a text box and a go button. There is no Browse so that i can upload the table files.

There is another tab that allows me to Create new table on database. It asks me for name and number of fields, but I don't know these.

Can someone guide me to how i can upload the sql file on my pc to create the correct database tables?

Any help is much appreciated.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2  
Old 04-06-2007, 06:59 PM
racefan20's Avatar
Major General
 
Join Date: Jul 2005
Location: Concord, NC
Posts: 2,339
Default Re: phpMyAdmin problem

Click the import tab rather than the sql tab.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT +1. The time now is 03:39 AM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC7
2005-2009 VodaHost Web Hosting Your Perfect Web Host - All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176