在phpmy admin中导入sql server或acess数据库 [英] import sql server or acess database in phpmy admin

问题描述

你好，
我想知道如何在我的mysql数据库中导入sql或access或任何其他数据库文件.我尝试了.sql文件，但它在第一行给出了错误. .sql文件是由ne服务器从sql服务器作为脚本生成的，用于检查目的.
请给我有关如何在mysql中导入.sql或.bak或任何其他数据库文件的步骤.
在此先感谢.

hello,
i want to know how to import sql or access or any other database file in my mysql database. i tried the .sql file but it give the error on first line. the .sql file is generate as a script from the sql server by ne for checking purpose.
kindly give me the step for fhow to import .sql or .bak or any other database file in mysql.
thanks in advance.

推荐答案

如果您使用的是phpmyadmin，则可以在系统中使用import选项.只是您需要浏览sql文件并上传.

谢谢

Anand Ayyappan

Hi,

If you are using phpmyadmin you can use the import option in the system. just you need to browse the sql file and upload.

Thanks

Anand Ayyappan

在这种情况下，请尝试使用

http://www.mysql.com/products/workbench/ [

Hi,

In that case try using

http://www.mysql.com/products/workbench/[^]

There was a tool earlier MySQL Migration Toolkit but i think its part of the workbench now

Thanks

Anand Ayyappan

我得到了数据加载器软件.借助它，我可以在其他数据库中恢复大部分数据库.

i got the data loader software. by the help of it i can restore the most of the data base in other database.

这篇关于在phpmy admin中导入sql server或acess数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！