alex asked:


I used “mysqldump -A” to copy some databases out and then “mysql” to import them back into another server. This works ok but all the user logins and privileges are lost. Is there an easy way to move the users and privileges?

Thanks!

Scottie”T” asked:


If i just have my stand alone computer, how can i practice using MySQL and viewing the web pages?

Peter asked:


Because in previous version the default encoding in mysql server is latin1 and not many remember to change it. So utf8 characters are saved in latin1 encoding. But what does this actually mean?

For example, some utf8 characters , which are not available in latin1, are 3-4 bytes long.

What binary data do they become after encoding them in latin1?

Thanks a lot.
Thanks for the link. But the link points to my own question.

Batman asked:


I have a mysql server up and running on my local machine, but I can’t seem to get a simple php script to execute on it. I thought I had php installed correctly. Is there some special folder I have to save the script in to make it work. I have it in my bin folder right now. Is there an easy way to know whether I have php installed correctly or not?