How to make a copy of my vB database?

[Mike Phillips]

How can I make a copy of my databases,

vBulletin
PhotoPhost
vBadvanced

I want to save them to my hard drive?

thanks,

Mike

[Tom E.]

How to backup a database from the FQ knowledge base & tutorials

[Mike Phillips]

okay, tried that and I'm getting this error in the telnet thing,

mysqldump : got error: 2002: Can't connect to local MySQL server through socket '/tem/mysql.sock' (2) when trying to connect

So what am I doing wrong?

[sheila]

You are not using the proper host name.

From the tutorial that Tom linked to, the command you want to use is:

mysqldump -q -uxmysqlusername -p -hmysql.example.com xdatabase >./myfile.txt

The green "example.com" is where you need to put your domain name, and the part that you have omitted (the -hmysql.example.com part).

[Mike Phillips]

Originally Posted by sheila

You are not using the proper host name.

From the tutorial that Tom linked to, the command you want to use is:

mysqldump -q -uxmysqlusername -p -hmysql.example.com xdatabase >./myfile.txt

Actually I did type that in, at least I thought, it wold look like this,

I changed the xmysqlusernamem to my username for my account
I changed the example.com to my domain name.com
I changed the xdatabase to the name of the data base as it appars in my Command N Control

[Mike Phillips]

Will try again

[sheila]

The username for your account would not be correct. You need to use the MySQL username which is different. It is shown in the MySQL Manager part of your CNC.

[Mike Phillips]

okay... that makes sense... saw that but didn't link the idea.

Will try right now

[Mike Phillips]

Got this error again

mysqldump : got error: 2002: Can't connect to local MySQL server through socket '/tem/mysql.sock' (2) when trying to connect

[Mike Phillips]

I reset my MySQL Manager password to make sure I'm entering the correct one and will try again.