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/[EMAIL PROTECTED]
