Memindahkan folder database mysql ke folder lain


root@google ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda6 38G 1.7G 35G 5% /
/dev/sda8 34G 177M 32G 1% /tmp
/dev/sda5 76G 184M 72G 1% /home
[mysqld]
/dev/sda3 95G 754M 89G 1% /var
/dev/sda2 426G 623M 404G 1% /data
/dev/sda1 1.9G 48M 1.8G 3% /boot
tmpfs 7.9G 0 7.9G 0% /dev/shm
[root@google ~]# ps aux | grep mysql
root 617 0.0 0.0 63864 1252 pts/1 S 07:48 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
mysql 829 3.0 0.3 399076 62644 pts/1 Sl 07:49 0:29 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
root 1069 0.0 0.0 61172 672 pts/1 S+ 08:05 0:00 grep mysql
[root@google ~]# /etc/init.d/mysqld stop
Stopping mysqld: [ OK ]
[root@google ~]#
[root@google ~]#
[root@google ~]#
[root@google ~]#
[root@google ~]#
[root@google ~]#
[root@google ~]# cp /etc/my.cnf /etc/my.cnf_ori
[root@google ~]# vim /etc/my.cnf
my.cnf my.cnf_ori
[root@google ~]# vim /etc/my.cnf
[root@google ~]# cd /data/
[root@google data]# ls
activemq apache-activemq-5.6.0-bin.tar.gz lost+found yahoo_sys
[root@google data]# cp -r /var/lib/mysql .
[root@google data]# ls -ltrh /var/lib/mysql
total 29M
drwx------ 2 mysql mysql 4.0K Sep 20 20:11 mysql
-rw-rw---- 1 mysql mysql 5.0M Sep 20 20:11 ib_logfile1
drwx------ 2 mysql mysql 12K Oct 3 07:56 googlereply
drwx------ 2 mysql mysql 4.0K Oct 3 07:57 googlereplysms
-rw-rw---- 1 mysql mysql 18M Oct 3 08:05 ibdata1
-rw-rw---- 1 mysql mysql 5.0M Oct 3 08:05 ib_logfile0
[root@google data]# ls -ltrh /var/lib
total 200K
drwxr-xr-x 2 root root 4.0K May 25 2008 tpm
drwxr-xr-x 2 root root 4.0K Jul 14 2008 bluetooth
drwxr-xr-x 2 root root 4.0K Mar 6 2011 hal
drwxr-x--- 2 root root 4.0K Mar 6 2011 dhcpv6
drwxr-xr-x 2 root root 4.0K May 11 2011 misc
drwxr-xr-x 2 root root 4.0K May 11 2011 games
drwxr-xr-x 2 root root 4.0K Jul 22 2011 spamassassin
drwxr-xr-x 2 root root 4.0K Aug 12 2011 dbus
drwxr-xr-x 8 root root 4.0K Feb 23 2012 iscsi
drwxr-xr-x 2 root root 4.0K Apr 2 2012 multipath
drwx------ 2 apache apache 4.0K Jun 6 21:04 dav
drwxr-xr-x 2 root root 4.0K Aug 3 07:47 dhclient
drwxr-xr-x 3 root root 4.0K Aug 9 21:06 stateless
drwxr-xr-x 2 root root 4.0K Sep 20 19:43 sepolgen
drwxr-xr-x 3 news news 4.0K Sep 20 19:43 news
drwxr-xr-x 2 webalizer root 4.0K Sep 23 20:26 webalizer
drwxr-xr-x 5 root root 4.0K Oct 2 18:58 nfs
drwxr-xr-x 2 root root 4.0K Oct 2 19:00 alternatives
drwxr-xr-x 3 root root 4.0K Oct 2 21:51 php
-rw------- 1 root root 512 Oct 3 02:18 random-seed
-rw-r--r-- 1 root root 1.7K Oct 3 04:02 logrotate.status
drwxr-x--- 2 root slocate 4.0K Oct 3 04:02 mlocate
drwxr-xr-x 2 root root 4.0K Oct 3 06:57 rpm
drwxr-xr-x 2 root root 4.0K Oct 3 07:54 yum
drwxr-xr-x 5 mysql mysql 4.0K Oct 3 08:05 mysql
[root@google data]# ls -ltrh /var/lib/mysql
total 29M
drwx------ 2 mysql mysql 4.0K Sep 20 20:11 mysql
-rw-rw---- 1 mysql mysql 5.0M Sep 20 20:11 ib_logfile1
drwx------ 2 mysql mysql 12K Oct 3 07:56 googlereply
drwx------ 2 mysql mysql 4.0K Oct 3 07:57 googlereplysms
-rw-rw---- 1 mysql mysql 18M Oct 3 08:05 ibdata1
-rw-rw---- 1 mysql mysql 5.0M Oct 3 08:05 ib_logfile0
[root@google data]# ls -ltrh
total 47M
-rw-r--r-- 1 root root 47M May 7 16:50 apache-activemq-5.6.0-bin.tar.gz
drwx------ 2 root root 16K Sep 20 19:38 lost+found
drwxr-xr-x 5 root root 4.0K Sep 24 01:43 yahoo_sys
drwxr-xr-x 10 501 games 4.0K Oct 2 18:21 activemq
drwxr-xr-x 5 root root 4.0K Oct 3 08:07 mysql
[root@google data]# chown mysql:mysql mysql/ -R
[root@google data]# ls -ltrh
total 47M
-rw-r--r-- 1 root root 47M May 7 16:50 apache-activemq-5.6.0-bin.tar.gz
drwx------ 2 root root 16K Sep 20 19:38 lost+found
drwxr-xr-x 5 root root 4.0K Sep 24 01:43 yahoo_sys
drwxr-xr-x 10 501 games 4.0K Oct 2 18:21 activemq
drwxr-xr-x 5 mysql mysql 4.0K Oct 3 08:07 mysql
[root@google data]# cd mysql/
[root@google mysql]# ls -ltrh
total 29M
drwx------ 2 mysql mysql 4.0K Oct 3 08:07 mysql
drwx------ 2 mysql mysql 4.0K Oct 3 08:07 googlereplysms
drwx------ 2 mysql mysql 12K Oct 3 08:07 googlereply
-rw-r----- 1 mysql mysql 18M Oct 3 08:07 ibdata1
-rw-r----- 1 mysql mysql 5.0M Oct 3 08:07 ib_logfile1
-rw-r----- 1 mysql mysql 5.0M Oct 3 08:07 ib_logfile0
[root@google mysql]# chmod 550 ib*
[root@google mysql]# ls -ltrh
total 29M
drwx------ 2 mysql mysql 4.0K Oct 3 08:07 mysql
drwx------ 2 mysql mysql 4.0K Oct 3 08:07 googlereplysms
drwx------ 2 mysql mysql 12K Oct 3 08:07 googlereply
-r-xr-x--- 1 mysql mysql 18M Oct 3 08:07 ibdata1
-r-xr-x--- 1 mysql mysql 5.0M Oct 3 08:07 ib_logfile1
-r-xr-x--- 1 mysql mysql 5.0M Oct 3 08:07 ib_logfile0
[root@google mysql]# chmod 770 ib*
[root@google mysql]# ls -ltrh
total 29M
drwx------ 2 mysql mysql 4.0K Oct 3 08:07 mysql
drwx------ 2 mysql mysql 4.0K Oct 3 08:07 googlereplysms
drwx------ 2 mysql mysql 12K Oct 3 08:07 googlereply
-rwxrwx--- 1 mysql mysql 18M Oct 3 08:07 ibdata1
-rwxrwx--- 1 mysql mysql 5.0M Oct 3 08:07 ib_logfile1
-rwxrwx--- 1 mysql mysql 5.0M Oct 3 08:07 ib_logfile0
[root@google mysql]# chmod 660 ib*
[root@google mysql]# ls -ltrh
total 29M
drwx------ 2 mysql mysql 4.0K Oct 3 08:07 mysql
drwx------ 2 mysql mysql 4.0K Oct 3 08:07 googlereplysms
drwx------ 2 mysql mysql 12K Oct 3 08:07 googlereply
-rw-rw---- 1 mysql mysql 18M Oct 3 08:07 ibdata1
-rw-rw---- 1 mysql mysql 5.0M Oct 3 08:07 ib_logfile1
-rw-rw---- 1 mysql mysql 5.0M Oct 3 08:07 ib_logfile0
[root@google mysql]# cd mysql/
[root@google mysql]# ks
-bash: ks: command not found
[root@google mysql]# ls
columns_priv.MYD func.MYD help_keyword.MYD help_topic.MYD proc.MYD tables_priv.MYD time_zone_leap_second.MYD time_zone_transition.MYD user.MYD
columns_priv.MYI func.MYI help_keyword.MYI help_topic.MYI proc.MYI tables_priv.MYI time_zone_leap_second.MYI time_zone_transition.MYI user.MYI
columns_priv.frm func.frm help_keyword.frm help_topic.frm proc.frm tables_priv.frm time_zone_leap_second.frm time_zone_transition.frm user.frm
db.MYD help_category.MYD help_relation.MYD host.MYD procs_priv.MYD time_zone.MYD time_zone_name.MYD time_zone_transition_type.MYD
db.MYI help_category.MYI help_relation.MYI host.MYI procs_priv.MYI time_zone.MYI time_zone_name.MYI time_zone_transition_type.MYI
db.frm help_category.frm help_relation.frm host.frm procs_priv.frm time_zone.frm time_zone_name.frm time_zone_transition_type.frm
[root@google mysql]# ls -ltrh
total 824K
-rw-r----- 1 mysql mysql 11K Oct 3 08:07 user.frm
-rw-r----- 1 mysql mysql 2.0K Oct 3 08:07 user.MYI
-rw-r----- 1 mysql mysql 332 Oct 3 08:07 user.MYD
-rw-r----- 1 mysql mysql 8.6K Oct 3 08:07 time_zone_transition_type.frm
-rw-r----- 1 mysql mysql 1.0K Oct 3 08:07 time_zone_transition_type.MYI
-rw-r----- 1 mysql mysql 0 Oct 3 08:07 time_zone_transition_type.MYD
-rw-r----- 1 mysql mysql 8.5K Oct 3 08:07 time_zone_transition.frm
-rw-r----- 1 mysql mysql 1.0K Oct 3 08:07 time_zone_transition.MYI
-rw-r----- 1 mysql mysql 0 Oct 3 08:07 time_zone_transition.MYD
-rw-r----- 1 mysql mysql 8.5K Oct 3 08:07 time_zone_name.frm
-rw-r----- 1 mysql mysql 1.0K Oct 3 08:07 time_zone_name.MYI
-rw-r----- 1 mysql mysql 0 Oct 3 08:07 time_zone_name.MYD
-rw-r----- 1 mysql mysql 8.5K Oct 3 08:07 time_zone_leap_second.frm
-rw-r----- 1 mysql mysql 1.0K Oct 3 08:07 time_zone_leap_second.MYI
-rw-r----- 1 mysql mysql 0 Oct 3 08:07 time_zone_leap_second.MYD
-rw-r----- 1 mysql mysql 8.5K Oct 3 08:07 time_zone.frm
-rw-r----- 1 mysql mysql 1.0K Oct 3 08:07 time_zone.MYI
-rw-r----- 1 mysql mysql 0 Oct 3 08:07 time_zone.MYD
-rw-r----- 1 mysql mysql 8.8K Oct 3 08:07 tables_priv.frm
-rw-r----- 1 mysql mysql 1.0K Oct 3 08:07 tables_priv.MYI
-rw-r----- 1 mysql mysql 0 Oct 3 08:07 tables_priv.MYD
-rw-r----- 1 mysql mysql 8.7K Oct 3 08:07 procs_priv.frm
-rw-r----- 1 mysql mysql 1.0K Oct 3 08:07 procs_priv.MYI
-rw-r----- 1 mysql mysql 0 Oct 3 08:07 procs_priv.MYD
-rw-r----- 1 mysql mysql 9.5K Oct 3 08:07 proc.frm
-rw-r----- 1 mysql mysql 1.0K Oct 3 08:07 proc.MYI
-rw-r----- 1 mysql mysql 0 Oct 3 08:07 proc.MYD
-rw-r----- 1 mysql mysql 9.2K Oct 3 08:07 host.frm
-rw-r----- 1 mysql mysql 1.0K Oct 3 08:07 host.MYI
-rw-r----- 1 mysql mysql 0 Oct 3 08:07 host.MYD
-rw-r----- 1 mysql mysql 8.6K Oct 3 08:07 help_topic.frm
-rw-r----- 1 mysql mysql 17K Oct 3 08:07 help_topic.MYI
-rw-r----- 1 mysql mysql 381K Oct 3 08:07 help_topic.MYD
-rw-r----- 1 mysql mysql 8.5K Oct 3 08:07 help_relation.frm
-rw-r----- 1 mysql mysql 15K Oct 3 08:07 help_relation.MYI
-rw-r----- 1 mysql mysql 7.5K Oct 3 08:07 help_relation.MYD
-rw-r----- 1 mysql mysql 8.5K Oct 3 08:07 help_keyword.frm
-rw-r----- 1 mysql mysql 14K Oct 3 08:07 help_keyword.MYI
-rw-r----- 1 mysql mysql 78K Oct 3 08:07 help_keyword.MYD
-rw-r----- 1 mysql mysql 8.5K Oct 3 08:07 help_category.frm
-rw-r----- 1 mysql mysql 3.0K Oct 3 08:07 help_category.MYI
-rw-r----- 1 mysql mysql 21K Oct 3 08:07 help_category.MYD
-rw-r----- 1 mysql mysql 8.5K Oct 3 08:07 func.frm
-rw-r----- 1 mysql mysql 1.0K Oct 3 08:07 func.MYI
-rw-r----- 1 mysql mysql 0 Oct 3 08:07 func.MYD
-rw-r----- 1 mysql mysql 9.3K Oct 3 08:07 db.frm
-rw-r----- 1 mysql mysql 4.0K Oct 3 08:07 db.MYI
-rw-r----- 1 mysql mysql 876 Oct 3 08:07 db.MYD
-rw-r----- 1 mysql mysql 8.7K Oct 3 08:07 columns_priv.frm
-rw-r----- 1 mysql mysql 1.0K Oct 3 08:07 columns_priv.MYI
-rw-r----- 1 mysql mysql 0 Oct 3 08:07 columns_priv.MYD
[root@google mysql]# chmod 660 *
[root@google mysql]# ls -ltrh
total 824K
-rw-rw---- 1 mysql mysql 11K Oct 3 08:07 user.frm
-rw-rw---- 1 mysql mysql 2.0K Oct 3 08:07 user.MYI
-rw-rw---- 1 mysql mysql 332 Oct 3 08:07 user.MYD
-rw-rw---- 1 mysql mysql 8.6K Oct 3 08:07 time_zone_transition_type.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 08:07 time_zone_transition_type.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 08:07 time_zone_transition_type.MYD
-rw-rw---- 1 mysql mysql 8.5K Oct 3 08:07 time_zone_transition.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 08:07 time_zone_transition.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 08:07 time_zone_transition.MYD
-rw-rw---- 1 mysql mysql 8.5K Oct 3 08:07 time_zone_name.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 08:07 time_zone_name.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 08:07 time_zone_name.MYD
-rw-rw---- 1 mysql mysql 8.5K Oct 3 08:07 time_zone_leap_second.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 08:07 time_zone_leap_second.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 08:07 time_zone_leap_second.MYD
-rw-rw---- 1 mysql mysql 8.5K Oct 3 08:07 time_zone.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 08:07 time_zone.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 08:07 time_zone.MYD
-rw-rw---- 1 mysql mysql 8.8K Oct 3 08:07 tables_priv.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 08:07 tables_priv.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 08:07 tables_priv.MYD
-rw-rw---- 1 mysql mysql 8.7K Oct 3 08:07 procs_priv.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 08:07 procs_priv.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 08:07 procs_priv.MYD
-rw-rw---- 1 mysql mysql 9.5K Oct 3 08:07 proc.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 08:07 proc.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 08:07 proc.MYD
-rw-rw---- 1 mysql mysql 9.2K Oct 3 08:07 host.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 08:07 host.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 08:07 host.MYD
-rw-rw---- 1 mysql mysql 8.6K Oct 3 08:07 help_topic.frm
-rw-rw---- 1 mysql mysql 17K Oct 3 08:07 help_topic.MYI
-rw-rw---- 1 mysql mysql 381K Oct 3 08:07 help_topic.MYD
-rw-rw---- 1 mysql mysql 8.5K Oct 3 08:07 help_relation.frm
-rw-rw---- 1 mysql mysql 15K Oct 3 08:07 help_relation.MYI
-rw-rw---- 1 mysql mysql 7.5K Oct 3 08:07 help_relation.MYD
-rw-rw---- 1 mysql mysql 8.5K Oct 3 08:07 help_keyword.frm
-rw-rw---- 1 mysql mysql 14K Oct 3 08:07 help_keyword.MYI
-rw-rw---- 1 mysql mysql 78K Oct 3 08:07 help_keyword.MYD
-rw-rw---- 1 mysql mysql 8.5K Oct 3 08:07 help_category.frm
-rw-rw---- 1 mysql mysql 3.0K Oct 3 08:07 help_category.MYI
-rw-rw---- 1 mysql mysql 21K Oct 3 08:07 help_category.MYD
-rw-rw---- 1 mysql mysql 8.5K Oct 3 08:07 func.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 08:07 func.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 08:07 func.MYD
-rw-rw---- 1 mysql mysql 9.3K Oct 3 08:07 db.frm
-rw-rw---- 1 mysql mysql 4.0K Oct 3 08:07 db.MYI
-rw-rw---- 1 mysql mysql 876 Oct 3 08:07 db.MYD
-rw-rw---- 1 mysql mysql 8.7K Oct 3 08:07 columns_priv.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 08:07 columns_priv.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 08:07 columns_priv.MYD
[root@google mysql]# ls -ltrh /var/lib/
alternatives/ dbus/ games/ logrotate.status multipath/ nfs/ rpm/ stateless/ yum/
bluetooth/ dhclient/ hal/ misc/ mysql/ php/ sepolgen/ tpm/
dav/ dhcpv6/ iscsi/ mlocate/ news/ random-seed spamassassin/ webalizer/
[root@google mysql]# ls -ltrh /var/lib/mysql/
ibdata1 ib_logfile0 ib_logfile1 googlereply/ googlereplysms/ mysql/
[root@google mysql]# ls -ltrh /var/lib/mysql/
ibdata1 ib_logfile0 ib_logfile1 googlereply/ googlereplysms/ mysql/
[root@google mysql]# ls -ltrh /var/lib/mysql/mysql/
total 1.1M
-rw-rw---- 1 mysql mysql 11K Sep 20 20:11 user.frm
-rw-rw---- 1 mysql mysql 8.6K Sep 20 20:11 time_zone_transition_type.frm
-rw-rw---- 1 mysql mysql 1.0K Sep 20 20:11 time_zone_transition_type.MYI
-rw-rw---- 1 mysql mysql 0 Sep 20 20:11 time_zone_transition_type.MYD
-rw-rw---- 1 mysql mysql 8.5K Sep 20 20:11 time_zone_transition.frm
-rw-rw---- 1 mysql mysql 1.0K Sep 20 20:11 time_zone_transition.MYI
-rw-rw---- 1 mysql mysql 0 Sep 20 20:11 time_zone_transition.MYD
-rw-rw---- 1 mysql mysql 8.5K Sep 20 20:11 time_zone_name.frm
-rw-rw---- 1 mysql mysql 1.0K Sep 20 20:11 time_zone_name.MYI
-rw-rw---- 1 mysql mysql 0 Sep 20 20:11 time_zone_name.MYD
-rw-rw---- 1 mysql mysql 8.5K Sep 20 20:11 time_zone_leap_second.frm
-rw-rw---- 1 mysql mysql 8.5K Sep 20 20:11 time_zone.frm
-rw-rw---- 1 mysql mysql 1.0K Sep 20 20:11 time_zone.MYI
-rw-rw---- 1 mysql mysql 0 Sep 20 20:11 time_zone.MYD
-rw-rw---- 1 mysql mysql 8.8K Sep 20 20:11 tables_priv.frm
-rw-rw---- 1 mysql mysql 1.0K Sep 20 20:11 tables_priv.MYI
-rw-rw---- 1 mysql mysql 0 Sep 20 20:11 tables_priv.MYD
-rw-rw---- 1 mysql mysql 9.2K Sep 20 20:11 host.frm
-rw-rw---- 1 mysql mysql 1.0K Sep 20 20:11 host.MYI
-rw-rw---- 1 mysql mysql 0 Sep 20 20:11 host.MYD
-rw-rw---- 1 mysql mysql 8.6K Sep 20 20:11 help_topic.frm
-rw-rw---- 1 mysql mysql 8.5K Sep 20 20:11 help_relation.frm
-rw-rw---- 1 mysql mysql 8.5K Sep 20 20:11 help_keyword.frm
-rw-rw---- 1 mysql mysql 8.5K Sep 20 20:11 help_category.frm
-rw-rw---- 1 mysql mysql 8.5K Sep 20 20:11 func.frm
-rw-rw---- 1 mysql mysql 1.0K Sep 20 20:11 func.MYI
-rw-rw---- 1 mysql mysql 0 Sep 20 20:11 func.MYD
-rw-rw---- 1 mysql mysql 9.3K Sep 20 20:11 db.frm
-rw-rw---- 1 mysql mysql 8.7K Sep 20 20:11 columns_priv.frm
-rw-rw---- 1 mysql mysql 1.0K Sep 20 20:11 columns_priv.MYI
-rw-rw---- 1 mysql mysql 0 Sep 20 20:11 columns_priv.MYD
-rw-rw---- 1 mysql mysql 1.0K Sep 20 20:11 time_zone_leap_second.MYI
-rw-rw---- 1 mysql mysql 0 Sep 20 20:11 time_zone_leap_second.MYD
-rw-rw---- 1 mysql mysql 8.7K Sep 20 20:11 procs_priv.frm
-rw-rw---- 1 mysql mysql 1.0K Sep 20 20:11 procs_priv.MYI
-rw-rw---- 1 mysql mysql 0 Sep 20 20:11 procs_priv.MYD
-rw-rw---- 1 mysql mysql 9.5K Sep 20 20:11 proc.frm
-rw-rw---- 1 mysql mysql 1.0K Sep 20 20:11 proc.MYI
-rw-rw---- 1 mysql mysql 0 Sep 20 20:11 proc.MYD
-rw-rw---- 1 mysql mysql 17K Sep 20 20:11 help_topic.MYI
-rw-rw---- 1 mysql mysql 381K Sep 20 20:11 help_topic.MYD
-rw-rw---- 1 mysql mysql 15K Sep 20 20:11 help_relation.MYI
-rw-rw---- 1 mysql mysql 7.5K Sep 20 20:11 help_relation.MYD
-rw-rw---- 1 mysql mysql 14K Sep 20 20:11 help_keyword.MYI
-rw-rw---- 1 mysql mysql 78K Sep 20 20:11 help_keyword.MYD
-rw-rw---- 1 mysql mysql 3.0K Sep 20 20:11 help_category.MYI
-rw-rw---- 1 mysql mysql 21K Sep 20 20:11 help_category.MYD
-rw-rw---- 1 mysql mysql 332 Oct 3 07:51 user.MYD
-rw-rw---- 1 mysql mysql 876 Oct 3 07:51 db.MYD
-rw-rw---- 1 mysql mysql 2.0K Oct 3 08:05 user.MYI
-rw-rw---- 1 mysql mysql 4.0K Oct 3 08:05 db.MYI
[root@google mysql]# ls -ltrh /var/lib/mysql/
ibdata1 ib_logfile0 ib_logfile1 googlereply/ googlereplysms/ mysql/
[root@google mysql]# ls -ltrh /var/lib/mysql/
ibdata1 ib_logfile0 ib_logfile1 googlereply/ googlereplysms/ mysql/
[root@google mysql]# ls -ltrh /var/lib/mysql/googlereply
total 366M
-rw-rw---- 1 mysql mysql 65 Oct 3 07:50 db.opt
-rw-rw---- 1 mysql mysql 9.4K Oct 3 07:55 google_log_transaksi.frm
-rw-rw---- 1 mysql mysql 8.8K Oct 3 07:55 google_log_status.frm
-rw-rw---- 1 mysql mysql 2.0K Oct 3 07:55 google_log_status.MYI
-rw-rw---- 1 mysql mysql 480 Oct 3 07:55 google_log_status.MYD
-rw-rw---- 1 mysql mysql 8.9K Oct 3 07:55 google_inbox.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:55 google_inbox.MYI
-rw-rw---- 1 mysql mysql 166K Oct 3 07:55 google_inbox.MYD
-rw-rw---- 1 mysql mysql 8.6K Oct 3 07:55 google_host_priority.frm
-rw-rw---- 1 mysql mysql 2.0K Oct 3 07:55 google_host_priority.MYI
-rw-rw---- 1 mysql mysql 132 Oct 3 07:55 google_host_priority.MYD
-rw-rw---- 1 mysql mysql 8.5K Oct 3 07:55 google_history_status.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:55 google_history_status.MYI
-rw-rw---- 1 mysql mysql 31K Oct 3 07:55 google_history_status.MYD
-rw-rw---- 1 mysql mysql 8.5K Oct 3 07:55 google_history_block_number.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:55 google_history_block_number.MYI
-rw-rw---- 1 mysql mysql 160 Oct 3 07:55 google_history_block_number.MYD
-rw-rw---- 1 mysql mysql 8.6K Oct 3 07:55 google_group_product_fb.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:55 google_group_product_fb.MYI
-rw-rw---- 1 mysql mysql 116 Oct 3 07:55 google_group_product_fb.MYD
-rw-rw---- 1 mysql mysql 8.5K Oct 3 07:55 google_group_product_hd.frm
-rw-rw---- 1 mysql mysql 2.0K Oct 3 07:55 google_group_product_hd.MYI
-rw-rw---- 1 mysql mysql 536 Oct 3 07:55 google_group_product_hd.MYD
-rw-rw---- 1 mysql mysql 8.5K Oct 3 07:55 google_group_product_dt.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:55 google_group_product_dt.MYI
-rw-rw---- 1 mysql mysql 2.1K Oct 3 07:55 google_group_product_dt.MYD
-rw-rw---- 1 mysql mysql 8.6K Oct 3 07:55 google_group_product.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:55 google_group_product.MYI
-rw-rw---- 1 mysql mysql 3.7K Oct 3 07:55 google_group_product.MYD
-rw-rw---- 1 mysql mysql 8.6K Oct 3 07:55 google_fail_status.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:55 google_fail_status.MYI
-rw-rw---- 1 mysql mysql 86K Oct 3 07:55 google_fail_status.MYD
-rw-rw---- 1 mysql mysql 8.6K Oct 3 07:55 google_error_number.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:55 google_error_number.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 07:55 google_error_number.MYD
-rw-rw---- 1 mysql mysql 8.6K Oct 3 07:55 google_error.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:55 google_error.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 07:55 google_error.MYD
-rw-rw---- 1 mysql mysql 8.9K Oct 3 07:55 google_distributor.frm
-rw-rw---- 1 mysql mysql 2.0K Oct 3 07:55 google_distributor.MYI
-rw-rw---- 1 mysql mysql 3.5K Oct 3 07:55 google_distributor.MYD
-rw-rw---- 1 mysql mysql 8.7K Oct 3 07:55 google_cek_status.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:55 google_cek_status.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 07:55 google_cek_status.MYD
-rw-rw---- 1 mysql mysql 8.6K Oct 3 07:55 google_cek_adsense.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:55 google_cek_adsense.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 07:55 google_cek_adsense.MYD
-rw-rw---- 1 mysql mysql 8.5K Oct 3 07:55 google_block_number.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:55 google_block_number.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 07:55 google_block_number.MYD
-rw-rw---- 1 mysql mysql 8.7K Oct 3 07:55 google_application.frm
-rw-rw---- 1 mysql mysql 2.0K Oct 3 07:55 google_application.MYI
-rw-rw---- 1 mysql mysql 84 Oct 3 07:55 google_application.MYD
-rw-rw---- 1 mysql mysql 8.8K Oct 3 07:56 trx_generate_google.frm
-rw-rw---- 1 mysql mysql 8.4K Oct 3 07:56 test.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:56 test.MYI
-rw-rw---- 1 mysql mysql 3.4K Oct 3 07:56 test.MYD
-rw-rw---- 1 mysql mysql 9.5K Oct 3 07:56 temp_transaksi.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:56 temp_transaksi.MYI
-rw-rw---- 1 mysql mysql 492 Oct 3 07:56 temp_transaksi.MYD
-rw-rw---- 1 mysql mysql 8.7K Oct 3 07:56 temp_status_host_voucher.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:56 temp_status_host_voucher.MYI
-rw-rw---- 1 mysql mysql 480 Oct 3 07:56 temp_status_host_voucher.MYD
-rw-rw---- 1 mysql mysql 9.0K Oct 3 07:56 temp_inbox_station_error.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:56 temp_inbox_station_error.MYI
-rw-rw---- 1 mysql mysql 272 Oct 3 07:56 temp_inbox_station_error.MYD
-rw-rw---- 1 mysql mysql 9.0K Oct 3 07:56 temp_inbox_station.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:56 temp_inbox_station.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 07:56 temp_inbox_station.MYD
-rw-rw---- 1 mysql mysql 8.6K Oct 3 07:56 tbluser.frm
-rw-rw---- 1 mysql mysql 4.0K Oct 3 07:56 tbluser.MYI
-rw-rw---- 1 mysql mysql 348 Oct 3 07:56 tbluser.MYD
-rw-rw---- 1 mysql mysql 8.8K Oct 3 07:56 tblmodules.frm
-rw-rw---- 1 mysql mysql 2.0K Oct 3 07:56 tblmodules.MYI
-rw-rw---- 1 mysql mysql 2.1K Oct 3 07:56 tblmodules.MYD
-rw-rw---- 1 mysql mysql 8.6K Oct 3 07:56 tblloglogin.frm
-rw-rw---- 1 mysql mysql 7.0K Oct 3 07:56 tblloglogin.MYI
-rw-rw---- 1 mysql mysql 19K Oct 3 07:56 tblloglogin.MYD
-rw-rw---- 1 mysql mysql 8.5K Oct 3 07:56 tblgroupuser.frm
-rw-rw---- 1 mysql mysql 2.0K Oct 3 07:56 tblgroupuser.MYI
-rw-rw---- 1 mysql mysql 140 Oct 3 07:56 tblgroupuser.MYD
-rw-rw---- 1 mysql mysql 8.5K Oct 3 07:56 tblgroup.frm
-rw-rw---- 1 mysql mysql 2.0K Oct 3 07:56 tblgroup.MYI
-rw-rw---- 1 mysql mysql 156 Oct 3 07:56 tblgroup.MYD
-rw-rw---- 1 mysql mysql 8.6K Oct 3 07:56 tblaccessmodule.frm
-rw-rw---- 1 mysql mysql 5.0K Oct 3 07:56 tblaccessmodule.MYI
-rw-rw---- 1 mysql mysql 2.1K Oct 3 07:56 tblaccessmodule.MYD
-rw-rw---- 1 mysql mysql 8.6K Oct 3 07:56 google_success_status2.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:56 google_success_status2.MYI
-rw-rw---- 1 mysql mysql 63K Oct 3 07:56 google_success_status2.MYD
-rw-rw---- 1 mysql mysql 8.6K Oct 3 07:56 google_success_status.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:56 google_success_status.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 07:56 google_success_status.MYD
-rw-rw---- 1 mysql mysql 8.7K Oct 3 07:56 google_status_fb.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:56 google_status_fb.MYI
-rw-rw---- 1 mysql mysql 5.3K Oct 3 07:56 google_status_fb.MYD
-rw-rw---- 1 mysql mysql 8.7K Oct 3 07:56 google_status_transfer_host2.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:56 google_status_transfer_host2.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 07:56 google_status_transfer_host2.MYD
-rw-rw---- 1 mysql mysql 8.6K Oct 3 07:56 google_status_adsense.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:56 google_status_adsense.MYI
-rw-rw---- 1 mysql mysql 24K Oct 3 07:56 google_status_adsense.MYD
-rw-rw---- 1 mysql mysql 8.5K Oct 3 07:56 google_status_result_fb.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:56 google_status_result_fb.MYI
-rw-rw---- 1 mysql mysql 376 Oct 3 07:56 google_status_result_fb.MYD
-rw-rw---- 1 mysql mysql 8.7K Oct 3 07:56 google_status_host2.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:56 google_status_host2.MYI
-rw-rw---- 1 mysql mysql 7.6K Oct 3 07:56 google_status_host2.MYD
-rw-rw---- 1 mysql mysql 8.7K Oct 3 07:56 google_sms_voucher_adsense.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:56 google_sms_voucher_adsense.MYI
-rw-rw---- 1 mysql mysql 356K Oct 3 07:56 google_sms_voucher_adsense.MYD
-rw-rw---- 1 mysql mysql 8.5K Oct 3 07:56 google_respon_host.frm
-rw-rw---- 1 mysql mysql 5.0K Oct 3 07:56 google_respon_host.MYI
-rw-rw---- 1 mysql mysql 41K Oct 3 07:56 google_respon_host.MYD
-rw-rw---- 1 mysql mysql 9.4K Oct 3 07:56 google_reply_fb.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:56 google_reply_fb.MYI
-rw-rw---- 1 mysql mysql 808 Oct 3 07:56 google_reply_fb.MYD
-rw-rw---- 1 mysql mysql 8.5K Oct 3 07:56 google_reply_sms_type.frm
-rw-rw---- 1 mysql mysql 2.0K Oct 3 07:56 google_reply_sms_type.MYI
-rw-rw---- 1 mysql mysql 60 Oct 3 07:56 google_reply_sms_type.MYD
-rw-rw---- 1 mysql mysql 9.4K Oct 3 07:56 google_reply.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:56 google_reply.MYI
-rw-rw---- 1 mysql mysql 128 Oct 3 07:56 google_reply.MYD
-rw-rw---- 1 mysql mysql 8.6K Oct 3 07:56 google_product_fb.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:56 google_product_fb.MYI
-rw-rw---- 1 mysql mysql 364 Oct 3 07:56 google_product_fb.MYD
-rw-rw---- 1 mysql mysql 8.6K Oct 3 07:56 google_product.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:56 google_product.MYI
-rw-rw---- 1 mysql mysql 6.9K Oct 3 07:56 google_product.MYD
-rw-rw---- 1 mysql mysql 8.5K Oct 3 07:56 google_ref_operator.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:56 google_ref_operator.MYI
-rw-rw---- 1 mysql mysql 35K Oct 3 07:56 google_ref_operator.MYD
-rw-rw---- 1 mysql mysql 8.6K Oct 3 07:56 google_operator.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:56 google_operator.MYI
-rw-rw---- 1 mysql mysql 676 Oct 3 07:56 google_operator.MYD
-rw-rw---- 1 mysql mysql 8.8K Oct 3 07:56 google_nominal_voucher.frm
-rw-rw---- 1 mysql mysql 2.0K Oct 3 07:56 google_nominal_voucher.MYI
-rw-rw---- 1 mysql mysql 132 Oct 3 07:56 google_nominal_voucher.MYD
-rw-rw---- 1 mysql mysql 8.6K Oct 3 07:56 google_modem.frm
-rw-rw---- 1 mysql mysql 2.0K Oct 3 07:56 google_modem.MYI
-rw-rw---- 1 mysql mysql 508 Oct 3 07:56 google_modem.MYD
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:56 google_log_transaksi.MYI
-rw-rw---- 1 mysql mysql 350M Oct 3 07:56 google_log_transaksi.MYD
-rw-rw---- 1 mysql mysql 8.7K Oct 3 07:56 trx_smsreply.frm
-rw-rw---- 1 mysql mysql 2.0K Oct 3 07:56 trx_smsreply.MYI
-rw-rw---- 1 mysql mysql 9.3K Oct 3 07:56 trx_smsreply.MYD
-rw-rw---- 1 mysql mysql 9.4K Oct 3 07:56 trx_generate_fb.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:56 trx_generate_fb.MYI
-rw-rw---- 1 mysql mysql 3.5K Oct 3 07:56 trx_generate_fb.MYD
-rw-rw---- 1 mysql mysql 581K Oct 3 07:56 trx_generate_google.MYI
-rw-rw---- 1 mysql mysql 13M Oct 3 07:56 trx_generate_google.MYD
[root@google mysql]# ls -ltrh /var/lib/mysql/googlereplysms/
total 2.1M
-rw-rw---- 1 mysql mysql 65 Oct 3 07:50 db.opt
-rw-rw---- 1 mysql mysql 8.4K Oct 3 07:57 test.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:57 test.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 07:57 test.MYD
-rw-rw---- 1 mysql mysql 9.3K Oct 3 07:57 sentitems_backup.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:57 sentitems_backup.MYI
-rw-rw---- 1 mysql mysql 1.5M Oct 3 07:57 sentitems_backup.MYD
-rw-rw---- 1 mysql mysql 9.3K Oct 3 07:57 sentitems.frm
-rw-rw---- 1 mysql mysql 4.0K Oct 3 07:57 sentitems.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 07:57 sentitems.MYD
-rw-rw---- 1 mysql mysql 8.8K Oct 3 07:57 phones.frm
-rw-rw---- 1 mysql mysql 2.0K Oct 3 07:57 phones.MYI
-rw-rw---- 1 mysql mysql 1.9K Oct 3 07:57 phones.MYD
-rw-rw---- 1 mysql mysql 8.4K Oct 3 07:57 pbk_groups.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:57 pbk_groups.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 07:57 pbk_groups.MYD
-rw-rw---- 1 mysql mysql 8.5K Oct 3 07:57 pbk.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:57 pbk.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 07:57 pbk.MYD
-rw-rw---- 1 mysql mysql 8.7K Oct 3 07:57 outbox_multipart.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:57 outbox_multipart.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 07:57 outbox_multipart.MYD
-rw-rw---- 1 mysql mysql 9.2K Oct 3 07:57 outbox.frm
-rw-rw---- 1 mysql mysql 4.0K Oct 3 07:57 outbox.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 07:57 outbox.MYD
-rw-rw---- 1 mysql mysql 8.9K Oct 3 07:57 inbox_backup.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:57 inbox_backup.MYI
-rw-rw---- 1 mysql mysql 357K Oct 3 07:57 inbox_backup.MYD
-rw-rw---- 1 mysql mysql 8.9K Oct 3 07:57 inbox.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:57 inbox.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 07:57 inbox.MYD
-rw-rw---- 1 mysql mysql 8.4K Oct 3 07:57 kannel.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:57 kannel.MYI
-rw-rw---- 1 mysql mysql 7 Oct 3 07:57 kannel.MYD
-rw-rw---- 1 mysql mysql 8.4K Oct 3 07:57 daemons.frm
-rw-rw---- 1 mysql mysql 1.0K Oct 3 07:57 daemons.MYI
-rw-rw---- 1 mysql mysql 0 Oct 3 07:57 daemons.MYD
[root@google mysql]# pwd
/data/mysql/mysql
[root@google mysql]# ls
columns_priv.MYD func.MYD help_keyword.MYD help_topic.MYD proc.MYD tables_priv.MYD time_zone_leap_second.MYD time_zone_transition.MYD user.MYD
columns_priv.MYI func.MYI help_keyword.MYI help_topic.MYI proc.MYI tables_priv.MYI time_zone_leap_second.MYI time_zone_transition.MYI user.MYI
columns_priv.frm func.frm help_keyword.frm help_topic.frm proc.frm tables_priv.frm time_zone_leap_second.frm time_zone_transition.frm user.frm
db.MYD help_category.MYD help_relation.MYD host.MYD procs_priv.MYD time_zone.MYD time_zone_name.MYD time_zone_transition_type.MYD
db.MYI help_category.MYI help_relation.MYI host.MYI procs_priv.MYI time_zone.MYI time_zone_name.MYI time_zone_transition_type.MYI
db.frm help_category.frm help_relation.frm host.frm procs_priv.frm time_zone.frm time_zone_name.frm time_zone_transition_type.frm
[root@google mysql]# cd ..
[root@google mysql]# ls
ib_logfile0 ib_logfile1 ibdata1 googlereply googlereplysms mysql
[root@google mysql]# cd googlereply
[root@google googlereply]# chmod 660 *
[root@google googlereply]# cd ..
[root@google mysql]# cd googlereplysms/
[root@google googlereplysms]# chmod 660 *
[root@google googlereplysms]# /etc/init.d/mysqld start
touch: cannot touch `/data/log/mysqld.log': No such file or directory
chown: cannot access `/data/log/mysqld.log': No such file or directory
chmod: cannot access `/data/log/mysqld.log': No such file or directory
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
[root@google googlereplysms]# mkdir -p /data/log/
[root@google googlereplysms]# chown mysql:mysql /data/log
[root@google googlereplysms]# chmod 777 /data/log/
[root@google googlereplysms]# /etc/init.d/mysqld start
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
[root@google googlereplysms]# cat /etc/my.cnf
[mysqld]
# Settings user and group are ignored when systemd is used (fedora >= 15).
# If you need to run mysqld under different user or group,
# customize your systemd unit file for mysqld according to the
# instructions in http://fedoraproject.org/wiki/Systemd
user=mysql

datadir=/data/mysql
socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

old_passwords=1
# max_connections=350
# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0
skip-name-resolve
max_allowed_packet=1024M
max_connections=500
max_user_connections=500
table_cache=1200
innodb_buffer_pool_size = 256M
# Semisynchronous Replication
# http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html
# uncomment next line on MASTER
;plugin-load=rpl_semi_sync_master=semisync_master.so
# uncomment next line on SLAVE
;plugin-load=rpl_semi_sync_slave=semisync_slave.so

# Others options for Semisynchronous Replication
;rpl_semi_sync_master_enabled=1
;rpl_semi_sync_master_timeout=10
;rpl_semi_sync_slave_enabled=1

# http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html
;performance_schema

[mysqld_safe]
log-error=/data/log/mysqld.log
pid-file=/data/mysqld/mysqld.pid
[root@google googlereplysms]# cat /data/log/mysqld.log
121003 08:11:15 mysqld_safe Starting mysqld daemon with databases from /data/mysql
121003 8:11:15 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
121003 8:11:15 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
121003 8:11:15 InnoDB: The InnoDB memory heap is disabled
121003 8:11:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121003 8:11:15 InnoDB: Compressed tables use zlib 1.2.3
121003 8:11:15 InnoDB: Using Linux native AIO
121003 8:11:15 InnoDB: Initializing buffer pool, size = 256.0M
121003 8:11:15 InnoDB: Completed initialization of buffer pool
121003 8:11:15 InnoDB: highest supported file format is Barracuda.
121003 8:11:15 InnoDB: Waiting for the background threads to start
121003 8:11:16 InnoDB: 1.1.8 started; log sequence number 1588761
121003 8:11:16 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
121003 8:11:16 [Note] - '0.0.0.0' resolves to '0.0.0.0';
121003 8:11:16 [Note] Server socket created on IP: '0.0.0.0'.
121003 8:11:16 [ERROR] /usr/libexec/mysqld: Can't create/write to file '/data/mysqld/mysqld.pid' (Errcode: 2)
121003 8:11:16 [ERROR] Can't start server: can't create PID file: No such file or directory
121003 08:11:16 mysqld_safe mysqld from pid file /data/mysqld/mysqld.pid ended
[root@google googlereplysms]# mkdir /data/mysqld
[root@google googlereplysms]# chown mysql:mysql /data/mysqld
[root@google googlereplysms]# /etc/init.d/mysqld start
Starting mysqld: [ OK ]
[root@google googlereplysms]# ps aux | grep mysql
root 1856 0.2 0.0 63864 1252 pts/1 S 08:12 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/data/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/data/mysqld/mysqld.pid --basedir=/usr --user=mysql
mysql 2134 0.4 0.3 516640 50024 pts/1 Sl 08:12 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/data/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/data/log/mysqld.log --pid-file=/data/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
root 2166 0.0 0.0 61172 668 pts/1 S+ 08:12 0:00 grep mysql
[root@google googlereplysms]# mysql -ugooglek3r3n -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.28 MySQL Community Server (GPL) by Remi

Copyright (c) 2000, 2012, 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> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| googlereply |
| googlereplysms |
+--------------------+
3 rows in set (0.00 sec)

mysql> use googlereply
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+---------------------------+
| Tables_in_googlereply |
+---------------------------+
| google_application |
| google_block_number |
| google_cek_adsense |
| google_cek_status |
| google_distributor |
| google_error |
| google_error_number |
| google_fail_status |
| google_group_product |
| google_group_product_dt |
| google_group_product_hd |
| google_group_product_fb |
| google_history_block_number |
| google_history_status |
| google_host_priority |
| google_inbox |
| google_log_status |
| google_log_transaksi |
| google_modem |
| google_nominal_voucher |
| google_operator |
| google_ref_operator |
| google_product |
| google_product_fb |
| google_reply |
| google_reply_sms_type |
| google_reply_fb |
| google_respon_host |
| google_sms_voucher_adsense |
| google_status_host2 |
| google_status_result_fb |
| google_status_adsense |
| google_status_transfer_host2 |
| google_status_fb |
| google_success_status |
| google_success_status2 |
| tblaccessmodule |
| tblgroup |
| tblgroupuser |
| tblloglogin |
| tblmodules |
| tbluser |
| temp_inbox_station |
| temp_inbox_station_error |
| temp_status_host_voucher |
| temp_transaksi |
| test |
| trx_generate_google |
| trx_generate_fb |
| trx_smsreply |
+---------------------------+
50 rows in set (0.00 sec)

mysql> sbow tables;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sbow tables' at line 1
mysql> show tables;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s