01.21.10

Upgrading MySQL

Posted in Hacks, Linux/*BSD/Unix at 4:12 pm by Nate Smith

Recent glitches required me to update a server I had running Php and MySQL.  Before upgrading mySQL I dumped all of my databases using the dump command.  When I went to recreate a couple databases in the new installation using PhpMyAdmin a few databases were a little too large and timed out as they were imported.  I found a hint to a nice way to import saved tables here (http://www.modwest.com/help/kb.phtml?qid=241&cat=6) but my favorite tip was in the comments: ”

 

"you can also get to the mysql shell and then type "source file.sql",where file.sql is your dump file"

This turned out to be very handy. Good stuff.

Leave a Comment

You must be logged in to post a comment.