• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Ranch Hand
Posts: 755
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 1071
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
reply
    Bookmark Topic Watch Topic
  • New Topic