On Thursday 17 February 2005 15:04, David G Stevenson wrote:
> Brant Fitzsimmons wrote:
> > SOTL wrote:
> >> Hi All
> >>
> >> As some of you are aware I started last week trying to make a data
> >> base using MySQL.
> >>
> >> I that light I have a nice book, some book examples, and questions
> >> that are not answered in the book.
> >>
> >> This computer is set up with all data located on a separate partition
> >> called /home/trunk/Common_Data which allows both the Linux and MS OS
> >> to see the data.. Yea I know strange location not using
> >> /mnt/Common_Data/{file name or directory} but I like it that way.
> >> Anyway I would like to place my data bases in the same location.
> >>
> >> Currently when I create a db it is located in /var/lib/mysql/{file
> >> name} so I preceded to copy one of the db I had made called "testdb"
> >> to my desired location. Then I tried to access "testdb" or as the db
> >> people say connect to "testdb".
> >> Anyway I tried the following
> >>
> >> use /home/trunk/Common_Data/testdb
> >>
> >> plus a few variations of this eachtime receiving the response that the
> >> db which MC says exist does not exist.
> >>
> >> Would some kind person please explain how one creates, connects, and
> >> uses a db in any other directory except /var/lib/mysql/*.
> >>
> >> Thanks
> >>
> >> Frank
> >
> > All of the following must be done as root.
> >
> > Turn off your mysql server process:
> >
> > *# service mysql stop
> >
> > *Copy your databases to the new location:
> >
> > *# cp -a /var/lib/mysql /home/trunk/Common_Data/
> >
> > *Rename your current mysql directory to keep it safe until you know that
> > your changes are working properly:
> >
> > *# mv /var/lib/mysql /var/lib/mysql_backup_20050217
> >
> > *Create a symlink in /var/lib/ to the new location:
> >
> > *# ln -s **/home/trunk/Common_Data/mysql /var/lib/mysql
> >
> > *Restart the server:
> >
> > *# service mysql start*
>
> or,
>
> stop mysql server,
>
> edit /etc/my.cnf
>
> change,
>
> datadir=/var/lib/mysql
>
> to
>
> datadir=/home/trunk/Common_Data/
>
> move the data to new location (including the system mysql database)
>
> then restart mysql serverThanks for the help I just checked and my version of Mandrake 10.1 does not have a file /etc/my.cnf Is that correct or am I missing something in my installation? If so whit should I do? Should I just generate the file with the above configuration parameters in it? If so am I missing other configuration parameters? Thanks Frank
____________________________________________________ Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com ____________________________________________________
