View Single Post
  #11 (permalink)  
Old 08-24-2007, 09:13 AM
wige's Avatar
wige wige is offline
Moderator
WebProWorld Moderator
 

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

There are several different ways to create a backup of a MySQL database. The most common is what has been discussed mostly above and which is covered in the documentation mentioned. This creates a single text file that lists all the SQL commands needed to recreate the database as it was. Other methods include simply taking the actual database data files from the original server and compressing and archiving them. This is usually less than ideal because you can run into problems with differences between versions of MySQL.

Does the original database still exist somewhere, or is it only in the backup file?
__________________
The best way to learn anything, is to question everything.
Interestingly Average Security Blog
Reply With Quote