I have to import a MS SQL Server database which is incorporated in the .mdf format via PhpMyAdmin to MySQL:

  1. Can One import it from PhpMyAdmin and when not then how do i translate this file into MySQL format?
  2. Also, how will i enhance the database size limit in PhpMyAdmin?

Phpmyadmin does not possess a facility for directly posting .mdf or .ldf files. You should use MSSQL Express and interface utility to create a raw sql dump from the database.


You should use the openDBcopy and ESF data migration toolkit. Actually, it is really an oft-talked about problem on SO. See these questions:

  1. Import data from Microsoft SQL (.MDF) file into MySQL

  2. Importing data to MySQL from MS SQL

For growing the import file limit, Inside your php.ini file, find and customize the following configurations:

post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M