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 server
Thanks 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?
Take a look at:
http://dev.mysql.com/doc/mysql/en/option-files.html
This will describe the my.cnf file at its available options. If the file exist it will be read and override default mysql options.
For example, here is my file:
<start example file> [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock
[mysql.server] user=mysql basedir=/var/lib
[safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid <end example file>
On the server this came from it is pretty default.
HTH
-- Thanks,
David
____________________________________________________ Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com ____________________________________________________