I'm in the process of moving a MySQL database with about 170 tables from my PC to a new MacBook Pro. On my PC, I exported each database table as a SQL file, then copied a folder containing all these files to my Mac.
I'd like to know if there's a way to import all these SQL files into a database on my Mac, or do I have to import them one at a time. I generally update my online database by deleting a table, then clicking a tab in phpMyAdmin that fetches a pop-up SQL window. However, it only allows me to import one SQL file at a time. Regardless of how I import these SQL files, I next need to know if I can copy or move more than one table at a time to another database. I want to dump everything into a temporary database, then move only the tables I decide to keep into a permanent database. I installed a program called MAMP, which includes MySQL 5 and the current phpMyAdmin. When I opened phpMyAdmin, I discovered that I can check multiple tables. But when I click the Operations tab to copy/move them to another database, it looks like I can only do one at a time. Thanks. --------------------------------- No need to miss a message. Get email on-the-go with Yahoo! Mail for Mobile. Get started.
