ElkArte Community

Elk Development => Feature Discussion => Topic started by: TigerAnt on June 15, 2017, 10:20:30 pm

Title: PC file
Post by: TigerAnt on June 15, 2017, 10:20:30 pm
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.
Title: Re: PC file
Post by: Jorin on June 16, 2017, 01:14:57 am
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.
Title: Re: PC file
Post by: TigerAnt on June 16, 2017, 09:52:56 am
Thanks!
Title: Re: PC file
Post by: Jorin on June 16, 2017, 12:27:08 pm
Did it work?
Title: Re: PC file
Post by: TigerAnt on June 16, 2017, 01:17:08 pm
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.
Title: Re: PC file
Post by: Jorin on June 16, 2017, 01:28:47 pm
What file extension has your backup file? When you download it, it should be .sql (not zipped) or .zip or .gz (zipped).
Title: Re: PC file
Post by: TigerAnt on June 16, 2017, 02:33:13 pm
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.
Title: Re: PC file
Post by: badmonkey on June 16, 2017, 05:13:48 pm
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. 
Title: Re: PC file
Post by: TigerAnt on June 16, 2017, 08:27:39 pm
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.
Title: Re: PC file
Post by: badmonkey on June 16, 2017, 10:41:17 pm
Quote from: Brother John – 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.  :)
Title: Re: PC file
Post by: TigerAnt on June 17, 2017, 09:42:41 am
Here is the SQL database
Title: Re: PC file
Post by: emanuele on June 17, 2017, 09:49:09 am
Please do never upload randomly sql dumps.
Title: Re: PC file
Post by: TigerAnt on June 17, 2017, 10:33:55 am
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.
Title: Re: PC file
Post by: badmonkey on June 17, 2017, 07:28:25 pm
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?
Title: Re: PC file
Post by: TigerAnt on June 17, 2017, 09:06:48 pm
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.
Title: Re: PC file
Post by: badmonkey on June 17, 2017, 10:45:27 pm
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. 
Title: Re: PC file
Post by: kucing on June 18, 2017, 12:40:27 am
@Brother John can you try to reset default file assocation in Windows 10? Looks like yours is broken.
Title: Re: PC file
Post by: emanuele on June 20, 2017, 03:30:26 pm
Quote from: Brother John – 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 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. ;)
Title: Re: PC file
Post by: TigerAnt on June 20, 2017, 04:28:52 pm
Thanks!