node9
09-19-2001, 06:29 PM
Hi guys
to put my question in a simple form
mysql was installed on my server, and lets just say, the configuration was messed, and the whole desgiend/setup was no good.... BUT THE db's were
the db's were in /usr/local/mysql/var/*
drwx------ 2 root root 4.0k Sep 19 15:05 bettorstalk
-rw-r----- 1 root root 86 Sep 19 15:05 host-bin.001
-rw-r----- 1 root root 86 Sep 19 15:05 host-bin.002
-rw-r----- 1 root root 0 Sep 19 15:05 host-bin.003
-rw-r----- 1 root root 0 Sep 19 15:05 host-bin.004
-rw-r----- 1 root root 0 Sep 19 15:05 host-bin.005
-rw-r----- 1 root root 0 Sep 19 15:05 host-bin.006
-rw-r----- 1 root root 1.5k Sep 19 15:05 host-bin.007
-rw-r----- 1 root root 13M Sep 19 15:05 host-bin.008
-rw-r----- 1 root root 6.7M Sep 19 15:05 host-bin.009
-rw-r----- 1 root root 73 Sep 19 15:05 host-bin.010
-rw-r----- 1 root root 727k Sep 19 15:05 host-bin.011
-rw-r----- 1 root root 6.0M Sep 19 15:05 host-bin.012
-rw-r----- 1 root root 903k Sep 19 15:05 host-bin.013
-rw-r----- 1 root root 22k Sep 19 15:05 host-bin.014
-rw-r----- 1 root root 4.3M Sep 19 15:05 host-bin.015
-rw-r----- 1 root root 0 Sep 19 15:05 host-bin.016
-rw-r----- 1 root root 0 Sep 19 15:05 host-bin.017
-rw-r----- 1 root root 0 Sep 19 15:05 host-bin.018
-rw-r----- 1 root root 0 Sep 19 15:05 host-bin.019
-rw-r----- 1 root root 0 Sep 19 15:05 host-bin.020
-rw-r----- 1 root root 165 Sep 19 15:05 host-bin.index
-rw-r--r-- 1 root root 23k Sep 19 15:05 host.bettorstalk.com.err
-rw-r----- 1 root root 5 Sep 19 15:05 host.bettorstalk.com.pid
drwx------ 2 root root 4.0k Sep 19 15:05 juleswins
drwx------ 2 root root 4.0k Sep 19 15:05 mysql
-rw-r--r-- 1 root root 21 Sep 19 15:05 pwd.txt
drwx------ 2 root root 4.0k Sep 19 15:05 test
i ran cp -Rf /usr/local/mysql/var /backup
so basically, ive backed up the entire var directory
i just totally removed mysql
after removing it i went and downloaded and installed the latest mysql source, i am now at this step
shell> chgrp -R mysql /usr/local/mysql
shell> cp support-files/my-medium.cnf /etc/my.cnf
shell> /usr/local/mysql/bin/safe_mysqld --user=mysql &
my question is this
do i set the password to mysql, and then replace the fresh, default, new /usr/local/mysql/var with the OLD /backup/var ? or do i just replace the DIR's
or what?
would it still work?
help plz
=\
to put my question in a simple form
mysql was installed on my server, and lets just say, the configuration was messed, and the whole desgiend/setup was no good.... BUT THE db's were
the db's were in /usr/local/mysql/var/*
drwx------ 2 root root 4.0k Sep 19 15:05 bettorstalk
-rw-r----- 1 root root 86 Sep 19 15:05 host-bin.001
-rw-r----- 1 root root 86 Sep 19 15:05 host-bin.002
-rw-r----- 1 root root 0 Sep 19 15:05 host-bin.003
-rw-r----- 1 root root 0 Sep 19 15:05 host-bin.004
-rw-r----- 1 root root 0 Sep 19 15:05 host-bin.005
-rw-r----- 1 root root 0 Sep 19 15:05 host-bin.006
-rw-r----- 1 root root 1.5k Sep 19 15:05 host-bin.007
-rw-r----- 1 root root 13M Sep 19 15:05 host-bin.008
-rw-r----- 1 root root 6.7M Sep 19 15:05 host-bin.009
-rw-r----- 1 root root 73 Sep 19 15:05 host-bin.010
-rw-r----- 1 root root 727k Sep 19 15:05 host-bin.011
-rw-r----- 1 root root 6.0M Sep 19 15:05 host-bin.012
-rw-r----- 1 root root 903k Sep 19 15:05 host-bin.013
-rw-r----- 1 root root 22k Sep 19 15:05 host-bin.014
-rw-r----- 1 root root 4.3M Sep 19 15:05 host-bin.015
-rw-r----- 1 root root 0 Sep 19 15:05 host-bin.016
-rw-r----- 1 root root 0 Sep 19 15:05 host-bin.017
-rw-r----- 1 root root 0 Sep 19 15:05 host-bin.018
-rw-r----- 1 root root 0 Sep 19 15:05 host-bin.019
-rw-r----- 1 root root 0 Sep 19 15:05 host-bin.020
-rw-r----- 1 root root 165 Sep 19 15:05 host-bin.index
-rw-r--r-- 1 root root 23k Sep 19 15:05 host.bettorstalk.com.err
-rw-r----- 1 root root 5 Sep 19 15:05 host.bettorstalk.com.pid
drwx------ 2 root root 4.0k Sep 19 15:05 juleswins
drwx------ 2 root root 4.0k Sep 19 15:05 mysql
-rw-r--r-- 1 root root 21 Sep 19 15:05 pwd.txt
drwx------ 2 root root 4.0k Sep 19 15:05 test
i ran cp -Rf /usr/local/mysql/var /backup
so basically, ive backed up the entire var directory
i just totally removed mysql
after removing it i went and downloaded and installed the latest mysql source, i am now at this step
shell> chgrp -R mysql /usr/local/mysql
shell> cp support-files/my-medium.cnf /etc/my.cnf
shell> /usr/local/mysql/bin/safe_mysqld --user=mysql &
my question is this
do i set the password to mysql, and then replace the fresh, default, new /usr/local/mysql/var with the OLD /backup/var ? or do i just replace the DIR's
or what?
would it still work?
help plz
=\
