Skip to content

Rename a database in MySQL

Ever tried to rename a database in MySQL? Obviously not.

Why not? MySQL does not support renaming databases. Funny, eh?

They once tried to implement this feature but failed and removed the code again. Note the sudden major feature shifts in minor releases.

So, how to rename a database? Dump the database, create a new database and import the dump. Both steps can be executed together:

mysqldump old_database | mysql new_database
  • Twitter
  • Bookmark Rename a database in MySQL at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Rename a database in MySQL
  • Bloglines Rename a database in MySQL
  • Technorati Rename a database in MySQL
  • Fark this: Rename a database in MySQL
  • Bookmark Rename a database in MySQL at YahooMyWeb
  • Bookmark Rename a database in MySQL at Furl.net
  • Bookmark Rename a database in MySQL at reddit.com
  • Bookmark Rename a database in MySQL at blinklist.com
  • Bookmark Rename a database in MySQL at Spurl.net
  • Bookmark Rename a database in MySQL at Simpy.com
  • Bookmark Rename a database in MySQL at blogmarks
  • Bookmark Rename a database in MySQL with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Trackbacks

No Trackbacks

Comments

Display comments as Linear | Threaded

No comments

Add Comment

Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
To leave a comment you must approve it via e-mail, which will be sent to your address after submission.
Form options