Mysql running .sql file

If the file exists, it is overwritten. Navigate to the database you wish to execute the SQL commands within, then go to the import tab and browse for the file you wish to execute. Be warned, if you are executing a particularly large file that may take some time to complete the command line is the best way to go, as phpMyAdmin is limited by the file upload size and is limited in how long it is allowed to execute tasks depending on the configuration of the webserver it is running from.

I'm Brad, and I'm nearing 20 years of experience with Linux. I've worked in just about every IT role there is before taking the leap into software development. Visit my blog or find me on Twitter to see what I'm up to. Your email address will not be published. Save my name, email, and website in this browser for the next time I comment. The path should not be wrapped in quotes! Excellent advice from elcuco! Also, probably use another flag after -p or have that be the last arg so another parameter is not erroneously taken to be the intended password.

Please note that, command line arguments are still visible by other users. AlexiusDiakogiannis can you give me example how can you view the command from history when you execute it with [space] before the command? Show 2 more comments. Bhushan Bhushan I think there should be no space between -p and the password — webNeat. See options and syntax here - dev. Give the path of. Shubham Verma Shubham Verma 7, 6 6 gold badges 48 48 silver badges 74 74 bronze badges.

Thanks a ton! Zac Smith Zac Smith 1, 1 1 gold badge 11 11 silver badges 13 13 bronze badges. Thanks, junix! The source option used this way is what I was looking for. If the above command is not working, copy the file to c: drive and try again. Shankar Kalyankar Shankar Kalyankar 2 2 silver badges 2 2 bronze badges. DataGuru DataGuru 6 6 silver badges 16 16 bronze badges. Jorge E. So many ways to do it. Hope this is helpful and not just redundant.

DonkeyKong DonkeyKong 11 11 silver badges 17 17 bronze badges. Ben Lin Ben Lin 7 7 silver badges 13 13 bronze badges. From linux I didn't see this approach in the answers above and thought it is a good contribution.

Dharman RicarHincapie RicarHincapie 1, 9 9 silver badges 17 17 bronze badges. Rajesh Paul Rajesh Paul 6, 6 6 gold badges 35 35 silver badges 52 52 bronze badges. Installation-Related Programs. Administrative and Utility Programs. Other myisamchk Options. Obtaining Table Information with myisamchk.

Specifying the mysqlbinlog Server ID. Program Development Utilities. InnoDB Cluster. InnoDB ReplicaSet.