Backing up vB

[ender]

bash$ mysqldump particle_vbulletindb > /home/particle/particlesundb.txt

mysqldump: Got error: 1045: Access denied for user: 'particle@localhost' (Using password: NO) when trying to connect

Okay..what now? Did I do this correct?

[steven]

Download a program called putty from here http://www.hostrocket.com/putty.exe
This is what I did, and it works perfectly.

1) Put in your ip address for your old host where it asks for your hostname. Then select the SSH radio button, and click on open, if your host supports secure telneting, if not click on telnet. It will prompt you for your login name to that server. Type in your login name and press enter, then it will prompt you for you password, type it in and press enter, and then do the following. (note) You will not see your password being typed in

2) Then I would do a dump of your database
mysqldump -uusername -ppassword databasename > file.sql

3) Now download the file.sql to your hard drive.

4) Use your FTP client to upload the file.sql to your new server in ASCII mode only!

5) Open a new session in putty by rightclicking the top bar.

6) Enter your NEW HOSTS ip address and select the SSH radio button then open.

7) Now you must restore the database
mysql -uusername -ppassword databasename < file.sql

8) Have Fun!!

So if my
database name is forums
username is steven
password is test
then Here is what to do.

mysqldump -usteven -ptest forums > forums.sql
Then upload the forums.sql to your new server in ASCII mode ONLY
Open a new session in Putty with your NEW HOSTS IP Address, click on the SSH radio button and then open. Put your Login name and password to your new hosts server. Then when you get prompted by a $ sign type
mysql -usteven -ptest forums < forums.sql

Let me know how it goes.
Hope this helps.
Steven

[JamesUS]

A much quicker way :)

Use this command in telnet:

mysqldump -uUSERNAME -pPASSWORD particle_vbulletindb > /home/particle/particlesundb.txt