[DLE] Issues restoring DB
- Thread starter xtone
- Start date
- Status
5 comments
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.
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.
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 !
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 !
- Status