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

MySQL Dev Zone
MySQL Server Documentation
Oracle

Options: ReplyQuote


Subject
Views
Written By
Posted
1082
November 26, 2020 12:44PM
459
November 26, 2020 01:09PM
394
November 30, 2020 06:40AM
429
November 30, 2020 11:49AM
367
November 30, 2020 12:00PM
445
December 02, 2020 02:15PM
366
December 02, 2020 08:58PM
326
December 03, 2020 06:55AM
390
December 03, 2020 10:20AM
389
December 03, 2020 11:30AM
340
December 03, 2020 11:47AM
358
December 03, 2020 10:23AM
367
December 03, 2020 11:36AM
Re: Conversion mysql to .sql
387
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.