You should paste all your error messages here. On Jan 4, 2008 7:29 PM, Vitaliy Okulov <[EMAIL PROTECTED]> wrote:
> You must copy all files from old location, probably /var/lib/mysql to > /data/mysqldata/. > Also open your mysql error log file & read it. > > > 2008/1/4, Krishna Chandra Prajapati <[EMAIL PROTECTED]>: > > > > Hi All, > > > > I was trying to change the data directory of mysql on debian. I have > added > > two thins in my.cnf > > innodb_data_home_dir = /data/mysqldata/ > > datadir = /data/mysqldata/ > > > > Then restarted mysql server. mysql shows there is no innodb storage > engine > > available. after then i again verified my.cnf. all skip-innodb is > > commented. > > I don't understand whats screwy is going on. Same thing i have tested on > > linux fedora its works properly. Whats wrong with debian. > > > > Thanks, > > -- > > Krishna Chandra Prajapati > > > -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn