I will install MySQL on my linode.

But how can I then use my backup file? This is not written in your link.

You'll need to upload your file to your Linode (after you've edited it since you've already got it on your computer).

Depending on the config of phpmyadin you *may* be able to import a file as large as 200MB, but don't count on it. You should google how to import your mysql file into mysql from the command line.

http://www.ozerov.de/bigdump/ could help

I found the following tutorial. https://library.linode.com/databases/my ... up-options

But I don't know if a backup of an entire DBMS or only of a single database. If I open the .sql backup in a text editor, the first lines are the following:



Can somebody say what type of backup it is?

It looks like it's just a dump of database 'xxx'.

_________________

/* TODO: need to add signature to posts */

MySQL commands aren't that difficult to learn, and the command line isn't that complex, though a lot of people seem to think it is. I don't have any control panel installed, so I do everything from the command line. I recently watched a video where someone called making a file executable with Terminal "crazy hacker stuff." ಠ_ಠ I prefer to manage databases with a GUI though.

This might still leave vulnerabilities, but you can and should use self signed SSL and .htaccess to restrict PHPmyAdmin to IP addresses of administrators. Is there any way that IP addresses can be faked for this purpose or a way that a hacker could get around this? It helps a lot, but I wouldn't assume it to be totally secure.

I blame a lot of web based stuff for compromising security in the name trying to save time or to make things more convenient. Wordpress allowing admins to edit PHP files from the web is one of those foolish things. I also blame the web FTP managers provided by shared hosting companies for this; they're difficult to navigate to, and they make noobs who see SSH as "crazy hacker stuff" do things like install file upload extensions in their web apps. Learn SCP. Not rocket science.

_________________
Homepage www.sturmkrieg.com
Social network Gamernet
Development website Sashaweb Development
Imageboard img.sturmkrieg.com
WikiHub free wiki host Community Wiki

If you want to use a gui (which isn't a bad thing when it comes to sql). Use MySQL workbench http://www.mysql.com/products/workbench/. It's free, cross-platform, doesn't require anything extra installed on the server and connects via ssh so it's secure.

_________________
Paid support
How to ask for help
1. Give details of your problem
2. Post any errors
3. Post relevant logs.
4. Don't hide details i.e. your domain, it just makes things harder
5. Be polite or you'll be eaten by a grue

So it's for your own computer? Doesn't that require making MySQL remotely accessible?

EDIT

I just got it set up without remotely accessible MySQL. I did SSH and then localhost connection.

_________________
Homepage www.sturmkrieg.com
Social network Gamernet
Development website Sashaweb Development
Imageboard img.sturmkrieg.com
WikiHub free wiki host Community Wiki