Can anybody tell me that how to get DB backup script from Remote Server in MySQL using command-line utility?
I'm using a command as follows, but not working:
C:\>mysqldump -h <server ip> -u <user-id> -p <password> <db name> >
E:\dumpfilename.sql
Asked
Active
Viewed 7,094 times
4
Unknown Coder
- 1,510
- 2
- 28
- 56
-
what do you mean under "DB backup script"? Db dump? – s.webbandit Jun 01 '12 at 07:53
-
1What is the error you're getting? – Jeffrey Vandenborne Jun 01 '12 at 07:54
-
@JeffreyVandenborne mysqldump: Got error: 1044: Access denied for user '
'@'%' to database ' – Unknown Coder Jun 01 '12 at 07:57' when selecting the database -
Do you mean to take dump for entire database or a particular table? – Rahul Jun 01 '12 at 07:59
-
@ShreekumarS, edited my post. Take a look now. – Rahul Jun 01 '12 at 09:58
1 Answers
5
The syntax for the password is wrong. You need to write the password immediately after the -p, without a space. That's why the password is interpreted as the database name.
Write this instead:
C:\>mysqldump -h <server ip> -u <user-id> -p<password> <db name> >
E:\dumpfilename.sql
Notice how there is no space after -p. An example would be -phunter2, where the password is "hunter2".
geon
- 8,128
- 3
- 34
- 41
-
I tried as follows `C:\>mysqldump -h 111.111.111.111 -u userid -pMyPassword DBname > E:\dumpfilename.sql` but not working – Unknown Coder Jun 01 '12 at 09:40
-
Again, what is your error message? Just stating that it isn't working isn't helpful. – geon Jun 01 '12 at 10:26