Jump to content

Running SQL files through MySQL


pl

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...

Link to comment
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.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.