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
-
what do you mean under "DB backup script"? Db dump?s.webbandit– s.webbandit2012-06-01 07:53:42 +00:00Commented Jun 1, 2012 at 7:53
-
1What is the error you're getting?Jeffrey Vandenborne– Jeffrey Vandenborne2012-06-01 07:54:37 +00:00Commented Jun 1, 2012 at 7:54
-
@JeffreyVandenborne mysqldump: Got error: 1044: Access denied for user '<user-id>'@'%' to database '<password>' when selecting the databaseUnknown Coder– Unknown Coder2012-06-01 07:57:31 +00:00Commented Jun 1, 2012 at 7:57
-
Do you mean to take dump for entire database or a particular table?Rahul– Rahul2012-06-01 07:59:36 +00:00Commented Jun 1, 2012 at 7:59
-
@ShreekumarS, edited my post. Take a look now.Rahul– Rahul2012-06-01 09:58:07 +00:00Commented Jun 1, 2012 at 9:58
Add a comment
|
1 Answer
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".
2 Comments
Unknown Coder
I tried as follows
C:\>mysqldump -h 111.111.111.111 -u userid -pMyPassword DBname > E:\dumpfilename.sql but not working
geon
Again, what is your error message? Just stating that it isn't working isn't helpful.