By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,953 Members | 1,097 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,953 IT Pros & Developers. It's quick & easy.

how to backup database

P: 69
Dear All,

I want to know that how can i take a backup database on mysql without root user. i am able to do update, insert, modify with another user & i can't able to take backup..

So any ideas will be appreciated..

Feb 21 '12 #1
Share this Question
Share on Google+
1 Reply

P: 1,059
I believe you have SELECT Right.
use mysqldump located in bin dir, you can save your data as csv as well as you can use mysqldump insert query from the available table record.

if you have phpmyadmin then you can take backup using this software. but if you want to write a routine using php to take backup. it might take several hour to build such application
Apr 14 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.