WordPress.org

1. nshumate
   Member
   Posted 3 years ago #

   I'm trying to restore an untouched backup via phpMyAdmin, but (after the first expected time-out and continuation) I get this error:

   Error
   
   SQL query:
   
   /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
   
   MySQL said: Documentation
   #1298 - Unknown or incorrect time zone: 'NULL'

   This is be a pristine backup (generated by WP-DB-Manager), so it should have no problems going right back into the WordPress installation it came from! Help!

2. stvwlf
   Member
   Posted 3 years ago #

   Hi

   There are sometimes a bunch of commands at the beginning and end of those backup files that don't need to run - that is what is causing the problem.

   lines that look like this
   /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

   make a copy of your file the way it is now, and then delete those lines from the version you are uploading into phpmyadmin. that should solve your problem. If you don't see a Drop Table line before each Create Table command, you will need to manually delete all the database tables from the database before trying the import again.

Topic Closed

This topic has been closed to new replies.