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... 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. 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! 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
Archived
This topic is now archived and is closed to further replies.