• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

populating info into a new database ?

 
Peter Primrose
Ranch Hand
Posts: 755
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have created a database (MySql) for a client of mine and he�s using it in conjunction with software I developed. From time to time I send him a new version of the software based on his request to improve the system in terms of more functionality.

Sometimes the revisions include adding extra tables in the database so it�s a bit complicated.

What I have in mind is getting a file from him using the mysqldump function and then populate all information in a new database (the one that include the extra tables). And then, send him the file (he�ll use the mysql �p �u root myDatabase<backup.txt

1.Any idea how to populate all information into a new database
2.Any other idea to do smooth the process above.

Thanks
Peter
 
Jeff Grant
Ranch Hand
Posts: 169
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I would just include the script to add the new tables with the new release and have him run it from the prompt.
 
Peter Primrose
Ranch Hand
Posts: 755
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks - do you have an exaple of a script?
 
Jeff Jetton
Ranch Hand
Posts: 71
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The dump should basically spit out the script exactly as it needs to be. It's just a series of INSERT commands.

- Jeff
 
Peter Primrose
Ranch Hand
Posts: 755
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
and how do you populate all info from db_a to db_b if db_b has more tables?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic