Hi,
I have used the mysqldump command successfully in the past. I used it to copy the database across remote machines. But i found that the same command when used to copy the database from a remote machine to the localhost, it doesnt work.
This is the command:
mysqldump --opt --user=YYYYY --password=XXXXX --host=host@domai n <name of the database> <name of the table> | mysql --user=username --password=<passw ord> --host=localhost -C <name of the database>
Please note that it works for different machines. But it wouldnt work when i try to give the details of the localhost (local MYsql database)..
Thanx
I have used the mysqldump command successfully in the past. I used it to copy the database across remote machines. But i found that the same command when used to copy the database from a remote machine to the localhost, it doesnt work.
This is the command:
mysqldump --opt --user=YYYYY --password=XXXXX --host=host@domai n <name of the database> <name of the table> | mysql --user=username --password=<passw ord> --host=localhost -C <name of the database>
Please note that it works for different machines. But it wouldnt work when i try to give the details of the localhost (local MYsql database)..
Thanx
Comment