mysqldump: no match

[ne00]

I'm having problems backing up my db.

I telnet into my account,
from the root directory I type in

mysqldump -uUSERNAME -pPASSWORD databasename > /public_html/backup/dump.sql

After that I get a mysqldump: no match message.

When i login via ftp I see the file dump.sql there but there is nothing in the file.

Not sure what I'm doing wrong?

[WizyWyg]

YOu can do a dump through your Admin cp

[Martin]

try putting the databasename before -u -p

[Kaizen]

Do this:

type mysqldump -uUSERNAME -pPASSWORD databasename > /path/to/dump.sql

e.g.

mysqldump -ujohnny5 -pisalive forum > /home/mywebsite/public_html/dump.sql

[ne00]

I tried this:

mysqldump -ujohnny5 -pisalive forum > /home/mywebsite/public_html/dump.sql

With my id/pass/db of course and mywebsite i changed to reflect my account. But received a message saying
> /home/mywebsite/public_html/dump.sql no such file or directory.

then i tried putting the database in front of the -u and -p but still says No Match.

I can't access my admin console since my host locked me out of my bbs folder. They claim my vb is causing major cpu resource issues, even though my maximum user on at once is only 24. I avg 6 users on at any given time per day.

Not sure if that would have anything to do with the No Match message.

Any more suggestions? Would any mods be willing to do a sqldump for me? I want to move the bbs to another host provider.

thanks for the responses.

[Kaizen]

I would do the dump for you.

Talk to me on ICQ: 84639736
MSN: [email protected]

and u can give the details through there...

[Martin]

it sounds like they may have killed your database, too.

I would talk to them and ask if they can do a dump of the database for you and find another host.

who were you hosting through?

[Kaizen]

Originally posted by Martin
it sounds like they may have killed your database, too.

Its worth checking though, i think.

Also, who are you hosting through ?

[ne00]

hosting through thenexus.co.uk

I can still see my database in phpmyadmin.

I will contact you through ICQ Kaizen

thanks for all the help