Love to get paid, but this is too easy. You can do both these quickly and easily with the mysqldump utility that comes with MySQL database. It's great for doing exactly what you are wanting to do. It even works great for moving all databases from one server to another. The following two lines typed into the command line should accomplish exactly what you want.
The following dumps the entire database structure with data into a file: Shell> mysqldump --opt database-name > backup-file.sql The following reads the backup-file back into MySQL: Shell> mysql database < backup-file.sql For details go to: http://www.mysql.com/doc/en/mysqldump.html If you need help installing MySQL (or a variety of other apps) on Mac OS X I suggest visiting Mark Liyanage's site on Mac OS X. He usually has easy-to-use binary install packages for all the latest versions. http://www.entropy.ch/software/macosx/ Chris > specifically, I need someone to do and instruct me on: > - migrating a database from dev to production > - migrating a database from ? platform to MacOS X > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
