rename table name

Hi all,
I need help with renaming table. For example "adminaccess" rename it to "new_adminaccess"
I was using phpMyAdmin to do it, but I didn't know how to.
Can anyone help?
Thanks in advance ;
Alex,

 

In phpmyadmin:
> Select the database you have the table in.
> Next to the tablename in the "bigger" right frame, second icon is "structure". Click it.
> Select "operations" in top tabs.

Here you'll see an option to rename the table.
Hope that helps...
regards

 

thank you sush, i will do it now and see how it works
thanks alot sush

 

#1142 - ALTER command denied to user 'alexkim'@'localhost' for table 'access'

i got that error message

 

That means that the "user" connecting to the database does not have permissions to do this.
The query is:
RENAME TABLE `db_name`.`table_name` TO `db_name`.`new_table_name`

Your user does not have "rename" permissions.

A second way is to do an "export" of this table, download the file it creates.
Open this file in notepad
Find your table name, and replace it with your new table name
You'll find the table name near the following:

CREATE TABLE `table_name`
INSERT INTO `table_name`

Change it here, and do an import.

If your table is big, then doing this will be a pain...
Do not "drop" the old table until your new table is properly created.
regards