Hi,
Agent Smith wrote:
>
> Hi everybody,
>
> I got a problem with the "mysqldump" function.
>
> I connect to mySql trough phpMyAdmin, select the database "xyz", which
> is the only database on the server.
> Then I enter the following string into the text field "Run SQL
> query/queries on database xyz:":
>
> mysqldump xyz | mysql --host=XXX.168.XXX.14 --port=3306
> --socket=/var/mysql/mysql.sock --username=XXXXX --password[XXXXX] xyz
>
> I want to copy the whole databse from one server to the other, but i
> always get th error message,
>
> MySQL said: You have an error in your SQL syntax near 'mysqldump
> catfxpboard | mysql --host=194.168.102.14 --port=3306 --socket=/var/my'
> at line 1
mysqldump is not an SQL command.
mysqldump is a program that must be run from the command line.
>
> But I can't find a mistake there!? Can you helpp me?
>
> Thanks!
>
--
Joseph Bueno
NetClub/Trader.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
