Ah, that's better. I learned how to use Terminal just the other day. I'll check out the other programs you recommended, too. Thanks.
----- Original Message ---- From: Douglas Sims <[EMAIL PROTECTED]> To: David Blomstrom <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Saturday, October 7, 2006 3:33:59 PM Subject: Re: Moving Database from PC to Apple Hi David mysqldump is a command-line program which you can run through the terminal window. The "Terminal" application is in the "Utilities" directory under the "Applications" directory. The unix command-line interface is amazingly useful; even though it may seem a bit intimidating at first, it is well worth getting used to. You will probably want to drag the Terminal application down to the Dock so you won't have to dig around for it every time. (Or you can just open the Spotlight window with Command-Space and then type "Terminal") You can also do the same thing with a gui tool, the MySQL administrator. There are three programs in this suite and they are all very nice (the newest one, the MySQL workbench, still crashes a bit but I'm sure that will improve.) You can download the gui tools here: http://dev.mysql.com/downloads/gui-tools/5.0.html and then from the MySQL Administrator program, choose "Backup". Good luck. I use a MacBook Pro for MySQL work also (mostly developing things that will run on a linux server) and I have been very pleased with it. Douglas Sims [EMAIL PROTECTED] On Oct 7, 2006, at 5:01 PM, David Blomstrom wrote: > Thanks. Is this something I can do through phpMyAdmin? I'm not used > to working with MySQL directly and don't understand exactly what > this command means: > shell> mysqldump [options] --all-databasesDoes "shell" mean I have > to be working in some sort of command line program? > > Also, if I can't figure this out and have to resort to creating new > databases, should I just ignore the Collation feature, presumably > letting it set a default setting, or should I enter a particular > value? > > Thanks. > > ----- Original Message ---- > From: mos <[EMAIL PROTECTED]> > To: mysql@lists.mysql.com > Sent: Saturday, October 7, 2006 2:26:19 PM > Subject: Re: Moving Database from PC to Apple > > At 04:00 PM 10/7/2006, you wrote: >> I recently purchased a MacBook Pro laptop and hired someone to >> help me set >> up Apache, PHP and MySQL on it. Now I want to import my database >> tables >> from my PC. So my main question is this: Is there a quick, simple of >> importing an entire database? If not, I figured I'd simply export >> each >> database table as an SQL file on my PC, then copy all the SQL >> files to my >> laptop's desktop and import them through phpMyAdmin one by one. >> Also, when >> I create a new database on my Mac, what should I choose for >> Collation - or >> should I just leave it alone (presumably the default setting)? The >> following default settings are already registered: Language: English >> (en_utf_8) MySQL Connection Collation: utf8_general_ci Thanks. > > David, > Try MySQLDump which is set up to do just this. > http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html > > Mike > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql? > [EMAIL PROTECTED] > > > > > > >
