Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > MySQL重装系统后还原MySQL数据库总结

MySQL重装系统后还原MySQL数据库总结

WBOY
Release： 2016-06-07 17:52:56
Original
1421 people have browsed it

我们经常会碰到关于MySQL数据库安装与数据库的还原方法总结，方法有很多种下面一一介绍。

方法一

在安装mysql数据库前我们利用phpmyadmin备份数据库，安装好之后直接导入即可。


方法二

1、先在运行中输入services.msc，找到MysQL的服务，将其停止；

2、然后备份新安装的MY.INI和DATA这两个目录，直接将其原来mysql/data下的文件拷到新安装的mysql/data目录下即可；

3、启动MysQL服务。


方法三

用mysql命令模式备份与还原数据

mysqldump -h 主机 -u数据户用户名 -p数据库密码 数据库 > bak.sql

MySql还原恢复数据库命令:

mysql -h 主机 -u数据户用户名 -p数据库密码 数据库

Related labels：
MySQL还原
source：php.cn
Previous article：mysql中mysqlhotcopy备份数据库总结 Next article：mysql LEFT JOIN多表联结查询
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Possibility to store ASP Classic code as string in MYSQL database Is it possible to store asp classic code into a MySQL database and have it execute the cod...
From 2024-04-06 13:38:43
0
1
358
Python/MySQL cannot persist integer data correctly No code is required here. I want to save a very long number because I'm making a game and ...
From 2024-04-04 19:09:44
0
1
367
Multiple starting letters for sorting countries Now in my high school class we are learning about MySQL and how to select and sort items b...
From 2024-03-30 22:35:22
0
2
391
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template