MySQL Forums
Forum List  »  MySQL Workbench

Re: Conversion mysql to .sql
Posted by: Jon Stephens
Date: December 04, 2020 09:09AM

If your database is on a running MySQL server, you should be able to use mysqldump to create a dump of SQL statements from that database (IOW a .sql file). mysqldump is part of the standard MySQL distribution and should already be installed with it.

If you have *only* the database files, then you may want to do as Peter suggests and find a third-party tool that can perform the conversion.

Do you have an existing live database, or only the files?

cheers

Jon Stephens
MySQL Documentation Team @ Oracle
Orlando, Florida, USA

MySQL Dev Zone
MySQL Server Documentation
Oracle

Options: ReplyQuote


Subject
Views
Written By
Posted
314
November 26, 2020 12:44PM
134
November 26, 2020 01:09PM
118
November 30, 2020 06:40AM
127
November 30, 2020 11:49AM
119
November 30, 2020 12:00PM
126
December 02, 2020 02:15PM
127
December 02, 2020 08:58PM
97
December 03, 2020 06:55AM
117
December 03, 2020 10:20AM
102
December 03, 2020 11:30AM
104
December 03, 2020 11:47AM
111
December 03, 2020 10:23AM
103
December 03, 2020 11:36AM
Re: Conversion mysql to .sql
100
December 04, 2020 09:09AM


Sorry, only registered users may post in this forum.

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.