By Valk-1 on

How exactly do i edit my mySQL database? All i see in the "How To" is stuff like "$ mysql -u nobody -p drupal < database/database.mysql"
The problem is i have no idea where to type these things... Does Drupal have a scripted PHP file that i can edit my database through?

Comments

Steven’s picture

Steven commented

Your host probably gave you a webbased control panel to use. Check their documentation/guidelines. PHPMyAdmin or similar will work fine.

You'll have a form where you can upload the database.mysql file from Drupal. If you don't have that, you'll most likely have a form where you can paste the contents of the database.mysql file (it's just a text file with SQL commands).

Valk-1’s picture

Valk-1 commented

yea, i have phpMyAdmin on my host.. but i don't understand really where i am supposed to be running some of these commands.. Forr example.. i already created a database before going into phpMyAdmin. Now that im in here, i don't really see a command prompt or anything.. also, my database name is some weird number/letter combo.. i couldn't make my own name for it, just a description.

Valk-1’s picture

Valk-1 commented

i really don't understand this... I mean, im looking around for info on phpMyAdmin and i can't find anything that actually tells me what i need to know. I keep seeing command lines and such, but i have NO IDEA where to type these in. Is there a main console or something? Do i use something like telnet? argh...

bertboerland’s picture

bertboerland commented

if you hosting on unix, you might have to telnet or ssh (use a program called putty. in case you are hosted on a windows box, you cant do that (normally).

In both cases, your hosting party will probably hae some kind of webshell round mysql. just ask your hoster if they offer mysql databases and how the webinterface is working

--

groets


bertb

--
groets
bert boerland

akamarvin’s picture

akamarvin commented

With most php/mysql basic hostings ( I don't know how basic is yours) you have one database already created that may have the name of your hosting account.

Since phpmyadmin 2.5.2 (or even before but that's the oldest I remember) ,
when you click on the database name in the left column, it brings you to the (maybe empty) list of tables of this db
with a tabbed like page showing "structure" then "sql" then "export" and so on.

Go the Sql tab, now you have the choice :

1. you paste the content of the #yourdrupaldir#/database/database.mysql file in the big textarea or...

2. you browse to the location of that file with the button next the below textfield.

Then click go or execute and watch the magic. PhpMyAdmin will execute all the SQL commands contained in the database.mysql file and thus create all the tables needed by your very own drupal site.

Hope it helps.

Valk-1’s picture

Valk-1 commented

AWESOME! That totally worked! Thank you for your help. At first i didn't understand the contents of phpmyadmin, so i wasn't sure what the big text box was for in SQL. I assumed, but i didn't want to ruin anything. Thank you everyone for your help!