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.
5 comments | Or you can just pop open query analyzer and hit F5 | | |
| Oh yeah? Is that going to work on both my OSX box and my Linux server? Hurumpht! | | |
| 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. | | |
| 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. | | |
|
|
