How import phpMyAdmin SQL Dump into a database

SAbboushi
SAbboushi used Ask the Experts™
on
I have limited experience with SQL databases.  My primary experience is with Access 2007.

I have a phpMyAdmin SQL Dump that I want to import into an SQL database.

I have Access 2007, IBM DB2 Express-C, MS SQL Server 2005 Express, and Oracle 10g Express that I can install on my machine (but I do not have a server OS).  I don't think MySQL is free anymore?

What steps can I take to get the SQL Dump into one of these databases (or if there is an alternate free DB).  The DB needs to be able to store Arabic.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2008

Commented:
>> I don't think MySQL is free anymore?

MySQL have both "community editions" and a commercial licenses. The free version is now called "MySQL Community Server".

http://dev.mysql.com/downloads/

To import a dump file, either use phpMyAdmin or the standard client from a command line:

mysql -uUser -p dbname < dumpfile.sql
Top Expert 2008
Commented:
mysql -uUser -p dbname < dumpfile.sql

Replace "User" with your mysql user name. Replace "dbname" with the name of the database, which must be created first, for instance using SQL statement "create database dbname". Replace "dumpfile.sql" with the actual name of your dump file. A path may be provided.

Author

Commented:
Thanks -

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial