Re: novice: how to run .sql script from php?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



tony yau wrote:
I realised that there is a fundamental problem with using mysql_query( ...)
to run a .sql script to setup a database, and that was the database needs to
be there in the first place for php to connect to! also there was a lot of
comment lines in the script that was causing problem. ... so I gave up
trying to parse the file.

instead I did this
1) create the database with phpmyadmin etc

so you have phpmyadmin installed. good. now while you have the database selected,

2) click the SQL (it's in the toolbar in the right frame)
3) click "Browse..." button, find the .sql file, click OK
4) click the bottom "Go" button, wait and relax

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux