LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   Mysql import table, how? (https://www.linuxquestions.org/questions/linux-newbie-8/mysql-import-table-how-753814/)

johnh10000 09-09-2009 05:49 AM
Mysql import table, how?
 
Err how do I do this?

Some of the games I want on my website come with a file filled with waht looks like mysql commands.

ex: newgame.sql

what do i do with this? The readme say import it. it doesn't say how.

thanks in advance

satishmali1983 09-09-2009 06:09 AM
Quote:
Originally Posted by johnh10000 (Post 3675629)
Err how do I do this?

Some of the games I want on my website come with a file filled with waht looks like mysql commands.

ex: newgame.sql

what do i do with this? The readme say import it. it doesn't say how.

thanks in advance
For Import in mysql from command line use following

mysql -h localhost -u username -p DBname < .sql file

-u usrename for DB
-p Prompt for DB password


All times are GMT -5. The time now is 08:51 PM.