澳门银河网上官方赌场_老品牌值得信赖

ITKeyword,专注技术干货聚合推荐

注册 | 登录

解决mysql - Restoring mysqldump backup with TYPE='MYISAM'

itPublisher 分享于

2020腾讯云双十一活动,全年最低!!!(领取3500元代金券),
地址https://cloud.tencent.com/act/cps/redirect?redirect=1073

【阿里云】双十一活动,全年抄底价,限时3天!(老用户也有),
入口地址https://www.aliyun.com/1111/home

推荐:Backup and Restore MySQL Database Using mysqldump

转自: http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump/ mysqldump is an effective tool to backup MySQL database.

This question already has an answer here:

-- MySQL dump 9.11
--
-- Host: localhost    Database: Books
-- ------------------------------------------------------
-- Server version   4.0.20a-debug

--
-- Table structure for table `BX-Users`
--

CREATE TABLE `BX-Users` (
  `User-ID` int(11) NOT NULL default '0',
  `Location` varchar(250) default NULL,
  `Age` int(11) default NULL,
  PRIMARY KEY  (`User-ID`)
) TYPE=MyISAM;

--

This is the view if the dump file that i want to restore. I used the command

C:\wamp\bin\mysql\mysql5.6.12\bin>mysql -h localhost -u medha -p Books < BX-User s.sql

it returns an error saying

ERROR 1064 (42000) at line 11: You have an error in your SQL syntax; check the m anual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 6

Please suggest. I also tried entering the user in specified database and then using source command to restore it .. doesn't work.

mysql sql mysqldump
|
  this question
asked Jun 1 '14 at 0:54 nik 152 1 3 10

marked as duplicate by nos, Jason Heo, Michael - sqlbot, Clockwork-Muse, brasofilo Jun 1 '14 at 12:19

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.



 | 

1 Answers
1

解决方法

Replace TYPE=MyISAM with ENGINE=MyISAM

I tested it and it worked. :)


|
  this answer
answered Jun 1 '14 at 1:02 user1100756 54 7

 | 

Not the answer you're looking for? Browse other questions tagged mysql sql mysqldump or ask your own question.

推荐:MYSQL常用命令 MyISAM to InnoDB, max connections , GRANT ALL PRIVILEGES , mysqldump 等等

? Date_add SELECT OrderId,DATE_ADD(OrderDate,INTERVAL 2 DAY) AS OrderPayDateFROM Orders ? ? MyISAM to InnoDB ALTER TABLE??boblog_blogs???? ENGINE=In


相关阅读排行


相关内容推荐

最新文章

×

×

请激活账号

为了能正常使用评论、编辑功能及以后陆续为用户提供的其他产品,请激活账号。

您的注册邮箱: 修改

重新发送激活邮件 进入我的邮箱

如果您没有收到激活邮件,请注意检查垃圾箱。

澳门银河网上官方赌场