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*
-- Brant Fitzsimmons [EMAIL PROTECTED] ------------------------------------------------------------------- Linux user #322847 | Linux machine #207465 | http://counter.li.org/ Mandrake 10.1 for i586, kernel 2.6.8.1-24mdk 14:20:00 up 17 days, 11:52, 1 user, load average: 1.08, 0.89, 0.67 ------------------------------------------------------------------- "Press on: nothing in the world can take the place of perseverance. Talent will not; nothing is more common than unsuccessful men with talent. Genius will not; unrewarded genius is almost a proverb. Education will not; the world is full of educated derelicts. Persistence and determination alone are omnipotent." -Calvin Coolidge
____________________________________________________ Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com ____________________________________________________
