error when dumping sql

[Joe Gronlund]

# Server version 3.23.45
mysqldump: Got error: 1103: Incorrect table name 'dump.sql' when doing LOCK TABLES

i also tried vbulletin.sql as the dump name , what am i doing wrong?

TIA
Joe

[Steve Machol]

What's the full command line you are using?

[Joe Gronlund]

mysqldump --opt -u username -p databasename /dump.sql

username and database name replaced with the correct names

[eva2000]

Originally posted by Asendin
mysqldump --opt -u username -p databasename /dump.sql

username and database name replaced with the correct names use /full/path/to/dump.sql ;)

[Joe Gronlund]

thanks

now i get

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

thanks for the help, im gettin their.

[Dave#]

Originally posted by Asendin
thanks

now i get

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

thanks for the help, im gettin their.

Maybe change username@localhost to whatever privilaged user can mysqldump - tip it will be the same as whats in your config.php for VB

[Joe Gronlund]

the username is the same as the one in my config.php

[Dave#]

Originally posted by Asendin
the username is the same as the one in my config.php

Password then

[Joe Gronlund]

yes password is the same also

[Dave#]

can you connect to mysqladmin at all using those username/password combination

mysqladmin - u username -p password version

[Joe Gronlund]

Originally posted by Dave#
can you connect to mysqladmin at all using those username/password combination

mysqladmin - u username -p password version

i dont believe so, i am new to using SSH, i tryied the above and it wouldnt connect either, but i am using the same username, databasename and password in my mysqladmin and config.php.

thanks for the help

Joe

[Dave#]

not much more I can do I'm afraid - sorry

[eva2000]

Originally posted by Asendin
thanks

now i get

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

thanks for the help, im gettin their. dedicated or virtually hosted ?

check your mysql username and password to see if they're correct

[Joe Gronlund]

Originally posted by eva2000
dedicated or virtually hosted ?

check your mysql username and password to see if they're correct

virtual @ hostrocket, i did recheck to make sure but they are correct.

does it have to be a dedicated server for the SSH dump to work?

[eva2000]

Originally posted by Asendin


virtual @ hostrocket, i did recheck to make sure but they are correct.

does it have to be a dedicated server for the SSH dump to work? are you using a control panel like cpanel ? i'd contact your web host and ask them

[Joe Gronlund]

Originally posted by eva2000
are you using a control panel like cpanel ? i'd contact your web host and ask them

yes we do use Cpanel, but im using SSH to try and back up the database..

[eva2000]

Originally posted by Asendin


yes we do use Cpanel, but im using SSH to try and back up the database.. in that case

1. make sure the created mysql database in cpanel's mysql module is assigned a username/password via the cpanel's mysql module page

2. make sure you are using username_mysqlusername as the mysql username

[Joe Gronlund]

yes did that also, still get access denied, really confused of why, could it be a write access problem?? :confused:

[Chris Schreiber]

Originally posted by Asendin
mysqldump --opt -u username -p databasename /dump.sql


Should be:
mysqldump --opt -u username -p databasename > /dump.sql

[Joe Gronlund]

Originally posted by Chris Schreiber


Should be:
mysqldump --opt -u username -p databasename > /dump.sql

that did the trick , its always something small.

thanks :)

[eva2000]

ah didn't see the missing > :o