Re: How to import a .bak file into a new SQL server
You will have problems if the database name is in your SQL file (what you call your bak file)
How big is the file? Are you aware that it is a text file, and that if you have a suitable editor, you can edit A COPY OF (!) the file. If the file contains the "use database" command, you can just delete it, as you have already told PHPMyAdmin which database to use.
The SQL file should contain a CREATE statement for each table, together with the INSERT commands for all the records.
|