Re: where is my data?

, Kaustubh Original Message Follows From: Michael Stassen <[EMAIL PROTECTED]> To: "kaustubh shinde" <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: where is my data? Date: Mon, 04 Apr 2005 12:45:04 -0400 On Apr 2, 2005, at 7:58 AM, kaustubh shinde wrote: Hi, I h

Re: where is my data?

On Apr 2, 2005, at 7:58 AM, kaustubh shinde wrote: Hi, I have suse 9.2 and MySQL 4.21 My basedir is /var/lib/mysql datadir /data/mysql/mysqldata As it stands now, mysqld_safe is broken when you move your data directory, so this may cause problems. (See bug 7249

Re: where is my data?

Thank you very much. that was a real life saver. u rock :) Regards Kaustubh Original Message Follows From: Thomas Spahni <[EMAIL PROTECTED]> To: kaustubh shinde <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: where is my data? Date: Mon, 4 Apr 2005 12:03:05 +02

Re: where is my data?

Hello. You may specify the configuration file to mysqld_safe with --defaults-file command line option. `basedir` variable points to location of MySQL installation. Have you installed MySQL to /var/lib/mysql? When you'll be able to login to the server, what does the following statement produc

Re: where is my data?

Hi, check the script /etc/rc.d/mysql which is the SuSE equivalent to mysqld_safe. That's where they set datadir= and you have to change this to reflect your new path. Change the paths to the socket and pid file as well. There should be no problem to move all data to a new place and start the ser

where is my data?

Hi, I have suse 9.2 and MySQL 4.21 My basedir is /var/lib/mysql datadir /data/mysql/mysqldata Both the directories and subdirectories and files are owned by user mysq,l group mysql with rights 755. So I guess I have got the permissions part right or so I hope. Everything was working fine till I d