On Wednesday 16 February 2005 08:48 pm, Gleb Paharenko wrote: > Hello. > > Please tell us, in what way do you launch your MySQL server. > Send your configuration file. > > > sql running as root. When I log on as root and look at the users, I do > > not see a mysql user. Do I need to create this user and what permissions > > does it > > Log on into the server and use 'ps aux' command to check under what user > account mysqld running is. Look into /etc/passwd file to check that mysql > user is present on your system. > > > the host database,etc. can these be copied to my new Linux enviroment or > > is it best to rebuild everything? > > I think you should, dump your data from the live windows server with the > mysqldump program (if you don't have such, setup it and copy tables to its > data directory). And then, import your data from the dump file into the new > Linux server. > > Russ <[EMAIL PROTECTED]> wrote: > > I have two questions: > > 1) I'm still having trouble getting mysql to run as user mysql. All the > > file and folders have been changed to be owned by user mysql but phpadmin > > shows my sql running as root. When I log on as root and look at the > > users, I do not see a mysql user. Do I need to create this user and what > > permissions does it need? How can the files and folders be owned by a > > user if they do not exist? > > > > 2) When my windows environment died I was unable to dump mysql. I was > > able to recover the Data files for both tables I had (.myd, .myi and > > .frm) Also for the host database,etc. can these be copied to my new Linux > > enviroment or is it best to rebuild everything? > > > > Thanks in advance for any help!! > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > <___/ www.mysql.com
-- I got my data working. I couldn't dump it since my whole windows environment went belly up. Everytime I tried and program or command my system hung. Had to do a complete format and install XP only to be able to support my wife's system. I'm now 100% Linux except for TurboTax. I will look into your other suggestions. Russ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]