Dear Agent Smith,
as said, mysqldump is a command line program, not an SQL command.
In PhpMyAdmin, use the CSV or SQL dump function built in. To dump a
database, select the database (left frame), then click "dump database"
(right frame), best with options "structure and data", "with drop table
statement" and "save to file". When prompted, select a file name on your
local machine. Then have a look at the file on your machine, and you
will find you have a perfect dump to import whereever you need it :)
Regards,
Stefan Hinz (Geschäftsleitung)
iConnect e-commerce solutions GmbH
www.iConnect.de - www.js-webShop.de
TEL +49 30 46307-382 - FAX -388
---
----- Original Message -----
From: Agent Smith <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 05, 2001 4:28 AM
Subject: problem with mysqldump
> 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
>
> But I can't find a mistake there!? Can you helpp me?
>
>
> Thanks!
>
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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
