Elxis CMS Forum

Support => General => Topic started by: ahmet on April 21, 2012, 00:33:33

Title: installing database(SOLVED)
Post by: ahmet on April 21, 2012, 00:33:33

hello all,
there was a problem in the host so, i had to reinstall again..
but i couldnt restore the database because of turkish carachters i guess..
heres the error..
any help appreciated..

SQL sorgusu:

--
-- Veritabanı: `information_schema`
--
CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

MySQL çıktısı: Belgeler
#1044 - Access denied for user 'wwwgloba'@'localhost' to database 'information_schema'

Title: Re: installing database
Post by: rentasite on April 21, 2012, 04:15:24

The problem is here:

Quote from: ahmet on April 21, 2012, 00:33:33

MySQL çıktısı: Belgeler
#1044 - Access denied for user 'wwwgloba'@'localhost' to database 'information_schema'

1) Wrong database name, given for sure!
2) Also is wwwgloba the correct user, assigned on the database?

Check those 2 issues, please!

Title: Re: installing database
Post by: ahmet on April 21, 2012, 09:33:14

they are sure right..
i changed them also from config.php
but in sql there was difference, i am changing that... also..
but i can not import database..

Title: Re: installing database
Post by: xmanhattan on April 21, 2012, 10:17:57

Try editing the sql backup file and changing the encoding to utf-8 without bom.  Just make sure that you use the right editor like notepad++.

Title: Re: installing database
Post by: ahmet on April 21, 2012, 10:47:50

what if i use dreamveaer and save it is as?(find replace tool)

Title: Re: installing database
Post by: xmanhattan on April 21, 2012, 15:21:10

I've done that and it works.

Title: Re: installing database
Post by: ahmet on April 21, 2012, 22:51:42

works..
thanks all.
utf-8 general-ci dumped works..