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 (http://service.futurequest.net/index.php?_a=knowledgebase&_j=questiondetails&_i=22) 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]

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.

[sheila]

I'm in an ssh session in your account, and I don't see the new command you just tried at all. However, the earlier commands you tried that I can see in the command line history do not have this part in them:

-h mysql.yourdomain.com

And the error you are reporting is consistent with omitting that part of the command.

[Mike Phillips]

now I got this error,

mysqldum;: got error: 1045: Access denied for user: 'USERNAME@lola.futurquest.net' (using password: YES) when trying to conect

[Kevin]

Sheila is right. Anytime you see that error (should be /tmp/mysql.sock) it means that the MySQL client is trying to connect to a local server instead of the networked servers that we use. Any time you see /tmp/mysql.sock it means something is wrong with the -h part of your command line.

[Mike Phillips]

Can I fill out a help ticket and have someone at FutureQuest do this for me?

I'm willing to keep trying, but having some problems here.

[sheila]

Copy and paste exactly the command that you are entering into a support ticket request. We need to see the exact command you are entering.

[Mike Phillips]

I'm in an ssh session in your account, and I don't see the new command you just tried at all. However, the earlier commands you tried that I can see in the command line history do not have this part in them:

-h mysql.yourdomain.com

And the error you are reporting is consistent with omitting that part of the command.

OKay I'll try again...

Maybe it's a case of thinking to slow and typing to sloppily?

[Mike Phillips]

I think the problem is I'm not leaving a space between the h and the mysql.yourdomain.com

[Kevin]

Also, do not put a space within the parameters. It is supposed to be -uusername not -u username same for -h. If you put -p by itself you will be prompted for the password so there is no need to use -ppassword.

[sheila]

I think the problem is I'm not leaving a space between the h and the mysql.yourdomain.com

Space or not is irrelevant.

[Mike Phillips]

Yeah, I 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]

Copy and paste exactly the command that you are entering into a support ticket request. We need to see the exact command you are entering.

Okay, will try this right now.

[Mike Phillips]

Thanks for all your help, I think I got what I needed.

Mike

[sheila]

:clapper:

[Mike Phillips]

Arghh....

Somehow I did something dumb and now my forum doesn't work.

:ytstars: :ytcoffee:

www.showcargarage.com

[sheila]

Did you change the password to your MySQL databases? If so, you need to update your forum config files with the new password. (Or else restore the old password through the MySQL Manager in your CNC.)

[Mike Phillips]

Did you change the password to your MySQL databases? If so, you need to update your forum config files with the new password. (Or else restore the old password through the MySQL Manager in your CNC.)

I can't remember what the password might have been, thus the reason I changed it to something I can aways remember.

How does one go about changing the config file(s)

[Jeff]

If your forum is installed in your web root, edit the file
/big/dom/xyourfuturequestaccountname/www/includes/config.php)

or if it is installed in a subdirectory,
/big/dom/xyourfuturequestaccountname/www/forums/includes/config.php
as appropriate.

Look for the line
$config['MasterServer']['password'] = 'oldpassword';

and change your oldpassword to the new MySQL password you set in your CNC

Easiest way is probably to edit the file via ftp download, edit locally using notepad, editplus, etc, and then upload.
Or you can change it from your ssh command line by navigating to the vbulletin /includes/ directory, ls to see the files there to be sure you're in the right place, and then typing pico -w config.php , edit the password between the tics, then click ctrl+x to exit and save changes (or you could use nano, vi, etc. editors from the command line.)

[Mike Phillips]

Easiest way is probably to edit the file via ftp download, edit locally using notepad, editplus, etc, and then upload.

That did it.

Thank you everyone for your help. Crossing my fingers but it looks like everything is back to normal.

Mike