Jump to content

Archived

This topic is now archived and is closed to further replies.

pl

Running SQL files through MySQL

Recommended Posts

Can anyone tell me how I run an SQL file through MySQL for creating databases and inserting database information. This type of information tells me nothing:

 

> mysql -h host -u user db pass < filexxx.sql

 

I need to know where to place the SQL file and how to run it accordingly.

 

Thanks...

Share this post


Link to post
Share on other sites

mysql database_name < path_to_file

 

breakdown:

 

mysql this executes mysql on the command line

database_name this tells mysql what database to use the file on

< this is a special symbol in unix for telling the command, in this case mysql, to use the following file as input

path_to_file this is the path to a file containing SQL

 

the -h -u and so on are parameters that are sometimes needed. to make things easier you can set these in the my.cnf file, or you may not have to use them at all.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.