distal-attribute
distal-attribute
distal-attribute
distal-attribute

export to linux box

User, date Message
Written by BubikolRamios
4 years ago
Category: Import/Export
326 posts since Thu, 14 Jan 10
export creates something like that:


# --------------------------------------------------------
# Host: 127.0.0.1
# Database: test
# Server version: 5.1.31-community
# Server OS: Win32
# HeidiSQL version: 4.0.0.2983
# Date/time: 2010-01-20 06:32:28
# --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

# Dumping structure for table test.lang
DROP TABLE IF EXISTS `lang`;
CREATE TABLE IF NOT EXISTS `lang` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`en` varchar(400) NOT NULL,
`sl` varchar(400) CHARACTER SET utf8 COLLATE utf8_slovenian_ci DEFAULT NULL,
`sr` varchar(400) CHARACTER SET utf8 COLLATE utf8_slovenian_ci DEFAULT NULL,
`it` varchar(400) DEFAULT NULL,
`de` varchar(400) DEFAULT NULL,
`fr` varchar(400) DEFAULT NULL,
`hr` varchar(400) CHARACTER SET utf8 COLLATE utf8_slovenian_ci DEFAULT NULL,
`ru` varchar(400) CHARACTER SET utf8 DEFAULT NULL,
`es` varchar(400) DEFAULT NULL,
PRIMARY KEY (`id`,`en`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

# Dumping data for table test.lang: 173 rows
....




run that in linux session of heidi sql, all goes OK, but there is no indexes on target table ?
Written by BubikolRamios
4 years ago
326 posts since Thu, 14 Jan 10
Actualy there are, coz I can see them with mysql query browser, heidi sql does ot see them !
Written by ansgar
4 years ago
4784 posts since Fri, 07 Apr 06
Ah, notice your "USING BTREE" addition. That's currently unsuppoerted by HeidiSQL. See issue #1576.
 

Please login to leave a reply, or register at first.