Elxis CMS Forum
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: EDC: Download extensions for Elxis 4.x
 
Pages: [1]
  Print  
Author Topic: installing database(SOLVED)  (Read 1778 times)
ahmet
Sr. Member
****
Offline Offline

Posts: 254


360 HDR Virtual Tours | Windsurfing Sailing


WWW
« on: April 20, 2012, 23: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'
« Last Edit: April 21, 2012, 21:52:07 by ahmet » Logged

rentasite
Elxis Community
Hero Member
*****
Offline Offline

Posts: 3137


Web Services


WWW
« Reply #1 on: April 21, 2012, 03:15:24 »


The problem is here:

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!
Logged

ahmet
Sr. Member
****
Offline Offline

Posts: 254


360 HDR Virtual Tours | Windsurfing Sailing


WWW
« Reply #2 on: April 21, 2012, 08: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..
« Last Edit: April 21, 2012, 09:08:03 by ahmet » Logged

xmanhattan
Hero Member
*****
Offline Offline

Posts: 973


If I'm still breathing, I'm doing something!


WWW
« Reply #3 on: April 21, 2012, 09: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++.
Logged

ahmet
Sr. Member
****
Offline Offline

Posts: 254


360 HDR Virtual Tours | Windsurfing Sailing


WWW
« Reply #4 on: April 21, 2012, 09:47:50 »

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

xmanhattan
Hero Member
*****
Offline Offline

Posts: 973


If I'm still breathing, I'm doing something!


WWW
« Reply #5 on: April 21, 2012, 14:21:10 »

I've done that and it works.
Logged

ahmet
Sr. Member
****
Offline Offline

Posts: 254


360 HDR Virtual Tours | Windsurfing Sailing


WWW
« Reply #6 on: April 21, 2012, 21:51:42 »

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

Pages: [1]
  Print  
 
Jump to: