Advertisement
Guest User

Untitled

a guest
Feb 29th, 2016
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. /*!40101 SET @saved_cs_client = @@character_set_client */;
  2. /*!40101 SET character_set_client = utf8 */;
  3. CREATE TABLE `attachment_types` (
  4. `ID` int(11) NOT NULL AUTO_INCREMENT,
  5. `DESCRIPTION` varchar(50) DEFAULT NULL,
  6. `COMMENTS` varchar(256) DEFAULT NULL,
  7. PRIMARY KEY (`ID`),
  8. UNIQUE KEY `UK_ATTACHMENT_TYPES___DESCRIPTION` (`DESCRIPTION`)
  9. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  10.  
  11. mysql --user=root --password=root < mysqldumpfile.sql
  12.  
  13. ERROR 1064 (42000) near ' ■/ ' at line 1
  14.  
  15. mysqldump -u root -p --default-character-set=utf8 --result-file=database1.backup.sql database1
  16.  
  17. mysql --user=root --password=root --default_character_set utf8 < database1.backup.sql
  18.  
  19. mysql --user=root --password=root --default_character_set utf8 < mysqldumpfile.sql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement