• 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Paul Clapham
  • Jeanne Boyarsky
  • Knute Snortum
Sheriffs:
  • Liutauras Vilda
  • Tim Cooke
  • Junilu Lacar
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Joe Ess
  • salvin francis
  • fred rosenberger

moving your tables+content to another MySql server

 
Ranch Hand
Posts: 755
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You could use mysqldump. This dumps the DDL plus the data.
 
Peter Primrose
Ranch Hand
Posts: 755
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 221
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 755
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Mo-om! You're embarassing me! Can you just read a tiny ad like a normal person?
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!