Guys, I need help with a problem. When you Download a MySQL Database Backup to your desktop. Well, it downloads in the wrong file type (Window media player) and I can't seem to change it back.
Press SHIFT with right click on the file, choose "open with" from the context menu, and then choose the right program for the SQL file. I prefer notepad++, but the Windows text editor will be fine too. Before you click on the program be sure to set the option "open always with this program" first.
Sorry, I don't use an english Windows, so the texts could be a little different.
Thanks!
Did it work?
No, not really! I know about the method you talked about. And I was about to convert the file to notepad. But I can not seem to return the file back to its original form.
What file extension has your backup file? When you download it, it should be .sql (not zipped) or .zip or .gz (zipped).
realchri_elka641 (1).sql but it downloads to a Wordpad file and I can't seem to get it to download to the sql file.
Sounds like you're actually good. There is a difference between the file extension and the program set as the default opener. .sql is what you want, and according to the filename, what you have. If memory serves, you can change the program which will open the file by right clicking, and choosing from the menu. Currently you have Wordpad set as the default. For the most part, you shouldn't need to open the file anyway. Saving it as a local copy serves the purpose of a backup in the event of a server crash or some other failure. Should that happen, you will upload it to the server as is in order to use it. Unless you are doing really advanced stuff it really doesn't matter what "type" it is.
That is the problem, I moved my account to another server (better, faster). I copied my SQL database and directory files but I could not get them to work on the new server.
What goes wrong? What indicates the database file is the issue? Most likely it's something else, something quite simple. Between all the minds here we should be able to help you figure it out. :)
Here is the SQL database
Please do never upload randomly sql dumps.
I do not understand what you are talking about. I'm not a tech guy. If I have done something against the rules I do apologize.
I don't believe it is so much a rule per se. It makes a HUGE post. And it contains info which could easily lead to your site being hacked. ;)
Rather than focus on the sql file, please tell us precisely what goes wrong. Error messages, warnings, fire?
I have already redone everything so I have no error reports. All my stuff has been moved to new servers. But what I can do is talk about what went on.
You know yourself, now a SQL file looks when you download it to your desktop from your own sites. I'm running Windows 10 and something when wrong and I can't figure out what. At one time I was able to download a SQL file the same as you, but something happened and now it's either downloading as a WordPad, Paint, Notepad, etc.
It's simply downloading and Windows is assigning it a "type". That's nothing more than the default program Windows will attempt to use to open the file when you double click it. Nothing more, nothing less. You can change it as described above.
@Brother John can you try to reset default file assocation in Windows 10? Looks like yours is broken.
I was a bit in a hurry.
The problem is not rules, but a database dump contains sensitive informations (email addresses, passwords hashes (that are robust, but are better kept hidden), personal messages, sessions data, etc.), that should not be shared lightly.
So, for your own safety and for the safety of your users, you should never, ever, upload a database dump in a web-accessible folder. Never. ;)
Thanks!