wood burning stoves 2.0*
The moose likes JDBC and the fly likes 'export' & 'import' database tables and content in MySql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark " Watch " New topic
Author

'export' & 'import' database tables and content in MySql

Peter Primrose
Ranch Hand

Joined: Sep 10, 2004
Posts: 755
Hi all,

Simply put, I have created a database (myDB) in MySql and now it has some tables and some info in it. I want to send it to a client of mine (who already have MySql db but not myDB) and he will be able to use those tables and the information. He is not a computer savvy and I want to guide him with minimal technicality.

Question: How can I 'export' my database and send it to him and how can he 'import' it and use it?

Note:

(1) I have read about mysqldump - but it's a utility command line (not good - client not comp savy) I read about replication (same thing)

(2) In MS access I used to send the file and that's it... I take it its more complicated with MySql.

Any thoughts?
Thanks
Steven Bell
Ranch Hand

Joined: Dec 29, 2004
Posts: 1071
You should be able to use the MySQL Administrator to 'backup' the DB and then have your client 'restore' the DB. If the DB is very large this may take some time.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: 'export' & 'import' database tables and content in MySql