Results 1 to 5 of 5
Thread: Few questions in SSH and server
-
12-22-2006, 06:06 PM #1Junior Guru
- Join Date
- Jul 2003
- Posts
- 180
Few questions in SSH and server
1. Why doesn't my server recognize special characters? For example in a webpage the text © copyright shows as ? copyright when accessed in a internet browser.
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.
-
12-22-2006, 07:36 PM #2WHT Addict
- Join Date
- Nov 2004
- Posts
- 152
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.
-
12-22-2006, 07:53 PM #3Disabled
- Join Date
- Dec 2002
- Location
- chica go go
- Posts
- 11,876
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
<enter password>
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.
-
12-23-2006, 01:15 AM #4Junior Guru
- Join Date
- Jul 2003
- Posts
- 180
Thanks for the help. This worked great!
-
12-23-2006, 02:54 AM #5Junior Guru
- Join Date
- Jul 2003
- Posts
- 180
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:
AddDefaultCharset <code>
i.e.
AddDefaultCharset ISO-8859-1
This can also be fixed (I believe) by putting meta tags on the header of your webpage:
Code:<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />