Importing database backups into MySQL

Reminder to self: The command to run an SQL file into MySQL is:
mysql -u USER -p DBNAME < dump.sql
More info to be found at google answers page.

Posted by dustin on April 19, 2005 with category tags of

5 comments
Or you can just pop open query analyzer and hit F5
   comment by James on April 19, 2005

Oh yeah? Is that going to work on both my OSX box and my Linux server? Hurumpht!
   comment by dustin (#1) on April 19, 2005

Also, the reason I wanted to do it from the command line was that I was transferring over a 55 MB database. That's not the kind of thing you want to load into a GUI tool.
   comment by dustin (#1) on April 20, 2005

Yes but it takes seconds to generate a backup of a MS SQL database and then you can restore it on any box that you want.
   comment by James on April 24, 2005

james, you are crazy.
   comment by dustin (#1) on April 25, 2005

Commenting is currently off. You can email the author.

   

VorgTag CloudArchives

Written by dustin
Photo Showcase
Quote Showcase

Friends of Vorg
Computer Games
Popular Posts

Hey You! Subscribe to dustin's RSS feed.
Or get wider opinion in the Vorg All Author feed.

 
 

Members login here.
© Vorg Group.