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
655
November 26, 2020 12:44PM
283
November 26, 2020 01:09PM
233
November 30, 2020 06:40AM
242
November 30, 2020 11:49AM
218
November 30, 2020 12:00PM
251
December 02, 2020 02:15PM
225
December 02, 2020 08:58PM
190
December 03, 2020 06:55AM
215
December 03, 2020 10:20AM
214
December 03, 2020 11:30AM
196
December 03, 2020 11:47AM
206
December 03, 2020 10:23AM
209
December 03, 2020 11:36AM
Re: Conversion mysql to .sql
220
December 04, 2020 09:09AM


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.