Re: from phpMyAdmin to MySQL Administrator

[Barry Galbraith]

Select "Restore" in the left hand column.
Click the "Open Backup file" button at the bottom right. Browse to your sql script.
At Target Schema, select "Original Schema" or "different Schema" as you require.
Then select the Restore Content tab at the top.
Select the Analyse Backup file Content button at bottom right.
Check the items you want to restore. Click on Start restore.

Alternatively, for more control, select Tools | Query Browser
In Query Browser, if your database already exists, then in the SQL window, type USE <database>
Execute the SQL statement to connect to your database.

If your database doesn't yet exist, then your sql script should contain
"CREATE database <database name>;"
statement
File | Open Script and then browse to your .sql file
Click on the Execute button, or the Step button to go line by line, and Bob's your uncle.

Good Luck.
Barry.



Edited 1 time(s). Last edit at 01/21/2009 03:30PM by Barry Galbraith.