![]() ![]() Pretty easy.īe 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 web server it is running from. ![]() Press the go button when you’re ready to go. 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. ![]() It’s a good tool for those less comfortable working on the command line. If you use phpMyAdmin to administrate your MySQL server, you can also execute MySQL files from there. The > command directs the output of the command into the given results file. Mysql -host="mysql_server" -user="user_name" -database="database_name" -password="user_password" "path/to/sql/results.txt" You can also execute an SQL file without logging into MySQL from the Linux shell – this is especially useful if you wish to make your command part of a Bash/Shell script: mysql -host="mysql_server" -user="user_name" -database="database_name" -password="user_password" results_file
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |