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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
