enow.com Web Search

Search results

1. Results from the WOW.Com Content Network

2. command line - How to run SQL script in MySQL? - Stack Overflow

   stackoverflow.com/questions/8940230

   So many ways to do it. From Workbench: File > Run SQL Script -- then follow prompts From Windows Command Line: Option 1: mysql -u usr -p mysql> source file_path.sql Option 2: mysql -u usr -p '-e source file_path.sql' Option 3: mysql -u usr -p < file_path.sql Option 4: put multiple 'source' statements inside of file_path.sql (I do this to drop and recreate schemas/databases which requires ...

3. How to connect to MySQL from the command line - Stack Overflow

   stackoverflow.com/questions/5131931

   Connecting from the terminal. Option 1: mysql -u root -p : This with connect to user called root, -p flag will prompt for a password. Option 2: mysql -u root -p<PASSWORD> : Here you enter the password directly into the command and after execution the server connects quick without password prompt.

4. mysql - SQL command to display history of queries - Stack...

   stackoverflow.com/questions/7818031

   Just some clarification to the above: The copy-paste commands here are for a single session of MySQL, e.g. you can enter these from the interactive MySQL command line. If you want them to be a permanent feature of your MySQL instance, you need to put those commands in /etc/mysql/my.cnf and restart the MySQL service. –

5. How to connect from windows command prompt to mysql command line

   stackoverflow.com/questions/13752424

   Go to environment variables, 2. add the path of your MySQL Bin directory (suppose if it is "C:\MySQL\Bin", add this path to "PATH" in environment variable). 3. click ok ok and save all. 4. open command prompt and write 5. mysql -u root -p.. hit enter and it should work. it worked for me. – Manoj Kumar.

6. How to import an SQL file using the command line in MySQL?

   stackoverflow.com/questions/17666249

   To dump a database into an SQL file use the following command. mysqldump -u username -p database_name > database_name.sql. To import an SQL file into a database (make sure you are in the same directory as the SQL file or supply the full path to the file), do: mysql -u username -p database_name < database_name.sql.

7. How to show the last queries executed on MySQL?

   stackoverflow.com/questions/650238

   1) If general mysql logging is enabled then we can check the queries in the log file or table based what we have mentioned in the config. Check what is enabled with the following command. mysql> show variables like 'general_log%'; mysql> show variables like 'log_output%'; If we need query history in table then.

8. How to execute a MySQL command from a shell script?

   stackoverflow.com/questions/8055694

   MySQL uses them as the delimiters for identifiers but the shell, which gets the string first, uses them as executable command delimiters. Miss the escape on a single backtick of the MySQL commands, and the whole thing explodes with errors. The whole issue can be solved by using a quoted LimitString for the HEREDOC:

9. Export MySQL dump from command line - Stack Overflow

   stackoverflow.com/questions/13484667

   If you want to do this remotely and you have the access to the server in question, then the following would work (presuming the MySQL server is on port 3306): $ mysqldump -P 3306 -h [ip_address] -u [uname] -p db_name > db_backup.sql. It should drop the .sql file in the folder you run the command-line from. EDIT: Updated to avoid inclusion of ...

10. A better way to execute multiple MySQL commands using shell...

    stackoverflow.com/questions/32869275

    here is the cmds.txt file which contains MySQL commands: select colA from TableA; select colB from TableB ...

11. How to clear MySQL screen console in Windows? - Stack Overflow

    stackoverflow.com/questions/8807836

    To clear MySQL console screen, type the following command: mysql> \! cls. Explanation: \! is used to execute system shell commands. cls is a command to clear the Windows command prompt screen. This will do the job for Windows. Similarly if you are on Linux, you will type Ctrl + L or the following: mysql> \! clear.