Member Avatar for davy_yg

Hallo,

How to rename database in MySQL - 5.0.21 ?

I try this:

rename database sunvone_scn TO indonusacms;

and get this error:

Error

SQL query:

RENAME DATABASE sunvone_scn TO indonusacms;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'database sunvone_scn TO indonusacms' at line 1
  • 2 Contributors
  • 1 Reply
  • 143 Views
  • 13 Minutes Discussion Span
  • Latest Post Latest Post by venkyb47
Member Avatar for venkyb47

RENAME DATABASE command was removed. You can create a copy of the table and after that drop old table.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.