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]
