moving your tables+content to another MySql server

[Peter Primrose]

Say I have created some tables (call it
myDB) and it is staffed with some info. I want to
send myDB to a different server with mySQL What should I send?

I tried sending the:
Program Files/MySQL/MYSQL server 4.1/ data/myDB
but for some reason not all tables are passed???

does anyone know what is the best way to send your tables+content in mySql to a different computer with mySql?

thanks
Ppr

[Paul Sturrock]

You could use mysqldump. This dumps the DDL plus the data.

[Peter Primrose]

the mysqlsump is a command-line utility. I would like my clients (not computer savvy) to duplicate the db for backup and to send it to me from time to time.

Q: Is there a less command-line more visualize way to do it?
thanks

[Horatio Westock]

The first thing that comes into my head is use the cron (or windows task scheduler etc.) to run the dump utility, then just get them to send you the output from wherever you tell it to put it.
[ March 08, 2005: Message edited by: Horatio Westock ]

[Peter Primrose]

I realized that the tables are located at
C:\Program Files\MySQL\MySQL Server 4.1\data

(first thing I did is to zip myDB and unzip it at the other end, but it doesnt work - it does work with MS Access)

so say I have a table name: myDB, how can I export it and how can the other side Import it?

does anyone have any java code that runs the mySqlDump utility?
Ppr