Re: Can't seem to use a different datadir....

2003-01-22 Thread Salam Baker Shanawa
If you haven't done this: run "mysql_install_db" to create the privilege tables db, host, user in "mysql" directory below the new directory. The script 'll create the test directories too. Regards Salam [EMAIL PROTECTED] wrote: Hi. Anyone know the trick to successfully using a different

Re: Can't seem to use a different datadir....

2003-01-22 Thread gerald_clark
Well, what does the log say? You did copy the mysql database into the new directory? [EMAIL PROTECTED] wrote: Hi. Anyone know the trick to successfully using a different directory for database files? I've tried changing my.cnf and also using the command line option. When I run mysqld_safe it

Re: Can't seem to use a different datadir....

2003-01-22 Thread Harmen Houtman
If you leave the parameter innodb_data_home_dir empty, you can specify absolute file paths in the parameter innodb_data_file_path: innodb_data_home_dir = innodb_data_file_path = /ibdata/ibdata1:988M;/disk2/ibdata2:50M:autoextend See http://www.mysql.com/doc/en/InnoDB_start.html Harmen. Quotin

Can't seem to use a different datadir....

2003-01-22 Thread jweeks
Hi. Anyone know the trick to successfully using a different directory for database files? I've tried changing my.cnf and also using the command line option. When I run mysqld_safe it says it's using the new directory but then writes "mysqld ended" and quits. Mysql never comes up. I changed