Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have just installed phpmyadmin on a Windows 2008 Sever with IIS installed and I want to important a database which I have created on my own machine onto this server within phpmyadmin.

When I try do so I get an error message

File could not be read

I have read this may be due to the open_basedir within php.ini

I have changed open_basedir to open_basedir = D:\inetpub and then placed the database.sql.zip file into the inetpub folder but I am still getting the same error message.

Anyone know where I am going wrong?

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

see this article. http://sourceforge.net/projects/phpmyadmin/forums/forum/72909/topic/3817584

I don't know why that works but seemed to help that case. My answer to you is don't use phpmyadmin as a crutch. You should at least learn the basic mysql syntax to import your database from the command line.

http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html

share|improve this answer
    
thanks very much –  user1132612 Feb 7 '12 at 15:53
    
+1 for "don't use phpmyadmin as a crutch" –  dunxd Mar 16 '12 at 12:05
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.