Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Renaming a Database???

Status
Not open for further replies.
colep

colep

Programmer
Jul 18, 2002
58
US
Is there a way to rename a database like the rename table command?? I haven't been able to find any info on it at mysql.com.... If not, what would be the easiest way to accomplish this???

Thanks in advance,
Cole ;)
 
Sort by date Sort by votes
MySQL does not have command-line functionality to rename a database. However, if you have access to the filesystem of the database server, you can shutdown MySQL (you must do this first), rename the directory in which the database's table files reside, then restart MySQL. Want the best answers? Ask the best questions: TANSTAAFL!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EdLentz
  • Locked
  • Question
How do I use a keyword in a query??
Replies
6
Views
507
EdLentz
EdLentz
Colin Burton
  • Locked
  • Question
Sending A a video clip to either a web server or MySql Database
Replies
2
Views
160
Colin Burton
Colin Burton
boylesg
  • Locked
  • Question
Can't sort my table by a particular column, records are returned in autinc order.
Replies
4
Views
470
spamjim
spamjim
Arthur Lewis
  • Locked
  • Question
Backup Mysql database to client machine
Replies
2
Views
151
Arthur Lewis
Arthur Lewis
BobThornton
  • Locked
  • Question
Drop/Truncate tables based on a stored procedures value 1
Replies
6
Views
541
BobThornton
BobThornton

Part and Inventory Search

Sponsor

Back
Top