Database Error On Restoring on the Server

[Rajdeep]

Hello,

I m getting the following databse error when i import the databse .sql

Error at the line 4823: /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

Query: /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

MySQL: Unknown or incorrect time zone: 'NULL'

Mysql Version info--

My Old Server Mysql Version - 5.0.45-community-
log --->> from where i took backup

MY Current Server Mysql Verison - 5.0.45-community--->>> On which i m restoring

PLEASE HELP Me

Thanks

[snakes1100]

How did you export/dump your DB?

[SEOvB]

Your host will need to fix that problem.

[Rajdeep]

Bigbump.php

Originally Posted by snakes1100

How did you export/dump your DB?

--------------- Added [DATE]1198562048[/DATE] at [TIME]1198562048[/TIME] ---------------

HOw can Host fix it??

Originally Posted by FRDS

Your host will need to fix that problem.

[Marco van Herwaarden]

I suggest you try something else then bigdump then.

The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/m...nce_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/m...ce_ssh_restore

P.S. If you don't have shell access, some people have also reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showt...t=mysqlhotcopy

[Rajdeep]

Thanks a lot Sir....

I used - MySQLDumper:
http://www.mysqldumper.de/en/index.php

And Done,, no error this time

Thanks

Originally Posted by Marco van Herwaarden

I suggest you try something else then bigdump then.

The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/m...nce_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/m...ce_ssh_restore

P.S. If you don't have shell access, some people have also reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showt...t=mysqlhotcopy