Re: archive data

[Paride De Gasperis]

Copy database directory in another location (ex. /db/data). This path must 
contains
your databases directories...
/db
--- /data
 --- /mysql
  --- data file...
  --- data file...
  --- data file...
  --- data file...
 --- /test
 --- /YourDB1
  --- data file...
  --- data file...
  --- data file...
 --- /YourDB2
  --- data file...
  --- data file...
  --- data file...

ecc ecc ecc...

Then change the base data directory to /db/data.
Settings are in the mysql.server script file, used for starting and 
stopping the service, usually
placed in your rc.d directory... RedHat has a complex service management 
policies and you will
find the script in rc.3, rc.4 or rc.5 directory in /etc/rc.d...
IMPORTANT: when you change the base data dir into file script you must 
create /db/data directories first
and set them correct permission. You simply change the owner of directories 
to mysql user.

Regards... :-)

hi,

i am using linux redhat 8 to power mysql. i installed mysql version 4.0.13
using rpm package. by default, the data file of mysql is alocated at
/var/lib/mysql, but i have a limited of diskspace of /var dir (it is about
1G), so, it was easily full loaded with data. now, i want to archive the
data into another dir. how can i switch the dir such that, i can have a
spacious diskspace to store my data. now, i am facing a problem that i cant
write into the db because of the no diskspace left.
how can i archive my data, then, switch the storing location to another dir
(previously it was /var/lib/mysql) which has bigger diskspace. then, restore
the data. how can i do this? pls, advise. thanks
Cheers,
yenonn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problems storing SHA1 Hash

[Paride De Gasperis]

Hello all,
I have a problem storing an SHA1 hash generated as user password for an application...
This is the original SELECT Command:
INSERT INTO Auth$ VALUES ('System', 
'%X;Z(B9?(?U?NE?$03?#j???-#N?[.6?^?', 3)
but the stored values are:
%X;Z(B9?(?U?NE?$03?#j???-#N?[.6?^?
this differes from the original in some characters and the password check fails...
I've tryed changing the table field in some ways but TEXT, BLOB, VARCHAR settings 
produces the same results...
Why?!?!? Anyone can help me?!?!

Thanks a lot for help...





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]