Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > 用Navicat for MySQL进行数据库的导入导出_MySQL

用Navicat for MySQL进行数据库的导入导出_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release： 2016-06-01 13:49:17
Original
2036 people have browsed it

Navicat

bitsCN.com

近日，在对客户的网站进行迁移时，发现了一个问题，当导出一个sql文件时，客户的数据库在导入时报错。
当时的处理是复制数据库文件夹给机房的服务器。


看见灰色的insert into 了吗，因为某字段里含有一些转义字符，所以就出错了。

今天，琢磨了一下Navicat for MySQL，发现了其竟然带有一个数据导入导出的功能、狂喜


就是这个Tools -> Data Transfer，数据传输、


选取远程的数据库，和本机的数据库，对应好。


点取Start就可以了。

看来良好的工具可以事半功倍。

bitsCN.com
Related labels：
database
Previous article：Qt使用msvc编译MySQL驱动_MySQL Next article：Mysql数据导入导出_MySQL
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
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
3
2825
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
11
2945
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
2470
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
2394
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
2444
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