| Author |
Topic |
|
Marto
Starting Member
5 Posts |
 Posted - 2008-03-13 : 16:49:54
|
| Hello and greetings from Bulgaria!The server of zendurl.com crashed and my forum gone away. With some help from the administrator, I got the latest database of it. But the forum is bulgarian, so there was mostly cyrillic. The problem is that the cyrillic can't be read in the latest database. Maybe the admin didn't save it properly. I tried to decode these symbols, but unfortunately with no success. I suppose that the encode must be UTF8 or something like this, I think that it can be done and I hope it works! Here's the database: http://disasterpriser.data.bg/zendurl_zendurl0sk8ordie.zipI hope that someone can recover the lost information.~ Regards, Marto The Creator |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-13 : 16:55:31
|
| Is your database Microsoft SQL Server?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
Marto
Starting Member
5 Posts |
Posted - 2008-03-13 : 18:59:14
|
I'm not sure. I'm not very good at databases... That's why I am asking for help in this forum.  |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-13 : 20:59:38
|
| What is cyrillic?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Marto
Starting Member
5 Posts |
Posted - 2008-03-13 : 21:33:56
|
| It is font script like Western, Hebrew, Arabic, Greek etc. It is used mostly by Russia, Bulgaria and other east-european countries. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-13 : 21:53:08
|
| In order for us to help, we'll need to know what type of database it is. If it is SQL Server, then we can probably help or at least point you in the right direction. If it is something else like MySql, then you'll need to ask for help on a forum that deals with that specific database type. I'm not willing to download that zip file and risk getting a virus since I don't know you. Perhaps your administrator can tell us what type of database it is.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Marto
Starting Member
5 Posts |
Posted - 2008-03-14 : 06:23:36
|
| I am sure that there isn't a virus in it, but nowadays you can't know who you can trust. As I said before, I'm not very good at databases. So I just copied the beginning of the file. Here it is:-- phpMyAdmin SQL Dump-- version 2.11.4-- http://www.phpmyadmin.net---- Host: localhost-- Generation Time: Feb 25, 2008 at 07:45 PM-- Server version: 4.1.22-- PHP Version: 5.2.3SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";---- Database: `zendurl_zendurl0sk8ordie`-- |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-14 : 11:39:33
|
| Since it's written in php, my guess is that your database is MySql. For MySql help, you should post ina MySql forum such as the one over at dbforums.com.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Marto
Starting Member
5 Posts |
Posted - 2008-03-14 : 17:22:35
|
Some guy fixed it! At last! Thanks for the attention, tkizer, and good luck :) Wish you best!  |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-18 : 15:24:48
|
| I guess cyrillic is collation setting. |
|
|
|
|
Database problem with cyrillic...