MySQL question

kevinm2 · 08-21-2004, 12:29 AM

I was given a file faq.sql to create a table in a database. I am suppose to run it; so it creates a new table called faq. How do I run it phpMyAdmin. or from the shell?

Cedrik · 08-21-2004, 02:03 AM

From the shell :
mysql -u <admin name> -p <database name>
enter password: <admin password>
mysql>source /path/to/faq.sql

With phpmyadmin, just follow the instruction, select your database, then click on "sql" and choose your file from the button "browse"

kevinm2 · 08-21-2004, 02:39 AM

Thank you for the reply. I had to created the table manually. But for the future, I will use your way . And also is there any way that this could be done from within phpMyAdmin.

kevinm2 · 08-21-2004, 02:44 AM

I am so sorry, you had already answered my question. I guess it's time to hit the bed. I have been on the computer for about 17 hours now! Thanks again.