Hello,
On Tue, 31 Mar 2009, an unexpectedly combative :-) balachandar muruganantham
wrote:
> 1. if i am asking for control panel access rather than ssh, you should think
> why i am asking for that.
If you read my original mail, I was asking what "control panel access"
is. I have no idea what it is so I have no basis for comparison. If
you tell me that it (CPA) is easier for you than typing commands from
the shell then I have to believe you.
> for me data is important and my aim is to fix the site ASAP. hence i
> was looking for control panel access.
Here is what I learned about recovering data that is stored in a mysql
data base. (Note: I have only recently started using mysql since we
are testing drupal for some internal operations at IMSc.)
A command like:
mysqldump --add-drop-tables --defaults-file=./mysql.cnf \
{name_of_db} | gzip -9 > output.sql.gz
will allow you to dump the entire sql command set to create the data
base to output.sql. The "mysql.cnf" file should specify the name of
the database server and the user/password for accessing the database
name_of_db on the server. So as long as you have sufficient _local_
disk space and reasonable bandwidth between your local machine and the
db server you can get your data.
Using ssh and standard shell commands you can also login from machine
A to dump the database from server B and send the output to machine
C.
Regards,
Kapil.
P.S. I suppose one can do a lot of work in FOSS without learning mysql
but I really doubt that doing remote FOSS site management without
learning ssh is a good idea. People should really learn to use ssh
well --- almost immediately after learning '(ba)sh' well! :-) It only
takes 15-30 minutes to follow one of the many tutorials on ssh.
--
_______________________________________________
To unsubscribe, email [email protected] with
"unsubscribe <password> <address>"
in the subject or body of the message.
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
