Import database from .dat file
Hello,
I am new to MySQL so please forgive me if this has been covered before.
I have a .dat file which appears to be a file created from tape backup. I was able to import or create a database in SQL Server from this file using the following:
RESTORE DATABASE [AR_Carroll_2008]
FROM DISK = N'C:\Temp\AR_Carroll_2008.DAT'
WITH FILE = 1,
MOVE N'AR_Carroll_2008_dat' TO N'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\AR_Carroll_2008_data.mdf',
MOVE N'AR_Carroll_2008_log' TO N'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\AR_Carroll_2008_log.LDF',
NOUNLOAD, REPLACE, STATS = 10
GO
How can I emulate this process in MySQL, I am guessing using the MySQL Command Line Client???
Thanks!
Subject
Views
Written By
Posted
Import database from .dat file
14347
June 12, 2008 10:17AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.