Chris Nizzardini, Salt Lake City Utah, Web Developer Specializing in LAMP+Ajax Since 2006

My Blog

Here is my awesome blog. You can find information on programming, linux, documentation, tips for code and database optimization, my thoughts and rants, and whatever else I feel like sharing. Feel free to contribute to the blog by posting comments and asking questions.
SQL

mysql running sql files

Posted by chris on April 21st, 2008 in SQL

From the MySQL command line use the database your SQL file will be affecting.

use database;

To execute the file.

source /path-to-file/file.sql

I always forget this one.

Related posts:

  1. linux using the cat command to append files together
  2. Mod-Log-SQL – Storing Apache Access Logs in a MySql Database
  3. WaitForExit method, running command line args in c#, and other hacks
  4. Querying MS SQL database looking for a specific column
  5. rsync debian linux

This entry was posted on Monday, April 21st, 2008 at 4:19 am and is filed under SQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply