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]