pl Posted January 14, 2003 Share Posted January 14, 2003 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... Quote Link to comment https://forums.phpfreaks.com/topic/46-running-sql-files-through-mysql/ Share on other sites More sharing options...
effigy Posted January 14, 2003 Share Posted January 14, 2003 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. Quote Link to comment https://forums.phpfreaks.com/topic/46-running-sql-files-through-mysql/#findComment-113 Share on other sites More sharing options...
pl Posted January 15, 2003 Author Share Posted January 15, 2003 Thanks for that! Quote Link to comment https://forums.phpfreaks.com/topic/46-running-sql-files-through-mysql/#findComment-115 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.