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

Reply via email to