| |

VerySource

 Forgot password?
 Register
Search
View: 1479|Reply: 5

How does mysql modify the database name?

[Copy link]

1

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 United States

Post time: 2020-2-7 15:00:01
| Show all posts |Read mode
alter database 'a' modify name = 'bb';
No way

sp_renamedb, not working in mysql

Master, give me pointers! Thank you
Reply

Use magic Report

0

Threads

20

Posts

17.00

Credits

Newbie

Rank: 1

Credits
17.00

 China

Post time: 2020-4-3 21:45:01
| Show all posts
Delete and create
Reply

Use magic Report

1

Threads

9

Posts

10.00

Credits

Newbie

Rank: 1

Credits
10.00

 China

Post time: 2020-4-16 19:30:01
| Show all posts
ALTER {DATABASE | SCHEMA} @var {db_name}
    @var {alter_specification} [, @var {alter_specification}] ...
Reply

Use magic Report

0

Threads

20

Posts

17.00

Credits

Newbie

Rank: 1

Credits
17.00

 China

Post time: 2020-5-6 16:45:01
| Show all posts
This will do:
Backup mysqldump -u root -ppwd databasename> c:\database.sql
  Restore mysql -u root -ppwd newdatabasename <c: /database.sql
Reply

Use magic Report

1

Threads

7

Posts

6.00

Credits

Newbie

Rank: 1

Credits
6.00

 China

Post time: 2020-8-2 10:30:01
| Show all posts
Is this interesting~ Once the database is used in the system, how can it change its name~?
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-9-2 19:30:02
| Show all posts
Go directly to the mysql installation directory and modify the name of the corresponding database folder!
The directory reference is as follows, the folder under the data directory is your database.
D:\Program Files\MySQL\MySQL Server 5.0\data
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list