nixCraft Linux Forum

nixCraft

Linux / UNIX Tech Support Forum

MySQL Rename Database SQL Command

This is a discussion on MySQL Rename Database SQL Command within the Databases servers forums, part of the Mastering Servers category; hello, Can you please tell me, how i can rename mysql database in CLI mode. Thanks...


Go Back   nixCraft Linux Forum > Mastering Servers > Databases servers

Linux answers from nixCraft.


Databases servers Discussions of databases of all types - especially MySQL.

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 30-08-2008, 01:34 AM
Junior Member
User
 
Join Date: Dec 2007
OS: Debian
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
myfoot is on a distinguished road
Default MySQL Rename Database SQL Command

hello,

Can you please tell me, how i can rename mysql database in CLI mode.


Thanks
Reply With Quote
  #2 (permalink)  
Old 30-08-2008, 05:54 PM
nixcraft's Avatar
Never say die
User
 
Join Date: Jan 2005
Location: BIOS
OS: RHEL
Scripting language: Bash and Python
Posts: 2,710
Thanks: 11
Thanked 244 Times in 183 Posts
Rep Power: 10
nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute
Default

MySQL 5.1.7 had rename database but it was removed due to many problem. MySQL does not support the rename of a database through command line.
MySQL :: MySQL 5.1 Reference Manual :: 12.1.18 RENAME DATABASE Syntax
Quote:
The safest way is to use mysqldump to back up the old database, then restore the dump
How to Rename database - The MySQL Relational Database
__________________
Vivek Gite
Linux Evangelist
Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group.
Always use CODE tags for posting system output and commands!
Do you run a Linux? Let's face it, you need help
Reply With Quote
Reply

Tags
linux , mysql , rename database , unix , windows


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads

Thread Thread Starter Forum Replies Last Post
how to do MYSQL online backup of huge database manish_2479 Databases servers 4 12-07-2008 12:36 PM
need to convert text files into mysql database zafar466 Databases servers 2 12-07-2008 12:31 PM
How to rename a file in Linux raj Linux software 0 22-04-2008 02:00 AM
ssh backup particular mysql table / database brothers Databases servers 11 25-10-2007 05:06 PM
How can I rename a file by its date? warren Linux software 5 30-03-2006 12:11 PM


All times are GMT +5.5. The time now is 04:35 PM.


Powered by vBulletin® Version 3.8.5 - Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.2
©2005-2010 nixCraft. All rights reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38