var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
Few questions in SSH and server
1. Why doesn't my server recognize special characters? For example in a webpage the text
shows as © copyright when accessed in a internet browser. ? copyright
2. How to execute and restore a mysql database in SSH? I want to execute a file called backup.sql using custom username/password for the database.
I have a CentOS Linux 4.3 w/ Webmin 1.310.
It sounds like more of a browser issue than a server issue, but canr be for sure. Try it in both Mozilla and IE. If same result, it may be server issue and check httpd config for a setting in there.
For restoring databases, i would use phpmyadmin.
First issue is a result of your web browser. Try typing © instead of pasting right off the character map.
Phpmyadmin doesn't work well with large database backups. upload backup.sql via ftp, and ise this command to restore the backup:
mysql -u username -p databasename < backup.sql
Then it'll restore. For larger backups, it will take a longer time. Whatever you do, don't exit while the program is running. It'll screw up your database, and it may take a long time to empty out all the old data.
Thanks for the help. This worked great!
Just for future people who may have the same problem, to fix the wrong character set codes, all you need to do is change this in the httpd.conf file:
This can also be fixed (I believe) by putting meta tags on the header of your webpage:
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />