I obviously have no idea about databases and stuff so my newbish question. I have few blogs running on one database. And I want to transfer one of them. So I obviously need to copy and transfer mysql database aswell. Can my other blogs get affected somehow if mysql database goes to the bad hands? I feel dumb asking this question but really have no idea what exzactly mysql thing does
No, usually it will be OK. They will have a copy of the entire blog (posts, comments, settings, etc.) but it won't change how your blog runs. I highly suggest you don't give them a copy of all your blogs just the one they bought/you gave to them. Also make sure you aren't giving the admin/users usernames and passwords away (if they are encrypted with MD5 or etc then you're OK, but if their in plaintext then delete them from the DB or atleast change them)
What do you mean? I won't give a copy of other blogs, Just one + mysql database which runs all my blogs. Or do you mean somehow give just a part of mysql database which is responsible just for that one blog?
Through phpMyAdmin you can select specific tables on a database to export, so if you have access to it, you can export just the tables related to the one blog. (If so, browse to phpMyAdmin select your database, go to export, on the left side in the listbox select your tables, near the bottome of the page select zipped as the compression and then just click go.)
Ok thanks for the answers However if i was too lazy and exported the whole database? Would that be ok. Or make the question like this: If I would export my mysql database to you and would say - do something bad to my blogs, would that be possible or revealed mysql database have nothing much to do with the security of my sites
It really depends in what is in those databases and how it is stored. Some databases I would give out even if it had my name, social security number, genome and all that, others I wouldn't let people see if it was just a password to a random site.
name, social security number? No lol. I just click create mysql database and thats it. Then I build wordpress blogs on it. It does not ask for personal details
Seriously why would anybody put social security number or his name in mysql dtabase....? I though mysql database was some kind of table to "put in" the script... Now I am confused more than I was opening the thread
I have a tendency to do that to people. A mysql database stores information, so you could store anything in it including your social security number, but if they are just WordPress databases they shouldn't have anything _too_ dangerous in them, but I wouldn'ty do it just in case.