Ask a Question Show All Questions All Unanswered FAQ
Please Sign up or sign in to vote. 0.00/5 (No votes) See more: database Hi, We are migrating Ms-Sql to MySql So i am trying to Restore form .bak file in mysql its not happening .Can any one please help me out Thanks & Regards Posted 5-May-15 1:43am Member 11270910 Add a Solution Comments hypermellow 5-May-15 7:48am Are you trying to restore a MSSQL .bak file directly into MySql? Member 11564708 5-May-15 13:30pm Yes,i need to get Sql database into my new MySql database. ZurdoDev 5-May-15 8:02am I don't know MySql but I seriously doubt it supports Microsoft Sql files. 1 solution
Please Sign up or sign in to vote. Solution 1You can't restore a MSSQL .bak file to MySql. You have to migrate the data : https://www.mysql.com/why-mysql/white-papers/guide-to-migrating-from-sql-server-to-mysql/[^] Permalink Share this answer Posted 5-May-15 2:10am Mehdi Gholam Comments Member 11564708 8-May-15 3:24am Thank you soo much for your accurate response.I have done my restoring but some tables not restoring which are having indexes . do you any idea . Mehdi Gholam 8-May-15 4:43am Indexes should not have any effect on the data migration, your problem is somewhere else, check the log from migration process for errors Add a Solution
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
Related Questions DATABASE RESTORE FROM .bak File .bak files cannot found in actual directory location? Restore multi database from one .BAK How to restore .bak file of SQL Server 2005 database Mysql Database Restore how to restore multiple database file(.bak) in sqlserver 2008 Trying to restore a local .BAK file to a remote SQL Server (on GoDaddy) sql error to add .bak file How to restore SQL 2005 .bak file using C# where the database is in use. Not able to restore a .bak file taken from another pc Advertise Layout: fixed | fluid Copyright © CodeProject, 1999-2022 Web01 2.8:2022-09-22:1 CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900 What is .BAK file used for?bak" is a filename extension commonly used to signify a backup copy of a file. When a program is about to overwrite an existing file (for example, when the user saves the document they are working on), the program may first make a copy of the existing file, with . bak appended to the filename. This common .
Can I delete SQL BAK files?Yes, you can manually delete old backup files without affecting the restore database. But in the long term, I would suggest you create and schedule a maintenance plan in SQL Server Management Studio.
What is a BAK file and how do I open it?These backup files have names ending with the ". bak" file extension, and you use them to restore database backups through Microsoft SQL Server. by navigating to the backup utility and loading the BAK file as a restoration medium, you can open the file and restore the database.
How do I restore a MySQL database from a BAK file?Windows Server. Open a command prompt.. Go to the MySQL bin folder, cd "C:\Program Files\MySQL\MySQL Server 5.6\bin" or. "C:\Program Files\MySQL\MySQL Server 5.7\bin". Restore the database. Execute: mysql -u whd -p whd < C:\whdbackup.sql.. Enter the whd database user password if prompted for a database password.. |