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
137
November 26, 2020 12:44PM
42
November 26, 2020 01:09PM
36
November 30, 2020 06:40AM
39
November 30, 2020 11:49AM
33
November 30, 2020 12:00PM
30
December 02, 2020 02:15PM
36
December 02, 2020 08:58PM
31
December 03, 2020 06:55AM
34
December 03, 2020 10:20AM
27
December 03, 2020 11:30AM
30
December 03, 2020 11:47AM
36
December 03, 2020 10:23AM
24
December 03, 2020 11:36AM
Re: Conversion mysql to .sql
28
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.