[DLE] Issues restoring DB

[xtone]

Hi em having issues restoring my DLE 9.2 DB to DLE 9.3 my host sent me a rar file which includes all of my site template db but i dont know how do i restore my db can any one help me with that ?

xtone Reviewed by xtone on 22nd Aug 2011. [DLE] Issues restoring DB Hi em having issues restoring my DLE 9.2 DB to DLE 9.3 my host sent me a rar file which includes all of my site template db but i dont know how do i restore my db can any one help me with that ? Rating: 5

[Sp32]

did he backup shared or a vps for you?

If it was shared unzip and upload all the contents to the public_html/www folder then go into cPanel/Webmin/Directadmin and import the .sql file into the database section.

[hatem20]

You can either do what sp32 said or follow this method:

Make a copy of your database (.sql) that you will find inside a folder called \mysql in your rar file - move it to \public_html\backup (which is one of DLE folders) then import your DB through Admin Panel >> Maintenance.





Done.

[DOPE]

Why not use phpMyAdmin?

[xtone]

done but em having another issue that is whenever some1 tries to register he gets this :

MySQL Error!
------------------------

The Error returned was:
Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp'

Error Number:
1267

SELECT COUNT(*) as count FROM dle_users WHERE email = 'asdfasd@asdfsdf.com' OR LOWER(name) REGEXP '[[:<:]][a?][s5][s5]f[[:>:]]' OR name = 'assf'

i think it means the language that my previous host was using in his server was cp1251 and this one is one unix or Linux so it uses UTF 8 so when he made a backup and gave it to me and i restored my db and get this error ... em not very familiar with these languages but its just a guess ! other thing is i can add user from admin panel but no one cannot regsiter normally need help here and by the way i think two languages are collapse so i think why is good in php and my sql can help me here !

[xtone]

need help please

Friendly bump