loading a database

[learning000]

Hi i have a saved database, i would like to load back how can i do this using phpmyadmin?.

[learning000]

Hi, i also have a database setup and have data in it, but i need a new column not a new row, as rows i can insert easy but how can i add a new column?

[jatar_k]

>> phpmyadmin

don't use it but is there a 'load data' or 'import' tab?

for adding a column look up ALTER TABLE [dev.mysql.com]

would something like

alter table tablename add column columnname columndefinition

[ergophobe]

There's someplace in PHPmyAdmin that lets you input SQL into a text window or lets you upload a file (I think even a zipped or gzipped file). This should be available on the main page for a given DB I think.

I know for records there is a little "edit" button and I bet there's something like that which provides an interface for changing a table definition.

[learning000]

Ok here's my problem, i have about 200+ bits of data in a perticular table, this table needs a new column but there's no way in phpmyadmin i can do this, i see no add column or nothing, i have a backup of my database incase anything goes wrong but also cannot find how i can load this database back up if something did go wrong so im stuck! :)
i see no alter table alter columns or anything like that.

[henry0]

Easy!

Top of PHPmyAdmin
Lateral nav
Click: SQL
it opens a query window
Paste in your data and execute the query

Adding a col:
Go back to initial admin page
click on left hand side nav the DB name you want to work with
Scroll down
above the index tool
Look for Add a Col
specify if you want it in last position (default)
or specify a location to create it (Before this.. or after that ..)
Enter the col genre, lenght etc..

hope it helped.