moving site...

[Optick]

i have moved everything but the sql i cant upload with phpmyadmin so i used BIGDUMP
and i get this error

Error at the line 4356: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
 Query: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

 MySQL: Variable 'sql_mode' can't be set to the value of 'NULL'

any ideas?

Optick Reviewed by Optick on 19th Sep 2008. moving site... i have moved everything but the sql i cant upload with phpmyadmin so i used BIGDUMP and i get this error Error at the line 4356: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; Query: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; MySQL: Variable 'sql_mode' can't be set to the value of 'NULL' any ideas? Rating: 5

[adi]

Try to optimize / repair your database via phpmyadmin
And re-dump again

Else check the sql
If the code is at the bottom, maybe try to ignore the error and test your web / forum

I remembered I had this error too, but I ignored it, and my site is still working perfectly

If my suggestions is wrong, maybe others can help you out.

Good luck!

[Prince]

I guess my advice about using mysqldumper wasn't wrong after all.

When you move the database you have to check it for errorsand after you fdownload it , you must test it with winrar or similar to avoid any errors

phpmyadmin isn't fit in bigger than 2M databases, so use big dump or mysqldumper.

[Optick]

well i got it in but im getting errors now and i dont know why =[
blah fail lmao

[pimpinjg]

if you have root at your own box just resotre it from ssh with the -f command to ignore erorrs