douchun9719 2015-07-16 21:07
浏览 42

如何使用phpMyAdmin将数据库的内容导入新数据库?

Inside my MySQL databases there are 15 tables. Each table currently contains nothing inside, here are the tables.

enter image description here

Now I have a folder on my PC which contains 15 files with the same name, as shown here.

enter image description here

Inside the file, I have this line at the top so It should import it into the already existing database if I'm correct.

DROP TABLE IF EXISTS inventories;

However when I do import it, I always get errors. Here is the error I get when I try to import the inventories file from my PC to the new database.

I don't know how to fix this. I'm very new to SQL as well.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 Matlab问题解答有两个问题
    • ¥50 Oracle Kubernetes服务器集群主节点无法访问,工作节点可以访问
    • ¥15 LCD12864中文显示
    • ¥15 在使用CH341SER.EXE时不小心把所有驱动文件删除了怎么解决
    • ¥15 gsoap生成onvif框架
    • ¥15 有关sql server business intellige安装,包括SSDT、SSMS。
    • ¥15 stm32的can接口不能收发数据
    • ¥15 目标检测算法移植到arm开发板
    • ¥15 利用JD51设计温度报警系统
    • ¥15 快手联盟怎么快速的跑出建立模型