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

mySQL error

Discussion in 'Installation, Upgrade, and Import Support' started by Tracy Perry, May 28, 2013.

  1. Tracy Perry

    Tracy Perry Well-Known Member

    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).
     
  2. Tracy Perry

    Tracy Perry Well-Known Member

    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!
     

Share This Page