Please help!

[indie]

I tried a backup via SSH and using putty, but my db username did not have the delete permission (i didnt think it needed it)
But now no one can log on my site, they get a DB error message, and I'm being emailed a bunch of DB errors that say
mysql error: delete command denied to user: ****** for table 'datastore'

What do I do??

Do i re-run the backup, and have delete permission set for the db user??
thanks!

[indie]

Invalid SQL:
REPLACE INTO datastore
(title, data)
VALUES
('cron', '1105491360')

mysql error: delete command denied to user: (username) for table 'datastore'

These are the emails I'm getting, and my home page is up, but you cannot log in you get db error message!

ANY help appreciated.... thanks!!
Do I re-run the backup???

[Andy]

Sounds like you damaged your database somehow. What was the command you used to backup? Here is what I use.

mysqldump --opt -u**** –p**** vbulletin > /path/to/somewhere/backup.sql

[indie]

Never mind, Steve answered:

Here is a list of MySQL permissions required by your db user:

create
delete
alter
insert
update
select
drop

Please let me know if you require any further assistance.

All the best,
Steve Machol
Customer Support Manager, vBulletin

Thanks Steve!