mysql> select version(); +------------------+ | version() | +------------------+ | 5.6.11-debug-log | +------------------+ 1 row in set (0.00 sec) mysql> show global variables like 'datadir'; +---------------+------------+ | Variable_name | Value | +---------------+------------+ | datadir | /tmp/5611/ | +---------------+------------+ 1 row in set (0.00 sec) mysql> create database test; Query OK, 1 row affected (0.00 sec) mysql> use test; Database changed mysql> create table if not exists abc( value varchar(10)); Query OK, 0 rows affected (0.06 sec) mysql> set global innodb_ft_user_stopword_table ="test/abc"; Query OK, 0 rows affected (0.01 sec) mysql> insert into abc values ("they"); Query OK, 1 row affected (0.00 sec) mysql> insert into abc values ("database"); Query OK, 1 row affected (0.00 sec) mysql> set session innodb_ft_user_stopword_table ="test/abc"; Query OK, 0 rows affected (0.01 sec) mysql> mysql> select @@innodb_ft_user_stopword_table; +---------------------------------+ | @@innodb_ft_user_stopword_table | +---------------------------------+ | test/abc | +---------------------------------+ 1 row in set (0.00 sec) mysql> mysql> CREATE TABLE if not exists articles ( id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, title VARCHAR(200), body TEXT, FULLTEXT (title,body) ) ENGINE=InnoDB; Query OK, 0 rows affected (0.25 sec) mysql> INSERT INTO articles (title,body) VALUES ('MySQL Tutorial','DBMS stands for DataBase ...') , ('How To Use MySQL Well','After you went through a they...') ; Query OK, 2 rows affected (0.01 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('they' IN NATURAL LANGUAGE MODE); Empty set (0.00 sec) mysql> SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database' IN NATURAL LANGUAGE MODE); Empty set (0.00 sec) mysql> SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('DBMS' IN NATURAL LANGUAGE MODE); +----+----------------+------------------------------+ | id | title | body | +----+----------------+------------------------------+ | 1 | MySQL Tutorial | DBMS stands for DataBase ... | +----+----------------+------------------------------+ 1 row in set (0.01 sec) [root@ushastry tmp]# ls -l /tmp/5611/test/ total 716 -rw-rw----. 1 mysql mysql 8562 Apr 23 11:44 abc.frm -rw-rw----. 1 mysql mysql 98304 Apr 23 11:44 abc.ibd -rw-rw----. 1 mysql mysql 8618 Apr 23 11:45 articles.frm -rw-rw----. 1 mysql mysql 114688 Apr 23 11:45 articles.ibd -rw-rw----. 1 mysql mysql 65 Apr 23 11:44 db.opt -rw-rw----. 1 mysql mysql 98304 Apr 23 11:45 FTS_0000000000000034_BEING_DELETED_CACHE.ibd -rw-rw----. 1 mysql mysql 98304 Apr 23 11:45 FTS_0000000000000034_BEING_DELETED.ibd -rw-rw----. 1 mysql mysql 98304 Apr 23 11:45 FTS_0000000000000034_CONFIG.ibd -rw-rw----. 1 mysql mysql 98304 Apr 23 11:45 FTS_0000000000000034_DELETED_CACHE.ibd -rw-rw----. 1 mysql mysql 98304 Apr 23 11:45 FTS_0000000000000034_DELETED.ibd ###### cleanshutdown and copy 5611/* to 56111/ [root@ushastry tmp]# ps aux|grep mysqld root 13474 0.0 0.0 106148 1444 pts/0 S 11:43 0:00 /bin/sh bin/mysqld_safe --defaults-file=my.cnf --user=mysql mysql 13692 0.4 5.3 963988 104064 pts/0 Sl 11:43 0:01 /home/ushastry/mybuilds/mysql-5.6.11-release/bin/mysqld --defaults-file=my.cnf --basedir=/home/ushastry/mybuilds/mysql-5.6.11-release --datadir=/tmp/5611 --plugin-dir=/home/ushastry/mybuilds/mysql-5.6.11-release/lib/plugin --user=mysql --log-error=/tmp/5611/ushastry.err --pid-file=/tmp/5611/ushastry.pid --socket=/tmp/5611/sock --port=3306 root 13763 0.0 0.0 103152 824 pts/2 S+ 11:47 0:00 grep mysqld [root@ushastry tmp]# kill -9 13474 13692 [root@ushastry tmp]# [root@ushastry tmp]# [root@ushastry tmp]# mkdir 56111 [root@ushastry tmp]# cp -ra 5611 5611/ 56111/ [root@ushastry tmp]# cp -ra 5611/. 5611 5611/ 56111/ [root@ushastry tmp]# cp -ra 5611/. 56111/ [root@ushastry tmp]# ls -l /tmp/56111/test/ total 716 -rw-rw----. 1 mysql mysql 8562 Apr 23 11:44 abc.frm -rw-rw----. 1 mysql mysql 98304 Apr 23 11:44 abc.ibd -rw-rw----. 1 mysql mysql 8618 Apr 23 11:45 articles.frm -rw-rw----. 1 mysql mysql 114688 Apr 23 11:45 articles.ibd -rw-rw----. 1 mysql mysql 65 Apr 23 11:44 db.opt -rw-rw----. 1 mysql mysql 98304 Apr 23 11:45 FTS_0000000000000034_BEING_DELETED_CACHE.ibd -rw-rw----. 1 mysql mysql 98304 Apr 23 11:45 FTS_0000000000000034_BEING_DELETED.ibd -rw-rw----. 1 mysql mysql 98304 Apr 23 11:45 FTS_0000000000000034_CONFIG.ibd -rw-rw----. 1 mysql mysql 98304 Apr 23 11:45 FTS_0000000000000034_DELETED_CACHE.ibd -rw-rw----. 1 mysql mysql 98304 Apr 23 11:45 FTS_0000000000000034_DELETED.ibd [root@ushastry tmp]# ls -l /tmp/56111/ total 176252 -rw-rw----. 1 mysql mysql 56 Apr 19 13:51 auto.cnf -rw-rw----. 1 mysql mysql 79691776 Apr 23 11:45 ibdata1 -rw-rw----. 1 mysql mysql 50331648 Apr 23 11:45 ib_logfile0 -rw-rw----. 1 mysql mysql 50331648 Apr 19 12:12 ib_logfile1 drwx------. 2 mysql mysql 4096 Apr 19 12:12 mysql drwx------. 2 mysql mysql 4096 Apr 19 12:12 performance_schema srwxrwxrwx. 1 mysql mysql 0 Apr 23 11:43 sock drwx------. 2 mysql mysql 4096 Apr 23 11:45 test -rw-rw----. 1 mysql mysql 3282 Apr 19 14:41 ushastry-bin.000001 -rw-rw----. 1 mysql mysql 4423 Apr 23 11:43 ushastry-bin.000002 -rw-rw----. 1 mysql mysql 1473 Apr 23 11:45 ushastry-bin.000003 -rw-rw----. 1 mysql mysql 66 Apr 23 11:43 ushastry-bin.index -rw-r-----. 1 mysql root 71398 Apr 23 11:43 ushastry.err -rw-rw----. 1 mysql mysql 6 Apr 23 11:43 ushastry.pid [root@ushastry tmp]# [root@ushastry mysql-5.6.11-release]# bin/mysqld_safe --defaults-file=my_111.cnf --user=mysql & [1] 13814 [root@ushastry mysql-5.6.11-release]# 130423 11:51:52 mysqld_safe Logging to '/tmp/56111/ushastry.err'. 130423 11:51:52 mysqld_safe Starting mysqld daemon with databases from /tmp/56111 [root@ushastry mysql-5.6.11-release]# bin/mysql -u root -p --port=3306 --protocol=TCP test Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.11-debug-log Source distribution Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select version(); +------------------+ | version() | +------------------+ | 5.6.11-debug-log | +------------------+ 1 row in set (0.00 sec) mysql> show global variables like 'datadir'; +---------------+-------------+ | Variable_name | Value | +---------------+-------------+ | datadir | /tmp/56111/ | +---------------+-------------+ 1 row in set (0.01 sec) mysql> SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('DBMS' IN NATURAL LANGUAGE MODE); +----+----------------+------------------------------+ | id | title | body | +----+----------------+------------------------------+ | 1 | MySQL Tutorial | DBMS stands for DataBase ... | +----+----------------+------------------------------+ 1 row in set (0.03 sec) mysql> show create table articles\G *************************** 1. row *************************** Table: articles Create Table: CREATE TABLE `articles` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(200) DEFAULT NULL, `body` text, PRIMARY KEY (`id`), FULLTEXT KEY `title` (`title`,`body`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 1 row in set (0.00 sec) mysql> select @@innodb_ft_user_stopword_table; +---------------------------------+ | @@innodb_ft_user_stopword_table | +---------------------------------+ | NULL | +---------------------------------+ 1 row in set (0.00 sec) mysql> mysql> set global innodb_ft_user_stopword_table ="test/abc"; Query OK, 0 rows affected (0.00 sec) mysql> set session innodb_ft_user_stopword_table ="test/abc"; Query OK, 0 rows affected (0.00 sec) mysql> select @@innodb_ft_user_stopword_table; +---------------------------------+ | @@innodb_ft_user_stopword_table | +---------------------------------+ | test/abc | +---------------------------------+ 1 row in set (0.00 sec) mysql> SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('they' IN NATURAL LANGUAGE MODE); Empty set (0.00 sec) mysql> SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database' IN NATURAL LANGUAGE MODE); Empty set (0.00 sec) mysql> SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('DBMS' IN NATURAL LANGUAGE MODE); +----+----------------+------------------------------+ | id | title | body | +----+----------------+------------------------------+ | 1 | MySQL Tutorial | DBMS stands for DataBase ... | +----+----------------+------------------------------+ 1 row in set (0.00 sec) #######