I am having a large (~150mb) SQL file that I try to import. The file is too large to do it through the PHPMyAdmin even splitting it into many pieces and it is also too large to import through a PHP script as it times out after some 30 seconds of processing the script. So I ty to directly import the file from the MySQL command line.
While looking on the internet, it has shown me that I must be using either use database_name < file_name.sql or source file_name.sql but I could not able to get either of those to be working.
Using < gives the generic MySQL syntax error while using the source gives a lightly more promising failed to open file 'file_name.sql', error: 2 so I thought that the source command is on the right track.
I am using the xampp as the localhost server on the windows machine. I have tried to place the file in the xamppmysqlbin and xamppmysqldatadatabase_name.
Any suggestions on how to import this .sql file into the MySQL either from the MySQL command line or by any other means would be greatly appreciated.