View Single Post
  #4 (permalink)  
Old 08-23-2007, 05:05 PM
wige's Avatar
wige wige is offline
Moderator
WebProWorld Moderator
 

Join Date: Jun 2006
Location: United States
Posts: 1,717
wige RepRank 4wige RepRank 4wige RepRank 4wige RepRank 4
Default Re: How to import a .bak file into a new SQL server

If the backup is a text file consisting of MySQL commands, you should be able to do this locally through a shell by entering
Code:
mysql -u username -ppassword database_name < file.bak
Note there is no space between "-p" and your password.

If you have a utility like phpMyAdmin, there is also a utility for recovering from a backup built in.
__________________
The best way to learn anything, is to question everything.
Interestingly Average Security Blog
Reply With Quote