Database Error

[badboyz]

Hello

im trying to import my old database into my new server but its giving me this error when i try from bigdump.php:erm:

Error at the line 83929: /*!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'

can someone help me

thanks

[MrPHD]

Hi BadBoyz, you are try to upload old DB through Dedicated servers or Hosting? If are try through hosting do not make upload whit php go to PhpMyAdmin and past table for table if you have not space to upload, some hosting companys make default upload files on 2MBs, if you have dedicated server you have one and easy option, through SSH, if you don´t know how to do it, i can help you. Regards

[badboyz]

Hi BadBoyz, you are try to upload old DB through Dedicated servers or Hosting? If are try through hosting do not make upload whit php go to PhpMyAdmin and past table for table if you have not space to upload, some hosting companys make default upload files on 2MBs, if you have dedicated server you have one and easy option, through SSH, if you don?t know how to do it, i can help you. Regards

yes i have a Dedicated server.

and i know SSH but how do i upload from it?

[MrPHD]

Hi, on old server you do That:
1 - mysqldump -u root -p NAMEDBTODUMP > filename.sql
2 - For Gzip do this: gzip filename.sql

3- To send to another server or new one, do this: - scp filename.sql.gz root@ip.of.destine.machine:/directory/of/destiny he goes ashk for Password.

On New Server
4 - To decompress Make this: - gunzip filename.sql.gz on new server of corse.

5 - To put Data Base on place make this: - mysql -u root -p BDNAME < filename.sql
you have created a new data base before this.

thats all, have any question, please ask. Regards

[badboyz]

I need to udate mysql version to import that database.

but i have no idea how to update mysql on a linux server.
can you help me?

[MrPHD]

Hi, you can check HERE (http://dev.mysql.com/doc/refman/5.0/en/upgrade.html) Regards

[badboyz]

Hello

i could not make it work.

can u help me in other way?

thanks