shell access

[Egg]

okay, I now have got shell access to my server.

how do I go about downloading the database??

firstly, how do I go about using the shell access?? I dont even know ow to access it as yet.... any pointers gratefully received

Egg

[Egg]

ok, have worked out how to get into it, using a ssh client.

now, what do I need to type to dump the DB???

[Spaceman-Spiff]

u can make dump files using phpmyadmin, it will be easier

[Egg]

phpmyadmin wont do it. it times out

ref http://www.yabbse.org/community/index.php?board=140;action=display;threadid=17776;start=0

[[Unknown]]

mysqldump --opt --databases YOURDBNAME > output.sql

-[Unknown]

[halebopp]

mysqldump --opt --databases YOURDBNAME > output.sql

-[Unknown]

Code Select Expand


mysqldump --opt YOURDBNAME -uusername -ppassword >output.sql

If you only have one database, you dont need the --databases  option. Specifying username and password is necessery in most cases, also. Be sure to have no space between -u/-p and the username/password.

If you can access the new database from your old server, you can directly import the dump in the new database:

Code Select Expand


mysqldump --opt YOURDBNAME -uusername -ppassword | mysql --host=newhost -uusername -ppassword  -C NEWDBNAME


[[Unknown]]

Using --databases adds a "use DATABASENAME" which I always find useful.

Further, he probably doesn't have access to the MySQL server from any host except localhost.

-[Unknown]

[Egg]

well I tried all the options above.

first I got an output.sql that was 0kb in size.. obviously empty.

then nothing at all. the .bash_history file shows what i did and it is what you put upstairs.

Code Select Expand

mysqldump --opt MYDBNAME -uMYUSERNAME -pMYPASSWORD >output.sql

strange.

is there a specific ssh client I should be using / you recommend? I am currently using PuTTY.. maybe I have it configured incorrectly.

[[Unknown]]

Ummm....

You did put your database name in for MYDBNAME, right?

-[Unknown]

[Egg]

yep

and I double checked to make sure I got the right name

[Egg]

is it

mysql_dump

or

mysqldump
??

*edit* if tis mysqldump I get

mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysqld.sock' (2) when trying to connect

if its mysql_dump I get


mysql: unrecognized option `--opt'

[Egg]

^^TTT

??

[[Unknown]]

It's mysqldump and you have to connect to the server with it.

I don't know how, I always do it via localhost...

-[Unknown]