Change DB Name

pakadtrader · 01-28-2007, 04:58 AM

Hi Friends,

I want to change DB name in MySQL but dont know how. Please help me.

jumpenjuhosaphat · 01-28-2007, 05:35 AM

If you have phpmyadmin, you can change the name of the table by clicking on the table you want changed, then clicking on the operations tab. Enter the new name of your table and click go.

If you need to script it, or don't have phpmyadmin, use

Code:

RENAME TABLE oldname TO newname

pakadtrader · 01-28-2007, 08:39 AM

I know how to rename table name. I want to change DB NAME

midlandi · 01-28-2007, 08:43 AM

Do you have Cpanel?

pakadtrader · 01-28-2007, 10:01 AM

Yes, I have Cpanel.

ForumJoiner · 02-09-2007, 07:40 PM

Let's say it's a local database. The database's name is actually the folder's name in which the database is stored. Change that folder's name with Explorer (if you have Windows) and that's it.

For mysql, the folder where all the databases are is:
mysql\data
(that is, the "data" subfolder of MySQL folder.

Make an experiment. Create a database using mysql command prompt. You'll see that "create database" actually creates an emplty folder on the data folder.

jumpenjuhosaphat · 02-09-2007, 07:56 PM

You can do that using phpmyadmin as well. If not:
RENAME TABLE thisname TO thatname

Check out the reference at http://dev.mysql.com/doc/refman/5.0/...ame-table.html

01-28-2007, 04:58 AM	#1
pakadtrader Junior Member Join Date: Oct 2006 Posts: 11	Change DB Name Hi Friends, I want to change DB name in MySQL but dont know how. Please help me.

01-28-2007, 05:35 AM	#2
jumpenjuhosaphat Forum Admin Contributor Join Date: Jun 2006 Location: Denver Posts: 4,459	Re: Change DB Name If you have phpmyadmin, you can change the name of the table by clicking on the table you want changed, then clicking on the operations tab. Enter the new name of your table and click go. If you need to script it, or don't have phpmyadmin, use Code: RENAME TABLE oldname TO newname __________________ Storage Sheds Lost Forum

01-28-2007, 08:39 AM	#3
pakadtrader Junior Member Join Date: Oct 2006 Posts: 11	Re: Change DB Name I know how to rename table name. I want to change DB NAME

01-28-2007, 08:43 AM	#4
midlandi iWEBTOOL Moderator Contributor Join Date: Oct 2006 Posts: 2,196	Re: Change DB Name Do you have Cpanel? __________________ SubmitterBot - Semi-automatic directory submission tool Free Link Directory

01-28-2007, 10:01 AM	#5
pakadtrader Junior Member Join Date: Oct 2006 Posts: 11	Re: Change DB Name Yes, I have Cpanel.

02-09-2007, 07:40 PM	#6
ForumJoiner Newcomer Join Date: Feb 2007 Posts: 9	Re: Change DB Name Let's say it's a local database. The database's name is actually the folder's name in which the database is stored. Change that folder's name with Explorer (if you have Windows) and that's it. For mysql, the folder where all the databases are is: mysql\data (that is, the "data" subfolder of MySQL folder. Make an experiment. Create a database using mysql command prompt. You'll see that "create database" actually creates an emplty folder on the data folder.

02-09-2007, 07:56 PM	#7
jumpenjuhosaphat Forum Admin Contributor Join Date: Jun 2006 Location: Denver Posts: 4,459	Re: Change DB Name You can do that using phpmyadmin as well. If not: RENAME TABLE thisname TO thatname Check out the reference at http://dev.mysql.com/doc/refman/5.0/...ame-table.html __________________ Storage Sheds Lost Forum

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

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How Often do you change your webhosts	pairbrother	Web Hosting	29	03-28-2007 11:55 AM
Backlinks And PR Change	Kirtan	Link Building	14	02-01-2007 12:06 AM
Request Name Change	UnKnown	Help and Support	6	11-23-2006 03:38 PM
Should i change...	King Gareth	Domain Name	4	01-09-2006 08:33 PM