• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

mySQL error

Tracy Perry

Well-known member
#1
Not sure if this should go here - and if not feel free to move it.
I'm moving over to a dedicated server and used phpMyAdmin to export my .sql file (635MB) for the first forum. Now, when I try to import it via mysql (haven't got phpMyAdmin to take that big of file yet) I get this

Code:
ERROR 1231 (42000): Variable 'character_set_client' can't be set to the value of 'NULL'
Query OK, 0 rows affected (0.00 sec)
 
ERROR 1231 (42000): Variable 'collation_connection' can't be set to the value of 'NULL'
Didn't have the problem when I imported it on my VPS (and not much has changed).
 

Tracy Perry

Well-known member
#2
OK.. we will see how this does.. used mysqldump for the file (much smaller)...

Fixed... no more phpMyAdmin for this old boy.. back to command line stuff - trust it a lot more!