Sun MySQL Logo

Related Topics:

Anonymous Posted on Aug 05, 2008

Rename a mysql database with phpmyadmin

Is there a way to rename a database with phpmyadmin?

2 Answers

Anonymous

Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

  • Contributor 1 Answer
  • Posted on Jun 06, 2011
Anonymous
Contributor
Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

Joined: Jun 06, 2011
Answers
1
Questions
0
Helped
2308
Points
1

Follow these steps:

1) In phyMyadminselect the database you want to rename
2) Click on the "Operations" tab
3) Place your cursor on the "Rename Database to" text box and type the new name of the database.
4) Click on the "Go" button and let it do its work.

Good luck.

Anonymous

Level 1:

An expert who has achieved level 1.

Corporal:

An expert that has over 10 points.

Problem Solver:

An expert who has answered 5 questions.

  • Contributor 8 Answers
  • Posted on Nov 26, 2008
Anonymous
Contributor
Level 1:

An expert who has achieved level 1.

Corporal:

An expert that has over 10 points.

Problem Solver:

An expert who has answered 5 questions.

Joined: Nov 26, 2008
Answers
8
Questions
0
Helped
7973
Points
11

Yes. In the SQL tab,

RENAME DATABASE test TO new_test ;

  • Anonymous Jun 06, 2011

    I trtied that as such:

    RENAME DATABASE classicmodels TO sampleorders;

    but it shows an error:

    #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 classicmodels TO sampleorders' at line 1

×

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

2,318 views

Ask a Question

Usually answered in minutes!

Top Sun Computers & Internet Experts

Rob Hill
Rob Hill

Level 3 Expert

1483 Answers

Narseman

Level 3 Expert

1092 Answers

Brad Brown

Level 3 Expert

19190 Answers

Are you a Sun Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...