HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMinor

Is it possible to convert a .mysql file to a .sql file?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
fileconvertsqlpossiblemysql

Problem

I am facing an issue with a MySql dump file (i.e mydump.mysql) generated by a Drupal export module. I am trying to import it on a local Drupal installation via Acquia Dev Desktop.

When browsing for my dump file, this application filters for .sql, .sql.gz and .mysql files. I thought it would load my .mysql easily, but I get an unsupported file type .mysql error.

Is there a way to convert my .mysql file into a .sql file, knowing that I don't have access to the original database used to generate my mydump.mysql? I would like to try to feed a .sql file to Acquia Dev Desktop instead.

P.S.: I am on Windows 7 if this is relevant. Thanks.

Solution

For the records, I finally managed to load my dump into Acquia Dev Desktop after renaming the file to .sql and specifying/using exactly the same database name as the original database name.

I don't know what caused the original issue or what solved it, since I don't believe the database name should be an issue at all.

Context

StackExchange Database Administrators Q#13059, answer score: 2

Revisions (0)

No revisions yet.