Your HostICan Community  


Go Back   Your HostICan Community > Programming & Design > PHP / MySQL Assistance
Reload this Page MySQL Backup
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

PHP / MySQL Assistance We understand. Not all of you are experienced programmers, but some of you are highly skilled at coding. So we've set aside this forum so you can ask questions, and provide answers to the most commonly asked PHP / MySQL issues.

 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-13-2009, 01:43 PM
stephenh stephenh is offline
Junior Member
  
Join Date: Sep 2009
Posts: 2
Default MySQL Backup
I've added the following to crontab:

Code:
nice -n 15 mysqldump -u userid -p password database_name > /home/user/database.sql
When it runs, it dies with the following error:

Quote:
Enter password: mysqldump: Got error: 1045: Access denied for user 'userid'@'localhost' (using password: NO) when trying to connect
Apparently I have something configured incorrectly for userid. I've checked the permissions and userid has all permissions to the database.

What do I need to change?
Reply With Quote
 

Tags
backup, mysql

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Threaded Mode Threaded Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump


All times are GMT -4. The time now is 04:23 AM.

Contact Us - Return to the HostICan Home Page - Archive - Top

Powered by vBulletin® Version 3.8.0
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.

Copyright © 2003 - 2008 HostICan. All Rights Reserved.